Announcement

Collapse
No announcement yet.

Error Codes

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

  • [Bug / Issue] Error Codes

    I recently moved server and keep getting a huge amount of error codes - can someone tell me how to fix them? Thanks

    Code:
    Database error in vBulletin 5.6.3:
    
                            Invalid SQL:
    SELECT * FROM closure
     WHERE `child` IN (24870)
     ORDER BY `child` ASC, `depth` ASC;
    
                            MySQL Error   : MySQL server has gone away
                            Error Number  : 2006
                            Request Date  : Wednesday, October 28th 2020 @ 09:15:08 AM
                            Error Date    : Wednesday, October 28th 2020 @ 09:15:16 AM
                            Script        : https://www.koboxingforum.com/forum/...-ready-to-lose
                            Referrer      :
                            IP Address    : 185.191.171.39
                            Username      : Guest
                            Classname     : vB_Database_MySQLi
                            MySQL Version :
    
    
    Stack Trace:
    #0 vB_Database->getErrorData() called in phar://[path]/vb/vb.phar/database.php on line 1207
    #1 vB_Database->halt() called in phar://[path]/vb/vb.phar/database/mysqli.php on line 249
    #2 vB_Database_MySQLi->execute_query() called in phar://[path]/vb/vb.phar/database.php on line 576
    #3 vB_Database->query_read() called in phar://[path]/vb/vb.phar/db/result.php on line 144
    #4 vB_dB_Result->rewind() called in phar://[path]/vb/vb.phar/db/result.php on line 68
    #5 vB_dB_Result->__construct() called in phar://[path]/vb/vb.phar/db/query/select.php on line 121
    #6 vB_dB_Query_Select->doSelect() called in phar://[path]/vb/vb.phar/db/query/select.php on line 98
    #7 vB_dB_Query_Select->execSQL() called in phar://[path]/vb/vb.phar/db/assertor.php on line 293
    #8 vB_dB_Assertor->assertQuery() called in phar://[path]/vb/vb.phar/library/node.php on line 3534
    #9 vB_Library_Node->fetchClosureParent() called in phar://[path]/vb/vb.phar/library/content.php on line 3074
    #10 vB_Library_Content->assembleContent() called in phar://[path]/vb/vb.phar/library/content/text.php on line 1026
    #11 vB_Library_Content_Text->assembleContent() called in phar://[path]/vb/vb.phar/library/content.php on line 2569
    #12 vB_Library_Content->getFullContent() called in phar://[path]/vb/vb.phar/library/content/text.php on line 83
    #13 vB_Library_Content_Text->getFullContent() called in phar://[path]/vb/vb.phar/library/node.php on line 2350
    #14 vB_Library_Node->getNodeFullContent() called in phar://[path]/vb/vb.phar/api/node.php on line 1611
    #15 vB_Api_Node->getNodeFullContent() called in phar://[path]/vb/vb.phar/api/node.php on line 1586
    #16 vB_Api_Node->getNodeContent() called in phar://[path]/vb/vb.phar/api/wrapper.php on line 201
    #17 vB_Api_Wrapper->__call() called in /home/wwwkoboxingforum/public_html/includes/api/interface/collapsed.php on line 105
    #18 Api_Interface_Collapsed->callApi() called in /home/wwwkoboxingforum/public_html/includes/vb5/template/runtime.php on line 1070
    #19 vB5_Template_Runtime::parseDataWithErrors() called in /home/wwwkoboxingforum/public_html/includes/vb5/template.php(399) : eval()'d code on line 62
    #20 eval() called in /home/wwwkoboxingforum/public_html/includes/vb5/template.php on line 399
    #21 vB5_Template->render() called in /home/wwwkoboxingforum/public_html/includes/vb5/template/cache.php on line 134
    #22 vB5_Template_Cache->replacePlaceholders() called in /home/wwwkoboxingforum/public_html/includes/vb5/template.php on line 421
    #23 vB5_Template->render() called in /home/wwwkoboxingforum/public_html/includes/vb5/frontend/controller/page.php on line 274
    #24 vB5_Frontend_Controller_Page->index() called in /home/wwwkoboxingforum/public_html/index.php on line 74
    AND

    Code:
    Database error in vBulletin 5.6.3:
    
                            Invalid SQL:
    SELECT * FROM searchlog
     WHERE `searchlogid` = 12874382
     LIMIT 1;
    
                            MySQL Error   : MySQL server has gone away
                            Error Number  : 2006
                            Request Date  : Monday, October 26th 2020 @ 10:01:02 PM
                            Error Date    : Monday, October 26th 2020 @ 10:01:17 PM
                            Script        : https://www.koboxingforum.com/search...scalp%22%5D%7D
                            Referrer      :
                            IP Address    : 185.191.171.41
                            Username      : Guest
                            Classname     : vB_Database_MySQLi
                            MySQL Version :
    
    
    Stack Trace:
    #0 vB_Database->getErrorData() called in phar://[path]/vb/vb.phar/database.php on line 1207
    #1 vB_Database->halt() called in phar://[path]/vb/vb.phar/database/mysqli.php on line 249
    #2 vB_Database_MySQLi->execute_query() called in phar://[path]/vb/vb.phar/database.php on line 576
    #3 vB_Database->query_read() called in phar://[path]/vb/vb.phar/db/result.php on line 144
    #4 vB_dB_Result->rewind() called in phar://[path]/vb/vb.phar/db/result.php on line 68
    #5 vB_dB_Result->__construct() called in phar://[path]/vb/vb.phar/db/query/select.php on line 121
    #6 vB_dB_Query_Select->doSelect() called in phar://[path]/vb/vb.phar/db/query/select.php on line 98
    #7 vB_dB_Query_Select->execSQL() called in phar://[path]/vb/vb.phar/db/assertor.php on line 293
    #8 vB_dB_Assertor->assertQuery() called in phar://[path]/vb/vb.phar/db/assertor.php on line 617
    #9 vB_dB_Assertor->getRow() called in phar://[path]/vb/vb.phar/search/core.php on line 569
    #10 vB_Search_Core->getCache() called in phar://[path]/vb/vb.phar/api/search.php on line 682
    #11 vB_Api_Search->getMoreNodes() called in phar://[path]/vb/vb.phar/api/search.php on line 797
    #12 vB_Api_Search->getMoreResults() called in phar://[path]/vb/vb.phar/api/search.php on line 232
    #13 vB_Api_Search->getInitialResults() called in phar://[path]/vb/vb.phar/api/wrapper.php on line 201
    #14 vB_Api_Wrapper->__call() called in /home/wwwkoboxingforum/public_html/includes/api/interface/collapsed.php on line 105
    #15 Api_Interface_Collapsed->callApi() called in /home/wwwkoboxingforum/public_html/includes/vb5/template/runtime.php on line 1070
    #16 vB5_Template_Runtime::parseDataWithErrors() called in /home/wwwkoboxingforum/public_html/includes/vb5/template.php(399) : eval()'d code on line 51
    #17 eval() called in /home/wwwkoboxingforum/public_html/includes/vb5/template.php on line 399
    #18 vB5_Template->render() called in /home/wwwkoboxingforum/public_html/includes/vb5/template/cache.php on line 134
    #19 vB5_Template_Cache->replacePlaceholders() called in /home/wwwkoboxingforum/public_html/includes/vb5/template.php on line 421
    #20 vB5_Template->render() called in /home/wwwkoboxingforum/public_html/includes/vb5/template/cache.php on line 134
    #21 vB5_Template_Cache->replacePlaceholders() called in /home/wwwkoboxingforum/public_html/includes/vb5/template.php on line 421
    #22 vB5_Template->render() called in /home/wwwkoboxingforum/public_html/includes/vb5/template/cache.php on line 134
    #23 vB5_Template_Cache->replacePlaceholders() called in /home/wwwkoboxingforum/public_html/includes/vb5/template.php on line 421
    #24 vB5_Template->render() called in /home/wwwkoboxingforum/public_html/includes/vb5/template/cache.php on line 134
    #25 vB5_Template_Cache->replacePlaceholders() called in /home/wwwkoboxingforum/public_html/includes/vb5/template.php on line 421
    #26 vB5_Template->render() called in /home/wwwkoboxingforum/public_html/includes/vb5/frontend/controller/search.php on line 323
    #27 vB5_Frontend_Controller_Search->actionResult() called in /home/wwwkoboxingforum/public_html/includes/vb5/frontend/controller/search.php on line 343
    #28 vB5_Frontend_Controller_Search->results() called in /home/wwwkoboxingforum/public_html/index.php on line 74
    Ringnews24's KO Boxing Forum
    www.koboxingforum.com

    I'd like to thank all the staff and members who have helped me on the VBulletin help forum. The help so far has been much appreciated.

  • #2
    These mean that MySQL is closing the connection to your PHP app before returning a result. Most often this is caused by two reasons...

    1) The wait_timeout (and corresponding innodb_lock_wait_timeout) are set to less than 120 seconds.
    2) The max_allowed_packet is less than 4 Megabytes. 8 Megabytes is recommended here.

    This can also manifest because PHP doesn't have enough memory to actually process the query. It is recommend that you have PHP configured to use up to 128 Megabytes. Larger sites (millions of posts) may need more memory.

    You will need to consult with your hosting provider on how you can change these values. If this is an unmanaged server and you do not know how to make these changes, you will need to search the web for answers. Usually searching on the OS Name, Version and keywords like MySQL Configuration or PHP Configuration helps me find what I need.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    Related Topics

    Collapse

    Working...
    X