Error message: MySQL Error: Table 'databaseprefix_databasename.options' doesn't exist MySQL Error Number: 1146

If you get an error like the one abelow during an upgrade:

MySQL Error :
Database Error In SunShop 4.3.2 Installer: Invalid SQL: SELECT * FROM `options` where name='version'

MySQL Error: Table 'databaseprefix_dbname.options' doesn't exist

MySQL Error Number: 1146

Date: Monday 14th 2012f May 2012 06:18:39 AM

Script: /install/index.php



This usually means that the $dbprefix line in your include/config.php file is incorrect. Make sure that  the line is commented or uncommented out depending on how you have it set up via MySQL or your hosting control panel.

For example, if you used "ss_" for your database but leave the line commented, it will lead the software to think your databases do NOT have prefixes and as such can't find the database you're defining.

Instead, make sure that line reads like the below:

$dbprefix = "ss_"; // Uncomment this line if this is a new install.

Adding the two slashes (//) in the beginning of that line "uncomments" the line.

If you're NOT using any prefix, that means you left the line commented during the initial installation. When you upgrade ensure that line retains its two slashes.


  • 89 Users Found This Useful
Was this answer helpful?

Related Articles

Our Hosting Recommendations

The following hosts have been reported to support the latest version of SunShop as of the...

Quick Installation Guide

1. First, download the following file to your local machine. (Version Checker). Once downloaded,...

Updating your software license key.

If we update your license key to change a domain, update the expiration, or make any profile...

Installing on a temporary or development server.

Our software licenses must be assigned to a domain in order for them to install properly. If you...

Checkout and My Account pages return "This Connection is Untrusted" or similar errors.

If you go to the "My Account" page ot try to checkout after adding a product to your cart and...