https://www.machform.com/forums/ MachForm Community Forums Topic: SQL error en Mon, 04 May 2026 00:08:28 +0000 https://www.machform.com/forums/topic/sql-error-2#post-22032 Wed, 22 Oct 2014 08:41:14 +0000 yuniar 22032@https://www.machform.com/forums/ <p>There seems to be some duplicate records within your "ap_element_options" table. We'll need to check this directly. Can you open support ticket please? We'll assist there. </p> https://www.machform.com/forums/topic/sql-error-2#post-22011 Mon, 20 Oct 2014 17:15:18 +0000 Lokidog 22011@https://www.machform.com/forums/ <p>I have a form that I need help with, it's been fine until lately when the review page is starting to show this, and you cannot proceed to submit:</p> <p> "SQL: [652] 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>Also I cannot see the entries made on the backend as it just returns this as well. :(</p> <p>Any ideas? </p>