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 ?
@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'.
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
@jonas_solutionsAwesome! Glad to see issue is resolved.
Problem solved? Please give 'Kudos' and accept 'Answer as Solution'.