Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 11-08-2006, 10:33 PM
InTeNsE-HuMoR InTeNsE-HuMoR is offline
 
Join Date: Sep 2006
Location: Northern Ireland, UK
Posts: 123
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default MySQL Error : Table 'extre9_vbulletin.forum' doesn't exist

Hi,
Can someone explain to me what I need to do to solve this problem:

Quote:
Database error in vBulletin 3.6.1:

Invalid SQL:
SELECT * FROM forum WHERE forumid='42';

MySQL Error : Table 'extre9_vbulletin.forum' doesn't exist
Error Number : 1146
Date : Wednesday, November 8th 2006 @ 04:28:05 PM
Script : -----------------------------------
Referrer : ----------------------------------
IP Address : -------------
Username : -------------
Classname : vb_database
I have alot of problems recently when I tried to install VbAdvanced on my forum. First the template looked screwed up then after un-installing vbadvanced followed by the template things got worse the more I tried to fix it. Everything on my forum now seems to work apart from this one error. Can anyone on here tell me what it means and show me how to fix it, please?
Reply With Quote
  #2  
Old 11-09-2006, 11:46 AM
r007 r007 is offline
 
Join Date: Jan 2003
Posts: 25
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hey InTeNsE-HuMoR -

The error is saying it can't find the 'forum' table in the 'extre9_vbulletin' database.
If you use something like phpmyadmin, does it list that table?
Reply With Quote
  #3  
Old 11-09-2006, 06:14 PM
InTeNsE-HuMoR InTeNsE-HuMoR is offline
 
Join Date: Sep 2006
Location: Northern Ireland, UK
Posts: 123
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yeah, it is definetly there. At least from what I can see (i'm a newbie) but I have backed up the database and am wondering if I should just use phpmyadmin to restore the backup and then just change the defualt template and apply the edits for each modification over again (I have installed a new template since when the last backup was created).
Reply With Quote
  #4  
Old 11-10-2006, 11:44 AM
r007 r007 is offline
 
Join Date: Jan 2003
Posts: 25
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The two other things you can try before you restore your backup is going to your vBulletin Options and disabling the Plugin/Hook System... Maybe there is a rogue plugin that's screwing something up.

The other thing you can try is reuploading all the vBulletin files and see if that does anything.
Reply With Quote
  #5  
Old 11-10-2006, 03:49 PM
Quarterbore Quarterbore is offline
 
Join Date: Mar 2005
Location: Valley Forge PA
Posts: 538
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Do you have a prfix on the table itself?

For example:

'extre9_vbulletin.vb_forum'

If so, you need that too! Is a custom hack generating this? If so, you need to remember to code in the prefix...

But I am just guessing with the limited info you shared! If it is the prefix, I bet you forgot to add it to the vBA config file!
Reply With Quote
  #6  
Old 11-13-2006, 06:40 PM
InTeNsE-HuMoR InTeNsE-HuMoR is offline
 
Join Date: Sep 2006
Location: Northern Ireland, UK
Posts: 123
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well after just having the same error 5 minutes ago (I did a clean install to fix the last problem) I was about to post here from some further help when I read your replies and started disabling plugins. The plugin that was causing the problem was "Age Lock v2 Beta" Everything seems to be working fine now.
Reply With Quote
  #7  
Old 02-03-2007, 01:01 PM
NaughtyStud's Avatar
NaughtyStud NaughtyStud is offline
 
Join Date: Jan 2007
Posts: 43
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by r007 View Post
The two other things you can try before you restore your backup is going to your vBulletin Options and disabling the Plugin/Hook System... Maybe there is a rogue plugin that's screwing something up.
I had been trying to help a friend of mine with his board and couldn't figure out what to do.That's exactly what it was..now the search begins for the bad plugin. Thank you so much r007.
Reply With Quote
Reply

Thread Tools
Display Modes

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:17 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.03882 seconds
  • Memory Usage 2,204KB
  • 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_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)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