Questions tagged [reindex]
Denotes Question about reindex data in index management in Magento 1 and 2.
480
questions
0
votes
1answer
9 views
Magento 2 - Column tier_price is set NULL in catalog_product_index_price table
I tried to populate column tier_price of catalog_product_index_price table but every time that reindex this column return NULL.
Why tier_price column return NULL every time i reindex magento 2?
...
0
votes
0answers
10 views
Magento 2.3.0 Frontend showing errors after reindexing
Hi I have created a clone of the main website https://magento-498758-1578521.cloudwaysapps.com/ working but products not showing then I run reindex command and then clone website showing the following ...
0
votes
0answers
31 views
Reindex process hangs and blocks website
I have a problem in my Magento 2 (version 2.3.4) shop that reindex process sometimes runs indefinitely and brings the whole site down (502 nginx error or timeouts).
I noticed on the DB level, that in ...
0
votes
1answer
16 views
ElasticSuite Reindex Fatal Error
I'm trying to reindex Elastic Search but I'm running into an error I don't know how to fix.
The reindexing runs fine on 2 other machines.
I've deleted all indices with the "curl -X DELETE http://...
1
vote
1answer
17 views
404 Not Found when displaying a product after reindexing
Before reindexing Magento I can see a product detail but after reindexing, I can't see the product detail. And the weird thing is when I search for some products I can find it, this one works well ...
0
votes
0answers
14 views
Magento 2 - How to debug indexer. error on customer_grid reindex
newly created customers are not appearing in the customer grid.
Then i noticed that my customer_grid index is not validating properly.
if i reset the index and reindex again. it will take forever and ...
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
1answer
21 views
How to improve reindexing magento 2.3.3 [EE]?
How to improve reindexing Magento 2.3.3 [EE]?
60K products
It takes around 20min to reindex full.
Thanks
0
votes
2answers
72 views
Invalid column data type when reindex Magento 2
I'm using Magento 2.3.4 for my website, when I try to reindex, the category flat was not reindex and appear error like this:
I search some post in here and try this solution:
magento 2.3.4 ...
0
votes
0answers
10 views
Reindexing with elastc search
In Magneto 2 If i do re-indexing with elastic search on one server, export that db and import on another server then again re-indexing will required or not?
0
votes
1answer
11 views
How to create a standalone PHP to reindex the store via browser?
I have a test environment locked via auth and I would like to create some standalone scripts in PHP in my pub folder in order to optimize the project managers' work, the first file requested is a file ...
0
votes
0answers
7 views
Flat category is missing
My main issue is : In the category I'm not retieving any products when I call $currentCateg->getProductCollection()
After some digging I found the request used to retrieve these products in the ...
0
votes
0answers
11 views
Magento 2 how to disable Magento catalog indexing after product save
In Magento 2 in want to disable magento catalog indexing after product save . I want disable it using magento pulgin or event observer.
How can I do this?
0
votes
0answers
40 views
ElasticSearch indexer_update_all_views error with index
I'm using ElasticSearch 6.8 + ElasticSuite in a Magento 2.3 Cloud, it's multistore. I'm seeing many errors in my cron history related to the job indexer_update_all_views, when I check the file var/log/...
0
votes
0answers
32 views
Magento 2.3 re-index failing for sales rule index
When I trying to re-index salesrule_rule index, It gives me bellow error and the sales rule grid is not loading in magento admin. Please advice.
Item (Magento\SalesRule\Model\Rule\Interceptor) with ...
1
vote
0answers
191 views
catalog_product index does not exist yet. Make sure everything is reindexed
In our production site using Magento 2.3.4 and Smile-SA elasticsuite extension with elasticsuite 6.x. After manual reindex site working well. But some time shows an error.
main.CRITICAL: ...
0
votes
1answer
61 views
Magento2 Elastic Search Configuration Issue
I am using following configurations for my magento2 project
Ubuntu 18.04
PHP 7.2
MYSQL 5.7
Elastic Search 7.x
Magento 2.3.5-p1
When i enabled elastic search in magento2 admin panel , the connection ...
1
vote
1answer
293 views
Elasticsearch: No alive nodes found in your cluster & test connection gets failed
I have run this command:
composer show elasticsearch/elasticsearch
then all stats of elastic search runs perfectly. Attached is the screenshot. Also, I have configured in the admin panel. The ...
0
votes
0answers
17 views
Magento 2.2.7 - Notice: Undefined index: magento2_product_1_v2648
When running indexing I am getting an error
bin/magento indexer:reindex catalogsearch_fulltext
Catalog Search indexer process unknown error:
Notice: Undefined index: magento2_product_1_v2648 in
/...
0
votes
1answer
13 views
Magento : Assigning products to (new) websites programmatically do I need to run an index and which one?
In Magento When assigning products to (new) websites programmatically do I need to run an index and which one?
When using
Mage::getModel('catalog/product_website')->addProducts(array($...
0
votes
2answers
348 views
Elasticsearch Limit of total fields [9165] in index [product_1_v2] has been exceeded
We face the following issue on our Magento 2.4 store with Elasticsearch 7 and more than 7000 attributes:
Catalog Search indexer process unknown error:
{"error":{"root_cause":[{&...
1
vote
2answers
91 views
Magento 2 Aftet Migration Error - Reindex No Such Entity Error
[root@test]# php bin/magento indexer:reindex
Design Config Grid index has been rebuilt successfully in 00:00:00
Customer Grid index has been rebuilt successfully in 00:00:00
Product Flat Data index ...
2
votes
0answers
11 views
Basic clarity on some magento default function
I had gone through a interview process. They fired some questions below which I don't know answers and couldn't find in google. The questions are below.
How to create a object and why we need to ...
1
vote
1answer
34 views
Urgent - Magento 2.3.4 - “One or more indexers are invalid. Make sure your Magento cron job is running.”
I am creating a store with Magento, but the products are not appearing, I believe it is due to the error "One or more indexers are invalid. Make sure your Magento cron job is running.".
I've ...
1
vote
0answers
23 views
Reindex programmatically in magento
I am new to magento. i have to indexer:reindex pragmatically and i looking for this solution. i found few source but there is no guide how and where i can use this code.
https://magecomp.com/blog/how-...
0
votes
1answer
36 views
how often that magento 2 reindex cron job run?
Anyone know how often that Magento 2 Reindex Cron job run daily?
thanks
1
vote
0answers
108 views
Getting error while reindexing in magento2
While re indexing in magento2 getting below error
Fatal error: Uncaught TypeError: Return value of Magento\PageBuilder\Model\Stage\Preview::isPreviewMode() must be of the type boolean, null returned ...
0
votes
0answers
11 views
Indexer with custom cron_group
We have created a new custom indexer as per requirement. And now we need to schedule that indexer with custom cron_group which can be scheduled according to business. We don't want to schedule with ...
0
votes
2answers
253 views
Magento Cloud reindex fail elasticsuite
I try to reindex my Magento Cloud and caught below error. Anyone whats wrong with the ElasticSuite
web@mymagento.0:~$ php bin/magento indexer:reindex
Design Config Grid index has been rebuilt ...
0
votes
0answers
45 views
Magento 2.3.2 - Issue with catalog_product_price reindex (Product Price)
I was getting below error while doing reindex for catalog_product_price (Product Price).
SQLSTATE[HY000]: General error: 1137 Can't reopen table: 'catalog_product_index_price_temp', query was: INSERT ...
0
votes
0answers
17 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
0answers
27 views
Failed to reindex “Product Flat Data” and “Product Price” getting error like illegal offset on DataObject.php
Failed to reindex "Product Flat Data" - Reorganize EAV product structure to flat structure and "Product Price"
I have got the below error while indexing from the backend.
"Warning: Illegal ...
0
votes
0answers
17 views
Magento 2.3.3 reindex error
i have this error and i don't understand to solve it
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '26974-207-1-0-26974' for key 'PRIMARY', query was: INSERT INTO ...
0
votes
0answers
11 views
Magento 2 Catalog rule Reindex Fail `Unknown column 'at_sku.store_id'` in 'on clause'
I am having this error when running php bin/magento indexer:reindex
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'at_sku.store_id' in 'on clause', query was: SELECT e.*, at_sku.sku FROM ...
0
votes
1answer
13 views
An error occurred while saving the URL rewrite in both System --> Index Management and through SSH
Magento 1.9.x
The Error from the Error log is as follows:
2020-04-20T23:17:52+00:00 ERR (3):
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'category/112-1-1' ...
0
votes
0answers
29 views
Catalog rule indexing issue after data migration in magento 2.3.4
main.CRITICAL: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'at_sku.store_id' in 'on clause', query was: SELECT `e`.*, `at_sku`.`sku` FROM `mee_catalog_product_entity` AS `e`
INNER JOIN `...
0
votes
1answer
49 views
Magento 2.3 reindex design_config_grid stucks on processing
design_config_grid and customer_grid stuck on processing when I use bin/magento indexer:reindex. Even after bin/magento indexer:reset and changing status to Invalid, when I reindex again, they stuck ...
0
votes
0answers
16 views
4472 Segmentation fault searchd --config fake.conf 2>&1
I have a problem with my Sphinx Search Engine. I'm running store on Magento 2.2 platform and durring reindex I getting an error like in topic.
After some debuging i found that the external module try ...
0
votes
0answers
224 views
Error “DDL statements are not allowed in transactions” while Reindexing programmatically using Event Observer Magento 2.3.0
Actually i am trying to reindex category data while saving category
from backend but i am getting an error DDL statements are not
allowed in transactions in log file while reindexing ...
3
votes
4answers
785 views
Magento 2 Setup:Upgrade giving error of Cannot add foreign key constraint
I have moved my website files and DB from one server to another.
Now, When I am running setup:upgrade command. I am getting below error:
Updating modules:
Schema creation/updates:
SQLSTATE[HY000]: ...
0
votes
1answer
38 views
Magento 2 is not showing product in categroy pages
I use Magento 2.2.2 and since yesterday I can't see any products in category pages. products are available individually but not available in any category pages
I've done these solutions but still, it'...
0
votes
0answers
25 views
Why products disappeared on the frontend after import?
I'm running my store in the Magento 2.3.1 + ElasticSearch 6 + PHP 7.2
With 12k products and 228 attributes, and PHP memory_limit = -1.
I have an integration that syncs the products through Magento's ...
1
vote
0answers
37 views
Magento2.3.4 - Switching Catalog Price Scope causes SQL error
After switching the Catalog Price Scope from Global to Website and trying to reindex I get the following SQL error. How do I fix it?
Design Config Grid index has been rebuilt successfully in 00:00:00
...
0
votes
0answers
29 views
Could not open input file: bin/magneto error after every command in magent2.3.3
I have freshly installed magento 2.3.3 but when i am trying to run indexer or any other command i am getting following errors.
Could not open input file: bin/magneto
I have tried so many commands ...
2
votes
4answers
338 views
Magento 2 while reindex INSERT INTO 'catalog_category_product_index_store1' stuck the query
I am working on Magento 2.3.2. When I run re-index command php bin/magento i:rei Design Config Grid and Customer Config Grid is completed. But it is taking too much time to re-index Category Products ...
0
votes
0answers
35 views
Magento 2 reindex process stuck on Category Products and Product Categories
I am working on Magento 2.3.2. I am doing reindex but the process is never ends for Product Categories and Category Products for total of 60K Prducts
I tried to reset these both and tried to reindex ...
0
votes
0answers
42 views
Catalog product index website is empty
From time to time the record of this table is deleted.
Catalog product index website is empty
Tech details:
PHP 7.0.33
Magento v2.1.18
Apache/2.4.25 (Debian)
10.1.41-MariaDB-0+deb9u1 Debian 9.9
...
1
vote
0answers
121 views
Problems re-indexing Category Products and Products Categories in Magento 2.3
We are facing the Reindex for the Category Products and Product Categories and we are getting the following error while reindexing through SSH (php bin/magento indexer:reindex)
Category Products ...
0
votes
1answer
245 views
SQLSTATE[42000]: 1142 TRIGGER command denied for table 'catalog_product_index_price_replica',
Good Day
I am very much a novice when it comes to this. I upgraded my store from Magento 2.2.8 to 2.3.3.
All seemed initially to go without issues.
However on reindexing i get the below error.
...
1
vote
0answers
35 views
Magento 1.9 menu and products stock problem
I have a problem with a Magento 1.9.1.1 store: categories menu in header disappears and in the meantime all the product stock seems to be unavailable. The strange thing is that the two problems occur ...
