https://www.machform.com/forums/ MachForm Community Forums Topic: Logic failure en Wed, 06 May 2026 13:42:41 +0000 https://www.machform.com/forums/topic/logic-failure#post-16946 Thu, 31 Jan 2013 04:05:18 +0000 zforray 16946@https://www.machform.com/forums/ <p>I have determined from both the error message and my removing the matrix fields that it is matrix fields causing this error. Since I had to redesign the form to remove the matrix fields, I no longer get this error. </p> https://www.machform.com/forums/topic/logic-failure#post-16933 Wed, 30 Jan 2013 23:29:39 +0000 zforray 16933@https://www.machform.com/forums/ <p>Just tried to use the logic option and it fails with: </p> <p>SQL: [672] 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_id) where A.form_id=? and A.live=1 and B.element_status=1 and B.element_type='matrix' order by A.element_id,A.option_id asc 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>