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?