mis à jour avec 4 erreurs

[fraggle14]

bonjour

 

j'ai mis à jour ma boutique 1.4.0.* vers la nouvelle version et lors de la mis à jour le début s'est bien passé mais à la fin un message m'indique que j'ai 4 erreurs je vous ai recopié les erreurs:

 

SET NAMES 'utf8'

ALTER TABLE `ps_tab_lang` MODIFY `id_lang` int(10) unsigned NOT NULL AFTER `id_tab`

ALTER TABLE `ps_carrier` ADD `is_free` tinyint(1) unsigned NOT NULL DEFAULT '0' AFTER `is_module`
(1060) Duplicate column name 'is_free'

UPDATE `ps_address_format` SET `format`=REPLACE(REPLACE(`format`, 'state_iso', 'State:name'), 'country', 'Country:name')

ALTER TABLE `ps_orders` ADD INDEX `date_add`(`date_add`)
(1061) Duplicate key name 'date_add'

/* PHP:update_module_followup(); */

INSERT IGNORE INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_STOCK_MVT_REASON_DEFAULT', 3, NOW(), NOW())

/* PHP:add_order_state(PS_OS_WS_PAYMENT, en:Payment remotely accepted|fr:Paiement à distance accepté, 0, 0, lightblue, 1, 0, 0); */

/* PHP:alter_blocklink(); */

/* PHP:update_module_loyalty(); */

/* PHP:remove_module_from_hook(blockcategories, afterCreateHtaccess); */

/* PHP:updatetabicon_from_11version(); */

SET NAMES 'utf8'

DELETE FROM `ps_configuration_lang` WHERE 1 AND `value` is NULL AND `date_upd` is NULL

SET NAMES 'utf8'

UPDATE `ps_country` SET `display_tax_label` = '1' WHERE `id_country` = 21

/* PHP:check_webservice_account_table(); */

/* PHP:add_module_to_hook(blockcms, leftColumn); */

/* PHP:add_module_to_hook(blockcms, rightColumn); */

/* PHP:add_module_to_hook(blockcms, footer); */

UPDATE `ps_cart` ca SET `secure_key` = IFNULL((SELECT `secure_key` from `ps_customer` `cu` WHERE `cu`.`id_customer` = `ca`.`id_customer`), -1) WHERE `ca`.`secure_key` = -1

SET NAMES 'utf8'

UPDATE `ps_address_format` SET `format`=REPLACE(`format`, 'state', 'State:name')

SET @defaultOOS = (SELECT value FROM `ps_configuration` WHERE name = 'PS_ORDER_OUT_OF_STOCK')

