Magento 1 catalog_product_flat_1 corrupt

Question

We have disabled the option to use catalog flat product.

Not we have a corrupt DB message:

magento.catalog_product_flat_1
Error    : Incorrect information in file: './magento/catalog_product_flat_1.frm'
error    : Corrupt

How can we solve this?

Can we for example safely remove the table: catalog_product_flat_1?

Try reindexing from index management or using shell and recompile Magento using shell. Magento shell file is mage which you can find in root directory of your Magento — Kumar M, Commented Aug 20, 2018 at 10:34
Delete all the tables catalog_product_flat_* and then try reindexing. — Sukumar Gorai, Commented Aug 20, 2018 at 11:02
@KumarM Thanks a lot! How can we recompile Magento using shell? This is a Magento 2 feature, right? — JGeer, Commented Aug 20, 2018 at 12:55
No Magento 1 has shell also, check a folder named "shell" in root folder of Magento — Kumar M, Commented Aug 20, 2018 at 12:56
@SukumarGorai Sadly we can not delete the table. We get the error: #1347 - 'magento.catalog_product_flat_1' is not VIEW — JGeer, Commented Aug 20, 2018 at 18:42

Kumar M · Accepted Answer · 2018-08-20 13:03:26Z

1

To run index and compilation use this using shell:

Goto your Magento root directory in shell/terminal

Then

php shell/indexer.php reindexall

To compile

php shell/compiler.php compile

answered Aug 20, 2018 at 13:03

Kumar M

7871 gold badge4 silver badges6 bronze badges

Thanks, it sadly did not solve the issue.
– JGeer
Commented Aug 20, 2018 at 18:42

Add a comment |

Sukumar Gorai · Accepted Answer · 2018-08-20 18:55:52Z

1

If your database is corrupted then Magento 1 has one tool for database repair.

Here is the link for Database Repair Tool

You need to clone the corrupted database and then perform the tasks according to the document.

Please take a backup of database and files before doing anything to live server.

answered Aug 20, 2018 at 18:55

Sukumar Gorai

10.9k4 gold badges19 silver badges46 bronze badges

Many thanks, but we face some issues with the script. See: magento.stackexchange.com/questions/238990/…
– JGeer
Commented Aug 20, 2018 at 20:12

Add a comment |

2 Answers 2