Questions tagged [index]

This tag is ambiguous. Use "indexing" for Magento indexes, "seo" for search engine indexing, "mysql-indexes" for MySQL indexes. For questions about "index.php" there is no specific tag.

Filter by
Sorted by
Tagged with
1
vote
1answer
11 views

How to enable asynchronous indexing in production mode?

I want to enable the asynchronous indexing, but the option is inside the Admin menu below, which is available just in developer mode. Stores > Settings > Configuration > Advanced > ...
0
votes
1answer
12 views

What's the purpose of the mview_state table in the database?

I saw the numbers increasing in the mview_state table in the database and there is no cleanup. So I wonder what's the purpose of this table and the values that we have there?
0
votes
0answers
27 views

Magento2.4.0 - Catalog search index process unknown error

I am getting a catalog search index process unknown error when I run php bin/magento indexer:reindex I don't know how to solve this. I have successfully connected to Elasticsearch 7 on admin panel. ...
1
vote
1answer
18 views

are the two codes same?

I'm starting to learn Magento 2 and I read some instructions to create Controller. There are the index.php. on Magento 2 _ development cookbook and another on website. /** @var \Magento\Framework\View\...
0
votes
0answers
69 views

Auto Increment column do not have index. Column - “value_id”, table - “catalog_product_entity_text”

I'm getting the following error after i upgrade magento version to 2.3.5 and try to run php bin/magento setup:upgrade Auto Increment column do not have index. Column - "value_id", table - &...
0
votes
0answers
15 views

Magento 2 not index price after change user db

