If this is your first visit, check our documentation. To post, register or login.
Forums / Installing on a Linux/Unix Server / cache problem on server install

cache problem on server install

Locked

Started by markov on 16 Nov 2006, 2:42 AM · Views: 2,311

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
16 Nov 2006, 2:42 AM
#1
markov avatar

markov

New Zenner

Join Date:
Sep 2006
Posts:
32
Plugin Contributions:
0

cache problem on server install

Hi there,
I am trying to install a copy of my testing site (which is on a local wampserver) to the Clients website. I have followed the details according to:
http://www.zen-cart.com/wiki/index.php/Server_Admin_-_Switch_Servers

. My local site was created on 3.1.5 Everything has been fine but I have hit a hurdle.
Basically i have done teh following:
I created a fresh install on the Client site via cPanel and Fantastico.
Tested it - all working.
Then I uploaded my old files over the new files on the new server.
Tested again - all still working - am seeing Classic Green and is still working correctly.
Before I drop all the new tables on the new database - I go to the admin and login with username and password. All good. I now test my site by switching to my NEW template. All good - I can see the site with my new look - but showing the default content of Classic Green. Everything is correct.

I now drop all tables in new database and IMPORT my old site database.
Executes correctly.
I now grab fix_cache_key.php and upload.

NOW - when I go to view the index.php page I am getting an error:
...........................................................................................

1146 Table 'ins58917_zc1.zen_db_cache' doesn't exist
in:
[select * from zen_db_cache where cache_entry_name = 'zc_7eb4ed1f36d90140477d9474b61e0e26']

...........................................................................................

Similarly if I try and run fix_cache_key.php - I get the same error.

I am stuck. Everthing was good until I uploaded my database. Can anyone help me out here? A point to notice is that my old site was created with version 1.3.5 - the new install via cPanel was 1.36 - however i don't know if this is a problem as I was seeing the site before I dropped the tables and uploaded my database.

Thanks

17 Nov 2006, 12:18 AM
#2
website_rob avatar

website_rob

Inactive

Join Date:
Oct 2006
Location:
Alberta, Canada
Posts:
4,572
Plugin Contributions:
0

Re: cache problem on server install

Working inbetween versions will always create problems. :ohmy:

You could try uploading the 'zc_install' dir. and run that, using the update db option. If it doesn't work, reinstall the v1.3.6 complete with a db, making sure to use the update db option. Then confirm all is working as it should. Only then, drop the current db and upload your previous.

Mind you, this all presumes you are not using any mods, else you will have to upload/install them before updating db.

The learning is in the doing.

Potent Products

17 Nov 2006, 12:37 AM
#3
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: cache problem on server install

Also, look in the files:
/includes/configure.php
/admin/includes/configure.php

Are you referencing prefixes in those such as:
zen_

Look at your database in phpMyAdmin ...

Are your 93 tables using names like:
zen_admin

or do you see:
admin

The database prefix in the configure.php files should be set to '' if no prefixes or should have the prefix set 'something_' if you are using them ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

17 Nov 2006, 1:21 AM
#4
markov avatar

markov

New Zenner

Join Date:
Sep 2006
Posts:
32
Plugin Contributions:
0

Re: cache problem on server install

Hi Website Rob - Hi Linda,
A very big thanks to you both for taking the time to answer my questions.
Linda was spot on with her answer - my prefix in the existing configure.php files was set to _zen. However - my old database files had no prefix. I checked this by comparing my old SQL DB against the new SQL DB on my Wampserver.

Once I removed _zen and left the prefix as '' - all worked perfectly.
Both of your answers were really very much appreciated - I can now go and make a cup of tea and relax a bit.

17 Nov 2006, 1:39 AM
#5
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: cache problem on server install

Thanks for the update and glad we were able to get you back up and running ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!