Erreur Msql Après Une Mise A Jour 1.4.10.0

[thierry2]

Bonjour, voila j'ai fait la mise a jour presta1.4.10.0 ,a la fin j'ai eu cette erreur ? par contre le site n'est pas planté je vous mes les erreurs si dessous ,si un professionnel peut regarder les erreurs et me dire si c'est grave avant de remettre ma boutique en prod Merci

 

 

SET NAMES 'utf8'

 

INSERT IGNORE INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_RESTRICT_DELIVERED_COUNTRIES', '0', NOW(), NOW())

 

UPDATE `ps_country_lang` SET `name` = 'United States' WHERE `name` = 'United State'

 

ALTER TABLE `ps_discount` ADD `include_tax` TINYINT(1) NOT NULL DEFAULT '0'

 

UPDATE `ps_order_detail` SET `product_price` = `product_price` /( 1-(`group_reduction`/100))

 

DELETE FROM `ps_configuration` WHERE name IN ('PS_LAYERED_BITLY_USERNAME', 'PS_LAYERED_BITLY_API_KEY', 'PS_LAYERED_SHARE') LIMIT 3

 

ALTER TABLE `ps_delivery` CHANGE `price` `price` DECIMAL(20, 6) NOT NULL

 

ALTER TABLE `ps_store` CHANGE `latitude` `latitude` DECIMAL(10, 8) NULL DEFAULT NULL

 

ALTER TABLE `ps_store` CHANGE `longitude` `longitude` DECIMAL(10, 8) NULL DEFAULT NULL

 

INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`, `live_edit`) VALUES ('attributeGroupForm', 'Add fields to the form "attribute group"', 'Add fields to the form "attribute group"', 0, 0), ('afterSaveAttributeGroup', 'On saving attribute group', 'On saving attribute group', 0, 0), ('afterDeleteAttributeGroup', 'On deleting attribute group', 'On deleting "attribute group', 0, 0), ('featureForm', 'Add fields to the form "feature"', 'Add fields to the form "feature"', 0, 0), ('afterSaveFeature', 'On saving attribute feature', 'On saving attribute feature', 0, 0), ('afterDeleteFeature', 'On deleting attribute feature', 'On deleting attribute feature', 0, 0), ('afterSaveProduct', 'On saving products', 'On saving products', 0, 0), ('productListAssign', 'Assign product list to a category', 'Assign product list to a category', 0, 0), ('postProcessAttributeGroup', 'On post-process in admin attribute group', 'On post-process in admin attribute group', 0, 0), ('postProcessFeature', 'On post-process in admin feature', 'On post-process in admin feature', 0, 0), ('featureValueForm', 'Add fields to the form "feature value"', 'Add fields to the form "feature value"', 0, 0), ('postProcessFeatureValue', 'On post-process in admin feature value', 'On post-process in admin feature value', 0, 0), ('afterDeleteFeatureValue', 'On deleting attribute feature value', 'On deleting attribute feature value', 0, 0), ('afterSaveFeatureValue', 'On saving attribute feature value', 'On saving attribute feature value', 0, 0), ('attributeForm', 'Add fields to the form "feature value"', 'Add fields to the form "feature value"', 0, 0), ('postProcessAttribute', 'On post-process in admin feature value', 'On post-process in admin feature value', 0, 0), ('afterDeleteAttribute', 'On deleting attribute feature value', 'On deleting attribute feature value', 0, 0), ('afterSaveAttribute', 'On saving attribute feature value', 'On saving attribute feature value', 0, 0)

 

ALTER TABLE `ps_employee` ADD `bo_show_screencast` TINYINT(1) NOT NULL DEFAULT '1' AFTER `bo_uimode`

 

UPDATE `ps_country` SET id_zone = (SELECT id_zone FROM `ps_zone` WHERE name = 'Oceania' LIMIT 1) WHERE iso_code = 'KI' LIMIT 1

 

ALTER TABLE `ps_lang` ADD `date_format_lite` char(32) NOT NULL DEFAULT 'Y-m-d' AFTER language_code

 

ALTER TABLE `ps_lang` ADD `date_format_full` char(32) NOT NULL DEFAULT 'Y-m-d H:i:s' AFTER date_format_lite

 

UPDATE `ps_lang` SET `date_format_lite` = 'd/m/Y' WHERE `iso_code` IN ('fr', 'es', 'it')

 

UPDATE `ps_lang` SET `date_format_full` = 'd/m/Y H:i:s' WHERE `iso_code` IN ('fr', 'es', 'it')

 

UPDATE `ps_lang` SET `date_format_lite` = 'd.m.Y' WHERE `iso_code` = 'de'

 

UPDATE `ps_lang` SET `date_format_full` = 'd.m.Y H:i:s' WHERE `iso_code` = 'de'

 

UPDATE `ps_lang` SET `date_format_lite` = 'm/d/Y' WHERE `iso_code` = 'en'

 

UPDATE `ps_lang` SET `date_format_full` = 'm/d/Y H:i:s' WHERE `iso_code` = 'en'

 

ALTER IGNORE TABLE `ps_specific_price_priority` ADD UNIQUE (`id_product`)

 

SET NAMES 'utf8'

 

SET NAMES 'utf8'

 

/* PHP:update_order_canada(); */

 

CREATE TABLE IF NOT EXISTS `ps_compare` ( `id_compare` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_customer` int(10) unsigned NOT NULL, PRIMARY KEY (`id_compare`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8

 

ALTER TABLE `ps_compare_product` DROP `id_compare_product` , DROP `id_guest` , DROP `id_customer`

 

ALTER TABLE `ps_compare_product` ADD `id_compare` int(10) unsigned NOT NULL, ADD PRIMARY KEY(`id_compare`, `id_product`)

 

ALTER TABLE `ps_store` CHANGE `latitude` `latitude` DECIMAL(11, 8) NULL DEFAULT NULL

 

ALTER TABLE `ps_store` CHANGE `longitude` `longitude` DECIMAL(11, 8) NULL DEFAULT NULL

 

ALTER TABLE `ps_address_format` ADD PRIMARY KEY (`id_country`)

(1062) Duplicate entry '0' for key 'PRIMARY'

 

ALTER TABLE `ps_address_format` DROP INDEX `country`

 

/* PHP:hook_blocksearch_on_header(); */

 

SET NAMES 'utf8'

 

/* PHP:add_module_to_hook(authorizeaim, header); */

 

SET NAMES 'utf8'

 

INSERT IGNORE INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_LIMIT_UPLOAD_IMAGE_VALUE', '2', NOW(), NOW()), ('PS_LIMIT_UPLOAD_FILE_VALUE', '2', NOW(), NOW())

 

SET NAMES 'utf8'

 

/* PHP:category_product_index_unique(); */

 

CREATE TABLE IF NOT EXISTS `ps_order_tax` ( `id_order` int(10) NOT NULL, `tax_name` varchar(40) NOT NULL, `tax_rate` decimal(6,3) NOT NULL, `amount` decimal(20,6) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8

 

INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`, `live_edit`) VALUES ('frontCanonicalRedirect', 'Front Canonical Redirect', 'Check for 404 errors before canonical redirects', 0, 0)

 

/* PHP:update_module_pagesnotfound(); */

 

ALTER TABLE `ps_order_state` ADD COLUMN `deleted` tinyint(1) UNSIGNED NOT NULL default '0' AFTER `delivery`

 

SET NAMES 'utf8'

 

SET NAMES 'utf8'

 

SET NAMES 'utf8'

 

SET NAMES 'utf8'

 

ALTER TABLE `ps_feature_product` ADD INDEX `id_product`(`id_product`)

 

SET NAMES 'utf8'

 

SET NAMES 'utf8'

 

SET NAMES 'utf8'

 

SET NAMES 'utf8'

 

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

 

/* PHP:clean_category_product(); */

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

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

 

ALTER TABLE `ps_product` ADD INDEX indexed (`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_blocklayered(); */

 

SET NAMES 'utf8'

 

/* PHP:update_module_mailalerts(); */

 

/* PHP:update_htaccess(); */

 

/* Backward compatibility */ INSERT INTO `ps_module` (`name`, `active`) VALUES ('backwardcompatibility', 1)

 

INSERT INTO `ps_hook_module` (`id_module`, `id_hook` , `position`) (SELECT id_module, 9, (SELECT max_position from (SELECT MAX(position)+1 as max_position FROM `ps_hook_module` WHERE `id_hook` = 9) tmp) FROM `ps_module` WHERE `name` = 'backwardcompatibility')

 

INSERT INTO `ps_hook_module` (`id_module`, `id_hook` , `position`) (SELECT id_module, 50, (SELECT max_position from (SELECT MAX(position)+1 as max_position FROM `ps_hook_module` WHERE `id_hook` = 50) tmp) FROM `ps_module` WHERE `name` = 'backwardcompatibility')

 

INSERT INTO `ps_hook_module` (`id_module`, `id_hook` , `position`) (SELECT id_module, 54, (SELECT max_position from (SELECT MAX(position)+1 as max_position FROM `ps_hook_module` WHERE `id_hook` = 54) tmp) FROM `ps_module` WHERE `name` = 'backwardcompatibility')

 

UPDATE `ps_order_state` SET `send_email` = 1 WHERE `id_order_state` = (SELECT `value` FROM `ps_configuration` WHERE `name` = 'PS_OS_WS_PAYMENT' LIMIT 1)

 

UPDATE `ps_order_state_lang` SET `template` = 'payment' WHERE `id_order_state` = (SELECT `value` FROM `ps_configuration` WHERE `name` = 'PS_OS_WS_PAYMENT' LIMIT 1)

 

ALTER TABLE `ps_county_zip_code` CHANGE `from_zip_code` `from_zip_code` VARCHAR( 12 ) NOT NULL , CHANGE `to_zip_code` `to_zip_code` VARCHAR( 12 ) NOT NULL

[ubergirl]

J'ai eu la même erreur. Vous n'avez pas eu de réponse?

[Gregory Roussac]

Hello,

 

Vous avez des lignes dans ps_address_format qui sont en doubles avec comme id_country = 0, donc il faudrait supprimer ces formats qui ne correspondent à aucun pays.

 

Par exemple

 

SELECT *
FROM `ps_address_format`
WHERE `id_country` =0

 

dans phpmyadmin devrait vous les donner

 

et

 

DELETE FROM `ps_address_format` WHERE `id_country` =0

 

les supprimer.

 

Bon courage