Bug VB 4.0.8 +Thanks 1.1.5 Database error

[Sajan Thomas]

ACP->DBtech Thank->Maintanence->Rebuild statistics

Produces below DB error

Database error in vBulletin 4.0.8:

Invalid SQL:

UPDATE vbGHD_dbtech_thanks_statistics
SET likes_given = 516,likes_received = 323,thanks_received = 39,thanks_given = 50,LOL_given = 6,WTFC_received = 1,LOL_received = 29
WHERE userid = 3;

MySQL Error : Unknown column 'WTFC_received' in 'field list'
Error Number : 1054
Script : http://gearheads.in/admincp/thanks.php?do=maintenance
Referrer : http://gearheads.in/admincp/thanks.php?do=maintenance
Classname : vB_Database_MySQLi
MySQL Version : 5.1.41-3ubuntu12.10

 

[Fillip H.]

Do you currently have any buttons created with varname "WTFC"?

 

[Sajan Thomas]

No there is no button with varname 'WTFC', there is only one custom button with varname 'LOL'

 

[Fillip H.]

Please try clicking the Repair Cache link, or if you run any caching systems like vBO or vBSEO, please try flushing them as well.

It appears that the button list still believes there's a button with the varname WTFC created.

Should the above not work, then it may be a server issue. Please try re-creating that button, but leave active set to No. That should fix the problem, and also not let that button be clickable

 

[Sajan Thomas]

Looks like WTFC button was created sometime and used once and latter deleted, deleting the 'WTFC given' entry solved the issue. Looks like if a button is added and used, later if button is removed then 'Rebuild statistics' will fail.

 

[Fillip H.]

It'll only fail if the rebuild stats still think the button exists for whatever reason (the reasons I stated in my previous post).