-
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.
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 SupportReplied on April 24, 2015 at 2: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
-
dkinneyReplied 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 SupportReplied 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:
-
dkinneyReplied 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 SupportReplied 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
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.
-
dkinneyReplied on May 1, 2015 at 11:01 AM
Thanks for your help, we have fixed the problem.