Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Category Flat Data - There was a problem with reindexing process. 
 
Freddy Ferdian Jaya
Jr. Member
 
Total Posts:  4
Joined:  2010-06-17
 

Hi, I just move magento site to VPS
when I try to reindexing it shows Category Flat Data There was a problem with reindexing process.

When I try reindexing through SSH, it shows:

[root@host shell]# php indexer.php reindexall
Product Attributes index was rebuilt successfully
Product Prices index was rebuilt successfully
Catalog URL Rewrites index was rebuilt successfully
Product Flat Data index was rebuilt successfully
Category Flat Data index process unknown error
:
exception \'PDOException\' with message \'SQLSTATE[42000]: Syntax error or access violation: 1142 DROP command denied to user \'ferlie\'@\'localhost\' for table \'catalog_category_flat_store_1\'\' in /var/zpanel/hostdata/zadmin/public_html/domain/lib/Zend/Db/Statement/Pdo.php:228
Stack trace
:
#0 /var/zpanel/hostdata/zadmin/public_html/domain/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /var/zpanel/hostdata/zadmin/public_html/domain/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /var/zpanel/hostdata/zadmin/public_html/domain/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /var/zpanel/hostdata/zadmin/public_html/domain/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 /var/zpanel/hostdata/zadmin/public_html/domain/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(\'DROP TABLE IF E...\', Array)
#5 /var/zpanel/hostdata/zadmin/public_html/domain/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(\'DROP TABLE IF E...\', Array)
#6 /var/zpanel/hostdata/zadmin/public_html/domain/lib/Varien/Db/Adapter/Pdo/Mysql.php(2349): Varien_Db_Adapter_Pdo_Mysql->query(\'DROP TABLE IF E...\')
#7 /var/zpanel/hostdata/zadmin/public_html/domain/app/code/core/Mage/Catalog/Model/Resource/Category/Flat.php(551): Varien_Db_Adapter_Pdo_Mysql->dropTable(\'catalog_categor...\')
#8 /var/zpanel/hostdata/zadmin/public_html/domain/app/code/core/Mage/Catalog/Model/Resource/Category/Flat.php(1418): Mage_Catalog_Model_Resource_Category_Flat->_createTable(\'1\')
#9 /var/zpanel/hostdata/zadmin/public_html/domain/app/code/core/Mage/Catalog/Model/Resource/Category/Flat.php(1431): Mage_Catalog_Model_Resource_Category_Flat->_createTables()
#10 /var/zpanel/hostdata/zadmin/public_html/domain/app/code/core/Mage/Catalog/Model/Category/Indexer/Flat.php(246): Mage_Catalog_Model_Resource_Category_Flat->reindexAll()
#11 /var/zpanel/hostdata/zadmin/public_html/domain/app/code/core/Mage/Index/Model/Process.php(209): Mage_Catalog_Model_Category_Indexer_Flat->reindexAll()
#12 /var/zpanel/hostdata/zadmin/public_html/domain/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#13 /var/zpanel/hostdata/zadmin/public_html/domain/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#14 /var/zpanel/hostdata/zadmin/public_html/domain/shell/indexer.php(198): Mage_Shell_Compiler->run()
#15 {main}

Next exception \'Zend_Db_Statement_Exception\' with message \'SQLSTATE[42000]: Syntax error or access violation: 1142 DROP command denied to user \'ferlie\'@\'localhost\' for table \'catalog_category_flat_store_1\'\' in /var/zpanel/hostdata/zadmin/public_html/domain/lib/Zend/Db/Statement/Pdo.php:234
Stack trace
:
#0 /var/zpanel/hostdata/zadmin/public_html/domain/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/zpanel/hostdata/zadmin/public_html/domain/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/zpanel/hostdata/zadmin/public_html/domain/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /var/zpanel/hostdata/zadmin/public_html/domain/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(\'DROP TABLE IF E...\', Array)
#4 /var/zpanel/hostdata/zadmin/public_html/domain/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(\'DROP TABLE IF E...\', Array)
#5 /var/zpanel/hostdata/zadmin/public_html/domain/lib/Varien/Db/Adapter/Pdo/Mysql.php(2349): Varien_Db_Adapter_Pdo_Mysql->query(\'DROP TABLE IF E...\')
#6 /var/zpanel/hostdata/zadmin/public_html/domain/app/code/core/Mage/Catalog/Model/Resource/Category/Flat.php(551): Varien_Db_Adapter_Pdo_Mysql->dropTable(\'catalog_categor...\')
#7 /var/zpanel/hostdata/zadmin/public_html/domain/app/code/core/Mage/Catalog/Model/Resource/Category/Flat.php(1418): Mage_Catalog_Model_Resource_Category_Flat->_createTable(\'1\')
#8 /var/zpanel/hostdata/zadmin/public_html/domain/app/code/core/Mage/Catalog/Model/Resource/Category/Flat.php(1431): Mage_Catalog_Model_Resource_Category_Flat->_createTables()
#9 /var/zpanel/hostdata/zadmin/public_html/domain/app/code/core/Mage/Catalog/Model/Category/Indexer/Flat.php(246): Mage_Catalog_Model_Resource_Category_Flat->reindexAll()
#10 /var/zpanel/hostdata/zadmin/public_html/domain/app/code/core/Mage/Index/Model/Process.php(209): Mage_Catalog_Model_Category_Indexer_Flat->reindexAll()
#11 /var/zpanel/hostdata/zadmin/public_html/domain/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#12 /var/zpanel/hostdata/zadmin/public_html/domain/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#13 /var/zpanel/hostdata/zadmin/public_html/domain/shell/indexer.php(198): Mage_Shell_Compiler->run()

Can anyone help me?

 
Magento Community Magento Community
Magento Community
Magento Community
 
G_Mehta
Guru
 
Avatar
Total Posts:  418
Joined:  2010-01-27
India
 

Hey Follow,

Refer my blog post, hope it helps you!

Cheers,

 
Magento Community Magento Community
Magento Community
Magento Community
 
Freddy Ferdian Jaya
Jr. Member
 
Total Posts:  4
Joined:  2010-06-17
 
G_Mehta - 16 June 2012 08:53 AM

Hey Follow,

Refer my blog post, hope it helps you!



Cheers,

Previously I ran like that, also I had increase memory_limit to 256M, but still no luck
Any other solution?
The error only for Category Flat Data, others works well

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
beoserviceNL
Newbie
 
Total Posts:  0
Joined:  2012-11-21
 

Probably not related to this issue though I also had a reindex issue only for category flat data.

Fix for me was granting right permissions to magento mysql admin as in:

GRANT CREATE, ALTER, INDEX, DROP, CREATE TEMPORARY TABLES, SELECT, INSERT, UPDATE, DELETE ON magento.* TO ‘magento_admin’@’localhost’ IDENTIFIED BY ‘&#xma;gento_admin_password%’;
GRANT CREATE, ALTER, INDEX, DROP, CREATE TEMPORARY TABLES, SELECT, INSERT, UPDATE, DELETE ON magento.* TO ‘magento_admin’@’localhost.localdomain’ IDENTIFIED BY ‘&#xma;gento_admin_password%’;
FLUSH PRIVILEGES;
quit

Goodluck

 
Magento Community Magento Community
Magento Community
Magento Community
 
Mirasvit
Guru
 
Avatar
Total Posts:  639
Joined:  2009-08-22
 

You can solve this problem using asynchronus queue. Check this one Fast Asynchronous Re-indexing http://mirasvit.com/magento-extensions/magento-asynchronous-reindex.html. After each product/category save this extension move reindex task to queue and process this queue as background process in cron.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top