Magento 1.9.1: Sitemap Menu Option Missing – Troubleshooting

Finally found the cause of the above issue: shopping cart rules with a category condition

First I installed xdebug to try to find out what was going on. I found out that the the Subselect.php and Combine.php files were in an infinite loop when adding a configurable product to the cart. Looking for that issue I found this post: Magento debug trace That post refers to "have a sales rule with a subselection of categories, I ran into the OPs issue with an infinite loop."

So I removed the shopping cart rules that had a category condition and then it work perfectly. I was able to add any configurable product to the cart again. But I need the shopping rules I used. Adding a new one didn't work: if the shopping cart rule had a category condition, impossible to add configurable product to the cart. Without a category condition, no issues.

The fix module from Briand Litzinger (or Husseycoding) didn't fix the issue for me. But by changing the core file:

app/code/core/Mage/SalesRule/Model/Rule/Condition/Product/Subselect.php

From:

if (parent::validate($item)) {

To:

if (Mage_Rule_Model_Condition_Combine::validate($item)) {

Fixed the issue and I'm able to use cart rules with a category condition and add a configurable product to the cart.

There seems to ba several bug reports open against 1.9.1 that are not fixed yet.

Seems there is a thread where is mentioned the same query:

• https://community.magento.com/t5/Technical-Issues/cannot-generate-sitemap/td-p/41623

There is also ticket open with the same issue:

• https://github.com/magento/magento2/issues/8671

By looking the query then t2_name is not found therein joins.

This is added to select in

vendor/magento/module-sitemap/Model/ResourceModel/Catalog/Product.php::getCollection

As also GitHub issues say then this is added only when you have enabled "Add Images to Sitemap".

You should try to disable this option to have at least sitemap without image info.