All Questions

Tagged with
Filter by
Sorted by
Tagged with
0
votes
1answer
47 views

Magento 2 localhost wamp cron jobs

I'm still getting the error on my admin page "One or more indexers are invalid. Make sure your Magento cron job is running" All field indexes rebuild successfully apart from Catalog Search. I'm using ...
0
votes
2answers
222 views

Magento 2 error : Command “indexer:reindex” is not defined

System : Ubuntu 18 Application : Magento2.3 PHP : 7.1 I have two indexer need to be reindex. I have update the indexer on the admin page but it is not work. I also use the following command on the ...
0
votes
0answers
46 views

Why “catalog_product_price” indexing is required while importing new products with tags Magento 1.9

I have to reindex catalog_product_price when I import products which have new tags. We have managed to create the tags if they are not in the system. We have created an observer which fires after ...
1
vote
0answers
128 views

Magento 2 mview_state mode disabled?

When I check indexer status with php bin/magento indexer:status, I got following result, +--------------------------------------+--------+-----------+-----------------+------------------+ | Title ...
0
votes
1answer
244 views

Magento 2.1.7 Product EAV Reindexer issue

I am very new to magento and am finding it ok to use (after overcomming a lot of issues it has) however i am now at one spot cdwhere i cant seem to resolved an issue i have with the Product EAV ...
0
votes
2answers
578 views

Index Management - Process taking a long time

I have an issue with my Index Management job stuck in "Processing". I have read about it and found out that I can check if the reindex process is running by checking in MySQL, which I did. It is ...
5
votes
1answer
683 views

Magento 2: Is there a way to lock indexer programmatically?

When I run my custom import script, and during it's execution starts reindex, it causes the error : SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try ...
0
votes
1answer
341 views

Catalog Search indexer process unknown error: SQLSTATE[HY000]: General error: 1813

**Catalog** **Search indexer** process unknown error: SQLSTATE[HY000]: General error: 1813 Tablespace for table '`mydb`.`catalogsearch_fulltext_scope1_tmp`' exists. Please DISCARD the tablespace ...
0
votes
1answer
802 views

Magento 2 - Cannot reindex Catalog rule product and catalog product rule

I get the following error when I try to reindex when I check index status... Design Config Grid: Ready Customer Grid: Ready ...
1
vote
1answer
1k views

Magento 2.1.8 Reindex Timeout

We have a Magento store that we upgraded to 2.1.8 last week. Everything seemed to be working well till then. However, after the update, I am no longer able to re-index Category Products and Product ...
1
vote
1answer
2k views

Magento 2 Reindex failed on customer grid

Magento 2 (Version 2.1.6) shows allways 2 or 3 Indexes with the processing state - and it never ends. It stays for days under processing. After a php bin/magento indexer:reset all the indexes are out ...
0
votes
2answers
201 views

Cron job issue with indexing

I have set cron for indexing issue. but i have got error in mail. /home/ltfab/public_html/shell/indexer.php: line 1: ?php: No such file or directory /home/ltfab/public_html/shell/indexer.php: line 2: ...
5
votes
1answer
1k views

Magento 2: How to display error message in CLI

I have an indexer, which needs to be configured first - requires API credentials. When I run in a reindex command in CLI: $ bin/magento indexer:reindex my_reindexer_name and the API credentials are ...
7
votes
2answers
4k views

Magento 2: How to set cron for reindex in SSH in magento 2?

I want to know how to set cron for reindexing a particular indexer method in Magento 2. I have used below code to reindex all but not working: * * * * * php –f /shell/indexer.php reindexall Can ...
1
vote
1answer
741 views

var/locks is always empty

I do see the var/locks folder in my Magento installation. But it is always empty - even while the indexer is running. I assume it will cause an issue if the indexer gets triggered more than once, is ...
2
votes
0answers
77 views

Prices Index Exception and Currency Multiplied by 10.000 in Adminhtml

I had no problems with the price index of the site, it was always possible reindexes it normally. But now whenever I try to reindex prices, I got this exception: 2015-12-05T18:49:17+00:00 DEBUG (7): ...
2
votes
1answer
676 views

Trouble reindexing - forgein key constrain fails

I deleted all products by truncating tables. Now, after uploading all products again I get this: Product Attributes index process unknown error: exception 'PDOException' with message '...
8
votes
2answers
1k views

enterprise_refresh_index Sleeping MySQL Connection

There are times that the indexer that is ran by cron seems to get stuck at the MySQL as Sleeping connections can be seen. Indexer runs for several hours and this actually not running at all. I've ...
1
vote
1answer
2k views

500 server error when I re-index my website

When I reindex my website it takes forever and then gives me server 500 error. Is there anything I can do? Thanks very much
1
vote
2answers
1k views

Couldn't reindex stock of one item programmatically

I'm trying to reindex one product only programmatically: $product = Mage::getModel('catalog/product')->load($_productId); $product->setForceReindexRequired(true); Mage::getSingleton('index/...
2
votes
3answers
748 views

Indexer won't work with SSH

I try to view or reindex the indexer by SSH. I get always the same response: xxxx:/home/www/xxxx/html/shell > php -f indexer.php -- status all X-Powered-By: PHP/5.6.5 Content-type: text/html; ...
2
votes
0answers
2k views

Index Management - Catalog Category Flat Data - Stuck on processing

The Catalog Category Flat Data has been now stuck for weeks and i can't seem to fix it. I tried to change the corresponding table in the database: TRUNCAT catalog_product_flat_1, ...
1
vote
1answer
357 views

Full reindex extension for backend doesn't work. How to run a full reindex for 13.1 in backend?

Since Magento EE 13.1 doesn't allow a full reindex in backend I developed an extension which provides a "Shell reindex" button in backend (on index management page) and suppose to run a full reindex. ...
1
vote
0answers
2k views

Fix error “There was a problem with reindexing process.” or “Cannot initialize the indexer process.”

I am having an issue reindexing my content in Magento. Both Product Flat Data and Product Category Data need to be re-indexed and it won't index for me. I have tried deleting all content in /var/...
5
votes
2answers
218 views

Magerun vs Command line indexer

Is it preferable to run a nightly re-index via the command line or would it be better to run it with Magerun? (Or doesn't it really make a difference)
1
vote
2answers
2k views

General error: 1005 Can't create table 'db_name.catalog_category_flat_store_1'

I am trying to reindex Category Flat Data via ssh with the command php indexer.php --reindex catalog_category_flat but I am getting error as below. I have tried all the solutions posted on the forum ...
0
votes
1answer
2k views

Magmi Magento Reindexer v1.0.2

What should be entered in the box labelled "PHP CLI command" for this option for reindexing products via Magmi? Should it be just left as "php" or should it be "php indexer.php" or something different?...