PDA

View Full Version : Help! Just installed "away message" hack.


iconic
03-24-2002, 09:43 PM
I installed the away message hack, and it works fine. Now, however, when I go to the Admin CP, and try to edit a user, i get an error message.

Database error in vBulletin Control Panel 2.2.4:

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 awaydateastactivity) 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=8
mysql error: You have an error in your SQL syntax near ') AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,
' at line 1

mysql error number: 1064

Date: Sunday 24th of March 2002 05:39:05 PM
Script: http://www.xwid.com/forums/forums/admin/user.php?action=edit&userid=8
Referer: http://www.xwid.com/forums/admin/user.php?action=find


^^ Is what I get.. I suck at vB.. so, yeh, help :)

Admin
03-25-2002, 04:31 AM
Crawl through the thread for this hack. It's a known issue and bira posted a fix to it in one of her posts.