[PhotoGenie]

My mistake on the last error but now I'm getting this error when I go to user options at the bottom of members profile..

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

Date: Tuesday 29th of January 2002 08:40:47 AM
Script: http://www.a2zautoforums.com/admin/u...edit&userid=27
Referer: http://www.a2zautoforums.com/admin/i...%26userid%3D27

I noticed a couple of other post with the same problem. Has anyone created a fix yet or figured out how to fix this?

Thanks

Please disregard this post the problem was the coma after:

FROM_UNIXTIME(awaydate) AS awaydate

was missing. Hasn't been updated in the install script.