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.
Back
Top