Questions tagged [indexing]

Questions about the Magento indexer. This includes the flat catalog index. For MySQL indexes, use the "mysql -indexes" tag instead.

Filter by
Sorted by
Tagged with
-1
votes
1answer
769 views

removing categorty in product page is giving error [duplicate]

We are facing issues - https://prnt.sc/mgdybf why we are not able to remove the Deal and Pre Owned category. Could not save product "26652" with position 0 to category 435 What is this error ...
1
vote
1answer
201 views

”Undefined offset: 4” when reindexing “Search indexer”

After module update I've got such error for indexing via SSH Catalog Search indexer process unknown error: Notice: Undefined offset: 4 in /home/sellastu/public_html/vendor/magento/module-catalog-...
3
votes
2answers
1k views

Magento 2.2.6 Catalog Search indexer process unknown error - Notice: Undefined offset: 53

I'm currently using Magento 2.2.6. I've recently encountered the following error while trying to reindex the catalogsearch_fulltext: Notice: Undefined offset: 53 in vendor/magento/module-catalog-...
4
votes
1answer
893 views

Magento 2 Is it possible to run reindexing per storeview?

My site has more than 100.000 products and almost 20 storeviews. Each time I run a full reindexing, it takes about 10 hours for reindexing to be finished. I wonder if it's possible to just run ...
1
vote
1answer
69 views

Magento1.9 Indexing fast

My catalog_product_flat indexing take too long time. How to make this indexing faster in Magento 1.9
1
vote
1answer
491 views

Error Elasticsearch on reindexing - No handler for type [text] declared on field [search]

When I launch a full reindex (php bin/magento indexer:reindex), I have two errors for these indexes : "Catalog Search" , "ElasticSuite Category" I have the Smile/Elasticsuite module installed on my ...
0
votes
2answers
40 views

Can't reindex from web admin

I can't reindex catalog_category_flat index from web admin, I see an error message. But I can reindex it from the console by running php shell/indexer.php --reindex catalog_category_flat without ...
2
votes
3answers
874 views

Magento 2 Down: replica Tales not found when reindexing!

My server went down because the disk was full, after fixing it, I noticed that the magento 2 website never came back: (Magento 2.2.4, PHP 7.0.30) When re-indexing, i get the following error: ...
0
votes
2answers
1k views

Magento 2 : Schedule Status : suspended

I'm on Magento 2.2.4 with php7. I have a cron job already set that reindexes it all twice a day. I usually also reindex manually and when i see a suspended index I reset it. But, when I do reindex:...
12
votes
2answers
4k views

How to solve indexer status “suspended” (n in backlog)

One of the indexers that are configured to be updated on schedule is locked in the state "suspended" and does not get updated anymore. Output of bin/magento indexer:status +-------------------------...
5
votes
2answers
221 views

Magento 2.1 - On reindex start event

I am looking for an observer event that is triggered when any re-index starts. I want to create an observer that sends out an email whenever an index has been initiated for re-indexing.
0
votes
0answers
222 views

DROP TABLE customer_grid_flat hangs - deadlock during customer grid indexing?

We have had an issue with Magento 2.2.5 on an AWS RDS instance (MySQL 5.7): Every then and when, essential Magento Admin functionality is blocked. It is possible to login, but order and customer list ...
0
votes
1answer
40 views

Magento 2.2 : Execute customer grid reindex after customer gets locked

My question is basically on the title, I've been trying to find some event being dispatched when an user gets locked for password attempts but so far I haven't find anything, maybe I'm coming at this ...
0
votes
1answer
164 views

Why are new products not showing?

Note: I'm aware of the existing question. This is a different, more specific question. A bigger multi-store setup recently stopped to show new products unless I run bin/magento indexer:reindex. ...
3
votes
1answer
1k views

M2.2.5 : Can someone explain the role / functionality of the various tables used by the indexing process?

I've read the documentation about indexing in Magento 2, but it's very much on the surface. What I am wondering is how do the internals of the indexing mechanism work. Can somebody explain this to me? ...
1
vote
0answers
284 views

Magento 2 how to run reindex for single product or some cart line products

Is there any way in magento to achieve to reindex only single product or some items. I have a inventory existing /update call on product page load and cart page load. Right now doing indexing for ...
1
vote
1answer
71 views

Yet another bulk product import issue

We are planning to import a few thousands of products with custom options in Magento CE 1.9. We use SOAP for that, CSV is not an option since additional attributes may store html, json or serialized ...
2
votes
2answers
2k views

Column not found: 1054 Unknown column 'at_status_default.value'

I'm actually kind of desperate.I tried many times to update my Community Edition from 2.2.1 to 2.2.5, always failing due to what I guess is a database inconsistency.After the update procedure - done ...
0
votes
1answer
412 views

Magento 2: How to reindex specific ids and in specific indexer using an observer

I know I can programatically trigger the indexer to index a list of product ids with the following: /** * @var \Magento\Framework\Indexer\IndexerInterfaceFactory */ protected $indexerFactory; ...
0
votes
1answer
265 views

Indexer always getting stuck processing when using the admin GUI

When completing a reindex via the admin GUI it always gets stuck and never completes. If I reindex via the command line it completes rather 3 minutes. Could anyone advise the best way to make the GUI ...
1
vote
1answer
61 views

Cleaning Changelog tables - Cron Enterprise_Index scheduledCleanup issue

Our instance is throwing an error on this cronjob PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name '' The code is pulling empty table ...
1
vote
0answers
74 views

What will be the background process execute when click on reindexing in Magento 2?

I want to know more about indexing. How in Magento2 re-indexing request processed in background.
2
votes
3answers
1k views

Magento2: How to temporarily disable “update on save” when saving products programatically?

I have a CLI command on my module that runs through the products collection & updates some of the attributes. I noticed that it's extremely slow. Each save() takes about 4-5 seconds, which is a ...
0
votes
1answer
156 views

Magento 2 : After Data Migration(Indexer issue)

After successfully migrated from Magento 1.x to 2.x I am getting issues with Indexer, Check below screen. (I need to Show products on frontend So, re-indexing is must) Please Help Thanks in Advance.
2
votes
1answer
5k views

Magento2 reindex via cron job

I have a store with 300k products, I set up the reindex to be "Update by Schedule", But I don't know what is the best way for reindexing, Should I do this manually by SSH command every 24 hours by ...
0
votes
1answer
172 views

Special price time dependent on frontend

I am trying to make special price dependent to time on frontend. I have already managed to save the date with time on backend and inside data table catalog_product_entity_datetimethanks to this post ...
2
votes
1answer
262 views

Turn off url rewrite indexing for disabled products

How can I turn off Catalog URL Rewrites indexing for disabled products in magento 1.9?
1
vote
0answers
283 views

Why some attributes can't search in storefront?

I have two custom attributes, all with these options: Products are imported programatically by cron, set in website and have these attributes. When I search one attribute I see results but by the ...
1
vote
0answers
397 views

ReIndex after updating the Product name via API's in Magento 2?

