Away Reason Hack

I've run into a bit of a problem with the away reason hack. Ever since I installed it, I cannot access any of the users' profiles in the ACP. It just tells me

There seems to have been a slight problem with the Halliwell Haven Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.



Database error in vBulletin Control Panel 2.2.9:

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=5
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

Date: Monday 27th of January 2003 10:41:59 PM
Script: http://www.charming-holly.com/hhg/hh...=edit&userid=5
Referer: http://www.charming-holly.com/hhg/ad...hp?action=find

Now, I know when the hack was installed, it installed a MySQL query where it added a table.

So the mdatabase could have looked like:
name
avatar
Online


And is now:

Name
avatar
away
here
Online.


I know this is most likely fixable, but I don't know how. If you could kindly tell me, I'd most appreciate it.

Thanks!

[mr e]

if you want to delete the away and here tables then open up phpMyAdmin and do it there

[glas]

I would have done that if I was confident that I could do it. But I'm not. So, is there a bit more detailed explanation that anyone can give me? I'd really appreciate it!

Thank you.

[glas]

if you want to delete the away and here tables then open up phpMyAdmin and do it there, it's a DROP command

I don't see any "away" or "here" tables at all. :\


Editing to add that I must disagree with the people who tell me that the vb.org team helps, because I've not received one ounce of help from anyone on this forum on a multitude of topics. How sad.

[TECK]

glas, if you are not sure about something... you should not install a hack... never.
Let me know what tables and fields the hack created, I will make a script for you to drop them... if you are not comfortable with phpmyadmin.

[glas]

Originally posted by TECK
glas, if you are not sure about something... you should not install a hack... never.
Let me know what tables and fields the hack created, I will make a script for you to drop them... if you are not comfortable with phpmyadmin.

That's the thing, Teck. I was sure I could do it, and I pretty much did do it. The hack works fine. It just screwed something up in the process and that's not what I'm sure of to fix and I won't fix it unless I sure it'll work.

[TECK]

FROM_UNIXTIME(awaydate) AS awaydate,

Add a comma there at the end.

[Rose]

The end comma fixed that error, but produced another. It seems the code was messed in the install file, but it's fixed now (for Glas)