Database error in vBulletin 5.4.2: Invalid SQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rag_gupta
    Member
    • Apr 2011
    • 74

    [Bug / Issue] Database error in vBulletin 5.4.2: Invalid SQL

    Since last 3 days we are not able to create new posts:


    Database error in vBulletin 5.4.2:

    Invalid SQL:
    INSERT INTO closure (`parent`,`child`,`depth`,`publishdate`)
    VALUES(2249,2249,0,'1530094132')
    /**closure**/;

    MySQL Error : Duplicate entry '2249-2249' for key 'closure_uniq'
    Error Number : 1062
    Request Date : Wednesday, June 27th 2018 @ 03:38:52 PM
    Error Date : Wednesday, June 27th 2018 @ 03:38:52 PM
    Script : https://forum.bookrailticket.com/create-content/text/
    Referrer : https://forum.bookrailticket.com/new-content/62
    IP Address : 103.52.50.97
    Username : Book Rail Ticket
    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/insert.php on line 115
    #4 vB_dB_Query_Insert->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/library/content.php on line 663
    #7 vB_Library_Content->add() called in [path]/vb/library/content/attach.php on line 106
    #8 vB_Library_Content_Attach->add() called in [path]/vb/library/content/text.php on line 1097
    #9 vB_Library_Content_Text->handleAttachments() called in [path]/vb/library/content.php on line 767
    #10 vB_Library_Content->beforeCommit() called in [path]/vb/library/content/text.php on line 737
    #11 vB_Library_Content_Text->add() called in [path]/vb/api/content/text.php on line 204
    #12 vB_Api_Content_Text->add() called in [path]/vb/api/wrapper.php on line 199
    #13 vB_Api_Wrapper->__call() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/api/interface/collapsed.php on line 101
    #14 Api_Interface_Collapsed->callApi() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/frontend/controller/createcontent.php on line 420
    #15 vB5_Frontend_Controller_CreateContent->createNewNode() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/frontend/controller/createcontent.php on line 285
    #16 vB5_Frontend_Controller_CreateContent->actionTextNodeInternal() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/frontend/controller/createcontent.php on line 171
    #17 vB5_Frontend_Controller_CreateContent->index() called in /home/raggupta/public/forum.bookrailticket.com/public/index.php on line 74
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73981

    #2
    Did you change the auto-increment settings on the node table? They need to be higher than the max parent used in the closure table.

    Once you have a working system, you should not make changes to any auto-increment fields.
    Translations provided by Google.

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

    Comment

    • BirdOPrey5
      Senior Member
      • Jul 2008
      • 9613
      • 5.6.3

      #3
      Do you have a backup from before the error you can try restoring to? Make a backup of the current site too, just in case. If you manually edit the database you might get it to work but it might cause bigger issues down the line, it would be a last resort.

      Comment

      • rag_gupta
        Member
        • Apr 2011
        • 74

        #4
        I never made changes in this month or earlier. Moreover it is ported from Mybb 2 months back.
        I'll try to restore to version before this.

        Comment

        • rag_gupta
          Member
          • Apr 2011
          • 74

          #5
          Looks like some posts have also been removed. This is very risky and has never happened with my with any sites ever. Silently posts getting removed due to error.

          This url disappeared https://webcache.googleusercontent.c...&ct=clnk&gl=in
          Last edited by rag_gupta; Thu 28 Jun '18, 10:50pm.

          Comment

          • rag_gupta
            Member
            • Apr 2011
            • 74

            #6
            It seems I upgraded to the latest version on 2nd June, 2018. Since then this problem is coming. Please tell me what to do.
            I've even checked version of 12 days old. It's the same problem. Google has still the snapshot of old pages think those may come back.

            Waiting for your response.
            Attached Files

            Comment

            • BirdOPrey5
              Senior Member
              • Jul 2008
              • 9613
              • 5.6.3

              #7
              Well the ideal thing to do would be to restore to the backup from the day or several days before the error, but you will lose content made since.

              If that isn't possible because there is no recent backup then please open a support ticket in the Member's Area, please link to this topic and also include your forum Administrator username/passowrd and FTP or cPanel/Plesk details (if available) in the sensitive data field of the support ticket system.

              Please provide a list of all recent changes made and exact time you got the error(s).

              Comment

              • Wayne Luke
                vBulletin Technical Support Lead
                • Aug 2000
                • 73981

                #8
                Originally posted by rag_gupta
                Looks like some posts have also been removed. This is very risky and has never happened with my with any sites ever. Silently posts getting removed due to error.

                This url disappeared https://webcache.googleusercontent.c...&ct=clnk&gl=in
                There is no mechanism in the software that "silently" deletes content. Deleting content should not cause the error you're encountering because the software does not reuse IDs either. We rely on accurate Auto-increment values to maintain accurate IDs.

                You can look in the Moderator Log in the AdminCP to see who has deleted content. You should remove their permission to do so if you don't want people deleting content. However, this won't resolve the current issue which is something changed on the database so the Auto-increment is out of sync.
                Translations provided by Google.

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

                Comment

                • rag_gupta
                  Member
                  • Apr 2011
                  • 74

                  #9
                  I will take back my words about content being deleted.

                  I'd restored 13th June database backup version and got created the lost posts. I've not touched anything in the database. If you need logs I'm ready to provide you.

                  Today again I've started getting similar Database Error. Please help me looks like serious problem with the software:

                  I'm pasting from 3 emails today:

                  [email protected] <[email protected]>
                  4:47 PM (1 hour ago)
                  to contactus
                  Database error in vBulletin 5.4.2:

                  Invalid SQL:
                  SELECT * FROM channel
                  WHERE `guid` IN ('vbulletin-4ecbdf567f2773.55528984','vbulletin-4ecbdf567f3341.44450667','vbulletin-4ecbdf567f3341.44451100','vbulletin-4ecbdf567f2c35.70389590','vbulletin-4ecbdf567f3a38.99555305','vbulletin-4ecbdf567f3a38.99555306','vbulletin-4ecbdf567f3a38.99555307','vbulletin-c-cmshome5229fa38b251e2.92227401','vbulletin-4ecbdf567f3da8.31769341','vbulletin-4ecbdf567f36c3.90966558','vbulletin-4ecbdf567f3a38.99555303','vbulletin-4ecbdf567f3a38.99555304','vbulletin-4ecbdf567f3a38.99555308');

                  MySQL Error : MySQL server has gone away
                  Error Number : 2006
                  Request Date : Monday, July 9th 2018 @ 04:47:28 PM
                  Error Date : Monday, July 9th 2018 @ 04:47:29 PM
                  Script : https://forum.bookrailticket.com/for...ney-experience
                  Referrer :
                  IP Address : 18.237.98.128
                  Username : Guest
                  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/library/content/channel.php on line 894
                  #9 vB_Library_Content_Channel->fetchChannelByGUID() called in [path]/vb/api/content/channel.php on line 141
                  #10 vB_Api_Content_Channel->fetchChannelByGUID() called in [path]/vb/library/node.php on line 2184
                  #11 vB_Library_Node->fetchVMChannel() called in [path]/vb/usercontext.php on line 534
                  #12 vB_UserContext->getChannelLimitPermission() called in [path]/vb/usercontext.php on line 823
                  #13 vB_UserContext->getChannelPermission() called in [path]/vb5/route/channel.php on line 21
                  #14 vB5_Route_Channel->__construct() called in [path]/vb5/route.php on line 854
                  #15 vB5_Route::selectBestRoute() called in [path]/vb/api/route.php on line 182
                  #16 vB_Api_Route->getRoute() called in [path]/vb/api/wrapper.php on line 199
                  #17 vB_Api_Wrapper->__call() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/api/interface/collapsed.php on line 101
                  #18 Api_Interface_Collapsed->callApi() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/frontend/routing.php on line 120
                  #19 vB5_Frontend_Routing->setRoutes() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/frontend/application.php on line 21
                  #20 vB5_Frontend_Application::init() called in /home/raggupta/public/forum.bookrailticket.com/public/index.php on line 48


                  [email protected] <[email protected]>
                  4:47 PM (1 hour ago)
                  to contactus
                  Database error in vBulletin 5.4.2:

                  Invalid SQL:
                  SELECT * FROM session
                  WHERE `userid` = 0 AND `host` = '18.237.98.128' AND `idhash` = '5b7dfaba12cf45c0079c02a54a3f6793'
                  LIMIT 1;

                  MySQL Error : MySQL server has gone away
                  Error Number : 2006
                  Request Date : Monday, July 9th 2018 @ 04:47:28 PM
                  Error Date : Monday, July 9th 2018 @ 04:47:29 PM
                  Script : https://forum.bookrailticket.com/for...c-coupe?p=1369
                  Referrer :
                  IP Address : 18.237.98.128
                  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/db/assertor.php on line 628
                  #9 vB_dB_Assertor->getRow() called in [path]/vb/session.php on line 211
                  #10 vB_Session->loadExistingSession() called in [path]/vb/session.php on line 456
                  #11 vB_Session->__construct() called in [path]/vb/session/web.php on line 31
                  #12 vB_Session_Web->__construct() called in [path]/vb/session/webapi.php on line 72
                  #13 vB_Session_WebApi->__construct() called in [path]/vb/session/webapi.php on line 66
                  #14 vB_Session_WebApi::createSessionNew() called in [path]/vb/request/webapi.php on line 54
                  #15 vB_Request_WebApi->createSessionNew() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/api/interfaceabstract.php on line 180
                  #16 Api_InterfaceAbstract->createSession() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/api/interface/collapsed.php on line 59
                  #17 Api_Interface_Collapsed->init() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/api/interfaceabstract.php on line 71
                  #18 Api_InterfaceAbstract::instance() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/frontend/routing.php on line 119


                  [email protected] <[email protected]>
                  4:47 PM (1 hour ago)
                  to contactus
                  Database error in vBulletin 5.4.2:

                  Invalid SQL:
                  UPDATE session SET `wol`='a:3:{s:6:"action";s:15:"viewing_forum_x";s:6:"params";a:2:{i:0;s:14:"Ticket Refunds";i:1;s:53:"https://forum.bookrailticket.com/forum/ticket-refunds";}s:6:"nodeid";i:18;}',`pagekey`='channel72.55.18',`location`='/forum/ticket-refunds'
                  WHERE (`sessionhash` = '069579e49854becfbf7a41616c0f60f7')
                  /**session**/;

                  MySQL Error : MySQL server has gone away
                  Error Number : 2006
                  Request Date : Monday, July 9th 2018 @ 04:47:27 PM
                  Error Date : Monday, July 9th 2018 @ 04:47:29 PM
                  Script : https://forum.bookrailticket.com/forum/ticket-refunds
                  Referrer :
                  IP Address : 18.237.98.128
                  Username : Guest
                  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/update.php on line 116
                  #4 vB_dB_Query_Update->doUpdates() called in [path]/vb/db/query/update.php on line 101
                  #5 vB_dB_Query_Update->execSQL() called in [path]/vb/db/assertor.php on line 304
                  #6 vB_dB_Assertor->assertQuery() called in [path]/vb/api/wol.php on line 65
                  #7 vB_Api_Wol->register() called in [path]/vb/api/wrapper.php on line 199
                  #8 vB_Api_Wrapper->__call() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/api/interface/collapsed.php on line 101
                  #9 Api_Interface_Collapsed->callApi() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/frontend/controller/page.php on line 78
                  #10 vB5_Frontend_Controller_Page->index() called in /home/raggupta/public/forum.bookrailticket.com/public/index.php on line 74


                  [email protected] <[email protected]>
                  4:47 PM (1 hour ago)
                  to contactus
                  Database error in vBulletin 5.4.2:

                  Invalid SQL:
                  SELECT `title`,`textonly`,`template_un`,`template` FROM template
                  WHERE `templateid` IN (2124);

                  MySQL Error : MySQL server has gone away
                  Error Number : 2006
                  Request Date : Monday, July 9th 2018 @ 04:47:27 PM
                  Error Date : Monday, July 9th 2018 @ 04:47:29 PM
                  Script : https://forum.bookrailticket.com/forum/other
                  Referrer :
                  IP Address : 18.237.98.128
                  Username : Guest
                  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/db/assertor.php on line 587
                  #9 vB_dB_Assertor->select() called in [path]/vb/library/template.php on line 124
                  #10 vB_Library_Template->fetchBulk() called in [path]/vb/library/template.php on line 50
                  #11 vB_Library_Template->fetch() called in [path]/vb/api/template.php on line 51
                  #12 vB_Api_Template->fetch() called in [path]/vb/api/wrapper.php on line 199
                  #13 vB_Api_Wrapper->__call() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/api/interface/collapsed.php on line 101
                  #14 Api_Interface_Collapsed->callApi() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/template/cache.php on line 221
                  #15 vB5_Template_Cache->fetchTemplate() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/template/cache.php on line 184
                  #16 vB5_Template_Cache->getTemplate() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/template.php on line 314
                  #17 vB5_Template->render() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/applicationabstract.php on line 634
                  #18 vB5_ApplicationAbstract::getPreheader() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/frontend/controller/page.php on line 45
                  #19 vB5_Frontend_Controller_Page->index() called in /home/raggupta/public/forum.bookrailticket.com/public/index.php on line 74


                  [email protected] <[email protected]>
                  4:47 PM (1 hour ago)
                  to contactus
                  Database error in vBulletin 5.4.2:

                  Invalid SQL:
                  SELECT `varname`,`languageid`,`text` FROM phrase
                  WHERE `varname` IN ('invalid_page_url','logo','powered_by_vbulletin_title','search','navbar_home','navbar_blo gs','navbar_articles','navbar_social_groups','navbar_todays_posts','navbar_member_list','n avbar_calendar','login_or_sign_up','you_can_also_login_as','facebook','twitterlogin_signin _with_twitter','googlelogin_signin_with_google','search_in_titles_only','advanced_search', 'navbar_help','navbar_contact_us','go_to_top','powered_by_vbulletin','today','footer_curre nt_time','working_ellipsis','yes','no','ok','cancel','facebook_language') AND `languageid` IN (1,0,-1);

                  MySQL Error : MySQL server has gone away
                  Error Number : 2006
                  Request Date : Monday, July 9th 2018 @ 04:47:27 PM
                  Error Date : Monday, July 9th 2018 @ 04:47:29 PM
                  Script : https://forum.bookrailticket.com/for...-ticket?p=1311
                  Referrer :
                  IP Address : 18.237.98.128
                  Username : Guest
                  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/db/assertor.php on line 653
                  #9 vB_dB_Assertor->getRows() called in [path]/vb/api/phrase.php on line 256
                  #10 vB_Api_Phrase->getPhrases() called in [path]/vb/api/phrase.php on line 166
                  #11 vB_Api_Phrase->fetch() called in [path]/vb/api/wrapper.php on line 199
                  #12 vB_Api_Wrapper->__call() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/api/interface/collapsed.php on line 101
                  #13 Api_Interface_Collapsed->callApi() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/template/phrase.php on line 182
                  #14 vB5_Template_Phrase->fetchPhrases() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/template/phrase.php on line 89
                  #15 vB5_Template_Phrase->replacePlaceholders() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/template.php on line 446
                  #16 vB5_Template->renderDelayed() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/template.php on line 348
                  #17 vB5_Template->render() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/applicationabstract.php on line 486
                  #18 vB5_ApplicationAbstract::showErrorPage() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/applicationabstract.php on line 288
                  #19 vB5_ApplicationAbstract::handleException() called in on line


                  [email protected] <[email protected]>
                  4:47 PM (1 hour ago)
                  to contactus
                  Database error in vBulletin 5.4.2:

                  Invalid SQL:
                  SELECT * FROM cache
                  WHERE `cacheid` IN ('vb_types.types');

                  MySQL Error : MySQL server has gone away
                  Error Number : 2006
                  Request Date : Monday, July 9th 2018 @ 04:47:27 PM
                  Error Date : Monday, July 9th 2018 @ 04:47:29 PM
                  Script : https://forum.bookrailticket.com/for...u-tte-niranjan
                  Referrer :
                  IP Address : 18.237.98.128
                  Username : Guest
                  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/cache/db.php on line 154
                  #9 vB_Cache_Db->readCacheArray() called in [path]/vb/cache.php on line 752
                  #10 vB_Cache->read() called in [path]/vb/types.php on line 183
                  #11 vB_Types->loadTypes() called in [path]/vb/types.php on line 151
                  #12 vB_Types->__construct() called in [path]/vb/types.php on line 167
                  #13 vB_Types::instance() called in [path]/vb/library/node.php on line 58
                  #14 vB_Library_Node->__construct() called in [path]/vb/library.php on line 46
                  #15 vB_Library::instance() called in [path]/vb/api/node.php on line 124
                  #16 vB_Api_Node->__construct() called in [path]/vb/api.php on line 185
                  #17 vB_Api::instanceInternal() called in [path]/vb/api/content.php on line 76
                  #18 vB_Api_Content->__construct() called in [path]/vb/api/content/text.php on line 50
                  #19 vB_Api_Content_Text->__construct() called in [path]/vb/api.php on line 213
                  #20 vB_Api::instance() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/api/interface/collapsed.php on line 88
                  #21 Api_Interface_Collapsed->callApi() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/template/runtime.php on line 972
                  #22 vB5_Template_Runtime:arseData() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/template.php(322) : eval()'d code on line 159
                  #23 eval() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/template.php on line 322
                  #24 vB5_Template->render() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/template/cache.php on line 134
                  #25 vB5_Template_Cache->replacePlaceholders() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/template.php on line 344
                  #26 vB5_Template->render() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/applicationabstract.php on line 486
                  #27 vB5_ApplicationAbstract::showErrorPage() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/applicationabstract.php on line 288
                  #28 vB5_ApplicationAbstract::handleException() called in on line


                  [email protected] <[email protected]>
                  4:47 PM (1 hour ago)
                  to contactus
                  Database error in vBulletin 5.4.2:

                  Invalid SQL:
                  SELECT `varname`,`languageid`,`text` FROM phrase
                  WHERE `varname` IN ('invalid_page_url','logo','powered_by_vbulletin_title','search','navbar_home','navbar_blo gs','navbar_articles','navbar_social_groups','navbar_todays_posts','navbar_member_list','n avbar_calendar','login_or_sign_up','you_can_also_login_as','facebook','twitterlogin_signin _with_twitter','googlelogin_signin_with_google','search_in_titles_only','advanced_search', 'navbar_help','navbar_contact_us','go_to_top','powered_by_vbulletin','today','footer_curre nt_time','working_ellipsis','yes','no','ok','cancel','facebook_language') AND `languageid` IN (1,0,-1);

                  MySQL Error : MySQL server has gone away
                  Error Number : 2006
                  Request Date : Monday, July 9th 2018 @ 04:47:27 PM
                  Error Date : Monday, July 9th 2018 @ 04:47:29 PM
                  Script : https://forum.bookrailticket.com/for...ral-queries-ac
                  Referrer :
                  IP Address : 18.237.98.128
                  Username : Guest
                  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/db/assertor.php on line 653
                  #9 vB_dB_Assertor->getRows() called in [path]/vb/api/phrase.php on line 256
                  #10 vB_Api_Phrase->getPhrases() called in [path]/vb/api/phrase.php on line 166
                  #11 vB_Api_Phrase->fetch() called in [path]/vb/api/wrapper.php on line 199
                  #12 vB_Api_Wrapper->__call() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/api/interface/collapsed.php on line 101
                  #13 Api_Interface_Collapsed->callApi() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/template/phrase.php on line 182
                  #14 vB5_Template_Phrase->fetchPhrases() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/template/phrase.php on line 89
                  #15 vB5_Template_Phrase->replacePlaceholders() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/template.php on line 446
                  #16 vB5_Template->renderDelayed() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/template.php on line 348
                  #17 vB5_Template->render() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/applicationabstract.php on line 486
                  #18 vB5_ApplicationAbstract::showErrorPage() called in /home/raggupta/public/forum.bookrailticket.com/public/includes/vb5/applicationabstract.php on line 288
                  #19 vB5_ApplicationAbstract::handleException() called in on line

                  Comment

                  • Mark.B
                    vBulletin Support
                    • Feb 2004
                    • 24286
                    • 6.0.X

                    #10
                    That's a completely different error.

                    "MySQL Server has gone away" is a server issue. You should contact your host about this.
                    MARK.B
                    vBulletin Support
                    ------------
                    My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
                    My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

                    Comment

                    • rag_gupta
                      Member
                      • Apr 2011
                      • 74

                      #11
                      I only manage the website and the server.
                      It is showing "Invalid SQL". Can you please tell me the reason?

                      And why I should get this Database Error second time without touching anything within the website within a month?


                      Comment

                      • In Omnibus
                        Senior Member
                        • Apr 2010
                        • 2310

                        #12
                        The link https://forum.bookrailticket.com/for...ral-queries-ac is coming up as an invalid page URL so it's impossible to tell from this side what might be causing the error. You should check the server error logs for a better idea of what is causing the issue.

                        Comment

                        • Mark.B
                          vBulletin Support
                          • Feb 2004
                          • 24286
                          • 6.0.X

                          #13
                          The important bit is this:

                          MySQL server has gone away

                          This is not a vBulletin error, it is a server error.
                          My original statement still stands. You need to speak to your host or whoever manages the MySQL server.
                          MARK.B
                          vBulletin Support
                          ------------
                          My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
                          My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

                          Comment

                          • Wayne Luke
                            vBulletin Technical Support Lead
                            • Aug 2000
                            • 73981

                            #14
                            Originally posted by rag_gupta
                            I only manage the website and the server.
                            It is showing "Invalid SQL". Can you please tell me the reason?

                            And why I should get this Database Error second time without touching anything within the website within a month?

                            Originally posted by Mark.B
                            The important bit is this:

                            MySQL server has gone away

                            This is not a vBulletin error, it is a server error.
                            My original statement still stands. You need to speak to your host or whoever manages the MySQL server.

                            Your database server is overloaded due to the way it is configured. It is returning a "MySQL Gone Away Error". This error means that MySQL closed the connection before returning the results of the query to the client (vBulletin in this case). The fix to this is to properly configure the server. If you don't reconfigure MySQL to prevent the error, it will continue to recur and fixing it is beyond the scope of support here. We don't know what your server needs are. All we can do is recommend some settings. Make sure the wait_timeout and innodb_lock_timeout values are default. Make sure that you're not restricted on the number of connections. Make sure that you're not restricted on the number of queries per hour.

                            Running MySQL 5.7 with its default settings is the best course of action if you're not a database administrator.
                            Translations provided by Google.

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

                            Comment

                            • rag_gupta
                              Member
                              • Apr 2011
                              • 74

                              #15
                              Thanks I'm looking into it. So does it mean that in other cases the site will be working just fine? Last time it simply stopped showing a few threads and disallowed editing or creating new ones. I hope it is temporary issue that should not affect the site. Let me restart the server to see if that will work.

                              Comment

                              Related Topics

                              Collapse

                              Working...