Recurring database errors

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • somasimple
    Senior Member
    • Jul 2005
    • 364
    • 5.3.x

    [Bug / Issue] Recurring database errors

    Hi all,
    I've got some recurring database errors (several time every day):

    Database error in vBulletin 5.3.2:
    Invalid SQL: UPDATE session SET `lastactivity`=1503551299,`styleid`=78,`languageid`=1 WHERE (`sessionhash` = 'e54************************************7d')

    /**session**/;
    MySQL Error : MySQL server has gone away Error Number : 2006
    Request Date : Thursday, August 24th 2017 @ 07:08:19 AM Error Date : Thursday, August 24th 2017 @ 07:12:13 AM
    Script : http://www.somasimple.com/forums/for...2?postcount=27
    Referrer : IP Address : 216.244.66.203 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 302 #6 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 537 #7 vB_dB_Assertor->update() called in [path]/vb/session.php on line 522 #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 506 #10 vB::shutdown() called in on line
    and this one too:
    Database error in vBulletin 5.3.2:
    Invalid SQL:
    SELECT n.nodeid, n.title FROM closure AS cl INNER JOIN node AS n ON n.nodeid = cl.child INNER JOIN groupintopic AS git ON git.nodeid = n.nodeid WHERE cl.parent = 3 AND git.groupid IN () and git.userid = 0 ORDER BY title
    /**getGitCanStartThreads**/;
    MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and git.userid = 0 ORDER BY title /**getGitCanStartThreads**/' at line 4 Error Number : 1064 Request Date : Thursday, August 24th 2017 @ 02:15:55 AM Error Date : Thursday, August 24th 2017 @ 02:15:55 AM Script : https://www.somasimple.com/forums/blogs Referrer : https://www.somasimple.com/forums/blog.php IP Address : 185.182.48.169 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 125 #4 vB_dB_Result->rewind() called in [path]/vb/db/result.php on line 62 #5 vB_dB_Result->__construct() called in [path]/vb/db/query/stored.php on line 103 #6 vB_dB_Query_Stored->execSQL() called in [path]/vb/db/assertor.php on line 302 #7 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 649 #8 vB_dB_Assertor->getRows() called in [path]/vb/api/user.php on line 6823 #9 vB_Api_User->getGitCanStart() called in [path]/vb/api/user.php on line 6844 #10 vB_Api_User->canCreateBlogEntry() called in [path]/vb/api/wrapper.php on line 129 #11 vB_Api_Wrapper->__call() called in /home/clients/4455*****************************488/web/forums/includes/api/interface/collapsed.php on line 91 #12 Api_Interface_Collapsed->callApi() called in /home/clients/4455*****************************488//web/forums/includes/vb5/template/runtime.php on line 548 #13 vB5_Template_Runtime:arseData() called in /home/clients/4455*****************************488//web/forums/includes/vb5/template.php(318) : eval()'d code on line 261 #14 eval() called in /home/clients/4455*****************************488//web/forums/includes/vb5/template.php on line 318 #15 vB5_Template->render() called in /home/clients/4455*****************************488//web/forums/includes/vb5/template/cache.php on line 134 #16 vB5_Template_Cache->replacePlaceholders() called in /home/clients/4455*****************************488//web/forums/includes/vb5/template.php on line 340 #17 vB5_Template->render() called in /home/clients/4455*****************************488//web/forums/includes/vb5/template/cache.php on line 134 #18 vB5_Template_Cache->replacePlaceholders() called in /home/clients/4455*****************************488//web/forums/includes/vb5/template.php on line 340 #19 vB5_Template->render() called in /home/clients/4455*****************************488//web/forums/includes/vb5/template/cache.php on line 134 #20 vB5_Template_Cache->replacePlaceholders() called in /home/clients/4455*****************************488//web/forums/includes/vb5/template.php on line 340 #21 vB5_Template->render() called in /home/clients/4455*****************************488//web/forums/includes/vb5/template/cache.php on line 134 #22 vB5_Template_Cache->replacePlaceholders() called in /home/clients/4455*****************************488//web/forums/includes/vb5/template.php on line 340 #23 vB5_Template->render() called in /home/clients/4455*****************************488//web/forums/includes/vb5/template/cache.php on line 134 #24 vB5_Template_Cache->replacePlaceholders() called in /home/clients/4455*****************************488//web/forums/includes/vb5/template.php on line 340 #25 vB5_Template->render() called in /home/clients/4455*****************************488//web/forums/includes/vb5/frontend/controller/page.php on line 256 #26 vB5_Frontend_Controller_Page->index() called in /home/clients/4455*****************************488//web/forums/index.php on line 74
    Is there some solution?
    Thanks.
    Bernard
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24325
    • 5.7.X

    #2
    Your first error:

    "MySQL Error : MySQL server has gone away"

    This is a server issue. You'll need to contact your host about this. Here are the reasons for the MySQL server going away:



    Also from the MySQL site:




    For the second, what version of PHP and MySQL are you using on your site?
    Vote for:

    - Admin Settable Paid Subscription Reminder Timeframe (vB6)
    - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

    Comment

    • somasimple
      Senior Member
      • Jul 2005
      • 364
      • 5.3.x

      #3
      Here are the infos.
      Attached Files
      Bernard

      Comment

      • somasimple
        Senior Member
        • Jul 2005
        • 364
        • 5.3.x

        #4
        And the weird thing is the other forums I own with the same settings does not send any errors of this kind.
        Bernard

        Comment

        • somasimple
          Senior Member
          • Jul 2005
          • 364
          • 5.3.x

          #5
          Other weird thing, I noticed that some some tables have MyISAM and some InnoDB as engines?
          Bernard

          Comment

          • somasimple
            Senior Member
            • Jul 2005
            • 364
            • 5.3.x

            #6
            Originally posted by somasimple
            And the weird thing is the other forums I own with the same settings does not send any errors of this kind.
            But the second site has blogs enabled and it seems that one recurring error call the blogs page.

            I tested the update session sql and systematically it says that no record was updated since the sessionhash is not in the database.
            Bernard

            Comment

            Related Topics

            Collapse

            Working...