cancel
Showing results for 
Search instead for 
Did you mean: 

Error During Reindex

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 ?

 

3 REPLIES 3

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'.

 

- Tarandeep
Problem solved?Please give 'Kudos' and accept 'Answer as Solution'.

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

Re: Error During Reindex

@jonas_solutionsAwesome! Glad to see issue is resolved.

 

Problem solved? Please give 'Kudos' and accept 'Answer as Solution'.

- Tarandeep
Problem solved?Please give 'Kudos' and accept 'Answer as Solution'.