The Arcive of Official vBulletin Modifications Site.

Away Reason Hack · **Released**: 01-28-2003

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

Quote:

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 · #2 01-28-2003, 02:55 AM

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

glas · #3 01-28-2003, 10:59 AM

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 · #4 01-28-2003, 05:43 PM

Quote:

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 · #5 01-29-2003, 04:03 AM

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 · #6 01-29-2003, 10:46 AM

Quote:

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 · #7 01-30-2003, 06:56 AM

Code:

FROM_UNIXTIME(awaydate) AS awaydate,

Add a comma there at the end.

Rose · #8 02-01-2003, 08:51 PM

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)

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04140 seconds Memory Usage 2,257KB Queries Executed 23 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_code (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (8)post_thanks_box (8)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (8)post_thanks_postbit_info (7)postbit (8)postbit_onlinestatus (8)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!