Recurring database errors

[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.

[somasimple]

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

[somasimple]

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

[somasimple]

Here are the infos.

[Trevor Hannant]

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?

[somasimple]

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.