MachForm Community Forums » MachForm 4

1. csamuel69
   Member

   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.

   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).

   It happens intermittently and I can not reproduce it but am getting reports from end users.

   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'

   Posted 9 years ago #
2. 

   yuniar

   Can you let me know the URL of the page where you embed the form please?
   Also, what version of MachForm do you use?

   ---

   MachForm Founder

   Posted 9 years ago #

3. csamuel69
   Member

   iframe embeded page: https://www.regmyevent.com/ars/2014/index.php/register1/
   Version: 4.1
   Thanks Yuniar

   Posted 9 years ago #
4. 

   yuniar

   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.

   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.

   ---

   MachForm Founder

   Posted 9 years ago #

5. csamuel69
   Member

   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.
   Could it be anything else that you can think of?
   Again I am using iFrame to embed the form. Thanks!

   Posted 9 years ago #
6. 

   yuniar

   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.

   ---

   MachForm Founder

   Posted 9 years ago #

7. dparker
   Member

   I am experiencing this same problem too.
   WEBSITE LINK https://www.dolphinshuttle.com/secure/expressclear.html
   DIRECT LINK TO FORM: https://www.dolphinshuttle.com/secure/machform/view.php?id=14150
   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.

   Warning: Invalid argument supplied for foreach() in /home/dolph824/public_html/secure/machform/includes/post-functions.php on line 2894
   SQL: [80] INSERT INTO ap_form_14150() SELECT from ap_form_14150_review 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'

   The mobile site (http://m.dolphinshuttle.com) uses the simple link code. The form IS NOT embedded using any of the other code options).
   My client is upset. Please help.

   UPDATE: This error is happening on all the MachForms that are on the site and being accessed by a mobile device:
   * FORM #1 https://www.dolphinshuttle.com/secure/machform/view.php?id=10310 (upgraded from MachForm 3)
   * FORM #2 https://www.dolphinshuttle.com/secure/machform/view.php?id=10868 (upgraded from MachForm 3)
   * FORM #3 https://www.dolphinshuttle.com/secure/machform/view.php?id=13537 (upgraded from MachForm 3)
   * FORM #4 https://www.dolphinshuttle.com/secure/machform/view.php?id=14868 (created new in Machform 4)

   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.

   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.

   Posted 9 years ago #

RSS feed for this topic

Reply

You must log in to post.