https://legacy.forums.gravityhelp.com/tags/mysql Gravity Support Forums Tag: MySQL - Recent Posts en-US Sun, 19 Apr 2026 16:34:37 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/gravity-forms-on-install-wordpress-database-error-mysql-has-gone-away#post-370085 Tue, 09 Jul 2013 03:32:17 +0000 Richard Vav 370085@https://legacy.forums.gravityhelp.com/ <p>I am glad you have found a workaround. </p> https://legacy.forums.gravityhelp.com/topic/gravity-forms-on-install-wordpress-database-error-mysql-has-gone-away#post-370013 Tue, 09 Jul 2013 03:07:17 +0000 rysen2888 370013@https://legacy.forums.gravityhelp.com/ <p>I installed wordpress database ping plugin and it seems to have stopped it for now. </p> https://legacy.forums.gravityhelp.com/topic/gravity-forms-on-install-wordpress-database-error-mysql-has-gone-away#post-367482 Mon, 08 Jul 2013 03:21:37 +0000 Richard Vav 367482@https://legacy.forums.gravityhelp.com/ <p>You might try <a href="http://www.techmesto.com/solving-wordpress-mysql-gone-error/" rel="nofollow">http://www.techmesto.com/solving-wordpress-mysql-gone-error/</a> </p> https://legacy.forums.gravityhelp.com/topic/gravity-forms-on-install-wordpress-database-error-mysql-has-gone-away#post-367429 Mon, 08 Jul 2013 02:45:09 +0000 rysen2888 367429@https://legacy.forums.gravityhelp.com/ <p>Oh okay thanks.</p> <p>Spoke to host and they said that there is nothing wrong with the mysql on their end</p> <p>Do you have any other alternate solutions to fix the issue</p> <p>Thanks </p> https://legacy.forums.gravityhelp.com/topic/gravity-forms-on-install-wordpress-database-error-mysql-has-gone-away#post-362703 Fri, 05 Jul 2013 03:00:06 +0000 Richard Vav 362703@https://legacy.forums.gravityhelp.com/ <p>Hi,</p> <p>Sorry to hear about your problem, unfortunately those errors are beyond Gravity Forms control.<br /> <pre><code>WordPress database error: [MySQL server has gone away]</code></pre> <p>WordPress is having problems connecting to the MySQL host, that is something only your web host can help you resolve.</p> <p>Regards,<br /> Richard </p> https://legacy.forums.gravityhelp.com/topic/gravity-forms-on-install-wordpress-database-error-mysql-has-gone-away#post-362146 Thu, 04 Jul 2013 21:10:11 +0000 rysen2888 362146@https://legacy.forums.gravityhelp.com/ <p>Hi</p> <p>I just tried installing gravity forms, but once i clicked activate i got Wordpress database error: mysql has gone away.</p> <p>I then click on pages, and everything is gone. I have to delete the plugin to see the pages/posts again and it really makes admin slow down and lag</p> <p>Here is a screenshot for the error.<br /> <a href="http://i.imgur.com/6S0wgqk.png" rel="nofollow">http://i.imgur.com/6S0wgqk.png</a></p> <p>Ive tried deleting and reinstalling, tho the error isnt showing anymore but it still removes all posts/pages until i re delete the plugin.</p> <p>Any help much appreciated<br /> Thanks </p> https://legacy.forums.gravityhelp.com/topic/using-mysqli_real_escape_string-with-gform_after_submission-and-a-mysql-database#post-360257 Wed, 03 Jul 2013 15:22:25 +0000 Richard Vav 360257@https://legacy.forums.gravityhelp.com/ <p>Andrew, thanks for sharing. </p> https://legacy.forums.gravityhelp.com/topic/using-mysqli_real_escape_string-with-gform_after_submission-and-a-mysql-database#post-360247 Wed, 03 Jul 2013 15:20:31 +0000 andrew carbn 360247@https://legacy.forums.gravityhelp.com/ <p>For anybody who is interested, here is the final code which is tested and working:</p> <p>ORIGINAL EXAMPLE CODE:<br /> *************************************************************************************<br /> add_action("gform_after_submission_1", "push_fields", 10, 2);<br /> function push_fields($entry, $form){</p> <p>$uploaderName = $entry["1"];<br /> $venueName = $entry["2"];<br /> $uploaderEmail = $entry["3"];</p> <p>$con=mysqli_connect("$DB_HOST","$DB_USER","$DB_PASSWORD","$DB_NAME");<br /> mysqli_query($con,"INSERT INTO $TABLE_NAME<br /> (uploaderName, venueName, uploaderEmail)<br /> VALUES<br /> ('$uploaderName', '$venueName', '$uploaderEmail')");<br /> }<br /> *************************************************************************************</p> <p>NEW CODE USING mysqli_real_escape_string via $wpdb:<br /> !!!!! Note re-ordering of SQL login details in line 9 below !!!!!!<br /> !!!!! DO NOT add or remove any double or single quotes !!!!!!<br /> *************************************************************************************<br /> add_action("gform_after_submission_1", "push_fields", 10, 2);<br /> function push_fields($entry, $form){</p> <p>$uploaderName = $entry["1"];<br /> $venueName = $entry["2"];<br /> $uploaderEmail = $entry["3"];</p> <p>global $wpdb;<br /> $con = new wpdb ("$DB_USER", "$DB_PASSWORD", "$DB_NAME", "$DB_HOST");<br /> $con-&gt;show_errors();<br /> $con-&gt;INSERT('$TABLE_NAME',<br /> array(<br /> 'uploaderName'=&gt;$uploaderName,<br /> 'venueName'=&gt;$venueName,<br /> 'uploaderEmail'=&gt;$uploaderEmail,<br /> ),<br /> array(<br /> '%s','%s','%s'<br /> )<br /> );<br /> }<br /> ************************************************************************************* </p> https://legacy.forums.gravityhelp.com/topic/using-mysqli_real_escape_string-with-gform_after_submission-and-a-mysql-database#post-344251 Tue, 25 Jun 2013 12:15:45 +0000 Alex Cancado 344251@https://legacy.forums.gravityhelp.com/ <p>It is because that method will do the escaping for you. As long as you are using the methods from $wpdb, you don't have to worry about escaping. That is the beauty of it. </p> https://legacy.forums.gravityhelp.com/topic/using-mysqli_real_escape_string-with-gform_after_submission-and-a-mysql-database#post-344190 Tue, 25 Jun 2013 11:22:52 +0000 andrew carbn 344190@https://legacy.forums.gravityhelp.com/ <p>Thanks.<br /> I've had a look at that page and something is not making sense to me.<br /> Under the section "INSERT rows" is says "Both $data columns and $data values should be "raw" (neither should be SQL escaped)."<br /> Is this because I am "inserting" data, and the danger is only when I am "querying" the data? </p>