Go Back   vb.org Archive > Community Discussions > Forum and Server Management
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 05-12-2011, 04:14 AM
pakhackerz pakhackerz is offline
 
Join Date: Jun 2010
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database Error Help

I Am getting this error

Database error in vBulletin 4.0.8:

Invalid SQL:
SELECT userid from post where threadid='125' AND userid=1;

MySQL Error : Table 'reviewca_vb.post' doesn't exist
Error Number : 1146
Request Date : Thursday, May 12th 2011 @ 05:12:10 AM
Error Date : Thursday, May 12th 2011 @ 05:12:11 AM
Script : http://forums.reviewcar.com/showthread.php?t=125
Referrer : http://forums.reviewcar.com/
IP Address : 182.177.57.163
Username : reviewcar
Classname : vB_Database
MySQL Version : 5.0.92-community


can someone help me in this??
Reply With Quote
  #2  
Old 05-12-2011, 08:33 AM
Jack.D Jack.D is offline
 
Join Date: Mar 2011
Posts: 40
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

try disabling mods in config.php

Originally Posted by Bob_R
Where would I find the aforementioned config.php file??

Turn off ALL MODIFICATIONS. You can do this by disabling them all but the best and highly recommended way of doing this is by locating your config.php file and edit it (make a copy of it first and do not use notepad to edit use an external editor such as notepad ++ google it etc) and at the top below <php? add this:

Code:
define('DISABLE_HOOKS', true);
Reply With Quote
  #3  
Old 05-12-2011, 01:29 PM
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Posts: 2,559
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by pakhackerz View Post
I Am getting this error

Database error in vBulletin 4.0.8:

Invalid SQL:
SELECT userid from post where threadid='125' AND userid=1;

MySQL Error : Table 'reviewca_vb.post' doesn't exist
Error Number : 1146
Request Date : Thursday, May 12th 2011 @ 05:12:10 AM
Error Date : Thursday, May 12th 2011 @ 05:12:11 AM
Script : http://forums.reviewcar.com/showthread.php?t=125
Referrer : http://forums.reviewcar.com/
IP Address : 182.177.57.163
Username : reviewcar
Classname : vB_Database
MySQL Version : 5.0.92-community


can someone help me in this??

It seems like the cause could be the db prefix. At the query it seems like you are not using it but at the error message it is reporting that it has vb_. Can you check your db tables and post here a screenshot?
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 01:22 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.03505 seconds
  • Memory Usage 2,177KB
  • 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
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)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