Announcement

Collapse
No announcement yet.

Data base Errors MySQL repetative

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Wayne Luke
    replied
    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.

    Leave a comment:


  • Eng.mohd.badawi
    started a topic [Bug / Issue] Data base Errors MySQL repetative

    Data base Errors MySQL repetative

    hi

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

    PHP Code:
    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  
    SundayMay 27th 2018 12:21:41 AM
               Error Date    
    SundayMay 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 
    PHP Code:
    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  
    SaturdayMay 19th 2018 @ 09:04:59 AM
               Error Date    
    SaturdayMay 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

    PHP Code:
    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  
    FridayMay 25th 2018 03:15:23 PM
               Error Date    
    FridayMay 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

    PHP Code:
    Database error in vBulletin 5.4.1:

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

               
    MySQL Error   Illegal mix of collations for operation ' IN '
               
    Error Number  1271
               Request Date  
    WednesdayMay 23rd 2018 03:07:27 AM
               Error Date    
    WednesdayMay 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

Related Topics

Collapse

Working...
X