About Magento Cache
This article targets the Magento Cache Management features. It aims to help web developers troubleshoot catalog rewrites, layered navigation indices, and rebuilding search index problems. These problems may or may not be the fault of a bug in Magento, therefore I have put together a checklist to help narrow down a solution, before reporting a bug.
This troubleshoot article, assumes you have direct access to your Magento files, either local or remote.
Problems
Magento stalls forever; when I Refresh Catalog Rewrites, Refresh Layered Navigation Indices; or when I Rebuild Search Index.
Magento redirects me to home page; when I Refresh Catalog Rewrites; Refresh Layered Navigation Indices, or when I Rebuild Search Index.
Nothing happens, when I Refresh Catalog Rewrites; Refresh Layered Navigation Indices, or when I Rebuild Search Index.
- 1.2.x and Similar
- Ubuntu Server (Linux)
- Moderate
- No Magento Mods
- Might require you to edit php config file and Magento file permissions.
Solution
The cache management scripts are not able to start or finish the task, below is a checklist containing possible fixes so that the scripts can do the job.
Checklist
777 your magento_install/app/etc/use_cache.ser
Edit your php.ini file to allow longer execution time;
max_execution_time = 18000
Make sure your attributes with multiple select, drop downs, and yes/no are not searchable (a.k.a quick search).
The only ones which should be searchable (a.k.a quick search) are text area and text field.
Make sure all your products have the required attributes filled in. In some cases you might of changed the attribute to required, so you have to go back to your products and fill it in.
Make sure your configurable products do not require a “Unique Value” in Attribute Properties
Other Helpful Tasks
If you’ve made changes to your ‘Attribute Properties’ in Catalog> Manage Attributes> Your Custom Attribute, make sure all the products correctly reflect the new ‘Attribute Properties’.
Manually delete all cache stored in magento_install/var/cache.
First refresh “Layered Navigation Indices” than rebuild “Search Index”.
" Refreshing, Clearing, Rebuilding Cache in Magento "
Great post! Just wanted to let you know you have a new subscriber- me!
" Refreshing, Clearing, Rebuilding Cache in Magento "
Thanks for your post! Your help and time is very much appreciated.
" Refreshing, Clearing, Rebuilding Cache in Magento "
The main cause of this problem is underresourced servers or very large product counts. Hence I developed several scripts to allow this process to be split up.
You might also note that when ever you perform a product import or update the layered navigation cache will run.
http://chrismckee.co.uk/magento-commerce-layered-navigation-cache-error-part-badger-part-duck/
" Refreshing, Clearing, Rebuilding Cache in Magento "
Hi Great post thanks for the info.
" Refreshing, Clearing, Rebuilding Cache in Magento "
We spent countless hours trying to get the Refresh of Layered Navigation Indices to work.
We had close to 10000 products on pacwave.com runnning on a VPS, and nothing we did worked.
The solution was to add RLimitCPU 1200 to the .htaccess file. This basically prevents the refresh script from consuming too much of the CPU resources and crashing.
" Refreshing, Clearing, Rebuilding Cache in Magento "
Dear Cj
Whenever i perform a search i get the follwing error message SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
Any ideas plz
" Refreshing, Clearing, Rebuilding Cache in Magento "
great, Thank you. saved me half a day.