Status
Not open for further replies.

Budget101

Customer
Every time a user makes a purchase the following vbulletin database error is generated:

Database error in vBulletin 4.0.2:

Invalid SQL:

UPDATE user
SET dbtech_vbshop_purchase = 'a:1:{i:1;a:6:{s:10:\"purchaseid\";s:1:\"1\";s:6:\"userid\";s:2:\"63\";s:5:\"buyer\";s:2:\"63\";s:7:\"feature\";s:4:\"gift\";s:9:\"featureid\";s:1:\"1\";s:8:\"dateline\";s:10:\"1279208312\";}}'
WHERE userid = 63;

MySQL Error : Unknown column 'dbtech_vbshop_purchase' in 'field list'
Error Number : 1054
Request Date : Thursday, July 15th 2010 @ 02:32:07 PM
Error Date : Thursday, July 15th 2010 @ 02:32:08 PM
Script : http://www.mysite.com/coupons-galore/6541-hershey-s-syrup-55-coupon.html
Referrer :
IP Address : 66.000.500.000
Username : Unregistered
Classname : vB_Database
MySQL Version :
 
Did you get any errors during install?

At any rate, to fix this, manually run this:
Code:
ALTER TABLE user ADD dbtech_vbshop_purchase MEDIUMTEXT NULL DEFAULT NULL
 
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