/* Set 0 for every non-attribute product */ UPDATE `ps_product` p SET `cache_default_attribute` = 0 WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product_attribute`)

/* First default attribute in stock */ UPDATE `ps_product` p SET `cache_default_attribute` = (SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = p.`id_product` AND default_on = 1 AND quantity > 0 LIMIT 1) WHERE `cache_default_attribute` IS NULL

/* Then default attribute without stock if we don't care */ UPDATE `ps_product` p SET `cache_default_attribute` = (SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = p.`id_product` AND default_on = 1 LIMIT 1) WHERE `cache_default_attribute` IS NULL AND `out_of_stock` = 1 OR `out_of_stock` = IF(@defaultOOS = 1, 2, 1)

/* Next, the default attribute can be any attribute with stock */ UPDATE `ps_product` p SET `cache_default_attribute` = (SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = p.`id_product` AND quantity > 0 LIMIT 1) WHERE `cache_default_attribute` IS NULL

/* If there is still no default attribute, then we go back to the default one */ UPDATE `ps_product` p SET `cache_default_attribute` = (SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = p.`id_product` AND default_on = 1 LIMIT 1) WHERE `cache_default_attribute` IS NULL

UPDATE `ps_order_state_lang` SET `name` = 'Zahlung eingegangen' WHERE `ps_order_state_lang`.`id_order_state` =2 AND `ps_order_state_lang`.`id_lang` = (SELECT id_lang FROM `ps_lang` WHERE `iso_code` = 'de')

UPDATE `ps_order_state_lang` SET `name` = 'Bestellung eingegangen' WHERE `ps_order_state_lang`.`id_order_state` =3 AND `ps_order_state_lang`.`id_lang` = (SELECT id_lang FROM `ps_lang` WHERE `iso_code` = 'de')

UPDATE `ps_order_state_lang` SET `name` = 'Versendet' WHERE `ps_order_state_lang`.`id_order_state` =4 AND `ps_order_state_lang`.`id_lang` = (SELECT id_lang FROM `ps_lang` WHERE `iso_code` = 'de')

UPDATE `ps_order_state_lang` SET `name` = 'Erfolgreich abgeschlossen' WHERE `ps_order_state_lang`.`id_order_state` =5 AND `ps_order_state_lang`.`id_lang` = (SELECT id_lang FROM `ps_lang` WHERE `iso_code` = 'de')

UPDATE `ps_order_state_lang` SET `name` = 'Storniert' WHERE `ps_order_state_lang`.`id_order_state` =6 AND `ps_order_state_lang`.`id_lang` = (SELECT id_lang FROM `ps_lang` WHERE `iso_code` = 'de')

UPDATE `ps_order_state_lang` SET `name` = 'Fehler bei der Bezahlung' WHERE `ps_order_state_lang`.`id_order_state` =8 AND `ps_order_state_lang`.`id_lang` = (SELECT id_lang FROM `ps_lang` WHERE `iso_code` = 'de')

UPDATE `ps_order_state_lang` SET `name` = 'Artikel erwartet' WHERE `ps_order_state_lang`.`id_order_state` =9 AND `ps_order_state_lang`.`id_lang` = (SELECT id_lang FROM `ps_lang` WHERE `iso_code` = 'de')

UPDATE `ps_order_state_lang` SET `name` = 'Warten auf Zahlungseingang' WHERE `ps_order_state_lang`.`id_order_state` =10 AND `ps_order_state_lang`.`id_lang` = (SELECT id_lang FROM `ps_lang` WHERE `iso_code` = 'de')

UPDATE `ps_order_state_lang` SET `name` = 'Warten auf Zahlungseingang von PayPal' WHERE `ps_order_state_lang`.`id_order_state` =11 AND `ps_order_state_lang`.`id_lang` = (SELECT id_lang FROM `ps_lang` WHERE `iso_code` = 'de')

UPDATE `ps_order_state_lang` SET `name` = 'PayPal Anmeldung erfolgreich' WHERE `ps_order_state_lang`.`id_order_state` =12 AND `ps_order_state_lang`.`id_lang` = (SELECT id_lang FROM `ps_lang` WHERE `iso_code` = 'de')

UPDATE `ps_meta_lang` SET `url_rewrite` = 'identita' WHERE `url_rewrite` = 'Identità '

/* PHP:add_missing_rewrite_value(); */

SET NAMES 'utf8'

INSERT IGNORE INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_BACKUP_DROP_TABLE', 1, NOW(), NOW())

UPDATE `ps_tab_lang` SET `name` = 'SEO & URLs' WHERE `id_tab` = (SELECT `id_tab` FROM `ps_tab` WHERE `class_name` = 'AdminMeta' LIMIT 1) AND `id_lang` IN (SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` IN ('en','fr','es','de','it'))

/* These 3 lines (remove_duplicate, drop index, add unique) MUST stay together in this order */ /* PHP:remove_duplicate_category_groups(); */

ALTER TABLE `ps_category_group` DROP INDEX `category_group_index`

ALTER TABLE `ps_category_group` ADD UNIQUE `category_group_index` (`id_category`,`id_group`)

SET NAMES 'utf8'

/* Fix wrong category level_depth caused by bug in 1.4.0.13 upgrade script */ /* PHP:regenerate_level_depth(); */

SET NAMES 'utf8'

