Magento平板产品 [英] Magento flat product

问题描述

当尝试启用产品平面数据并为其重新编制索引时-从magento中获取错误

when trying to enable and reindex Product Flat Data - getting error from magento

平面目录模块的可过滤和/或可排序限制为64个 属性.当前有521个.请减少数量 的可过滤/可排序属性，以使用此模块.

The Flat Catalog module has a limit of 64 filterable and/or sortable attributes. Currently there are 521 of them. Please reduce the number of filterable/sortable attributes in order to use this module.

我不明白这是什么意思，以及magento从何处获得此值. 在属性中，我只有321种不同的属性，因此从magento那里获取当前使用的521值，并从其中限制其中的64个值.

I can't understand what this means and from where magento gets this values. In attributes I have only 321 different attributes so from where magento gets value of 521 currently used and where it takes limit for 64 of them???

thnx.

推荐答案

当您的产品数量超过

<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)

这篇关于Magento平板产品的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！