且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Magento平板产品

更新时间:2023-11-30 12:03:46

当您的产品数量超过

<global>
    <catalog>
        <product>
            <flat>
                <max_index_count>64</max_index_count>
            </flat>
        </product>
    </catalog>
</global>

索引.此最大值通常在app/code/core/Mage/Catalog/etc/config.xml中定义,并且与默认的mySQL安装允许的最大64个键匹配,直到它们出现错误

indexes. This maximum usually is defined in app/code/core/Mage/Catalog/etc/config.xml and matches the maximum number of 64 keys allowed by default mySQL installations, before they error with

ERROR 1069: Too many keys specified. Max 64 keys allowed

您的问题不是产品具有多少属性,而是可过滤和/或可排序的属性(当然, all 除外).

Your problem is not how many attributes your products have, but how many of them are filterable and/or sortable (except all your attributes are, of course).

跟踪Mage_Catalog_Model_Resource_Product_Flat_Indexer::getFlatIndexes(),以了解Magento如何达到总共521个索引.

Trace Mage_Catalog_Model_Resource_Product_Flat_Indexer::getFlatIndexes() to find out how Magento reaches a total of 521 indexes.

要进行快速检查,您还可以查看catalog_eav_attribute表,并检查可过滤(is_filterable = 1)和/或可排序(used_for_sort_by = 1)的属性的数量

For a quick check you can also have a look at your catalog_eav_attribute table and check how many attributes are filterable (is_filterable = 1) and/or sortable (used_for_sort_by = 1)