VB CP List visitors in the last 24 hours MYSQL error

[carpman]

Hello, i get following error when in VB CP and click link 'List visitors in the last 24 hours '

version 2.2.6
php ver 4.2.2

error =

Database error in vBulletin Control Panel 2.2.6:

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=3
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: Thursday 22nd of August 2002 09:32:56 PM
Script: http://www.mydomain.com/forums/forum...=edit&userid=3
Referer: http://www.mydomain.com/forums/admin/index.php?s=$session[sessionhash]

[George L]

try reuploading a fresh copy of all php files in /admin from your vB 2.2.6 zip file

[carpman]

ok will try, will check to see if i have any hack in there first!

[carpman]

I checked vb settings and i had turned off upload in safe mode, i thought it was disabled, but recent php upgrade must have set it be on, all seems ok but will test some more.

update:

now edit user repots error, php files should be ok with php 4.2.2 as it was clean install of vb 2.2.6!