Announcement

Collapse
No announcement yet.

Recurring database errors

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

  • somasimple
    replied
    Originally posted by somasimple View Post
    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.

    Leave a comment:


  • somasimple
    replied
    Other weird thing, I noticed that some some tables have MyISAM and some InnoDB as engines?

    Leave a comment:


  • somasimple
    replied
    And the weird thing is the other forums I own with the same settings does not send any errors of this kind.

    Leave a comment:


  • somasimple
    replied
    Here are the infos.
    Attached Files

    Leave a comment:


  • Trevor Hannant
    replied
    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:

    https://www.vbulletin.com/forum/show...265#post310265

    Also from the MySQL site:

    http://dev.mysql.com/doc/refman/5.0/en/gone-away.html


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

    Leave a comment:


  • somasimple
    started a topic [Bug / Issue] Recurring database errors

    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.

Related Topics

Collapse

Working...
X