How to configure the Form Tabs widget and avoid "MysQL Gone Away" error

  • ninjaforms
    Asked on April 24, 2015 at 11:49 AM

    Hi we are getting MysQL Gone Away Error. error. I have already contacted you, and got a response that the problem is caused by our script. So I contacted the developer and he said that we have no database on our end. There is no SQL on our end.

    I am not able to access the my original post, so I am copying all info here.

     

    This is the response I got from you:

    I believe this is more related to your query, please check your PHP script. It seems like the connection in your database when running the PHP script closes, you can check this documentation on what that error might be related to: MysQL Gone Away Error.

    Here's our guide in for sending POST data to your MySQL database: http://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP.

    Do let us know if you need more help on this.

    Kind regards.

     

    This is what my developer sent me:

     

    We’re not running any sql queries in the pdf generation code I’ve written for smartsealed. There are no databases: 
     
    1. We receive POST data from jotform.
    2. We put that data into a flat file so we can refer to it later or regenerate it if needed.
    3. We use the data to generate html which is pdf compliant.
    4. We send that html to docraptor, who generates a pdf.
    5. We put the pdf in Google Drive.
    6. We send an e-mail.
     
     
  • Jeanette JotForm Support
    Replied on April 24, 2015 at 2:06 PM

    The problem was caused due to a misconfiguration of the Form Tabs widget

     How to configure the Form Tabs widget and avoid MysQL Gone Away error Image 1 Screenshot 40

    I went to inspect the form and in fact, the tabs were not defined correctly, you should not separate the title of the tabs with commas: How to configure the Form Tabs widget and avoid MysQL Gone Away error Image 2 Screenshot 51

     

    Just place them in order without the commas and that should be it.

     How to configure the Form Tabs widget and avoid MysQL Gone Away error Image 3 Screenshot 62

     

    Here is my clone with a working form tabs widget:

    http://form.jotformpro.com/form/51135079605958

     

  • dkinney
    Replied on April 28, 2015 at 12:54 PM

    Hi, I have first changed the tab gadget the way you suggested, then I have removed it completely from the form, but the problem is still there. Could you please take a look now (the gadget is removed) and see maybe something else is causing the problem. Thanks.

  • Jeanette JotForm Support
    Replied on April 28, 2015 at 2:39 PM

    I think it would be easier for you to clone my form:

    http://form.jotformpro.com/form/51135079605958

     

     Here is a guide to CLONE A FORM

    You would need to modify the URL in the thank you page, which still shows the original link:

     

  • dkinney
    Replied on April 28, 2015 at 4:25 PM

    If we clone the form, we will have to re-connect the script, and our developer is not available at the moment, so fixing existing form would be preferable. Or at least if you could explain what is causing the problem. Thanks.

  • Jeanette JotForm Support
    Replied on April 28, 2015 at 7:35 PM

    I have moved the form to your account http://www.jotformpro.com/form/51135079605958

    Now, you only need to re-build the integration with google drive. Here is a guide to do it. When you finish let me know, so I can update the link in the autoresponder that will be sent to the submitter.

    You open it on edit mode. Simply click on My Forms, find  the form "SmartSealed Proposal Tool Final- New", which is the one I moved and click on Edit Form

     How to configure the Form Tabs widget and avoid MysQL Gone Away error Image 1 Screenshot 20

    Now, follow this guide to integrated with Google Drive.

    https://www.jotform.com/help/192-How-to-Integrate-a-Form-with-Google-Drive

    When you are done, then let me know and we or your IT person can update the link in the autoresponder.

     

  • dkinney
    Replied on May 1, 2015 at 11:01 AM

    Thanks for your help, we have fixed the problem.