[Bug / Issue] Data base Errors MySQL repetative

[ienajah.com]

hi

I'm receiving this errors weekly 2 or three times, please help in providing solutions.

Database error in vBulletin 5.4.1:

           Invalid SQL:
INSERT  IGNORE  INTO session (`sessionhash`,`userid`,`host`,`idhash`,`lastactivity`,`location`,`styleid`,`languageid`,`loggedin`,`inforum`,`inthread`,`incalendar`,`badlocation`,`useragent`,`bypass`,`profileupdate`,`apiclientid`,`apiaccesstoken`,`emailstamp`)
           VALUES('5ef1a31a4541c765d07a420dbc7dcf98',0,'103.20.249.53','3c35e13e466439e1f135f5d7d7dc2825',1527394901,'',21,2,0,0,0,0,0,'vBulletin',0,0,0,'',0)
/**session**/;

           MySQL Error   : MySQL server has gone away
           Error Number  : 2006
           Request Date  : Sunday, May 27th 2018 @ 12:21:41 AM
           Error Date    : Sunday, May 27th 2018 @ 12:26:49 AM
           Script        : https://www.ienajah.com/vb/
           Referrer      : 
           IP Address    : 103.20.249.53
           Username      : ضيف
           Classname     : vB_Database_MySQLi
           MySQL Version : 


Stack Trace:
#0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1188
#1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201
#2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 542
#3 vB_Database->query_write() called in [path]/vb/db/query/insertignore.php on line 88
#4 vB_dB_Query_InsertIgnore->doInserts() called in [path]/vb/db/query/insert.php on line 98
#5 vB_dB_Query_Insert->execSQL() called in [path]/vb/db/assertor.php on line 304
#6 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 476
#7 vB_dB_Assertor->insertIgnore() called in [path]/vb/session.php on line 550
#8 vB_Session->save() called in [path]/vb/shutdown.php on line 86
#9 vB_Shutdown->shutdown() called in [path]/vb/vb.php on line 486
#10 vB::shutdown() called in  on line 

Database error in vBulletin 5.4.1:

           Invalid SQL:
INSERT  IGNORE  INTO session (`sessionhash`,`userid`,`host`,`idhash`,`lastactivity`,`location`,`styleid`,`languageid`,`loggedin`,`inforum`,`inthread`,`incalendar`,`badlocation`,`useragent`,`bypass`,`profileupdate`,`apiclientid`,`apiaccesstoken`,`emailstamp`)
           VALUES('488e4db2c1e8b87a3246c641a8208452',0,'113.83.194.91','92434f52a32d4939932253486e12576c',1526735099,'',21,2,0,0,0,0,0,'Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko',0,0,0,'',0)
/**session**/;

           MySQL Error   : MySQL server has gone away
           Error Number  : 2006
           Request Date  : Saturday, May 19th 2018 @ 09:04:59 AM
           Error Date    : Saturday, May 19th 2018 @ 09:10:01 AM
           Script        : https://www.ienajah.com/vb/
           Referrer      : 
           IP Address    : 113.83.194.91
           Username      : ضيف
           Classname     : vB_Database_MySQLi
           MySQL Version : 


Stack Trace:
#0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1188
#1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201
#2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 542
#3 vB_Database->query_write() called in [path]/vb/db/query/insertignore.php on line 88
#4 vB_dB_Query_InsertIgnore->doInserts() called in [path]/vb/db/query/insert.php on line 98
#5 vB_dB_Query_Insert->execSQL() called in [path]/vb/db/assertor.php on line 304
#6 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 476
#7 vB_dB_Assertor->insertIgnore() called in [path]/vb/session.php on line 550
#8 vB_Session->save() called in [path]/vb/shutdown.php on line 86
#9 vB_Shutdown->shutdown() called in [path]/vb/vb.php on line 486
#10 vB::shutdown() called in  on lin 

and the below errors one time so far

Database error in vBulletin 5.4.1:

           Invalid SQL:
INSERT INTO searchtowords_p (`nodeid`,`wordid`,`is_title`,`score`,`position`) VALUES (173818,48374,0,10000,8)
/**searchtowords_p**/;

           MySQL Error   : Duplicate entry '48374-173818' for key 'wordid'
           Error Number  : 1062
           Request Date  : Friday, May 25th 2018 @ 03:15:23 PM
           Error Date    : Friday, May 25th 2018 @ 03:16:16 PM
           Script        : https://www.ienajah.com/vb/create-content/Text/
           Referrer      : https://www.ienajah.com/vb/forum/industrial-engineering-fields-%D9%85%D8%AC%D8%A7%D9%84%D8%A7%D8%AA-%D8%A7%D9%84%D9%87%D9%86%D8%AF%D8%B3%D8%A9-%D8%A7%D9%84%D8%B5%D9%86%D8%A7%D8%B9%D9%8A%D8%A9/safety-ergonomics-%D8%A7%D9%84%D8%B3%D9%84%D8%A7%D9%85%D8%A9-%D9%88%D8%A7%D9%84%D8%B9%D9%88%D8%A7%D9%85%D9%84-%D8%A7%D9%84%D8%A7%D9%86%D8%B3%D8%A7%D9%86%D9%8A%D8%A9/173818-%D8%B4%D8%B1%D8%AD-%D9%83%D8%A7%D9%85%D9%84-%D9%88%D8%A7%D9%81%D9%8A-%D8%B9%D9%86-%D8%A7%D9%84%D8%B3%D9%84%D8%A7%D9%85%D8%A9-%D8%A7%D9%84%D9%85%D9%87%D9%86%D9%8A%D8%A9-occupational-safety
           IP Address    : 92.99.214.152
           Username      : HaMooooDi
           Classname     : vB_Database_MySQLi
           MySQL Version : 5.6.39-cll-lve