i using magento 2.x, yesterday i wan`t user and pass mysql. Website run success but i checked table catalog_product_index_price. It not insert new row when i insert new product I reindex and clear ...
1
vote
0answers
24 views

Magento2: Notice: Undefined index:

We use mageplaza extension products grid. Impossible open products --> catalog Notice: Undefined index: position in /home/user/domains/domain.com/public_html/app/code/Mageplaza/ProductGrid/Ui/...
1
vote
0answers
25 views

Notice: Undefined index: quantity

I am currently facing a problem with the below error and was hoping if someone could help. Notice: Undefined index: quantity in /public_html/Magento/vendor/magento/module-inventory-sales/Model/...
1
vote
0answers
30 views

Magento 2: AWS Elastic Search: Index product manually

I am using Magento 2. Using AWS Elastic Search Service. I want to index only 5-10 products. Is it possible to manually/progrmatically index only X products?
0
votes
0answers
9 views

Magento stock status index inconsistent with product table after reindexing

I migrated from Magento 1.8.1 to 2.2.3. Problem: in the shop I see simple products that are out of stock even when I filter on stockstatus = in stock. What I have found out, is that the index for ...
0
votes
0answers
23 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
23 views

How to relate an entity type to an entity_id within an indexer's mview changelog?

I am trying to contribute to some performance enhancements on the indexing of my website. I'm having an issue knowing which entity types are being referred to in the changelog (*_cl) tables. As a ...
1
vote
2answers
55 views

Magento 2 Truncate Index tables

Is it possible to truncate catalog_product_index_price without causing problems to the actual products?
0
votes
1answer
28 views

Restrict Indexation in Multistore Website

I have multistore website .When I have done translation for one store , I have found that it is done on the other stores also. I want to make restring on indexing in the other stores . The canonical ...
-1
votes
1answer
74 views

Explain Magento 2 stock index

Can somebody explain how stock index works in Magento 2 and what is it used for and how? If I set it "index on schedule" what exactly happens and how does it affect the shop if stock index is in "...
1
vote
3answers
80 views

Indexer Issue - idle (741 in backlog)

Some categories meta title & description is not setting.I am getting backlog in index status. any idea to fix this issue?
0
votes
2answers
192 views

Can I remove indexing from cron:run?

The cron php bin/magento cron:run is set to run every minute in our project. Along with various other tasks it runs indexing in Magento. Indexing is part of index cron group. For debugging purpose ...
1
vote
0answers
27 views

Magento2 - Is cache invalidation supposed to work properly when index is on-schedule?

We have the following problem: Over the night, products are imported via REST interface. Now in the morning some categories are shown as empty. Indexes are set on update-on-schedule, that means, the ...
2
votes
1answer
62 views

index backlog grows without reason?

We have the problem that some categories do not show products in the morning after an import via REST interface during the night. So we had a look at n98-magerun2 index:status The backlog grows and ...
1
vote
0answers
88 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 ...
1
vote
0answers
21 views

Unknown index “UsernamePasswordFormAuthenticve_index” in cron logfile - security issue?

Today i noticed a really strange index and code dump in cron.log: UsernamePasswordFormAuthenticve_index is successfully finished ^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@...
1
vote
1answer
26 views

Do indexes work in developer mode?

Are index tables relevant when developer mode is on? If so which ones?
0
votes
1answer
53 views

Need help to stop malicious code in index.php file

Need help to stop malicious code in index.php file Please help me if anyone have faced this same issue. I am using Magento ver. 1.9.4.3 index.php : * @category Mage */ $swvJgN7="xQC+...
1
vote
0answers
253 views

Magento 2 what is the use of indexer backlogs?

When we run the php bin/magento index:status command it throws the complete view of the indexer. In Below screenshot you can see the backlogs are way higher. I am trying to understand what is the use ...
0
votes
0answers
102 views

Magento, Wyomind : No type specified for field [name] for products

I am working on Magento where we have wyomind running. I want to generate indexes for the products, but it's not working out. WHen I flush wyomind indexes from magento-admin, I get the following error ...
0
votes
2answers
157 views

Magento 2: Multistore with the same domain

I want to have many sites with the same domain, for example, example.com/site1, example.com/site2, and so on... This is what I've done by far: 1- Change base URL of the site for example.com/site1 2-...
0
votes
1answer
379 views

Index Times takes so long in magento 2.3.2?

Hello I would like to ask a few things about Indexing. I am using Magento 2.3.2 and i am building a website in localhost. Until now i have imported 45.000 products. I runned index and it took about 9 ...
0
votes
1answer
415 views

Index process in Magento 2.3.2

I am new to Magento. I build a new site (currently is live in Joomla and the reason that I change that my products will be more than 500.000. now is at 350.000 in Joomla) I am in Magento in localhost. ...
0
votes
1answer
38 views

Index management in magento 1.3 [duplicate]

I want to run indexing in magento 1.3 but i dont find indexing option in system tab. Whats the issue? how can we run indexing through command in magento 1.3
0
votes
5answers
5k views

cache_dir “/var/www/html/Magento2/var/cache/” is not writable

I'm running a fresh Magento2.3 install on ubuntu 18.04. I managed to edit sample data yesterday, but today I had a go at adding a new product. After saving - I got the error : One or more ...
1
vote
0answers
95 views

cat_index_position defaults to 10001. Magento 2.1.9

Magento 2.1.9 right now. We have a fec categories and set the position according to our liking. However this isnt reflected in the frontend for every product. Some work, some dont. Screenshot of the ...
0
votes
2answers
138 views

Magento2: Index page running problem (index source code displaying)

I have complete installation&run successfully magento2 package some days ago... But, Now I trying to run the package index.php source code was displaying while executing the magento2 package. i ...
1
vote
4answers
1k views

Magento2: How to fix error not showing?

When I submit data to saveprofile.php (controller). saveprofile.php use Magento\Authorization\Model\UserContextInterface as UserContextInterface; use Magento\Authorization\Model\Acl\Role\User as ...
0
votes
1answer
82 views

Trying to not index catalog search result page

I'm trying to have the search result page not indexed. /public/vendor/vaimo/theme-***/Magento_CatalogSearch/layout/catalogsearch_result_index.xml I have this: <?xml version="1.0"?><page ...
4
votes
2answers
293 views

Understanding the Magento 2 index

Generally Magento's index can be updated in 3 ways (depending on usage and configuration): "On Save" "By Schedule" Using indexer:reindex command This is what I can gather from the description in the ...
1
vote
0answers
23 views

New to Magento 2 - Is it possible to change every product price every minute?

I work in -precious metal industry- where item prices change every minute based on markets. At the basic level, UnitPrice=MarketPrice+Premiums per tier. My questions are: If we want to import ...
1
vote
2answers
46 views

Reindex from different computer

Ok so basically I have been given this one task to manage the admin side for a website that used Magento 2. But then, I have encountered some problem with the reindexing. I have been searching about ...
0
votes
0answers
63 views

Messed up magento database indexes

Probably due to errors during reindexing, our store got really slow. Reindexing didn't solve it. I activated query log to identify which ones take are slower. Following is one of them. How could I ...
0
votes
1answer
615 views

Magento 2 Error: Product disappeared on frontend, one store view only

We are having a weird problem since some days after the shop running for months without trouble. On one day (only thing we did were some backup-operations on the database which might have caused this)...
1
vote
1answer
951 views

catalog_category_product_index table empty (Magento 2.2.5)

Our indexer re-fills the table catalog_category_product_index_store1, but the table catalog_category_product_index remains empty. I have found this issue https://github.com/Smile-SA/elasticsuite/...
1
vote
1answer
448 views

Magento 2: Question about set reindex (update on schedule or update on save)

I have a script that is responsible for automatic updating of states with an external storage (automatically adds products and automatically updates states) every 15 minutes. How to set index? Please ...
1
vote
1answer
78 views

Sites are only loading if I add `index.php` to the URL

I just copied the live database to my local environment. I changed the base_url to the new domain (virtual host). My sites on my local environment are only loading if I add index.php to the URL. e.g. ...
4
votes
0answers
646 views

Magento 2, Unable to save products (Catalog rule indexing failed. See details in exception log.)

I receive the error "Catalog rule indexing failed. See details in exception log." when I try to save a product, and get the error below in the exception log. [2018-08-26 05:09:05] main.CRITICAL: ...
1
vote
1answer
111 views

Setting the Indexer Scedule when using “Update by schedule"

I understand that using Update by schedule refers to the cron schedule for timing, when changing the Mode under Index Management. But I require some clarification. M1 In M1, you would set the ...
0
votes
1answer
514 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; ...
1
vote
2answers
411 views

Magento ver. 1.9.3.9 After update catalog url rewrite stuck on processing

I am faced with an issue, whereby after updating magento to 1.9.3.9 from 1.9.3.8 my catalog_url_rewrite index is stuck on processing. Checking process list I cannot see anything untoward. Also, ...
0
votes
1answer
810 views

Magento 2: Reindex script does not work with cronjob

Ok, true desparation here. Since the reindex via default cron simply does not want to work (Reindex gets scheduled by cron but never executed) I decided to create a separate cron just to trigger the ...
1
vote
1answer
959 views

Reindex gets scheduled by cron but never executed

For magento 2.2.4 my cron.sh looks like this (crontab is not available in this environment): #!/bin/bash PHP_BIN=`which php7-71STABLE-CLI`; DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && ...
1
vote
1answer
2k views

Update custom columns in sales_order_grid / Regenerate sales_order_grid

I have a custom module that adds an extra column to sales_order which is updated at a point after the order is made. I have in my upgradeShcema the following code $setup->getConnection()->...
0
votes
1answer
284 views

Magento 1 autoindex:error /skin/frontend

We get some php errors in our server log, that the DirectoryIndex could not be found in /skin/frontend/theme/theme/. But that seems to be right. That error only display sometimes and on different ...