Main Menu

Đăng ký học joomla

Tin tức mới nhất

Thống kê truy cập

Truy cập trong ngày:	273
Truy cập hôm qua:	226
Tổng số truy cập:	620166

Đang online: 52 Khách

mysql server has gone away query insert into watchdog drupal

Khi chạy drupal, đôi khi do dữ liệu chứa web khá lớn nên rất hay gặp lỗi:

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'MySQL server has gone away\nquery: LOCK TABLES cache_page WRITE en la línea 172 del archivo /home/planetac/public_html/includes/database.mysql.inc.', 2, '', 'http://www.planetaconsorcio.com/', 'http://www.planetaconsorcio.com/user/76/edit', '200.122.115.187', 1204484718) in /home/planetac/public_html/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 (0, 'php', ' en la línea 172 del archivo /home/planetac/public_html/includes/database.mysql.inc.', 2, '', 'http://www.planetaconsorcio.com/', 'http://www.planetaconsorcio.com/user/76/edit', '200.122.115.187', 1204484718) in /home/planetac/public_html/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 (0, 'php', 'MySQL server has gone away\nquery: UNLOCK TABLES en la línea 172 del archivo /home/planetac/public_html/includes/database.mysql.inc.', 2, '', 'http://www.planetaconsorcio.com/', 'http://www.planetaconsorcio.com/user/76/edit', '200.122.115.187', 1204484718) in /home/planetac/public_html/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 (0, 'php', 'MySQL server has gone away\nquery: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values(&#039;&#039;, &#039;node&#039;, &#039;http://www.planetaconsorcio.com/user/76/edit&#039;, &#039;200.122.115.187&#039;, 0, &#039;aea730725310fbdd67b9355d86ed6513&#039;, 43293, 1204484718) en la línea 172 del archivo /home/planetac/public_html/includes/database.mysql.inc.', 2, '', 'http://www.planetaconsorcio.com/', 'http://www.planetaconsorcio.com/user/76/edit', '200.122.115.187', 1204484718) in /home/planetac/public_html/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 (0, 'php', 'MySQL server has gone away\nquery: SELECT sid FROM sessions WHERE sid = &#039;aea730725310fbdd67b9355d86ed6513&#039; en la línea 172 del archivo /home/planetac/public_html/includes/database.mysql.inc.', 2, '', 'http://www.planetaconsorcio.com/', 'http://www.planetaconsorcio.com/user/76/edit', '200.122.115.187', 1204484718) in /home/planetac/public_html/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 (0, 'php', 'MySQL server has gone away\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES (&#039;aea730725310fbdd67b9355d86ed6513&#039;, 0, 0, &#039;200.122.115.187&#039;, &#039;messages|a:1:{s:5:\\&quot;error\\&quot;;a:4:{i:0;s:147:\\&quot;user warning: MySQL server has gone away\\nquery: LOCK TABLES cache_page WRITE in /home/planetac/public_html/includes/database.mysql.inc on line 172.\\&quot;;i:1;s:85:\\&quot;user warning: in /home/planetac/public_html/includes/database.mysql.inc on line 172.\\&quot;;i:2;s:132:\\&quot;user warning: MySQL server has gone away\\nquery: UNLOCK TABLES in /home/planetac/public_html/includes/database.mysql.inc on line 172.\\&quot;;i:3;s:391:\\&quot;user warning: MySQL server in /home/planetac/public_html/includes/database.mysql.inc on line 172

Để fix lỗi này, bạn mở file my.ini trong thư mục mysql/bin/my.ini ở trong xampp, sau đó search dòng max_allowed_packet và thay đổi giá trị mặc định (là 1MB) thành 200MB. Sau đó khởi động lại Xampp và reload lại trang là ok.

Chúc các bạn thành công!