I have a magento website based on community edition 22.214.171.124 which i have upgraded from magento 126.96.36.199.My website is having more than 40,000 products.
My problem is that the indexing process on flat data is not working properly and i am not able to save my product as when i click save product button it keeps processing but never stops processing and no got data saved.
I am using this SSH command :
php shell/indexer.php --reindex catalog_product_flat
and this error comes :
Product Flat Data index process unknown error: exception 'PDOException' with message 'SQLSTATE: Syntax error or access violation: 1142 ALTER command denied to user 'user'@'localhost' for table 'catalog_product_flat_1'' in /path.../lib/Zend/Db/Statement/Pdo.php:228
Thanks in advance, Sarvagya