Stack Trace:
#0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1188
#1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201
#2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 542
#3 vB_Database->query_write() called in [path]/vb/db/query/multipleinsert.php on line 114
#4 vB_dB_Query_MultipleInsert->doMultipleInserts() called in [path]/vb/db/query/multipleinsert.php on line 89
#5 vB_dB_Query_MultipleInsert->execSQL() called in [path]/vb/db/assertor.php on line 304
#6 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 519
#7 vB_dB_Assertor->insertMultiple() called in [path]/packages/vbdbsearch/core.php on line 161
#8 vBDBSearch_Core->indexText() called in [path]/vb/search/core.php on line 118
#9 vB_Search_Core->index() called in [path]/vb/library/search.php on line 42
#10 vB_Library_Search->index() called in [path]/vb/library/content.php on line 2118
#11 vB_Library_Content->update() called in [path]/vb/library/content/text.php on line 471
#12 vB_Library_Content_Text->update() called in [path]/vb/api/content.php on line 421
#13 vB_Api_Content->update() called in [path]/vb/api/content/text.php on line 295
#14 vB_Api_Content_Text->update() called in  on line 
#15 call_user_func_array() called in [path]/vb/api/wrapper.php on line 199
#16 vB_Api_Wrapper->__call() called in  on line 
#17 vB_Api_Wrapper->update() called in  on line 

and

Database error in vBulletin 5.4.1:

           Invalid SQL:
SELECT * FROM routenew
WHERE `prefix` IN ('forum/المنتديات-الترفيهية/استراحة-الاعضاء/59236-إسرائيل-تستهدف-المسرح-العربي-بحيفا','forum/المنتديات-الترفيهية/استراحة-الاعضاء','forum/المنتديات-الترفيهية','forum');

           MySQL Error   : Illegal mix of collations for operation ' IN '
           Error Number  : 1271
           Request Date  : Wednesday, May 23rd 2018 @ 03:07:27 AM
           Error Date    : Wednesday, May 23rd 2018 @ 03:07:27 AM
           Script        : https://www.ienajah.com/vb/forum/%D8%A7%D9%84%D9%85%D9%86%D8%AA%D8%AF%D9%8A%D8%A7%D8%AA-%D8%A7%D9%84%D8%AA%D8%B1%D9%81%D9%8A%D9%87%D9%8A%D8%A9/%D8%A7%D8%B3%D8%AA%D8%B1%D8%A7%D8%AD%D8%A9-%D8%A7%D9%84%D8%A7%D8%B9%D8%B6%D8%A7%D8%A1/59236-%D8%A5%D8%B3%D8%B1%D8%A7%D8%A6%D9%8A%D9%84-%D8%AA%D8%B3%D8%AA%D9%87%D8%AF%D9%81-%D8%A7%D9%84%D9%85%D8%B3%D8%B1%D8%AD-%D8%A7%D9%84%D8%B9%D8%B1%D8%A8%D9%8A-%D8%A8%D8%AD%D9%8A%D9%81%D8%A7
           Referrer      : 
           IP Address    : 66.249.66.208
           Username      : ضيف
           Classname     : vB_Database_MySQLi
           MySQL Version : 


Stack Trace:
#0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1188
#1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201
#2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 557
#3 vB_Database->query_read() called in [path]/vb/db/result.php on line 126
#4 vB_dB_Result->rewind() called in [path]/vb/db/result.php on line 63
#5 vB_dB_Result->__construct() called in [path]/vb/db/query/select.php on line 121
#6 vB_dB_Query_Select->doSelect() called in [path]/vb/db/query/select.php on line 98
#7 vB_dB_Query_Select->execSQL() called in [path]/vb/db/assertor.php on line 304
#8 vB_dB_Assertor->assertQuery() called in [path]/vb/api/route.php on line 153
#9 vB_Api_Route->getRoute() called in  on line 
#10 call_user_func_array() called in [path]/vb/api/wrapper.php on line 199
#11 vB_Api_Wrapper->__call() called in  on line 
#12 vB_Api_Wrapper->getRoute() called in  on line 

and

[Wayne Luke]

Not sure why the first two errors happened. Unless your database was overwhelmed and simply couldn't run the query before the wait_timeout value expired. By default this value is 86400 seconds or one day.

The third is the system trying to reindex the same topic for some reason.

The fourth is because you have different collations on your tables. All of them should be the same collation.