AbanteCart Community
Shopping Cart Operations => Support => Topic started by: HADY on December 11, 2019, 10:00:36 AM
-
Hello!
since 2 days I see this error, can you tell me what is that means and what I have to to do to fix it please??
2019-12-11 17:54:51 - database error: AbanteCart core v.1.2.15 SQL Error: MySQL server has gone away
Error No: 2006
SQL: SELECT p.product_id,
p.subtract,
SUM(COALESCE(pov.subtract,0)) as option_subtract,
p.quantity,
SUM(COALESCE(pov.quantity,0)) as option_quantity
FROM ac_products p
LEFT JOIN ac_product_options po
ON (po.product_id = p.product_id AND po.status = 1)
LEFT JOIN ac_product_option_values pov
ON (po.product_option_id = pov.product_option_id)
WHERE p.product_id IN (698, 33, 51, 1, 49, 2, 44, 14, 54, 21, 6, 17, 30, 100, 12, 59, 13, 57, 23, 36, 413, 463, 456, 50, 678, 330, 408, 404, 537, 376, 403, 367, 38, 65, 614, 45, 464, 326, 737, 470, 579, 556, 402, 480, 685, 29, 483, 481, 424, 432, 543, 101, 686, 474, 416, 538, 406, 52, 798, 11, 391, 380, 387, 58, 467, 534, 425, 356, 369, 593, 371, 334, 393, 683, 498, 608, 390, 558, 318, 62, 540, 42, 27, 331, 60, 16, 63, 355, 47, 582, 580, 493, 389, 710, 427, 719, 702, 680, 316, 705, 363, 706, 440, 541, 679, 435, 701, 321, 707, 323, 783, 792, 784, 793, 785, 794, 780, 739, 394, 778)
GROUP BY p.product_id in <b>public_html/core/database/amysqli.php</b> on line <b>114</b>
your answers very important to me
Thanks in advance
HADI
-
Hello.
Contact your hosting provider
"MySQL server has gone away" is error related to your database connection
-
Hello.
Contact your hosting provider
"MySQL server has gone away" is error related to your database connection
Thank you for support my friend.
I increased the time out for now. i need to be sure if its working before contacting hosting co
Regards
HADI
-
hello!
from time to time we see this error log. I know this is something related to hosting services but, can you explain us what is the reason behind such error please?
Thanks
-
There is no straight answer to your error. It could be caused by many different things:
Read here https://dev.mysql.com/doc/refman/8.0/en/gone-away.html or select a correct version of your Mysql.
Your database server drops the connection.
-
There is no straight answer to your error. It could be caused by many different things:
Read here https://dev.mysql.com/doc/refman/8.0/en/gone-away.html or select a correct version of your Mysql.
Your database server drops the connection.
Noted...
Thanks.