[Xplorer4x4]

I had an old product version, but still having a database problem when I try to edit a user. I uploaded the new PHP files just to be safe. It does not happen if I disable this hack.

PHP Code:

 Database error in vBulletin 3.5.0 Release Candidate 3: Invalid SQL:
UPDATE user SET
### Bitfield: user.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 16, options, options + 16),
options = IF(options & 256, options - 256, options),
options = IF(options & 512, options - 512, options),
options = IF(options & 32, options - 32, options),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options - 4096, 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 & 64, options, options + 64),
options = IF(options & 128, options - 128, options),
options = IF(options & 32768, options - 32768, options),
usertitle = 'Wrestling Student',
customtitle = 0,
username = 'Mika',
email = '',
languageid = 1,
homepage = '',
birthday_search = '1972-01-18',
birthday = '01-18-1972',
icq = '',
aim = '',
yahoo = '',
msn = '',
parentemail = '',
posts = 101,
referrerid = 0,
ipaddress = '***.***.***.***',
ucash = '1838.59',
vbookie_cash = 500,
alerts = 0,
warnings = 0,
warning_level = 0,
warning_bans = 0,
usergroupid = 13,
reputationlevelid = 5,
reputation = 20,
pmpopup = 1,
autosubscribe = -1,
threadedmode = 0,
showvbcode = 1,
styleid = 0,
timezoneoffset = '-6',
daysprune = 0,
joindate = 1125405420,
lastactivity = 1127005860,
lastpost = 1127005860,
membergroupids = ''
WHERE userid = 125; MySQL Error : Unknown column 'alerts' in 'field list'
Error Number : 1054
Date         : Saturday, September 17th 2005 @ 11:27:07 PM
Script     : /forums/admincp/user.php
Referrer     : /forums/admincp/user.php?do=edit&u=125
IP Address : 
Username     : Xplorer4x4
Classname    : vb_database 


I am still getting a completley white DB error page(not just the main frame) when I click Statistics - Warnings Per User.

PHP Code:

Database error in vBulletin 3.5.0 Release Candidate 3:
Invalid SQL:
SELECT COUNT(*) AS users FROM user AS user where warnings>0 OR alerts>0;
MySQL Error : Unknown column 'warnings' in 'where clause'
Error Number : 1054
Date         : Saturday, September 17th 2005 @ 11:35:18 PM
Script     : http://www.xtremepain.net/forums/admincp/admin_warn.php?act=viewwarnedusers&type=warnings
Referrer     : http://www.xtremepain.net/forums/admincp/index.php
IP Address : 
Username     : Xplorer4x4
Classname    : vb_database 


I am also noticing that if a user has entered a yahoo ID, 2 vertical columned yahoo icons apear under the typical horizontal row of online icons.

I also have a cutom profile field on my postbit_legacy. This has changed the font of it as well.

NOTE That I have not installed any template mods yet.

Any idea how to fix this? Thanks Kirby.