Deleting categories caused cache problems

[DaveDajew]

I've seached the forums and could not find an answer.

 

I deleted a category on the site and here's what happened:

 

Admin side

- /admin summary - normal. All 2600+ products

- /admin/categories.php - nothing

 

Website

- /categories.php - nothing

There is nothing in the category tree save one arrow gif.

There are products on the first page and you can navigate through what's new. The search feature does not work. External links to products do not work.

 

I think the problem is cache problem but do not know how to fix it.

 

Cache-ing is set to true to the /tmp folder.

 

I found an old post that Harold fixed the reset() to clear() in 2003. I don't know what version mine is. How do I check.

 

Suggestions?

 

dave

[mushindo]

I've seached the forums and could not find an answer.

 

I deleted a category on the site and here's what happened:

 

Admin side

- /admin summary - normal. All 2600+ products

- /admin/categories.php - nothing

 

Website

- /categories.php - nothing

There is nothing in the category tree save one arrow gif.

There are products on the first page and you can navigate through what's new. The search feature does not work. External links to products do not work.

 

I think the problem is cache problem but do not know how to fix it.

 

Cache-ing is set to true to the /tmp folder.

 

I found an old post that Harold fixed the reset() to clear() in 2003. I don't know what version mine is. How do I check.

 

Suggestions?

 

dave

 

Try turning cache off for the moment via admin tools, see if the links work okay again, then try turning it back on. Sort of an easy way to "flush" the cache system.

[DaveDajew]

Tried and failed. Any other suggestions?

[mushindo]

Tried and failed. Any other suggestions?

 

Do you have any funky punctuation in your category names?

 

For example: Bruce's Category instead of Bruce Category?

 

If so try to remove the puntuation and see if that resolves the issue. I ran across a similar issue on a custom cart not long ago, and that was the cause of it.

[DaveDajew]

All categories have exclamation points after the words. It's been this way for 2+ years. When you click on categories/products from the /admin page, there are no products.

 

dave

[DaveDajew]

Any help is appreciated. I can always go to the backup but that was 14 days ago and as I understand it, all new customer information, orders, etc revert to that date.

 

dave

[DaveDajew]

Here's the error codes on the admin/tools/cache controls:

 

Warning: filemtime(): Stat failed for /tmpcategories_box-english.cache24 (errno=2 - No such file or directory) in /home3/xxxxxxx/public_html/catalog/admin/cache.php on line 95

 

Warning: filemtime(): Stat failed for /tmpmanufacturers_box-english.cache (errno=2 - No such file or directory) in /home3/xxxxxxx/public_html/catalog/admin/cache.php on line 95

 

Warning: filemtime(): Stat failed for /tmpalso_purchased-english.cache862 (errno=2 - No such file or directory) in /home3/xxxxxxxx/public_html/catalog/admin/cache.php on line 95

[DaveDajew]

Here's the partial code with line 95 highlighted:

 

while ($cache_file = $dir->read()) {

$cached_file = ereg_replace('-language', '-' . $language, $cache_blocks[$i]['file']);

 

if (ereg('^' . $cached_file, $cache_file)) {

$cache_mtime = strftime(DATE_TIME_FORMAT, filemtime(DIR_FS_CACHE . $cache_file));

break;

}

}

 

$dir->close();

}

?>

[mushindo]

Here's the partial code with line 95 highlighted:

 

while ($cache_file = $dir->read()) {

$cached_file = ereg_replace('-language', '-' . $language, $cache_blocks[$i]['file']);

 

if (ereg('^' . $cached_file, $cache_file)) {

$cache_mtime = strftime(DATE_TIME_FORMAT, filemtime(DIR_FS_CACHE . $cache_file));

break;

}

}

 

$dir->close();

}

?>

 

The exclaimatrion points would not make a difference in the category or product names, only apostrophies would create issues.

 

Did you recently change up your configuration files?

 

Also I am not so sure that restoring the database from 14 days ago would resolve your cache problem. Issues like this are why I typically say away from the cache tool, especially since the load time gained from it is so minimal and not worth it in my opinion.

[DaveDajew]

the filemtime warnings have been taken care of in Cache Controls. The error messages were taken care of by putting changing /tmp to /tmp/

 

However, this did not fix the category tree issue. The categories are still not showing up on the index.

 

I need some help with this!

 

dave

[DaveDajew]

It's been 2 days. Here's where the site is at:

 

/admin:

summary shows correct info on products under the statistics heading

categories.php shows no products

 

/catalog (public side)

index shows new products. Everything looks normal EXCEPT the categories box. There are no categories nor a category tree!

Also, quick find does not work. The site can be browsed through the 'what's new" tab, but that's the only way. Direct links to products also work from external links. I've tried adding categories in the admin with the same names as the ones that disappeared hoping that products would link back into categories but that hasn't worked.

 

Who can help?