PDA

View Full Version : Database Error? SQL Help?


idoL1
05-15-2009, 05:20 PM
well i installed a bridge to integrate my main cpanel (EGL) to vbulletin...and after that i attempted to upgrade vbull from 3.8.1 to 3.8.2 ...and i added a vb_ prefix to my sql database....and now whenever u try n view a post....i get this error
Invalid SQL:
SELECT t.champion, u.userid FROM vb_tournaments AS t
LEFT JOIN vb_user AS u ON (t.champion = u.username)
WHERE champion<>'';

MySQL Error : Table 'padilac_idal.vb_tournaments' doesn't exist

i have backup of my tables..when i try and do a fresh install of vbull it asks which tables i would like to delete but it forces me to delete all of them.....if i freshinstall vbulletin again...can i overwrite certain tables (my users..and posts etc with my current backup files?

Lynne
05-15-2009, 06:15 PM
Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

You may want to uninstall that modification and reinstall it correctly without the prefix.