adriandaz
11-05-2002, 05:16 AM
Hi, I was installing the Away hack by Bira, and now I get this when I goto view user properties in the admin panel:
Database error in vBulletin Control Panel 2.2.8:
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,
signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN signature ON signature.signatureid=user.signatureid
LEFT JOIN customsignature ON customsignature.userid=user.userid
WHERE user.userid=16
mysql error: You have an error in your SQL syntax near 'FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,' at line 1
mysql error number: 1064
Please advise me of how to fix this,
thanks,
Adrian.
Database error in vBulletin Control Panel 2.2.8:
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,
signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN signature ON signature.signatureid=user.signatureid
LEFT JOIN customsignature ON customsignature.userid=user.userid
WHERE user.userid=16
mysql error: You have an error in your SQL syntax near 'FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,' at line 1
mysql error number: 1064
Please advise me of how to fix this,
thanks,
Adrian.