HELP - cache does not exist

[kuroi]

If your host has attempted to unilaterally upgrade your site, then run like hell. That can only end in tears and they shouldn't be doing it.

However, the sudden appearance of a new admin section and a Zen Cart trying to find the cache table using the unrecognized (but default) zen_ prefix, does sound like somebody has been playing with the site.

Although you can upgrade by installing 1.3.7, reimporting and then upgrading your database and copying across stylesheets and other template files that you have changed, you would also need to amend those stylesheets and other template files to reflect changes that have been made in the versions of Zen Cart that come later than that which you were running when you created them - so it's not trivial.

I wouldn't even start such an upgrade until I was clear about the changes had occurred in the first place and was confident that they wouldn't happen again.

[midiwhale]

Thanks kuroi
Obviously I am greatly concerned about that too.

Can I just reset this cache setting?

But in my phpmyadmin config there is no setting for cache directory that I can see, as outlined by lynda in another post.

How can I best set this back to a working state and keep my existing products (and ideally orders/client records).

Should I just upgrade 1.37 over it ?

Is that safe if I was on a 1.2 something?
Problem is I can' remember exactly which version it was.

If I'm going to have to export the database and re-import it, any quick pointers how to do this efficiently wothout having to rename table prefixes and re-importing rubbish admin and cache settings back in?

I'm begining to think the smart money is in two databases, one for admin and 1 purely for client data.... which is 100% portable and idiot proof portable!

[kuroi]

It's difficult to advise here without knowing more about your original setup and what it is now.

Here's what seems likely ... you still have a database as you haven't been plopped into the zc_install routine so step 1 is lock it down by doing a back up using phpMy Admin.

Then look at it (also via phpMyAdmin) to see whether it uses table prefixes and if so what they are.

Then look in your includes/configure.php admin/includes/configure.php and blah/includes/configure.php to see what the database prefix is defined as in there (it will be in the block towards the bottom).

Then go into the includes/templates/template_default/css/stylesheet.css and take a look at the date in the version $ID line at the top. This will tell me which version of the Zen Cart code is now on your system.

Post all that back here and separately PM me the name of your host (that last piece of data is by private message because I wouldn't want to cast aspersions about a host by having them named publicly, but knowing which it is may provide some clues as to what has happened).

[kuroi]

One other task ...

Using phpMyAdmin again, look at the project_version table in your database, which will tell you what Zen Cart version your database is.

[midiwhale]

The default stylesheet on my local backup says

// +----------------------------------------------------------------------+
// $Id: stylesheet.css 1223 2005-04-22 03:46:20Z ajeh $

The default stylesheet on the broken web shop says
(waiting an hour to download it all now.....)

One oddity, is on my local backup I have no index.php in the cache folder.
On the broken web version I have an index.php in the cache folder.
Is that normal and from what version ?

cache index.php
// $Id: index.php 1322 2005-05-06 23:22:28Z drbyte $
//

// send to domain root
session_write_close();
header('Location: ' . 'http://' . $_SERVER['HTTP_HOST']);
exit();
?>

[midiwhale]

Project version - Cool Tip ;-)

Project version says 2.5 for main and db
Project history says 2.4

I can't remember if I did do an upgrade or not.

So doesn't look like a forced (or attempted?) 3.6 upgrade then ..... ?

[DrByte]

None of the upgrade tools do anything to the db_cache table.
If your db_cache table is missing, you can recreate it by finding the "CREATE TABLE db_cache ..." section of the mysql_zencart.sql file in the zc_install folder.

[midiwhale]

Thanks DrByte !!

I had a db_cache entry in the database. Just not the entry in the php file, lynda mentioned.


I've found the includes config had changed for the SSL path entry.

Also counters had changed from the backup.

I'm now getting;

1146 Table 'microban_zc1.meta_tags_categories_description' doesn't exist
in:
[select * from meta_tags_categories_description mcd where mcd.categories_id = '0' and mcd.language_id = '1']

and indeed this isn't in the current database (v2.5)

Seems it's a half way upgrade ? - not sure how, who or to what.


Assuming this is a 2.5 version, is it safe for me to do a 3.6 upgrade and do the table upgrades ? bearing in mind I can't log-in as admin, or visit the front page yet ?

WDYT ??

I could do a complete backup to live restore, but AYK it takes ages and there's not guarantee it will work anyway even then.

WDYT is my safest course of action?

I have backed up the mysql file (including config table, which is the bit that worries me) and the broken shop in a spare folder.

Sorry I can't think clearly at the moment. I just wasn't expecting this right now......

Thanks for your help guys !