Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
Away Reason Hack Details »»
Away Reason Hack
Version: , by glas glas is offline
Developer Last Online: Dec 2003 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 01-28-2003 Last Update: Never Installs: 0
 
No support by the author.

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!

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 01-28-2003, 02:55 AM
mr e's Avatar
mr e mr e is offline
 
Join Date: Dec 2001
Posts: 461
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

if you want to delete the away and here tables then open up phpMyAdmin and do it there
Reply With Quote
  #3  
Old 01-28-2003, 10:59 AM
glas glas is offline
 
Join Date: Dec 2002
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #4  
Old 01-28-2003, 05:43 PM
glas glas is offline
 
Join Date: Dec 2002
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #5  
Old 01-29-2003, 04:03 AM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #6  
Old 01-29-2003, 10:46 AM
glas glas is offline
 
Join Date: Dec 2002
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #7  
Old 01-30-2003, 06:56 AM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Code:
FROM_UNIXTIME(awaydate) AS awaydate,
Add a comma there at the end.
Reply With Quote
  #8  
Old 02-01-2003, 08:51 PM
Rose's Avatar
Rose Rose is offline
 
Join Date: Nov 2001
Location: K-Town, Germany
Posts: 619
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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)
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:12 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
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