Not sure what to do - mysql error number: 1064

[Sadie Frost]

When I try to look at a user profile in the admin cp, I get the following error message:

Database error in vBulletin Control Panel 2.2.1:

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=4
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


I have recently installed the avatar category, the away message, the birthday email and the style hacks. Can anyone help? Thanks! :)

[Admin]

Looks like the Away Reason hack is acting up for you.
This was fixed in a post by bira btw. :)

Anyway, in user.php look for:
FROM_UNIXTIME(awaydate) AS awaydate
and add a comma (,) right after it.

[Sadie Frost]

Thank you so much! :) - and I'm really sorry for asking about this - I must have missed bira's post :(