What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

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

    Asked by ninjaforms 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.
     
     
    Page URL:
    http://www.jotform.us/form/33234689232153

    MySQL gone away Form Tabs widget MySQL gone error
  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on April 24, 2015 at 02:06 PM

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

    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:

     

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

     

    Here is my clone with a working form tabs widget:

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

     

  • Profile Image

    Answered by dkinney 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.

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on April 28, 2015 at 02: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:

     

  • Profile Image

    Answered by dkinney on April 28, 2015 at 04: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.

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on April 28, 2015 at 07: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

    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.

     

  • Profile Image

    Answered by dkinney on May 01, 2015 at 11:01 AM

    Thanks for your help, we have fixed the problem.