PDA

View Full Version : error


Boofo
05-30-2002, 03:04 PM
I just got this errro while trying to edit a user's profile in the admin cp. Cam anyone tell me what it is and how I can fix it? Please?

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: SELECT *,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost
avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE user.userid=23
mysql error: You have an error in your SQL syntax near 'avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
' at line 2

mysql error number: 1064

Admin
05-30-2002, 03:50 PM
In user.php replace this:
(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost
With this:
(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,

Boofo
05-30-2002, 04:04 PM
Thanks , Chen. I don't know how I missed the comma there. Been a long night I guess. :)