The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
error
I just got this errro while trying to edit a user's profile in the admin cp. Cam anyone tell me what it is and how I can fix it? Please?
Database error in vBulletin Control Panel 2.2.5: Invalid SQL: SELECT *,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost 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=23 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 |
#2
|
||||
|
||||
In user.php replace this:
Code:
(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost Code:
(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost, |
#3
|
||||
|
||||
Thanks , Chen. I don't know how I missed the comma there. Been a long night I guess.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|