ERROR 0071: There appears to be a problem with the database. Maintenance is required.

This error generally means that one or more system tables cannot be found in the database.

This can occur if you've provided valid DB credentials in your configure.php files and the database itself exists but contains no tables. In this case you need to run zc_install to properly setup the database contents.

Further, this symptom most commonly occurs when moving your site to another server and not properly preserving the DB_PREFIX setting from the old site's configure.php into the new site's configure.php, thus the tablenames cannot be located because they don't match up properly. Or you need to run zc_install to create the proper tables. Or you need to import the correct matching database data, since what you've got in the database presently isn't suitable for your current DB_PREFIX configuration.

(To manually figure out the correct prefix to use, look at the database using phpMyAdmin and see what common 2-4 letter prefix starts all the tablenames. Then set that value into the DB_PREFIX definition in your configure.php file.)
 
  • 104 Users Found This Useful
Was this answer helpful?

Related Articles

How can I find out what version of Zen Cart or PHP or MySQL I'm using?

To find out what version of Zen Cart or PHP or MySQL you are currently using, you can simply go...

Getting a BLANK PAGE? Here's the answer ...

If you're getting a blank page when trying to browse to a certain page on your store, or after...

What's New in the Upcoming v2.0 release?

Database Abstraction Layer and Sql CacheThe abstraction layer has been re-factored to include a...

Image Preparation - How-to

I've seen several posts where people obviously aren't quite sure about the best way to set up...

Some tips to modify stylesheet

1. Download Web Developer extension for FireFox here2. Install & restart FireFox. You should...