https://www.machform.com/forums/ MachForm Community Forums Topic: SQL Error en Tue, 05 May 2026 07:41:49 +0000 https://www.machform.com/forums/topic/sql-error-3#post-22297 Mon, 08 Dec 2014 14:48:47 +0000 yuniar 22297@https://www.machform.com/forums/ <p>Hi Daniel, there seems to be some issue with the backend database of your form. Can you contact us directly and let us know temporary FTP login to your machform folder please? We'll check it. </p> https://www.machform.com/forums/topic/sql-error-3#post-22263 Wed, 03 Dec 2014 14:20:17 +0000 danielschneider 22263@https://www.machform.com/forums/ <p>Hi,</p> <p>i get following error:</p> <p>SQL: [671] 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 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>in this form:</p> <p><a href="http://f2150201.td-fn.net/formulare/view.php?id=57963" rel="nofollow">http://f2150201.td-fn.net/formulare/view.php?id=57963</a></p> <p>when i hit "send".</p> <p>What do i wrong?</p> <p>Kind regards</p> <p>Daniel </p>