BUG - After I did the recalculate achievements, it got stuck a long time in #8 and then it started spitting out duplicate values, e.g. user name being awarded an item twice, duplicated once after the next.
And another bug when I tried to clear existing awards and create the default ones:
Database error in vBulletin 4.0.7:
Invalid SQL:
UPDATE user SET xperience_awards='';
MySQL Error : Unknown column 'xperience_awards' in 'field list'
Error Number : 1054
Request Date : Tuesday, September 28th 2010 @ 06:15:21 PM
Error Date : Tuesday, September 28th 2010 @ 06:15:21 PM
Script :
http://www.mysite.com/forums/control...=doclearawards
Referrer :
http://www.mysite.com/forums/control...do=clearawards
Classname : vB_Database
MySQL Version : 5.0.77