Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Deleting categories caused cache problems


DaveDajew

Recommended Posts

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

Link to comment
Share on other sites

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.

Sincerely,

Bruce

 

19 contributions submitted

Link to comment
Share on other sites

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.

Sincerely,

Bruce

 

19 contributions submitted

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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();

}

?>

Link to comment
Share on other sites

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.

Sincerely,

Bruce

 

19 contributions submitted

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...