- ninjaformsAsked 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.
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.
- JotForm Support ManagerJeanetteAnswered 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:
- dkinneyAnswered 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.
- dkinneyAnswered 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.
- JotForm Support ManagerJeanetteAnswered 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.
When you are done, then let me know and we or your IT person can update the link in the autoresponder.
- dkinneyAnswered on May 01, 2015 at 11:01 AM
Thanks for your help, we have fixed the problem.