Questions tagged [flat-indexer]

The tag has no usage guidance.

8 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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
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
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
370 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 ...