what's the wrong (Database error ...)

[ahmad]

Database error in vBulletin 5.5.6:

Invalid SQL:
/** saveDbCache */ SELECT * FROM cacheevent WHERE cacheid IN ('node_1262_lvl1data');

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, February 3rd 2020 @ 04:12:05 PM
Error Date : Monday, February 3rd 2020 @ 04:17:05 PM
Script : http://www.accesswordkingdome.com/fo.../fetch?id=1262
Referrer : http://www.accesswordkingdome.com/forum/node/1249
IP Address : 185.90.106.14
Username : ضيف
Classname : vB_Database_MySQLi
MySQL Version :


Stack Trace:
#0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1207
#1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 249
#2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 576
#3 vB_Database->query_read() called in [path]/vb/db/mysql/querydefs.php on line 7110
#4 vB_dB_MYSQL_QueryDefs->saveDbCache() called in [path]/vb/db/query/method.php on line 175
#5 vB_dB_Query_Method->execSQL() called in [path]/vb/db/assertor.php on line 301
#6 vB_dB_Assertor->assertQuery() called in [path]/vb/cache/db.php on line 387
#7 vB_Cache_Db->shutdown() called in [path]/vb/vb.php on line 478
#8 vB::shutdown() called in on line

[Wayne Luke]

The error means that MySQL closed the connection before returning the results of the query. There are a number of reasons that this can happen.

1. The MySQL max_allowed_packet value is too small. This should be at least four megabytes on modern servers.
2. The MySQL wait_timeout value is too small. This should be at least 120 seconds.
3. The MySQL innodb_lock_wait_timeout value is too small. This should be at least 120 seconds.
4. MySQL needs more memory allocated.

You may be able to stop the issue temporarily by running these queries:

truncate table cacheevent;
truncate table cache;

If you are storing attachments in the database, you should move these to the file system. To do this log into the AdminCP and go to Attachments -> Attachment Storage Type.