Warning: MySQL server has gone away query:INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname,

How to handle this error:

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp)

VALUES (1, 'php', '<em>MySQL server has gone away\nquery: UPDATE cache SET data =&amp;#039;a:4....

in C:\xampp\htdocs\studentindia\includes\database.mysql.inc on line 172

Solution:

The error is because max packet allowed by mysql has been exceeded.You need to change it.This generally happens whan the table size becomes very large. Therefore, do the following to solve it:

i) Go to xampp\mysql\bin

ii) open my.cnf

iii)change the Max packet Allowed = 64M instead of 8M.

 

Help - Warning: MySQL server has gone away query: INSERT INTO

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>Lost connection to MySQL server during query\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, &amp;#039;xmlsitemap&amp;#039;, &amp;#039;Site map successfully submitted to Ask.com.&amp;#039;, 0, &amp;#039;&amp;#039;, &amp;#039;http://www.4nintendowii.com/home?destination=node%2F2&amp;#039;, &amp;#039;http://www.4nintendowii.com&amp;#039;, &amp;#039;192.197.82.153&amp;#039;, 1207835080)</em> in <em>/home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.4nintendowii.com/home?destination=node%2F2', 'http://www.4nintendowii.com', '192.197.82.153', 1207835080) in /home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>MySQL server has gone away\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, &amp;#039;xmlsitemap&amp;#039;, &amp;#039;Site map successfully submitted to Windows Live.&amp;#039;, 0, &amp;#039;&amp;#039;, &amp;#039;http://www.4nintendowii.com/home?destination=node%2F2&amp;#039;, &amp;#039;http://www.4nintendowii.com&amp;#039;, &amp;#039;192.197.82.153&amp;#039;, 1207835081)</em> in <em>/home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.4nintendowii.com/home?destination=node%2F2', 'http://www.4nintendowii.com', '192.197.82.153', 1207835081) in /home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>MySQL server has gone away\nquery: LOCK TABLES variable WRITE</em> in <em>/home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.4nintendowii.com/home?destination=node%2F2', 'http://www.4nintendowii.com', '192.197.82.153', 1207835081) in /home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>MySQL server has gone away\nquery: DELETE FROM variable WHERE name = &amp;#039;xmlsitemap_changed&amp;#039;</em> in <em>/home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.4nintendowii.com/home?destination=node%2F2', 'http://www.4nintendowii.com', '192.197.82.153', 1207835081) in /home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>MySQL server has gone away\nquery: INSERT INTO variable (name, value) VALUES (&amp;#039;xmlsitemap_changed&amp;#039;, &amp;#039;b:0;&amp;#039;)</em> in <em>/home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.4nintendowii.com/home?destination=node%2F2', 'http://www.4nintendowii.com', '192.197.82.153', 1207835081) in /home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>MySQL server has gone away\nquery: UNLOCK TABLES</em> in <em>/home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.4nintendowii.com/home?destination=node%2F2', 'http://www.4nintendowii.com', '192.197.82.153', 1207835081) in /home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>MySQL server has gone away\nquery: DELETE FROM cache WHERE cid = &amp;#039;variables&amp;#039;</em> in <em>/home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.4nintendowii.com/home?destination=node%2F2', 'http://www.4nintendowii.com', '192.197.82.153', 1207835081) in /home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>MySQL server has gone away\nquery: SELECT sid FROM sessions WHERE sid = &amp;#039;69dade067c6cc603808177e84d1306dc&amp;#039;</em> in <em>/home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.4nintendowii.com/home?destination=node%2F2', 'http://www.4nintendowii.com', '192.197.82.153', 1207835081) in /home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>MySQL server has gone away\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES (&amp;#039;69dade067c6cc603808177e84d1306dc&amp;#039;, 1, 0, &amp;#039;192.197.82.153&amp;#039;, &amp;#039;messages|a:1:{s:5:\\&amp;quot;error\\&amp;quot;;a:9:{i:0;s:228:\\&amp;quot;warning: Cannot modify header information - headers already sent by (output started at /home/content/k/i/n/kingbalou/html/wii/themes/sib/template.php:7) in /home/content/k/i/n/kingbalou/html/wii/includes/session.inc on line 100.\\&amp;quot;;i:1;s:247:\\&amp;quot;warning: session_regenerate_id(): Cannot send session cookie - headers already sent by (output started at /home/content/k/i/n/kingbalou/html/wii/themes/sib/template.php:7) in /home/content/k/i/n/kingbalou/html/wii/includes/session.inc on line 103.\\&am in /home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>Cannot modify header information - headers already sent by (output started at /home/content/k/i/n/kingbalou/html/wii/themes/sib/template.php:7)</em> in <em>/home/content/k/i/n/kingbalou/html/wii/includes/common.inc</em> on line <em>314</em>.', 2, '', 'http://www.4nintendowii.com/home?destination=node%2F2', 'http://www.4nintendowii.com', '192.197.82.153', 1207835081) in /home/content/k/i/n/kingbalou/html/wii/includes/database.mysql.inc on line 172

Please contact me :  demerm@gmail.com

Re: MySQL server has gone away query

I dont think that is the solution. Because my sql file size is only 52KB. I am still trying to figure out. So if anyone finds the answer pls email me at NQVU_2003@yahoo.com

Thank you very much

Re: MySQL server has gone away query

IF you have an access to php.ini you can add this line :

mysqli.reconnect = On