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
0
votes
2answers
91 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
22 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
0answers
17 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
23 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
18 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
23 views

Do indexes work in developer mode?

Are index tables relevant when developer mode is on? If so which ones?
0
votes
1answer
43 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
70 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
26 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
39 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
182 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
152 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
36 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
60 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
2k 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
37 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
42 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
586 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
32 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
144 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
45 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
54 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
405 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)...
0
votes
1answer
656 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
329 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
66 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
503 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
73 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
338 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
297 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
624 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
702 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
240 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 ...
0
votes
1answer
518 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
516 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
216 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
71 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
210 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
627 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?
0
votes
1answer
181 views

After changing to developer mode, website crashes

magento 2.1.7 php 70 After changing magento to dev mode, website is crashing and getting php error and can't understand what is that error about. How can I solve this problem ?
0
votes
1answer
27 views

How to remove different pages of a website from google indexing?

In webmater , i have added only my base url ,but the other pages are indexed. do i have to enter all pages manually to remove each page form google indexing? please suggest a solution?
2
votes
0answers
403 views

Changing the currency format in index page

I am trying to set the currency format in My magento store based on the option selected by the customer. When customers click on an option in the header I am redirecting them to a page called check....
1
vote
0answers
983 views

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry while indexing

When I run php bin/magento indexer:reindex It gives below result Customer Grid index has been rebuilt successfully in 00:00:32 Design Config Grid index has been rebuilt successfully in 00:00:00 ...
1
vote
1answer
1k views

Magento 1.9 - After indexing, update at time doesn't change on Magento

As website is bigger, I can see some issues on index process. After indexing, update at time of product prices doesn't change on Magento Comparing to time of indexing, index of product prices takes ...
7
votes
2answers
1k views

Difference between index catalog_category_product and catalog_product_category

Could someone explain me what is the difference between the indexes catalog_category_product and catalog_product_category? From db i see that catalog_category_product is related to table ...
2
votes
1answer
255 views

Category URL number need removing

My URLs for categories keep adding numbers at the end of the URL in this format: /solid-oak-beds-13.html It is getting increasingly hard to keep track of links, since the urls are not getting ...
1
vote
3answers
6k views

Magento 2: How to Override Abstract Class for Product Category Indexing Issue?

I have 2000 products which is assigned to multiple categories. When i run php bin/magento indexer:reindex catalog_category_product In catalog_category_product_index total record count is 1700. So ...