Prices turn zero after product edit

[completepresta]

Hi i have installed prestashop 1.5.2.0

Every time that i edit a product the prices change to zero on the frontend.

I found the following code that fix it temporary

 

UPDATE `ps_product` SET `cache_default_attribute` = 0;
UPDATE `ps_product_shop` SET `cache_default_attribute` = 0;

UPDATE `ps_product` AS p, `ps_product_attribute` AS pa SET p.`cache_default_attribute` = pa.`id_product_attribute`
WHERE p.`id_product` = pa.`id_product` AND pa.`default_on` = 1

UPDATE `ps_product_shop` AS p, `ps_product_attribute` AS pa SET p.`cache_default_attribute` = pa.`id_product_attribute`WHERE p.`id_product` = pa.`id_product` AND pa.`default_on` = 1

 

How can i fix this permanently?

 

Thanks

Edited April 3, 2013 by jsonjuri (see edit history)

[completepresta]

Hi i have installed prestashop 1.5.2.0

Every time that i edit a product the prices change to zero on the frontend.

I found the following code that fix it temporary

 

UPDATE `ps_product` SET `cache_default_attribute` = 0;
UPDATE `ps_product_shop` SET `cache_default_attribute` = 0;

UPDATE `ps_product` AS p, `ps_product_attribute` AS pa SET p.`cache_default_attribute` = pa.`id_product_attribute`
WHERE p.`id_product` = pa.`id_product` AND pa.`default_on` = 1

UPDATE `ps_product_shop` AS p, `ps_product_attribute` AS pa SET p.`cache_default_attribute` = pa.`id_product_attribute`WHERE p.`id_product` = pa.`id_product` AND pa.`default_on` = 1

 

How can i fix this permanently?

 

Thanks

 

Anyone?