重新索引“类别扁平数据”时出现Magento错误


Magento error when reindexing "Category Flat Data "

我有一个奇怪的问题,当尝试重新索引"类别扁平数据",我得到了这个错误- "有一个问题与重新索引的过程。"

这里是例外。log -

DEBUG (7): Exception message: Notice: Undefined offset: 162  in /home/user**/public_html/WEBSITES/*****/app/code/core/Mage/Catalog/Model/Resource/Category/Flat.php on line 833
Trace: #0 /home/user**/public_html/WEBSITES/*****/app/code/core/Mage/Catalog/Model/Resource/Category/Flat.php(833): mageCoreErrorHandler(8, 'Undefined offse...', '/home/user**/...', 833, Array)
#1 /home/user**/public_html/WEBSITES/*****/app/code/core/Mage/Catalog/Model/Resource/Category/Flat.php(528): Mage_Catalog_Model_Resource_Category_Flat->_getAttributeValues(Array, '1')
#2 /home/user**/public_html/WEBSITES/*****/app/code/core/Mage/Catalog/Model/Resource/Category/Flat.php(1482): Mage_Catalog_Model_Resource_Category_Flat->rebuild()
#3 /home/user**/public_html/WEBSITES/*****/app/code/core/Mage/Catalog/Model/Category/Indexer/Flat.php(260): Mage_Catalog_Model_Resource_Category_Flat->reindexAll()
#4 /home/user**/public_html/WEBSITES/*****/app/code/core/Mage/Index/Model/Process.php(210): Mage_Catalog_Model_Category_Indexer_Flat->reindexAll()
#5 /home/user**/public_html/WEBSITES/*****/app/code/core/Mage/Index/Model/Process.php(258): Mage_Index_Model_Process->reindexAll()
#6 /home/user**/public_html/WEBSITES/*****/app/code/core/Mage/Index/controllers/Adminhtml/ProcessController.php(127): Mage_Index_Model_Process->reindexEverything()
#7 /home/user**/public_html/WEBSITES/*****/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Index_Adminhtml_ProcessController->reindexProcessAction()
#8 /home/user**/public_html/WEBSITES/*****/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('reindexProcess')
#9 /home/user**/public_html/WEBSITES/*****/app/code/community/Mage/Core/Controller/Varien/Front.php(223): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#10 /home/user**/public_html/WEBSITES/*****/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#11 /home/user**/public_html/WEBSITES/*****/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#12 /home/user**/public_html/WEBSITES/*****/index.php(94): Mage::run('', 'store')
#13 {main}

**我还注意到配置->目录->前端->使用平面目录类别被设置为"否",我不能将其更改为"是",因为该选项被禁用。

请帮我解决这个奇怪的错误

是否禁用编译?尝试禁用编译并尝试重新索引。(system -> tools -> compilation)

如果索引仍然不工作,则再次索引。清空缓存并锁定文件(/var/cache &magento根目录下的/var/lock)。然后再次尝试重新索引。

如果再次失败,则可能是数据库中存在完整性约束错误。你必须删除违反完整性约束的行,然后它才能正确地重新索引。

使用以下命令从终端重新索引。

php indexer.php --reindexall