Xplorer4x4 |
01-05-2006 08:12 AM |
I seemed to get this error when attemptin to use on my new server which makes me thinkg it is a PHP/MySQL conflict.
MySQL V5
PHP v4.4.1 & PHP v5.1.1
Not sure which is in effect.
Code:
Database error in vBulletin 3.5.3:
Invalid SQL:
UPDATE user SET
passworddate = FROM_UNIXTIME(1136455772),
password = 'fb98a3830432d6ff9ad9ac5a5a1b7d4e',
### Bitfield: user.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 1024, options - 1024, options),
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 = 'Administrator',
customtitle = 0,
username = 'Xplorer4x4',
email = '',
languageid = 0,
homepage = '',
birthday_search = '1984-10-22',
birthday = '10-22-1984',
showbirthday = 2,
icq = '',
aim = '',
yahoo = '',
msn = '',
skype = '',
parentemail = '',
posts = 592,
referrerid = 0,
ipaddress = '',
vbookie_cash = 500,
ucash = '2230.54',
isstaffrank = '0',
staffrank = '',
staffrank_opentag = '',
staffrank_closetag = '',
alerts = 0,
warnings = 0,
warning_level = 0,
warning_bans = 0,
usergroupid = 6,
reputationlevelid = 5,
reputation = 23,
pmpopup = 1,
autosubscribe = -1,
threadedmode = 0,
showvbcode = 2,
styleid = 0,
timezoneoffset = '-6',
daysprune = 0,
joindate = 1132099380,
lastactivity = 1136455740,
lastpost = 1136455620,
membergroupids = ''
WHERE userid = 1;
MySQL Error : Unknown column 'isstaffrank' in 'field list'
Error Number : 1054
Date : Thursday, January 5th 2006 @ 10:09:32 AM
Script : /admincp/user.php
Referrer : /admincp/user.php?do=edit&u=1
IP Address :
Username : Xplorer4x4
Classname : vb_database
|