- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Error During Reindex
Hello, I've got this error during reindexing `catalog_product_price` index on my magento 2.2.4
bin/magento indexer:reindex catalog_product_price SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1, query was: INSERT INTO `catalog_product_index_price_temp` SELECT `catalog_product_index_price_final_temp`.`entity_id`, `catalog_product_index_price_final_temp`.`customer_group_id`, `catalog_product_index_price_final_temp`.`website_id`, `catalog_product_index_price_final_temp`.`tax_class_id`, `catalog_product_index_price_final_temp`.`orig_price` AS `price`, `catalog_product_index_price_final_temp`.`price` AS `final_price`, `catalog_product_index_price_final_temp`.`min_price`, `catalog_product_index_price_final_temp`.`max_price`, `catalog_product_index_price_final_temp`.`tier_price` FROM `catalog_product_index_price_final_temp`
Is there someone who already have this kind of error before ?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Error During Reindex
@jonas_solutionsError simply says that column count does not match due to which indexing is failing. Did you recently upgrade/downgrade your Magento site? If not then did you install / uninstalled an extension?
If none of the above applies then pause if any cron is running. Make sure there is not current indexing processing is in progress. Run the following command.
php bin/magento cache:flush php bin/magento setup:upgrade php bin/magento setup:di:compile php bin/magento indexer:reindex
Problem solved? Please give 'Kudos' and accept 'Answer as Solution'.
Problem solved?Please give 'Kudos' and accept 'Answer as Solution'.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Error During Reindex
Not better.
It seems that some datas are corrupted inside the database.
I have reloaded a previous mysql dump and now error seems have disappeared
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Error During Reindex
@jonas_solutionsAwesome! Glad to see issue is resolved.
Problem solved? Please give 'Kudos' and accept 'Answer as Solution'.
Problem solved?Please give 'Kudos' and accept 'Answer as Solution'.