https://www.machform.com/forums/ MachForm Community Forums Topic: Logic Troubleshooting en Sun, 03 May 2026 20:40:30 +0000 https://www.machform.com/forums/topic/logic-troubleshooting#post-21682 Mon, 01 Sep 2014 07:12:39 +0000 yuniar 21682@https://www.machform.com/forums/ <p>What version of MachForm do you use? There seems to be some issue with the records within your database.<br /> Can you contact us directly please? We'll help to check it.</p> <p><a href="http://www.appnitro.com/contact" rel="nofollow">http://www.appnitro.com/contact</a> </p> https://www.machform.com/forums/topic/logic-troubleshooting#post-21665 Fri, 29 Aug 2014 03:07:11 +0000 barb080M 21665@https://www.machform.com/forums/ <p>Have set up a rule for skipping to a particular page in the form, when I go to edit the rule or add another rule the following script appears, how is this fixed please anyone know?</p> <p>"SQL: [653] select A.element_id, A.option_id, (select if(B.element_matrix_parent_id=0,A.option, (select C.<code>option</code> from ap_element_options C where C.element_id=B.element_matrix_parent_id and C.form_id=A.form_id and C.live=1 and C.option_id=A.option_id)) ) 'option_label' from ap_element_options A left join ap_form_elements B on (A.element_id=B.element_id and A.form_id=B.form Params: 1 Key: Position #0: paramno=0 name=[0] "" is_param=1 param_type=2 Query Failed: SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row."</p> <p>Thanks Barb </p>