[RoryF]

I'm sorry for bringing up this old thread, but i get this error in user.php when this is all done.

Database error in vBulletin Control Panel 2.3.7:

Invalid SQL: SELECT *,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,FROM_UNIXTIME(awaydate) AS awaydate
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=1
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascus

mysql error number: 1064

Date: Saturday 04th of June 2005 03:11:21 AM
Script: http://www.scrubs-boards.com/admin/u...=edit&userid=1
Referer: http://www.scrubs-boards.com/admin/i...t%26userid%3D1