General error: 2006 MySQL server has gone away

[aiswarjya]

How to fix it

2016-05-03 4:37:34 - : AbanteCart core v.1.2.6 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>52</b>

[abantecart]

This indicates that connection to your Mysql server closed in the middle of execution.
This can be one time issue as Mysql server was restarted or lost connection. If this persists, check your Mysql server.

[aiswarjya]

This type of error are always come & site is slow

i found this error

2016-05-05 7:21:13 - : AbanteCart core v.1.2.6 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>52</b>
2016-05-05 7:21:13 - : AbanteCart core v.1.2.6 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>52</b>
2016-05-05 8:50:03 - Error: EHLO not accepted from server!
2016-05-05 8:50:03 - Error: AUTH LOGIN not accepted from server!
2016-05-05 8:50:03 - Error: Username not accepted from server!
2016-05-05 8:50:03 - Error: Password not accepted from server!
2016-05-05 8:50:03 - Error: MAIL FROM not accepted from server!
2016-05-05 8:50:03 - Error: RCPT TO not accepted from server!
2016-05-05 8:50:03 - Error: DATA not accepted from server!
2016-05-05 8:50:03 - Error: QUIT not accepted from server!
2016-05-05 11:39:58 - : AbanteCart core v.1.2.6 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>52</b>
2016-05-05 17:54:56 - : AbanteCart core v.1.2.6 SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>52</b>
2016-05-05 17:55:19 - : AbanteCart core v.1.2.6 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>52</b>
2016-05-05 17:55:19 - : AbanteCart core v.1.2.6 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>52</b>
2016-05-05 17:55:20 - : AbanteCart core v.1.2.6 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>52</b>

[Basara]

Hello
Try to change timeout in your php.ini or better to ask help hosting support

Code: [Select]

ini_set('mysql.connect_timeout', 300);
ini_set('default_socket_timeout', 300);

[aiswarjya]

i put this on php.ini file

ini_set('mysql.connect_timeout', 30000);
ini_set('default_socket_timeout', 30000);

Now i get this error

2016-05-07 6:58:44 - : AbanteCart core v.1.2.6 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>52</b>
2016-05-07 6:59:01 - : AbanteCart core v.1.2.6 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>52</b>
2016-05-07 7:00:16 - App Error: AbanteCart core v.1.2.6 0 in /home/site/public_html/site.com/core/database/apdomysql.php on line 75
2016-05-07 7:00:16 - database error: AbanteCart core v.1.2.6 Error: SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query
Error No: HY000
SELECT DISTINCT p.manufacturer_id, m.name
FROM ac_products p
LEFT JOIN ac_manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM ac_products_to_categories p2c
INNER JOIN ac_products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (65, 386, 456)); in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>78</b>
2016-05-07 7:00:17 - : AbanteCart core v.1.2.6 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>52</b>
2016-05-07 7:00:17 - : AbanteCart core v.1.2.6 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>52</b>
2016-05-07 7:00:17 - : AbanteCart core v.1.2.6 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>52</b>
2016-05-07 7:03:34 - : AbanteCart core v.1.2.6 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>52</b>
2016-05-07 7:03:34 - : AbanteCart core v.1.2.6 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>52</b>
2016-05-07 7:03:34 - : AbanteCart core v.1.2.6 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>52</b>
2016-05-07 7:03:34 - warning: AbanteCart core v.1.2.6 unlink(/home/site/public_html/site.com/system/cache/product/product.rating.1993.1462604481): No such file or directory in <b>/home/site/public_html/site.com/core/lib/cache.php</b> on line <b>332</b>
2016-05-07 7:03:34 - warning: AbanteCart core v.1.2.6 unlink(/home/site/public_html/site.com/system/cache/product/product.rating.1993.1462604481): No such file or directory in <b>/home/site/public_html/site.com/core/lib/cache.php</b> on line <b>332</b>
2016-05-07 7:04:11 - : AbanteCart core v.1.2.6 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in <b>/home/site/public_html/site.com/core/database/apdomysql.php</b> on line <b>52</b>

I check this one manually its work fine

SELECT DISTINCT p.manufacturer_id, m.name
FROM ac_products p
LEFT JOIN ac_manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM ac_products_to_categories p2c
INNER JOIN ac_products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (65, 386, 456));

If i open more then 10 pages another pages show "site is not working".

[Basara]

Please remove this lines if they not help you.

It is still looks like something wrong with your Mysql server . I suggest you to ask your hosting provider to help you find issue
or you can play with your mysql connection settings http://stackoverflow.com/questions/7942154/mysql-error-2006-mysql-server-has-gone-away