Bug Database error on saving user profile in ACP.

[Taurus]

When attempting to save a userprofile in my ACP I now get this database error after upgrading to the latest Thanks update:

Database error in vBulletin 4.2.0:

Invalid SQL:
UPDATE vbuser SET
### Bitfield: vbuser.adminoptions ###
adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
usertitle = 'Moderator',
customtitle = 0,
username = 'Vigoni',
birthday_search = 'xxxxxxxx',
birthday = 'xxxxxxxxx',
referrerid = 0,
dbtech_thanks_excluded = 0,
displaygroupid = 0,
membergroupids = '40,67',
joindate = 1322077980,
lastactivity = 1339225980,
lastpost = 1339222680
WHERE userid = xxxxx;

MySQL Error : Unknown column 'dbtech_thanks_excluded' in 'field list'
Error Number : 1054
Request Date : Saturday, June 9th 2012 @ 09:14:19 AM
Error Date : Saturday, June 9th 2012 @ 09:14:19 AM
Script :
Referrer :
IP Address : xxxxxxxxxxx
Username : TheBull
Classname : vB_Database
MySQL Version : 5.1.63-cll

Thanks.

 

[Fillip H.]

ALTER TABLE vbuser ADD dbtech_thanks_excluded TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'

is the SQL query to fix this, I've updated the installer script for others who have not yet updated

 

[Taurus]

Can I run that query within my ACP? And if my database prefix is vb what would the query be then?

Sorry, I just don't know.

 

[Fillip H.]

Yeah, I added your table prefix since I saw it in the query above, it should be good to go as-is via the Execute SQL Queries page

 

[Taurus]

And again....thank you so much. Worked fine. All good now. :RpS_thumbsup: