Questions tagged [flat-indexer]
The flat-indexer tag has no usage guidance.
14
questions
19
votes
3answers
6k 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 ...
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 ...
4
votes
0answers
98 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
598 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 ...
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, ...
1
vote
1answer
664 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
1answer
688 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
2answers
181 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 ...
1
vote
1answer
105 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 ...
0
votes
0answers
4 views
How is magento creating flat
I have some products with stock which are not appearing in my flat store table.
I would like to understand why these products are not handled by the indexer.
Can anyone tell me where magento is going ...
0
votes
0answers
18 views
Re-indexing not happening for the catalog_product_flat - got the error Syntax error or access violation: 1118 Row size too large
Re-indexing not happening for the catalog_product_flat getting the below error.
Syntax error or access violation: 1118 Row size too large. The ...
0
votes
1answer
371 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 ...
0
votes
0answers
462 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
289 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 ...
