[marc49]

ok, this thread is 20 pages long so maybe this has been answered already but I am getting this error

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,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=103
mysql error: You have an error in your SQL syntax near 'avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
' at line 4

mysql error number: 1064

Date: Wednesday 14th of August 2002 02:53:11 PM
Script: http://www.mysite.com/admin/user.php...dit&userid=103
Referer: mysite.com/admin/user.php

I am running 2.2.5


*EDIT*

Never mind, I started looking through the pages while I was waiting for a reply and I think I got it fixed.