We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [flat-indexer]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
4
votes
0answers
52 views

Is it possible to reduce the default varchar size in catalog_product_flat? (M2)

I have a seemingly common problem. With too many custom attributes that are necessary and no way to change them in a way that would make the use of the default flat catalog possible I am searching for ...
2
votes
1answer
354 views

Enabling Use Flat Catalog Products Results In Frontend Pages Not Loading

I am running Magento 1.9.3.8 and would like to enable Use Flat Catalog Product as I have over 100k skus. After enabling it, rebuilding the indexes, and clearing cache, the frontend will not load. It ...
0
votes
1answer
298 views

Reindexing catalog_product_flat causes Mysql error 1117 Too many colums

We are building a Magento 2 website with 60K products and 1 website, 64 stores with 64 store views. Now we try to enable catalog_product_flat and catalog_category_flat (this works fine) for ...
17
votes
3answers
4k views

Magento 2: Are Flat Tables Still a Thing?

Are flat tables still a thing we need to worry about in Magento 2? I know there's UI where we can turn the flat tables on, but I'm unsure how well they've been tested, and if they're even needed ...
0
votes
0answers
368 views

Restoring flat tables after truncate

I am planning to truncate catalog_product_flat_* tables to fix the Catalog Serach Index per this StackOverflow answer. “There was a problem‍​​ with reindexing process.” after product import In the ...
0
votes
0answers
285 views

Flat product/category tables producing category URL instead of product on list view

I have enabled the flat product and category tables on a development site to test before using live, and for some reason product links in category views now link back to the category itself rather ...
1
vote
1answer
449 views

Category Flat Data problem: description is missing in flat table without indexing error

I'm working on M1 CE 1.7.0.2. I've enabled Use Flat Catalog Category from backend (catalog/frontend/flat_catalog_category = 1). Then I reindex php shell/indexer.php --reindexall without any error. ...
1
vote
2answers
154 views

Block cache and flat tables (Mage_Catalog_Block_Product_List)

We are using Magento Enterprise and use flat tables and automatic re-index. I have a block that extends Mage_Catalog_Block_Product_List. Block cache is enabled and block cache is tagged with all the ...
4
votes
3answers
6k views

MySQL server has gone away when maual reindex catalog_product_flat

In my Magento EE 14.0.1, when I try to reindex catalog_product_flat like this: php indexer.php --reinex catalog_product_flat After serveral minutes, it throws me this error: Product Flat Data index ...
1
vote
1answer
673 views

Magento EE 1.14.1 catalog_product_flat table re-indexing issues

We've recently discovered (after an upgrade) that Magento EE 1.14.1 no longer keeps the catalog_product_flat tables updated unless you have Use Flat Catalog Product in System->Config->Catalog-&...
1
vote
1answer
101 views

Custom Source Model Attribute's Label is Indexed Incorrectly

I have an int/select attribute with a custom source model. Most things (admin, attribute save/load, indexing option IDs, filtering in layered nav, etc.) work fine. One of the things that's not working ...
2
votes
0answers
2k views

Index Management - Catalog Category Flat Data - Stuck on processing

The Catalog Category Flat Data has been now stuck for weeks and i can't seem to fix it. I tried to change the corresponding table in the database: TRUNCAT catalog_product_flat_1, ...