Every time I reindex using command line:
php shell/indexer.php reindexall
And try to load the product page, it goes into infinite redirect loop. For example in firefox, the browser results as:
But all the other pages: Homepage, Product listing(category) page etc. just works fine.
But one strange thing is, when you go through each category in backend to resave it and try to re-load the product page, it works fine.
I am trying to debug this strange issue. One thing I have noticed in product listing (category page) is: body class is empty for css selector:
After resaving that category, then only body class shows the proper selector value for
Has anyone faced this kind of issue? Any idea/suggestions on the fixings?
Note: I am using Magento EE 1.13 & flat catalog is turned on. And we have updated the category & product url_key attribute from global to store view (to have different urls for different stores):
UPDATE catalog_eav_attribute SET is_global=0 WHERE attribute_id IN (SELECT attribute_id FROM eav_attribute WHERE attribute_code IN('url_key'))
After debugging, it is found that catalog_category_flat_store_[store_id] table's url_key field is NULL after reindexing. Also, catalog_category_entity_varchar has no entries for url_key for those categories for which product are not loading.