CODEWITHSUNDEEP
magento-1.7magento
Rohan Patil
Rohan Patil

Reputation: 1963

Magento getting error on product flat data reindixing

Getting this error

while reindexing using ssh command

exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1005 Can't create table './admin_magento16/catalog_product_flat_4.frm' (errno: 150)' in /home/magesite/public_html/store/lib/Zend/Db/Statement/Pdo.php:228

in my magento database there is no catalog_product_flat_4 table is present

what should I need to do for this?

Upvotes: 2

Views: 550

Answers (2)

Rohan Patil
Rohan Patil

Reputation: 1963

able to solve this problem with our team

1st I checked database

checked the core_store table there are 4 store created

also the catalog_product_flat_2 , 3 , 4 tables are missed

I checked my admin panel there is only 1 store

so create the sites from admin panel add added the catalog_product_flat_2 , 3 , 4 then re-index is works fine

cheers :)

Upvotes: 0

orottech
orottech

Reputation: 11

Did you clean Magento cache before reindexing? I can recommend you to check your database with original Magento Database Repair Tool

Upvotes: 1

Related Questions