UPDATE `ps_address_format` SET `format`='firstname lastname company address1 address2 city State:name postcode Country:name' WHERE `id_country` = (SELECT `id_country` FROM `ps_country` WHERE `iso_code`='GB')

UPDATE `ps_country` SET `contains_states` = 1 WHERE `id_country` = 145

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_LEGACY_IMAGES', '1', NOW(), NOW())
(1062) Duplicate entry 'PS_LEGACY_IMAGES' for key 'name'

SET NAMES 'utf8'

ALTER TABLE `ps_image` MODIFY COLUMN `position` SMALLINT(2) UNSIGNED NOT NULL DEFAULT 0

INSERT IGNORE INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_OS_CHEQUE', '1', NOW(), NOW()), ('PS_OS_PAYMENT', '2', NOW(), NOW()), ('PS_OS_PREPARATION', '3', NOW(), NOW()), ('PS_OS_SHIPPING', '4', NOW(), NOW()), ('PS_OS_DELIVERED', '5', NOW(), NOW()), ('PS_OS_CANCELED', '6', NOW(), NOW()), ('PS_OS_REFUND', '7', NOW(), NOW()), ('PS_OS_ERROR', '8', NOW(), NOW()), ('PS_OS_OUTOFSTOCK', '9', NOW(), NOW()), ('PS_OS_BANKWIRE', '10', NOW(), NOW()), ('PS_OS_PAYPAL', '11', NOW(), NOW()), ('PS_OS_WS_PAYMENT', '12', NOW(), NOW()), ('PS_IMAGE_QUALITY', 'jpg', NOW(), NOW()), ('PS_PNG_QUALITY', '7', NOW(), NOW()), ('PS_JPEG_QUALITY', '90', NOW(), NOW()), ('PS_COOKIE_LIFETIME_FO', '480', NOW(), NOW()), ('PS_COOKIE_LIFETIME_BO', '480', NOW(), NOW())

ALTER TABLE `ps_lang` ADD `is_rtl` TINYINT(1) NOT NULL DEFAULT '0'
(1060) Duplicate column name 'is_rtl'

UPDATE `ps_country_lang` SET `name` = 'United State' WHERE `name` = 'USA' AND `id_lang` = ( SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'en' LIMIT 1 )

UPDATE `ps_hook` SET `live_edit` = 1 WHERE `name` = 'leftColumn' OR `name` = 'home' OR `name` = 'rightColumn' OR `name` = 'productfooter' OR `name` = 'payment'

ALTER TABLE `ps_stock_mvt_reason` MODIFY `sign` TINYINT(1) NOT NULL DEFAULT '1' AFTER `id_stock_mvt_reason`

UPDATE `ps_tab_lang` SET `name` = 'Geolocation' WHERE `name` = 'Geolocalization'

UPDATE `ps_tab_lang` SET `name` = 'Counties' WHERE `name` = 'County'

ALTER TABLE `ps_tax_rule` MODIFY `id_county` INT NOT NULL AFTER `id_country`

UPDATE `ps_address_format` set `format`='firstname lastname company address1 address2 city, State:name postcode Country:name phone' WHERE `id_country` = (SELECT `id_country` FROM `ps_country` WHERE `iso_code`='US')

ALTER TABLE `ps_attachment` CHANGE `mime` `mime` VARCHAR(128) NOT NULL

CREATE TABLE IF NOT EXISTS `ps_compare_product` ( `id_compare_product` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_product` int(10) unsigned NOT NULL, `id_guest` int(10) unsigned NOT NULL, `id_customer` int(10) unsigned NOT NULL, `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, PRIMARY KEY (`id_compare_product`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

DELETE FROM `ps_configuration` WHERE name = 'PS_LAYERED_NAVIGATION_CHECKBOXES' LIMIT 1

/* PHP:add_new_tab(AdminUpgrade, en:Upgrade|fr:Mise à jour, 9); */

/* PHP:alter_productcomments_guest_index(); */

SET NAMES 'utf8'

 

 

Si quelqu'un pouvait me dire ce que je dois faire, ça serait sympa de sa part merci d'avance