PDA

View Full Version : Database Error Help


pakhackerz
05-12-2011, 04:14 AM
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??

Jack.D
05-12-2011, 08:33 AM
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);

borbole
05-12-2011, 01:29 PM
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?