Author Topic: database error  (Read 866 times)

Offline HADY

  • Full Member
  • ***
  • Posts: 222
  • Karma: +18/-4
    • View Profile
database error
« 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
« Last Edit: December 11, 2019, 10:02:22 AM by HADY »
-----------------------------
Regards
HADY

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 4867
  • Karma: +254/-2
    • View Profile
Re: database error
« Reply #1 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

Offline HADY

  • Full Member
  • ***
  • Posts: 222
  • Karma: +18/-4
    • View Profile
Re: database error
« Reply #2 on: December 12, 2019, 02:22:05 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
-----------------------------
Regards
HADY

Offline HADY

  • Full Member
  • ***
  • Posts: 222
  • Karma: +18/-4
    • View Profile
Re: database error
« Reply #3 on: May 31, 2021, 07:15:29 AM »
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
-----------------------------
Regards
HADY

Offline maxter

  • Full Member
  • ***
  • Posts: 209
  • Karma: +64/-0
    • View Profile
Re: database error
« Reply #4 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.

Offline HADY

  • Full Member
  • ***
  • Posts: 222
  • Karma: +18/-4
    • View Profile
Re: database error
« Reply #5 on: May 31, 2021, 10:19:54 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.
-----------------------------
Regards
HADY

 

Powered by SMFPacks Social Login Mod