[apokphp]

I get this error when setting default font options in the UserCP.

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE user SET
### Bitfield: user.options ###
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 4, options, options + 4),
options = IF(options & 16, options, options + 16),
options = IF(options & 32, options - 32, options),
options = IF(options & 256, options, options + 256),
options = IF(options & 512, options - 512, options),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options - 4096, options),
options = IF(options & 131072, options - 131072, options),
options = IF(options & 32768, options - 32768, options),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options, options + 128),
languageid = 0,
autosubscribe = -1,
threadedmode = 0,
timezoneoffset = '-8',
showvbcode = 1,
pmpopup = 1,
maxposts = 30,
daysprune = 365,
startofweek = 1,
showdonor = 0,
mgc_cb_params = 'a:7:{s:13:\"mgc_cb_police\";s:13:\"Comic Sans MS\";s:13:\"mgc_cb_taille\";i:0;s:14:\"mgc_cb_coul eur\";s:6:\"000080\";s:8:\"mgc_cb_b\";i:1;s:8:\"mg c_cb_u\";i:0;s:8:\"mgc_cb_i\";i:0;s:11:\"mgc_cb_sh ow\";i:1;}'
WHERE userid = 1;

MySQL Error : Unknown column 'showdonor' in 'field list'
Error Number : 1054
Date : Tuesday, September 11th 2007 @ 09:21:52 AM
Script : http://www.onlinedebate.net/forums/p...=updateoptions
Referrer : http://www.onlinedebate.net/forums/p...do=editoptions
IP Address : xx.xx.xx.xx
Username : Apokalupsis
Classname : vb_database

See the "show donor"? That's from a PayPal donations hack. I have uninstalled that mod, but for some reason, that part still exists...I'm assuming that this is the culprit?

I tried to remove it via phpmyadmin, but I couldn't find "showdonor" or "field list" anywhere.


*EDIT*

Actually, it's ANY change made whatsoever in the UserCP > Options page, that creates the error. Here's what happens when I try to change styles via the UserCP - Options...

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE user SET
### Bitfield: user.options ###
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 4, options, options + 4),
options = IF(options & 16, options, options + 16),
options = IF(options & 32, options - 32, options),
options = IF(options & 256, options, options + 256),
options = IF(options & 512, options - 512, options),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options - 4096, options),
options = IF(options & 131072, options - 131072, options),
options = IF(options & 32768, options - 32768, options),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options, options + 128),
styleid = 41,
languageid = 0,
autosubscribe = -1,
threadedmode = 0,
timezoneoffset = '-8',
showvbcode = 1,
pmpopup = 1,
maxposts = 30,
daysprune = 365,
startofweek = 1,
showdonor = 0,
### Bitfield: user.quoteitoptions ###
quoteitoptions = IF(quoteitoptions & 1, quoteitoptions - 1, quoteitoptions),
### Bitfield: user.glossaryuseroptions ###
glossaryuseroptions = IF(glossaryuseroptions & 1, glossaryuseroptions, glossaryuseroptions + 1),
mgc_cb_params = 'a:7:{s:13:\"mgc_cb_police\";s:0:\"\";s:13:\"mgc_c b_taille\";i:0;s:14:\"mgc_cb_couleur\";b:0;s:8:\"m gc_cb_b\";i:0;s:8:\"mgc_cb_u\";i:0;s:8:\"mgc_cb_i\ ";i:0;s:11:\"mgc_cb_show\";i:0;}'
WHERE userid = 1;

MySQL Error : Unknown column 'showdonor' in 'field list'
Error Number : 1054
Date : Tuesday, September 11th 2007 @ 09:36:57 AM
Script : http://www.onlinedebate.net/forums/p...=updateoptions
Referrer : http://www.onlinedebate.net/forums/p...do=editoptions
IP Address : xx.xx.xx.xx
Username : Apokalupsis
Classname : vb_database