PRODUCT FLAT DATA reindexing

If you have recently upgraded your Magento website and tried to reindex your data, then you might be stuck at PRODUCT FLAT DATA reindexing. This problem is mainly due to the fact of too many attributes usage, etc. In order to fix this, - Edit app/code/core/Mage/Catalog/Model/Resource/Product/Flat/Indexer.php comment out this line :
1
//$adapter->quoteInto(’additional_table.is_used_for_promo_rules = ?’, 1),
inside function getAttributeCodes() Another fix is here, http://www.magentocommerce.com/boards/viewthread/261848/#t365431

Site Search

Contact Us

 
 
 
Parent Technology Inc.
1535 Rosalind Rd Se
East Grand Rapids, MI 49506, USA
 
 

This email address is being protected from spambots. You need JavaScript enabled to view it.