Bug DB Error when enabling every item

Status
Not open for further replies.

D19RNY

Customer
Every item gives me the following db error:

Code:
Database error in vBulletin 4.1.4:

Invalid SQL:
UPDATE dbtech_vbshop_item SET
	onlygiftable = '0',
	permissions = 'a:19:{i:19;s:2:\"-1\";i:26;s:2:\"-1\";i:8;s:2:\"-1\";i:29;s:2:\"-1\";i:31;s:2:\"-1\";i:7;s:1:\"1\";i:30;s:2:\"-1\";i:9;s:1:\"1\";i:18;s:2:\"-1\";i:2;s:1:\"1\";i:24;s:2:\"-1\";i:20;s:2:\"-1\";i:15;s:2:\"-1\";i:5;s:1:\"1\";i:11;s:1:\"1\";i:6;s:1:\"1\";i:1;s:2:\"-1\";i:3;s:2:\"-1\";i:4;s:2:\"-1\";}'
WHERE itemid = 1;

MySQL Error   : Unknown column 'onlygiftable' in 'field list'
Error Number  : 1054
Request Date  : Thursday, June 30th 2011 @ 08:10:13 AM
Error Date    : Thursday, June 30th 2011 @ 08:10:13 AM
Script        : http://www.fivestargamerz.com/xxxxxxx/vbshop.php?do=item
Referrer      : http://www.fivestargamerz.com/xxxxxx/vbshop.php?do=item&action=modify&itemid=1
IP Address    : xxxxxxxxxxxx
Username      : xxxxxxxxxxxxx
Classname     : vB_Database
MySQL Version : 5.5.12-55-log
 
Sounds like upon upgrading to 2.0 something went wrong. Manually execute

ALTER TABLE dbtech_vbshop_item ADD onlygiftable ENUM('0','1') NOT NULL DEFAULT '0'
 
Status
Not open for further replies.

Legacy vBShop

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