After upgrading from 5.4 to 5.5.1 today, I am now getting MySQL Database errors. I've submitted a ticket and haven't gotten a response yet, so I thought I'd post here.
I'm running:
IIS 10 on Win Server 2019
PHP 7.3.4
MySQL 8.0.15
vBulletin 5.5.1
My vBulletin install is a completely clean copy (deleted old files, uploaded new files, edited config files with db connection info, everything else is as shipped in the vBulletin download). No hacks, no addons, no template edits.
This is what I get when I try to access certain threads (others work fine):
Database error in vBulletin 5.5.1:
Invalid SQL:
UPDATE session SET `lastactivity`=1554903985,`styleid`=2,`languageid`=1
WHERE (`sessionhash` = 'b52e7cdf9ca810993208bb289b1c3355')
/**session**/;
MySQL Error : Commands out of sync; you can't run this command now
Error Number : 2014
Request Date : Wednesday, April 10th 2019 @ 01:46:25 PM
Error Date : Wednesday, April 10th 2019 @ 01:46:26 PM
I've also gotten this error when I access the initial forum page. Note that whenever this db problem happens, in the vBulletin browser window I just get a blank page, no error message. The DB error message gets emailed to my account.
Database error in vBulletin 5.5.1:
Invalid SQL:
INSERT IGNORE INTO session (`sessionhash`,`userid`,`host`,`idhash`,`lastactivity`,`location`,`styleid`,`languageid`,` loggedin`,`inforum`,`inthread`,`incalendar`,`badlocation`,`useragent`,`bypass`,`profileupd ate`,`apiclientid`,`apiaccesstoken`,`emailstamp`)
VALUES('ff13bcfdadf8fcbc4a3f0f587082f02f',0,'128.173.39.5','aeaa50617a6dc35ab376d2678f7de2 d2',1554905236,'',2,1,0,0,0,0,0,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36',0,0,0,'',0)
/**session**/;
MySQL Error : Commands out of sync; you can't run this command now
Error Number : 2014
Request Date : Wednesday, April 10th 2019 @ 02:07:16 PM
Error Date : Wednesday, April 10th 2019 @ 02:07:17 PM
Script : https://vtsl.vetmed.vt.edu/forums/
Referrer :
IP Address : 128.173.39.5
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :
Stack Trace:
#0 vB_Database->getErrorData() called in [path]\vb\database.php on line 1203
#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_write() called in [path]\vb\db\query\insertignore.php on line 88
#4 vB_dB_Query_InsertIgnore->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 301
#6 vB_dB_Assertor->assertQuery() called in [path]\vb\db\assertor.php on line 473
#7 vB_dB_Assertor->insertIgnore() called in [path]\vb\session.php on line 593
I'm running:
IIS 10 on Win Server 2019
PHP 7.3.4
MySQL 8.0.15
vBulletin 5.5.1
My vBulletin install is a completely clean copy (deleted old files, uploaded new files, edited config files with db connection info, everything else is as shipped in the vBulletin download). No hacks, no addons, no template edits.
This is what I get when I try to access certain threads (others work fine):
Database error in vBulletin 5.5.1:
Invalid SQL:
UPDATE session SET `lastactivity`=1554903985,`styleid`=2,`languageid`=1
WHERE (`sessionhash` = 'b52e7cdf9ca810993208bb289b1c3355')
/**session**/;
MySQL Error : Commands out of sync; you can't run this command now
Error Number : 2014
Request Date : Wednesday, April 10th 2019 @ 01:46:25 PM
Error Date : Wednesday, April 10th 2019 @ 01:46:26 PM
I've also gotten this error when I access the initial forum page. Note that whenever this db problem happens, in the vBulletin browser window I just get a blank page, no error message. The DB error message gets emailed to my account.
Database error in vBulletin 5.5.1:
Invalid SQL:
INSERT IGNORE INTO session (`sessionhash`,`userid`,`host`,`idhash`,`lastactivity`,`location`,`styleid`,`languageid`,` loggedin`,`inforum`,`inthread`,`incalendar`,`badlocation`,`useragent`,`bypass`,`profileupd ate`,`apiclientid`,`apiaccesstoken`,`emailstamp`)
VALUES('ff13bcfdadf8fcbc4a3f0f587082f02f',0,'128.173.39.5','aeaa50617a6dc35ab376d2678f7de2 d2',1554905236,'',2,1,0,0,0,0,0,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36',0,0,0,'',0)
/**session**/;
MySQL Error : Commands out of sync; you can't run this command now
Error Number : 2014
Request Date : Wednesday, April 10th 2019 @ 02:07:16 PM
Error Date : Wednesday, April 10th 2019 @ 02:07:17 PM
Script : https://vtsl.vetmed.vt.edu/forums/
Referrer :
IP Address : 128.173.39.5
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :
Stack Trace:
#0 vB_Database->getErrorData() called in [path]\vb\database.php on line 1203
#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_write() called in [path]\vb\db\query\insertignore.php on line 88
#4 vB_dB_Query_InsertIgnore->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 301
#6 vB_dB_Assertor->assertQuery() called in [path]\vb\db\assertor.php on line 473
#7 vB_dB_Assertor->insertIgnore() called in [path]\vb\session.php on line 593
Comment