Bug SQL error after Mysql server update; Error Number : 1054

[mirel]

Hi @all!
After a upgrade from vBulletin 4.2.4 to 4.2.5, i have this error:

Database error in vBulletin 4.2.5:

Invalid SQL:

		SELECT *
		FROM dbtech_thanks_entry AS entry
		WHERE contentid IN (Array)
			AND contenttype = 'post';

MySQL Error   : Unknown column 'Array' in 'where clause'
Error Number  : 1054
Request Date  : Sunday, December 24th 2017 @ 11:19:33 AM
Error Date    : Sunday, December 24th 2017 @ 11:19:34 AM
Script        : http://xxxxxxxxxxxxx
Referrer      : 
IP Address    : xxxxxx
Username      : Unregistered
Classname     : vB_Database_MySQLi
MySQL Version : 
Server        : xxxxx
User Agent    :

I try to rebuild table, no change.
I have a backup, and i try to rebuild the db, but when i send:

DROP TABLE IF EXISTS `dbtech_thanks_entry`;
CREATE TABLE `dbtech_thanks_entry` (
`entryid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`varname` varchar(50) NOT NULL,
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`contenttype` enum('post') NOT NULL,
`contentid` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`receiveduserid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`entryid`),
KEY `entryid` (`userid`,`entryid`),
KEY `entryid_2` (`receiveduserid`,`entryid`),
KEY `userid` (`userid`),
KEY `receiveduserid` (`receiveduserid`)
) ENGINE=MyISAM AUTO_INCREMENT=24888 DEFAULT CHARSET=latin1

i get this error:

An error occurred while attempting to execute your query. The following information was returned. 
error number: 1064 
error desc: 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 'CREATE TABLE `dbtech_thanks_entry` (
`entryid` int(10) unsigned NOT NULL AUTO' at line 2

I have PHP 5.6.32 and MySQL 5.6.34.

Thank you for your help.

 

[Fillip H.]

Version 3.1.7 is years old and is no longer supported. Please upgrade to the latest version.

 

[DragonByte Technologies]

Hello mirel,

This ticket has now been closed with the status Not A Bug.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!