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
0answers
25 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
7 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
12 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
19 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
38 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
27 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
48 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
33 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
126 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
25 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
41 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
57 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
19 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
50 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
167 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
63 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
66 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
282 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
304 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
0answers
97 views

Catalog Rule Product and Catalog Product Rule reindex not working in magento2

When I run following commands php bin/magento indexer:reindex catalogrule_rule php bin/magento indexer:reindex catalogrule_product error: [2019-07-24 12:48:35] main.CRITICAL: SQLSTATE[42S01]: ...
0
votes
3answers
4k 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
65 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
83 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
913 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
54 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
239 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
22 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
60 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
520 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
830 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
401 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
73 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
602 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
97 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
435 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
370 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
726 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
843 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
276 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 ...
1
vote
1answer
604 views

Magento Catalog Product Flat can not index

I got the following error, when I want to reindex my catalog_product_flat. Product Flat Data index process unknown error: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1118 Row ...
2
votes
2answers
526 views

Fresh Installation of Magento 2.2.2 is showing Error 503

I am trying to install Magento 2.2.2 via a demo directory and getting Error 503 While Magento 2.2.1 is installing fine on the same directory. The Link www.domain.com/demo is showing Error 503 on ...
1
vote
2answers
241 views

About index Fatal error

I have some problem, on my magento 2.2.1 php71 centos7 EasyApache 4 PHPfpm suphp MYSQL5.6.38 Please help, thank you very much chmod 777 vendor chmod 777 app/etc chmod 777 pub/static chmod 777 var ...
1
vote
0answers
74 views

Product Catalog images cannot be indexed

In Magento 2, I site: my site in google images, and I found that all the large images didn't be indexed by google, I checked the code in product catalog page, all these images in gallery was shown ...
2
votes
0answers
223 views

Using numeric only increment_id for orders? READ THIS! Magento 1

There's a bug in MySQL which disabled searching by index if two columns are compared which are of a different type. Magento stores increment_id as VARCHAR in sales_flat_order but Magento does not cast ...
9
votes
1answer
4k views

Magento 1.9: Product Price tables - how they work?

Magento has many tables for managing prices It looks to me that: in product/category pages the product prices are loaded from the catalog_product_flat tables. in search pages the _idx table are ...
1
vote
1answer
731 views

Magento 2. In which database table is catalogsearch_fulltext index saved?

In which table is information produced by catalogsearch_fulltext index saved when SQL is set as a search engine?