Am re-indexing the Product programmatically every time its name is updated via API. But still, it shows old data. The code which I use to reindex a product, $indexers = array('...
1
vote
1answer
2k views

Magento 2 catalog search full text reindex problem

I'm facing strange issue in my website. The products are not getting appeared if I reindex only flat and product related reindex. It requires catalogsearch_fulltext reindex. If I dont do catalog ...
1
vote
0answers
453 views

Magento1 reindexing: running indexer from command is queuing instead of reindexing

I am trying to run Magento indexer with: php shell/indexer.php --reindex catalog_url But I am getting: Catalog URL Rewrites index was rebuilt successfully in 00:00:00 Which first made no sense to ...
1
vote
1answer
481 views

Execute Custom Index before Magento Indexes - Re-order Indexing

I have created a custom module which contains indexing logic. The indexing is working and my data is being indexed. But the problem is that my custom indexes always executes after Magento's default ...
1
vote
0answers
95 views

Error whilst indexing price + products

The error started when I made the switch to flat catalogues. Exception 1: 2018-02-07T01:14:41+00:00 DEBUG (7): Exception message: SQLSTATE[21S01]: Insert value list does not match column list: 1136 ...
3
votes
1answer
511 views

Rogue “enterprise_refresh_index” causing excessive Merchandising failures

Thanks in advance for reading, and for any help you can hopefully offer. My company uses Magento for our marketplace, and while we've always had occasional issues with AOE Scheduler unable to kick ...
0
votes
0answers
119 views

Updating products on back end not reflected on front end

I have 2 problems and I am not sure if they are related. First of all I have added a new category with new products, I can click on the Category but no products are displayed. If I go to the actual ...
3
votes
2answers
986 views

Difference between magento 1 indexing and magento 2 indexing

I would like to know what is a difference between Magento 1 indexing and Magento 2 indexing. I heard that Magento 2 indexing is faster than Magento 1 indexing. Anyone explain that what indexing ...
8
votes
1answer
1k views

PHP Fatal error: Uncaught Mage_Core_Model_Store_Exception

I just upgraded to Magento 1.9.3.7 via SFTP. When I tried to reindex all indexes and recompiled everything, I received the following error: PHP Fatal error: Uncaught Mage_Core_Model_Store_Exception ...
2
votes
1answer
81 views

Issue while reindexing customer_grid 2.1.7

I have migrated the data from m1.9 to m2.1.7 but I find that customers are not loaded into the grid where I checked the table customers are present. As I googled I tried to update the indexer_status ...
1
vote
0answers
111 views

Magento2 - Number of search results

In my Magento2 store I am only getting 9 search results visible, although there are more hits ... But there is no pagination at the underside to go to the next page ... So something is overruling ...
2
votes
1answer
2k views

Magento 2 - How to reindex one product

I have issue with missing some products on frontend. I noticed that reindexig catalog_product_category is fixing this issue. In observer triggered after import I just add reindexing script: public ...
1
vote
2answers
42 views

Why indexing in command/CLI works?

Whenever I had problems with admin Index Management, I just have to go to the CLI/Command and execute the command line to reindex specific or all indexes to fix the issue. This was suggested by the ...
0
votes
1answer
95 views

css and js not loading in magento2 [duplicate]

In my case css and js files are not loading. It shows only html content both front end and backend part. I applied many times clear the cache and reindexing. Also run these commands: 1.sudo php -f ...
0
votes
0answers
21 views

Imported backed up database and now frontend categories appear to be empty

Steps to Reporoduce: Flat products/categories enabled. Products/Categories: Enabled and visible on frontend DB Backup mysqldump --routines=true --single-transaction -h 'replica-db-fake-host.rds....
1
vote
0answers
208 views

Magento 1.9.3 reindex notification in admin won't disappear

All reindexing have been done and shows green(Ready) status. Re-indexing has done manually in admin panel and tried to it with SSH, but still, it shows re.indexing required message, just wondering is ...
19
votes
3answers
5k 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 ...
2
votes
0answers
467 views

search_tmp processes slowing whole site and making it inaccessible

Magento 2.1.8 installation, left catalog search index running overnight. It appeared to be successful and all products were showing this morning in the store. However shortly after the site has become ...
0
votes
0answers
585 views

New orders are missing from admin when “Asynchronous indexing” is enabled

After enabling Asynchronous indexing new orders are missing from admin and Order Emails too not sending. My cronjobs seems to be working just fine & I also tried to run the cron:run & setup:...
0
votes
1answer
53 views

magento product link goes blank after searching product

I am using Luxury theme and I am getting issue regarding search. See my video about the error: https://www.screencast.com/t/sCcPQFeC Whenever we search the product by name and click on product ...
1
vote
1answer
31 views

in my men's category, other category product is showing i only assign 6 products but i don't knw why 40 product is showing

In my men category, other category product is showing i only assign 6 products but i don't knew why 40 product is showing here please help me. i only assign 6 product to this category i checked from ...
1
vote
0answers
1k views

Magento2: Lock wait timeout exceeded - catalog_product_entity - loading products

I am experiencing locks on the catalog_product_entity table when uploading a lot of products in a short period. Error: SQLSTATE[HY000]:General error: 1205 Lock wait timeout exceeded; try ...

1
2
3 4 5
8