Try the Demo

Magento

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?

 
 
Posted: June 16 2012
   |  top
 
Magento Community Magento Community
Magento Community
Magento Community
 
G_Mehta
Guru
 
Avatar
Total Posts:  413
Joined:  2010-01-27
India
 

Hey Follow,

Refer my blog post, hope it helps you!

Cheers,

 Signature 

Gaurav Mehta | Magento Developer
skype: ggmehta

 
 
Posted: June 16 2012
   |  top  |  # 1 
 
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 09: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

 
 
Posted: June 16 2012
   |  top  |  # 2 
 
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

 
 
Posted: February 13 2013
   |  top  |  # 3 
 
Magento Community Magento Community
Magento Community
Magento Community
 
Mirasvit
Guru
 
Avatar
Total Posts:  645
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.

 
 
Posted: March 21 2013
   |  top  |  # 4 
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
 
currency switcher will not show in product page
Blank screen on system > configuration in admin panel