[Forum] Upgrade 3.8.7 to 4.2.1 MySQL Error: Table 'database.setting' doesn't exist

[Kwak]

Hello, I'm getting the following error message upon going into install/upgrade.php when upgrading 3.8.7PL3 to current 4.2.1. How would you resolve this, thank you.


Database error in vBulletin :

Invalid SQL:

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

MySQL Error : Table 'database.setting' doesn't exist
Error Number : 1146
Request Date : Thursday, May 9th 2013 @ 04:08:45 PM
Error Date : Thursday, May 9th 2013 @ 04:08:45 PM
Script : http://www.website.com/install/upgrade.php
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.68-cll

[BirdOPrey5]

If you open your /includes/config.php file, do you have any value set for your table prefix? If so, what is it?

[BirdOPrey5]

BTW is this is an UPGRADE you should delete the install.php file from your /install/ directory as soon as possible, though it is unrelated to this error.

[Kwak]

If you open your /includes/config.php file, do you have any value set for your table prefix? If so, what is it?

table prefix is blank
Deleted the install.php.

In the config.php file, I've only edited webmaster email, database username/password, and the admin directory name.

[Kwak]

I forgot to change the prefix to what the mysql database show, so I've edited to 'vB3_' prefix and reuploaded the config.php file.

The same error message.

[BirdOPrey5]

OK well no prefix is good in a way... that means it's not a bug in the upgrader- which I also verified while I was waiting for an answer...

So now the problem is that your setting table doesn't exist- Either the config.php is pointing to the wrong database or somehow your setting table was deleted. Use phpmyadmin or whatever other MySQL tool you have to log into the database manually (the one in the VB4 config.php file) and see if the setting table exists. It should, but this error is saying it doesn't.

If it's not there, which I suspect it won't be- is the rest of the database there? Is there any database left? Hopefully you are just pointing to the wrong database.

[Kwak]

Thank you Joe! Problem resolved.