PDA

View Full Version : Damn Database Error


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.

FWC
11-05-2002, 05:50 AM
Change AS lastvisit to AS lastvisit,

Change SELECT * to SELECT user.*