PLEASE HELP: zen_db_cache does not exist

[isaacr25]

I just completed a database migration and when I go to the store url to attempt running fix_cache_key.php, I get the following error:

1146 Table 'jacksold_zc1.zen_db_cache' doesn't exist
in:
[db_cache table]

I've checked the configure.php files in both admin/includes and includes directories, and they both have the DB_PREFIX as "zen_"

Please advise. Thanks.

[DrByte]

1146 Table 'jacksold_zc1.zen_db_cache' doesn't exist

Let's dissect the error message:
1146 = the error number assigned from MySQL
Table = we're talking about a Table here
jacksold_zc1 = this is the name of the database being accessed
zen_db_cache = this is the name of the table where the problem was found
doesn't exist = this is the problem encountered

So, you already confirmed that "zen_" is the consistent prefix expected.
Now you need to open your "jacksold_zc1" database and make sure that the zen_db_cache table actually exists there.
But first I suggest that you check to be sure that you really meant to use "jacksold_zc1". Isn't that your "old" database?

[isaacr25]

Let's dissect the error message:
1146 = the error number assigned from MySQL
Table = we're talking about a Table here
jacksold_zc1 = this is the name of the database being accessed
zen_db_cache = this is the name of the table where the problem was found
doesn't exist = this is the problem encountered

So, you already confirmed that "zen_" is the consistent prefix expected.
Now you need to open your "jacksold_zc1" database and make sure that the zen_db_cache table actually exists there.
But first I suggest that you check to be sure that you really meant to use "jacksold_zc1". Isn't that your "old" database?

I actually don't have a table called zen_db_cache. I do have one called db_cache.

The "old" is actually part of the company name... it doesn't refer to an old database.

What next? Thanks.

[Ajeh]

Do any other tables start with zen_ or ... do they all have more normal names like:
admin
address_book
products
products_description
etc. etc. etc.

[isaacr25]

Do any other tables start with zen_ or ... do they all have more normal names like:
admin
address_book
products
products_description
etc. etc. etc.

The tables have "normal" names.

[DrByte]

I've checked the configure.php files in both admin/includes and includes directories, and they both have the DB_PREFIX as "zen_"

The tables have "normal" names.

okay, then why are you using "zen_" as a table prefix in your configure.php files?

[Ajeh]

Could you peek at your files, on the server, and see if they contain a prefix:

  define('DB_PREFIX', 'zen_');

And change them in the files:
/includes/configure.php
/admin/includes/configure.php

to read:

  define('DB_PREFIX', '');

and see if removing the prefix makes the magic occur ...

[isaacr25]

Ok,
I removed the zen_ from both DB_PREFIX settings in both configure files, and this worked fine.

Another issue: Now I'm getting an error saying that the configure.php file is writeable. I try chmodding to 444 (its currently 644), but the permissions aren't saving. When I go back to permissions, they're back to 644.

See the site here.

[DrByte]

okay, then why are you using "zen_" as a table prefix in your configure.php files?

Ok,
I removed the zen_ from both DB_PREFIX settings in both configure files, and this worked fine.

Why did you have "zen_" as the prefix in the first place?

[Ajeh]

This is because your hosting site is not giving you control via FTP to make this change to 444 ...

Go into your Control Panel and change the setting ...

NOTE: changing to 444 means you cannot overwrite this file without first changing to 644 via your FTP program ...

NOTE: be sure you carefully review your new found data and that it is, in fact, the right data and most current for your site ...