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: enter image description here

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:
categorypath-[empty] category-[empty] After resaving that category, then only body class shows the proper selector value for categorypath- & category-

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.

closed as off-topic by Sander Mangel, Marius Feb 14 '15 at 12:09

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions describing a problem that can't be reproduced OR seemingly went away on its own (or went away when a typo was fixed) are off-topic as they are unlikely to help future readers." – Sander Mangel, Marius
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    I haven't experienced this issue firsthand, although I have seen wacky reindexing issues with EE 1.13. If you were to take a clean copy of EE1.13.1.0 with your database. Using the default Enterprise theme, attempt to reindex via SSH. I wonder if you will still see the issue. If you don't see the issue anymore, you can point it to being a code issue, and if you do still see the issue you can point it to being a database issue. I would also suggest toggling flat catalog on and off (which I prefer to be turned off with EE1.13 due to issues). – kab8609 May 24 '14 at 20:27
  • 1
    @kab8609 fyi, flat catalog is turned on. May be i will try to toggle this and check further. Thanks – MagePsycho May 24 '14 at 20:35
  • @kab8609 Seems to be an issue with Flat Catalog. When I turned off the Flat Catalog then I can see the css selector in body class and the product page is loading fine. After that I turned it on and the same weird issue. – MagePsycho May 24 '14 at 20:57
  • Other notes: the category(product listing) page has url_key empty when reindexed. And I think the issue is somehow related with this empty url_key which gets populated when the related category is saved. – MagePsycho May 25 '14 at 17:25
  • What specific version are you on in 1.13? – kab8609 May 25 '14 at 17:42