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

Status
Not open for further replies.

mirel

New member
Hi @all!
After a upgrade from vBulletin 4.2.4 to 4.2.5, i have this error:
PHP:
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:
PHP:
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:

PHP:
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.
 
Version 3.1.7 is years old and is no longer supported. Please upgrade to the latest version.
 
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!
 
Status
Not open for further replies.

Legacy Advanced Post Thanks / Like

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
4,024
Customer rating
5.00 star(s) 1 ratings
Back
Top