The Arcive of vBulletin Modifications Site. |
|
Details »»
|
|||||||||||||||||||||||||
When I try to look at a user profile in the admin cp, I get the following error message:
Database error in vBulletin Control Panel 2.2.1: 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=4 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 I have recently installed the avatar category, the away message, the birthday email and the style hacks. Can anyone help? Thanks! ![]() Show Your Support
|
|||||||||||||||||||||||||
| Comments |
|
#2
|
||||
|
||||
|
Looks like the Away Reason hack is acting up for you.
This was fixed in a post by bira btw. ![]() Anyway, in user.php look for: Code:
FROM_UNIXTIME(awaydate) AS awaydate |
|
#3
|
||||
|
||||
|
Thank you so much!
- and I'm really sorry for asking about this - I must have missed bira's post
|
![]() |
|
|