http://www.magentocommerce.com/bug-tracking/ en MagentoCommerce Copyright {gmt_date format="%Y"} {gmt_date format="%Y-%m-%dT%H:%i:%s%Q"} http://www.magentocommerce.com/bug-tracking/issue?issue=5207 Posted: 2009-02-11 18:04:13
Category: Product
Version: 1.2.1
Priority: normal
Status: closed
Reported By: burleyb

Steps to Reproduce:
1- Add at least 61 websites to your installation
2 - Try to save a product

Results:
You will receive a mysql error:
General error: 1116 Too many tables; MySQL can only use 61 tables in a join


Analysis:
I found that the function applyAllRulesForDateRange in
app/code/core/Mage/CatalogRule/Model/Mysql4/Rule.php saves rules for every website by joining in a table for every website. This reaches mysql's limit for joins on my platform. This is 61 for me, but I believe this varies by mysql version and 64 vs. 32 bit. I fixed it by only doing the refresh on websites that the product is assigned to. This obviously has the same limit if you assign a product to 61 websites, but works for me for now.

Also in that file the function removeCatalogPricesForDateRange creates a query for inserting into catalogrule/affected_product that never gets executed.

---

]]> #1 / Comment by Magento Team

Hello burleyb,

This issue was fixed. Please check the latest Magento release at http://www.magentocommerce.com/download/

Thank you.]]>