News:

AbanteCart v1.4.2 is released.

Main Menu

Do you like AbanteCart? Please rate AbanteCart or share your experience with other eCommerce entrepreneurs. Go to Softaculous rating page to add your rating or write a review

database error

Started by HADY, December 11, 2019, 10:00:36 AM

Previous topic - Next topic

HADY

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
Thank you In Advanced
Regards
HADY

Basara

Hello.
Contact your hosting provider
"MySQL server has gone away" is error related to your database connection

HADY

Quote from: Basara on December 12, 2019, 12:33:50 AM
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
Thank you In Advanced
Regards
HADY

HADY

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
Thank you In Advanced
Regards
HADY

maxter

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.

HADY

Quote from: maxter on May 31, 2021, 08:35:38 AM
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.
Thank you In Advanced
Regards
HADY

Forum Rules Code of conduct
AbanteCart.com 2010 -