1146 Table 'xxxxx_xxx.configuration' doesn't exist

**mw4kids** · 3 Nov 2010, 01:24 PM

Hi All,

Recently moved my site to a new server. All was fine until this morning I saw this message when trying to access my site:

1146 Table 'xxxxx_xxx.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

Not sure if it occurred before or after canceling the old account.

Any ideas how I can fix this?

Thanks!

**kuroi** · 3 Nov 2010, 03:37 PM

Does you database have a prefix in front of the tables? e.g. zen_configuration?

**mw4kids** · 3 Nov 2010, 04:10 PM

Hi Kuroi,

Yes it does.

**kuroi** · 3 Nov 2010, 04:31 PM

Then you will need to add that prefix to your includes/configure.php and admin/includes/configure.php files.

Look for the lines that read

define('DB_PREFIX', '');

and insert your prefix between the two quotes after the comma.

**mw4kids** · 3 Nov 2010, 05:37 PM

thanks so much! Will give that a shot

**kuroi** · 4 Nov 2010, 02:07 AM

We've also seen a number of reports over the past 24 hours of configuration tables, with and without prefixes, simply disappearing. One hosts name seems to be involved in each case, either directly or as the possible ultimate host behind a reseller.

If your configuration table is missing, the above solution won't work for you. please post back here with details of your host and the version of Zen Cart that you are using.

**mw4kids** · 4 Nov 2010, 03:35 AM

HI Kuroi,

I was actually able to get my front end up by deleting the database and restoring a backup.

However, I still can't get into my admin area. Getting error message:

1146 Table 'xxxx_t4k.xxxxproject_version' doesn't exist
in:
[select * from xxxxproject_version WHERE project_version_key = 'Zen-Cart Database' ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Checked the config files and all seems fine with the paths

Trying to access using path:
http://mysite.com/admin/

no success

P.S. I transfered my site over to hostgator. Hosted a couple of other sites with them for some time now and never had an issue. Hope they are not the source of the problem.

Also I'm still using version 1.3.8

Thanks!

**DrByte** · 4 Nov 2010, 04:55 AM

Does the DB_PREFIX for your /admin/includes/configure.php match the DB_PREFIX in your /includes/configure.php ?

Does that prefix match the names of your tables in your database?

**mw4kids** · 4 Nov 2010, 05:26 AM

OK, think I know what i did wrong. My database has a prefix, but my tables in my mysql doesn't.

So when I took out that prefix name from

define('DB_PREFIX', '');

it worked!

Looks like I got the DB_Database and DB_Prefix mixed up.

Thanks for the help...would of taking me hours to figure that one out!!

Ciao!

**Ajeh** · 4 Nov 2010, 06:34 PM

Originally Posted by mw4kids

Also I'm still using version 1.3.8

Using that very old version of Zen Cart ... have you applied all of the Known Bug Fixes ...
http://www.zen-cart.com/forum/showthread.php?t=82619

and Security Patches and Updates ...
http://www.zen-cart.com/forum/showthread.php?t=131115

NOTE: upgrading to the current Zen Cart on our Home page has all of this and more ...

And have you looked through your site for signs of hacks in your files and database?