https://www.machform.com/forums/ MachForm Community Forums Topic: SQL Error? en Mon, 04 May 2026 00:09:37 +0000 https://www.machform.com/forums/topic/sql-error#post-19601 Thu, 07 Nov 2013 22:40:43 +0000 Lokidog 19601@https://www.machform.com/forums/ <p>Thanks for the up AMurray, I did miss that.<br /> I did think it strange and unusual at the time that the support ticket was taking some time as I usually get a quick response within 48 hrs.</p> <p>However, everything has now been fixed by Yuniar and all is well again. :)</p> <p>Thanks Yuniar! </p> https://www.machform.com/forums/topic/sql-error#post-19598 Thu, 07 Nov 2013 05:36:05 +0000 AMurray 19598@https://www.machform.com/forums/ <p>Appnitro had trouble with their systems. In case you haven't seen the announcement (in the forum list) about the support delay:</p> <p><a href="http://www.appnitro.com/forums/topic/news-support-delay?replies=2" rel="nofollow">http://www.appnitro.com/forums/topic/news-support-delay?replies=2</a> </p> https://www.machform.com/forums/topic/sql-error#post-19594 Wed, 06 Nov 2013 13:55:07 +0000 Lokidog 19594@https://www.machform.com/forums/ <p>Hi Yuniar<br /> is there any progress with this problem? :) </p> https://www.machform.com/forums/topic/sql-error#post-19555 Thu, 31 Oct 2013 19:42:51 +0000 Lokidog 19555@https://www.machform.com/forums/ <p>Details sent via contact form </p> https://www.machform.com/forums/topic/sql-error#post-19552 Thu, 31 Oct 2013 17:32:47 +0000 yuniar 19552@https://www.machform.com/forums/ <p>It seems there is some problem with the matrix field structure.<br /> We'll need to check directly into your database for this.</p> <p>Can you contact us directly and let us know temporary FTP login to your machform folder please?<br /> We'll check it. </p> https://www.machform.com/forums/topic/sql-error#post-19545 Wed, 30 Oct 2013 21:21:37 +0000 Lokidog 19545@https://www.machform.com/forums/ <p>I'm getting this when I select the "Submit" button, and get no further.</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>Looks like it has something to do with "Logic" but I'm only using the Matrix field as a Q&#38;A and not using conditional questions.</p> <p>Form is here:<br /> <a href="http://www.davidarmstrongdesign.com/digital-online/view.php?id=57" rel="nofollow">http://www.davidarmstrongdesign.com/digital-online/view.php?id=57</a></p> <p>The form is not active yet but soon will be, any ideas where I have gone wrong?</p> <p>//David </p>