Magento Flat Product

when trying to enable and re-index flat product data - getting an error from magento

The Flat Directory module has a limit of 64 filtered and / or sortable attributes. Currently, there are 521 people. Reduce the number of filtered / sortable attributes to use this module.

I cannot understand what this means and where magento gets these values ​​from. In the attributes, I only have 321 different attributes, so where does magento get the 521 value that is currently being used, and where does it accept the limit for 64 of them ???

Thnx.

+5
source share
2 answers

The method Mage_Catalog_Model_Resource_Product_Flat_Indexer::prepareFlatTable()throws this exception when your product has more

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

. app/code/core/Mage/Catalog/etc/config.xml 64 , mySQL,

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

, , / ( , ).

Mage_Catalog_Model_Resource_Product_Flat_Indexer::getFlatIndexes(), , Magento 521 .

catalog_eav_attribute , (is_filterable = 1) / (used_for_sort_by= 1)

+5

, , :

/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Flat|Indexer.php

, config.xml, :

/app/code/core/Mage/Catalog/etc|config.xml

"max_index_count", , 64.

, , , 64. DEVELOPMENT ( , , ), , .

, (521), getFlatIndexes Indexer.php. , 521, 321 + , Magento .

, , . , , .

+4

All Articles