2

After updating from 1.7.0.2 to 1.9.2.1 the catalog_product_flat index is not longer shown.

The index is neither shown in Magento Backend nor if i call 

php shell/indexer.php info

It is activated under System > Config > Catalog > Catalog > Shop

I can still call it directly via

php shell/indexer.php --reindex catalog_product_flat

and the database tables are filled and used.

Any idea how it comes or to fix it?

Improve this question

2 Answers 2

Reset to default
1

The reason is an old version of Miravisit AsyncIndex extension. If I deactivate it, the catalog product index appears. If the extension is active, the index is hidden.

Improve this answer
1
  • An update of the extension fixed the problem.
    – waltavista
    Commented Nov 20, 2015 at 15:34
0

That might be because your Flat Catalog Product and Flat Catalog Category is set to No in admin panel

System->Configuration->Catalog->Frontend

Use Flat Catalog Category
Use Flat Catalog Product

Change this settings to Yes and check indexing page

Improve this answer
3
  • No, it is activated for both.
    – waltavista
    Commented Oct 5, 2015 at 14:10
  • Have you cleared cache ?
    – Minesh Patel
    Commented Oct 5, 2015 at 17:27
  • Of course :) Many times. Only catalog_product_flat is not available. catalog_category_flat shown as normal.
    – waltavista
    Commented Oct 6, 2015 at 3:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.