cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade method from 1.9.1 to 1.9.2.1

Upgrade method from 1.9.1 to 1.9.2.1

Bonjour,

 

Après une maj de magento de 1.9.1 à 1.9.2, l'activation du flat catalog fait planter mon site, avec une erreur SQL tel que e.status n'existe pas : 

 

a:5:{i:0;s:1188:"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.status' in 'where clause', query was: SELECT MAX(e.min_price -(e.min_price/(1+(CASE e.tax_class_id WHEN 4 THEN 0.2000 ELSE 0 END))*CASE e.tax_class_id WHEN 4 THEN 0.2000 ELSE 0 END)+((e.min_price-(e.min_price/(1+(CASE e.tax_class_id WHEN 4 THEN 0.2000 ELSE 0 END))*CASE e.tax_class_id WHEN 4 THEN 0.2000 ELSE 0 END))*CASE e.tax_class_id WHEN 4 THEN 0.2000 ELSE 0 END) ) AS m_max_price FROM `catalog_product_index_price` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '141' WHERE (e.status = 1) AND ( e.website_id = '1' ) AND ( e.customer_group_id = 0) AND (e.min_price -(e.min_price/(1+(CASE e.tax_class_id WHEN 4 THEN 0.2000 ELSE 0 END))*CASE e.tax_class_id WHEN 4 THEN 0.2000 ELSE 0 END)+((e.min_price-(e.min_price/(1+(CASE e.tax_class_id WHEN 4 THEN 0.2000 ELSE 0 END))*CASE e.tax_class_id WHEN 4 THEN 0.2000 ELSE 0 END))*CASE e.tax_class_id WHEN 4 THEN 0.2000 ELSE 0 END) IS NOT NULL) ORDER BY `m_max_price` DESC";i:1;s:5055:"#0 lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)

 

Pour info j'ai supprimé le cache 10x, reindexé les catégories et les produits etc....

 

Merci de votre aide.