How can I fix this error?

[ptbyjason]

Please help me if you can. I run version 2.03 and the last hack I installed was the "user away message" hack.

I recieved the following error message when I was trying to view someone's profile in the admin panel:


There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


Database error in vBulletin Control Panel: 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=1838
mysql error: You have an error in your SQL syntax near 'avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
' at line 1
mysql error number: 1064
Date: Monday 17th of December 2001 08:17:45 PM
Script: /vbulletin/admin/user.php?s=&action=edit&userid=1838
Referer: http://www.anabolicreview.com/vbulletin/admin/user.php

[Admin]

Look in the thread for this hack, I think bira posted a fix to this already. :)

[ptbyjason]

I totally missed that before. Sorry. Thanks Firefly, I was only looking for things in that thread that applied to the version I had. It's amazing how important a little comma is.