Invalid SQL after installing upgrade?

[farrellzach]

So I finally got all the VB4 files transferred to the server, and now I go to the upgrade portion of the site. The first time after I typed in my customer no., it gave me this:

Database error in vBulletin :

Invalid SQL:

SELECT value
FROM setting
WHERE varname = 'upgrade_from';;

MySQL Error : Table 'cbraught_cbraught9.setting' doesn't exist
Error Number : 1146
Request Date : Saturday, July 30th 2011 @ 04:59:24 AM
Error Date : Saturday, July 30th 2011 @ 04:59:24 AM
Script : http://ugbodybuilding.com/forums/install/upgrade.php
Referrer :
IP Address : 97.125.184.17
Username :
Classname : vB_Database
MySQL Version : 4.1.22-standard


And now it won't even let me type in my no. before going to that. Any help?

[Videx]

The error is not "invalid sql" - it's "Table 'cbraught_cbraught9.setting' doesn't exist". I'm no expert but I'm pretty sure that's not a standard vbulletin table. Could it have come from some previously installed (and incorrectly uninstalled) modification?

You're going to have to give lots more information about what you're doing. Moving to a new server? Upgrading from what to what?

[kh99]

cbraught_cbraught9 is the database name, "setting" is the table, which is a standard vbulletin table. Maybe you forgot to set your table prefix in the new config.php?