The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Damn Database Error
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. |
#2
|
||||
|
||||
Change AS lastvisit to AS lastvisit,
Change SELECT * to SELECT user.* |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|