Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 08-27-2004, 05:32 AM
digitalPIMP digitalPIMP is offline
 
Join Date: Jun 2002
Location: Brooklyn, NY
Posts: 5
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default [HELP!!] Please help...I'm Locked out of my forum

After a member said that they couldn't see the forums, I logged out just to see if it was a cookie problem.
Low and behold...I'm locked out!!!
I cant login into the admin area to turn off the vbpager and All of my SQL tables start with hevdigg_vb_blah blah blah

What could be the script making the forum look for a table called hevdigg_vb.pager???

Here's the error page

PHP Code:
Database error in vBulletin 3.0.3:

Invalid SQLselect p.tosessionid from pager as p left join session as 
s on (s.sessionhash p.tosessionidwhere p.active=and  
p.tosessionid='02f62bcf40833670c25e3c57a6f4378e'
mysql errorTable 'hevdigg_vb.pager' doesn't exist

mysql error number: 1146

Date: Thursday 26th of August 2004 10:58:48 PM
Script: http://forum.crnunplugged.com/
Referer: 
Username: Unregistered
IP Address: xxxxxxxxxxxxx 
Any help is appreciated as I'm lost in what to do and truly locked out of my forum that I just started promoting.

Thanks in advance guys/gals,
digitalPIMP
Reply With Quote
  #2  
Old 08-27-2004, 05:39 AM
digitalPIMP digitalPIMP is offline
 
Join Date: Jun 2002
Location: Brooklyn, NY
Posts: 5
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sorry...I forgot to mention that I have the:
HTL hack
Arcade hack
Ucost store hack
and the vbpager hack installed
Reply With Quote
  #3  
Old 08-27-2004, 01:49 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

it seems the vbpager hack doesn't support table prefixes.
It's a bug most authors tend to produce sometimes

look through the vbpager install file into the query and change all
Code:
FROM pager AS p
into
Code:
FROM " . TABLE_PREFIX ."pager AS p
Reply With Quote
  #4  
Old 08-28-2004, 08:11 AM
digitalPIMP digitalPIMP is offline
 
Join Date: Jun 2002
Location: Brooklyn, NY
Posts: 5
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks alot Xenon.....Thats exactly where the problem was.
It was inside of the global.php file.....back to promoting.

thx again bro!
Reply With Quote
  #5  
Old 08-28-2004, 03:21 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

you're welcome
Reply With Quote
Reply


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 10:58 PM.


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.04159 seconds
  • Memory Usage 2,198KB
  • Queries Executed 11 (?)
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)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_code
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)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_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