Zen Cart Logo
trapezoid-twopenny
Open navigation menu
Home Community Forum Plugins
Documentation
For Developers For Storeowners
Services Donate Get Started
Forums / General Questions / "Fix Cache Key" Issues

"Fix Cache Key" Issues

Locked
Results 1 to 10 of 10
This thread is locked. New replies are disabled.
03 Aug 2009, 01:17
#1
jbcholdings avatar

jbcholdings

New Zenner

Join Date:
Jul 2009
Posts:
32
Plugin Contributions:
0

"Fix Cache Key" Issues

I am migrating a Zen-cart installation from a godaddy host.

Follow instructions here: https://www.zen-cart.com/tutorials/index.php?article=100

I have successfully loaded the exported working database from the install on the website, and imported it successfully as well.

[scr]http://www.xbox360outletstore.com/ebay_images/db_export.png[/scr]

When upload this to ZC root and run it I get the following error:

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

(I blanked out the DB title) but you get the point!

I double checked all my settings in /includes/configure.php and they appear to correctly point to the cache directory!
03 Aug 2009, 03:31
#2
jbcholdings avatar

jbcholdings

New Zenner

Join Date:
Jul 2009
Posts:
32
Plugin Contributions:
0

Re: "Fix Cache Key" Issues

Oh yes -- not pictured but I did select the "DROP / VIEW / " feature...
03 Aug 2009, 04:54
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,506
Plugin Contributions:
173

Re: "Fix Cache Key" Issues

Usually that message appears when you've skipped the part in the tutorial about making sure the DB_PREFIX in the new site matches what was in the old site.
03 Aug 2009, 05:34
#4
jbcholdings avatar

jbcholdings

New Zenner

Join Date:
Jul 2009
Posts:
32
Plugin Contributions:
0

Re: "Fix Cache Key" Issues

DrByte:

Usually that message appears when you've skipped the part in the tutorial about making sure the DB_PREFIX in the new site matches what was in the old site.


The tutorial I linked to doesn't even have the string DB_PREFIX in it...I just ran a search

So what is this thing?
03 Aug 2009, 05:42
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,506
Plugin Contributions:
173

Re: "Fix Cache Key" Issues

Step 2a:
a. Install (when asked about the database-table-prefix during Database-Setup, use the same prefix that your old store uses)
03 Aug 2009, 05:44
#6
jbcholdings avatar

jbcholdings

New Zenner

Join Date:
Jul 2009
Posts:
32
Plugin Contributions:
0

Re: "Fix Cache Key" Issues

DrByte:

Step 2a:


I see thank you. I will give this a shot.

Thanks!
04 Aug 2009, 07:14
#7
jbcholdings avatar

jbcholdings

New Zenner

Join Date:
Jul 2009
Posts:
32
Plugin Contributions:
0

Re: "Fix Cache Key" Issues

DrByte:

Step 2a:


This is kind of embarrassing because I thought I understood--

I left my "DB_PREFIX" blank when I installed on the original server.

Now when I install the basis for my transplant I should leave it blank as well?
04 Aug 2009, 11:24
#8
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,506
Plugin Contributions:
173

Re: "Fix Cache Key" Issues

Yes .
04 Aug 2009, 15:13
#9
jbcholdings avatar

jbcholdings

New Zenner

Join Date:
Jul 2009
Posts:
32
Plugin Contributions:
0

Re: "Fix Cache Key" Issues

DrByte:

Yes .


I originally followed these steps (not changing the DB_PREFIX, leaving it blank when I installed the local version (Zen-cart).

(2) Save dumped the SQL db it populated (local installation)

(3) Re-imported and over-wrote the files (local installation)

(4) Replaced configuration files (with local installation originals)

(5) Imported remote webstore sql (from remote)

(6) Run fix_cache_key.php (locally, in root/index folder)

Ok just repeated the steps I took where am I going wrong!?
04 Aug 2009, 19:57
#10
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,506
Plugin Contributions:
173

Re: "Fix Cache Key" Issues

Okay, so, in your database, what are the names of the tables you have listed? Do they all have a common prefix? If yes, what is it?

And, if you go to your old server and do the same, what do you see?


Also, in your new server's configure.php files, what are ALL the database settings?
Are they different from the settings on your OLD server? They SHOULD be. If they're the same on both servers, then you likely copied your old server's configure.php files to the new server and now the new server can't find the data because the credentials in the files are invalid for the new server.