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]
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]
Comment