I got the same error as grumpy, and followed your directions here...
Quote:
Originally posted by cocomiel
if you have phpMyAdmin instaled, select to your database
and in the USER table delete the 'avatarrevision' field
then go to the SETTINGS table and delete the last two fields
|
Now the options in my CP don't load, and I get this error:
Database error in vBulletin Control Panel: Invalid SQL: SELECT settingid,title,varname,value,description,optionco de,displayorder FROM setting WHERE settinggroupid=1 ORDER BY displayorder
mysql error: Unknown column 'optioncode' in 'field list'
mysql error number: 1054
I've been to some threads on my board, and the hack actually seems to work. But I just can't seem to log into my CP. I think I need to add two fields or rows back into my Settings table. I should have backed up, I know... but my forum isn't live yet, so I'm just testing.