https://www.machform.com/forums/ MachForm Community Forums Topic: SQL Error INSERT INTO en Thu, 18 Jun 2026 11:23:06 +0000 https://www.machform.com/forums/topic/sql-error-insert-into#post-21655 Wed, 27 Aug 2014 05:25:35 +0000 dparker 21655@https://www.machform.com/forums/ <p>I am experiencing this same problem too.<br /> WEBSITE LINK <a href="https://www.dolphinshuttle.com/secure/expressclear.html" rel="nofollow">https://www.dolphinshuttle.com/secure/expressclear.html</a><br /> DIRECT LINK TO FORM: <a href="https://www.dolphinshuttle.com/secure/machform/view.php?id=14150" rel="nofollow">https://www.dolphinshuttle.com/secure/machform/view.php?id=14150</a><br /> The form takes a while to process. It WILL work on the desktop version of the site. However, when a customer tries to complete the form via a mobile device, the same sort of error code come up.</p> <p>Warning: Invalid argument supplied for foreach() in /home/dolph824/public_html/secure/machform/includes/post-functions.php on line 2894<br /> SQL: [80] INSERT INTO <code>ap_form_14150</code>(<code></code>) SELECT <code></code> from <code>ap_form_14150_review</code> WHERE id=? Params: 1 Key: Position #0: paramno=0 name=[0] "" is_param=1 param_type=2 Query Failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'field list'</p> <p>The mobile site (http://m.dolphinshuttle.com) uses the simple link code. The form IS NOT embedded using any of the other code options).<br /> My client is upset. Please help.</p> <p>UPDATE: This error is happening on all the MachForms that are on the site and being accessed by a mobile device:<br /> * FORM #1 <a href="https://www.dolphinshuttle.com/secure/machform/view.php?id=10310" rel="nofollow">https://www.dolphinshuttle.com/secure/machform/view.php?id=10310</a> (upgraded from MachForm 3)<br /> * FORM #2 <a href="https://www.dolphinshuttle.com/secure/machform/view.php?id=10868" rel="nofollow">https://www.dolphinshuttle.com/secure/machform/view.php?id=10868</a> (upgraded from MachForm 3)<br /> * FORM #3 <a href="https://www.dolphinshuttle.com/secure/machform/view.php?id=13537" rel="nofollow">https://www.dolphinshuttle.com/secure/machform/view.php?id=13537</a> (upgraded from MachForm 3)<br /> * FORM #4 <a href="https://www.dolphinshuttle.com/secure/machform/view.php?id=14868" rel="nofollow">https://www.dolphinshuttle.com/secure/machform/view.php?id=14868</a> (created new in Machform 4)</p> <p>Again, no errors when accessed via a desktop computer (but it the forms take a while to process). We DO get errors when the forms are accessed via a mobile device.</p> <p>Also, these forms were upgraded from the previous MachForm v.3. We did not have this problem in previous version. The problems began after we upgraded to version 4. </p> https://www.machform.com/forums/topic/sql-error-insert-into#post-21649 Tue, 26 Aug 2014 11:43:20 +0000 yuniar 21649@https://www.machform.com/forums/ <p>Try to logout from your MachForm panel first before testing your form. Or open a new/different browser window to test the form, so that the session won't get mixed up. </p> https://www.machform.com/forums/topic/sql-error-insert-into#post-21636 Fri, 22 Aug 2014 22:41:35 +0000 csamuel69 21636@https://www.machform.com/forums/ <p>Thank you for the information Yuniar. I made some changes as suggested and have the same issue on another form I created. This time I was testing the form and filled out the form within minutes w/o leaving and the error happened.<br /> Could it be anything else that you can think of?<br /> Again I am using iFrame to embed the form. Thanks! </p> https://www.machform.com/forums/topic/sql-error-insert-into#post-21389 Mon, 07 Jul 2014 13:28:02 +0000 yuniar 21389@https://www.machform.com/forums/ <p>Your embedded form seems to be fine. The error message above usually happened when the session of your form is timing out. This could be happened when the client fills your form and leave for a while. When he/she returned and submitted the last page of the form, the session already timed out.</p> <p>If you would like to avoid this, you can do so by adjusting the PHP configuration file (php.ini) on your server and increase the value of "session.gc_maxlifetime" setting. </p> https://www.machform.com/forums/topic/sql-error-insert-into#post-21377 Sun, 06 Jul 2014 05:25:14 +0000 csamuel69 21377@https://www.machform.com/forums/ <p>iframe embeded page: <a href="https://www.regmyevent.com/ars/2014/index.php/register1/" rel="nofollow">https://www.regmyevent.com/ars/2014/index.php/register1/</a><br /> Version: 4.1<br /> Thanks Yuniar </p> https://www.machform.com/forums/topic/sql-error-insert-into#post-21310 Thu, 26 Jun 2014 10:18:57 +0000 yuniar 21310@https://www.machform.com/forums/ <p>Can you let me know the URL of the page where you embed the form please?<br /> Also, what version of MachForm do you use? </p> https://www.machform.com/forums/topic/sql-error-insert-into#post-21281 Fri, 20 Jun 2014 05:22:07 +0000 csamuel69 21281@https://www.machform.com/forums/ <p>Has anyone seen the following error when submitting a form? I do not know exactly what the end users is don't however here is what I know.</p> <p>They fill out a multi page form. When they click submit they get the error below and not the success page. It does appear at the end of the day their information IS saved in the database BUT no email is sent (from what I know right now).</p> <p>It happens intermittently and I can not reproduce it but am getting reports from end users.</p> <p>SQL: [80] INSERT INTO 'ap_form_8888' ('') SELECT '' form 'ap_form_8888_review' WHERE id=? Params: 1Key: Position #0 paramno=0 name=[0] "" is_param=1 param_type=2 Query Failed: SQLSTATE[42S22]: Column not found: 1054 Unknownd column "in 'field list' </p>