Uptade 1.4.8.2 to 1.4.9.0

[japanknife]

Hello

 

I updated my prestashop from 1.4.8.2 to 1.4.9.0 and I think the most important things are correct, but I have the following errors:

 

SET NAMES 'utf8'

 

SET NAMES 'utf8'

 

ALTER TABLE `ps_image` ADD UNIQUE KEY `idx_product_image` (`id_image` , `id_product` , `cover`)

(1061) Duplicate key name 'idx_product_image'

 

ALTER TABLE `ps_category_product` DROP INDEX `category_product_index`, ADD PRIMARY KEY (`id_category`, `id_product`)

(1091) Can't DROP 'category_product_index'; check that column/key exists

 

ALTER TABLE `ps_cms_category_lang` DROP INDEX `category_lang_index`, ADD PRIMARY KEY (`id_cms_category`, `id_lang`)

(1091) Can't DROP 'category_lang_index'; check that column/key exists

 

ALTER TABLE `ps_order_tax` ADD `id_order_tax` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST

(1060) Duplicate column name 'id_order_tax'

 

ALTER TABLE `ps_feature_lang` ADD INDEX feature_name (`id_lang`, `name`)

(1061) Duplicate key name 'feature_name'

 

ALTER TABLE `ps_state` ADD INDEX statename (`name`)

(1061) Duplicate key name 'statename'

 

ALTER TABLE `ps_category` ADD INDEX nleftrightactive (`nleft`, `nright`, `active`)

(1061) Duplicate key name 'nleftrightactive'

 

ALTER TABLE `ps_category` ADD INDEX level_depth (`level_depth`)

(1061) Duplicate key name 'level_depth'

 

ALTER TABLE `ps_category` ADD INDEX nright (`nright`)

(1061) Duplicate key name 'nright'

 

ALTER TABLE `ps_category` ADD INDEX nleft (`nleft`)

(1061) Duplicate key name 'nleft'

 

ALTER TABLE `ps_specific_price` ADD INDEX from_quantity (`from_quantity`)

(1061) Duplicate key name 'from_quantity'

 

ALTER TABLE `ps_product` ADD INDEX indexed (`indexed`)

(1061) Duplicate key name 'indexed'

 

UPDATE `ps_country` SET `zip_code_format` = 'NNNNN' WHERE `iso_code` = 'MC' LIMIT 1

 

UPDATE `ps_county_zip_code` SET `to_zip_code` = `from_zip_code` WHERE `to_zip_code` = 0

 

UPDATE `ps_configuration` SET `value` = 0 WHERE `name` = 'PS_HIGH_HTML_THEME_COMPRESSION' LIMIT 1

 

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`)(SELECT 'PS_TAX_DISPLAY_ALL', `value`, NOW(), NOW() FROM `ps_configuration` WHERE name = 'PS_TAX_DISPLAY' LIMIT 1)

 

DELETE FROM `ps_referrer_cache` WHERE id_referrer NOT IN (SELECT id_referrer FROM `ps_referrer`)

 

/* PHP:update_module_mailalerts(); */

 

/* PHP:update_module_blocklayered(); */

 

 

 

And the "LiveEdit" doesn't work - fatal error

 

Any solution ? Or I can try to update to 1.5?

 

Thanks

[bellini13]

mostly just duplicate key errors, nothing I see in their to worry about.

 

As for the live edit issue, no clue, I would suggest posting that as a separate topic with more specific subject line and details.