I have written a cron that updates the inventory of my products every night. What indexes need to be reindexed for products to display correctly after stock is changed via script? Does cache need to be refreshed? Trying to pinpoint the exact issue…
What are the most important factors which affects the time of indexing ...
product attributes
product prices
catalog url rewrites
and also the indexes for flat tables.
I know that the number of products and categories are important, but I want…
We (abc.com) have Magento Multiwebsite and multistoreview built in Magento CE 1.9.X. Each website has one store view. We are basically a marketplace system. We sale products from different magento systems. All the products of different magento…
I have a problem when in edit catalog, product and save it. My website will reindex, that do my website run very slow. I want to disable reindex after save catalog,product
But when i created new catalog, product other. Website will reindex…
I just updated form magento 1.7 to 1.9 and everything on my front end is working perfect. The only problem i have encountered is when i came to re-indexing my catalogue search index and a extension called "Lucene Search Index" it isnt timing out all…
Every time Magento's cron runs the reindexer, it always gets stuck in Processing for the catalog url rewrites index. As a result, the reindexer stops and leaves the other indexes in "Reindex Needed".
However, if I run the indexer in SSH, it will…
I am facing the catalog product flat reindexing issue in my project. I have tried many solution, but can't get any success. I have tried following solutions around Google:
1- I truncated all the catelog_producr_flat tables(like…
When I try to run the reindex process for product flat data I get this error message
SQLSTATE[HY000]: General error: 1005 Can't create table 'mylal_mage233.#sql-4497_2115c' (errno: 121)
The query being executed is:
ALTER TABLE…
I am having the same problem with the error message "cannot initialize the index processor", however that is the only error message I have. I read some of the answers I do not have very big descriptions for my products, and I only added maybe 5…
Recently I've been facing issues with reindex process, some indexes are shown with status Reindex Required and even if I achieve to reindex them they continue with the same status.
After some days indexes got stuck and reindex never ends.
So I…
I am getting "Invalid Samesite attribute." error while run the reindex command from CLI
"php bin/magento indexer:reindex" in the magento 2 setup (version 2.4.4, PHP 8.1, and Apache).
I have tried all the way to find out the solution but no luck.
Can…
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' for key…
My catalog url rewrite has been stuck for days, the core url rewrite table was empty, but the url rewrites did show on the website. we truncated the core url rewrite, the site url rewrite have gone, the reindex is still stuck and no rows showing in…
I reindexed everything, except I can't get this last point to reindex, the
"Catalog URL Rewrites Index product and categories URL rewrites ".
In exception.log I get this error message when I try to reindex it:
Exception message: SQLSTATE[42000]:…