erreur sql mise a jour 1.4.4.1 vers 1.4.7.3

[stephforum]

Bonjour,

En faisant la mise jour vers la version 1.4.7.3, le rapport indique qu'il y a eu 2 erreur SQL. Savez vous si elles sont graves ?

C'est possible de l'ai faire manuellement ?

Merci beaucoup pour vos réponses

Voici le rapport d'erreur :

 

 

Malheureusement, 2 erreurs SQL sont apparues.

 

 

SET NAMES 'utf8'


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
(1048) Column 'id_zone' cannot be null



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=MyISAM 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`)


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(11)

NOT NULL, `tax_name` varchar(40) NOT NULL, `tax_rate`

decimal(6,3) NOT NULL, `amount` decimal(20,6) NOT NULL )

ENGINE=MyISAM 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)


SET @id_hook = (SELECT `id_hook` FROM `ps_hook` WHERE `name` =

'frontCanonicalRedirect')


SET @position = (SELECT IFNULL(MAX(`position`),0)+1 FROM

`ps_hook_module` WHERE `id_hook` = @id_hook)


SET @id_module = (SELECT `id_module` FROM `ps_module` WHERE

`name` = 'pagesnotfound')


INSERT INTO `ps_hook_module` (`id_hook`, `id_module`,

`position`) VALUES (@id_hook, @id_module, @position)
(1048) Column 'id_module' cannot be null



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'