Big problems whit upgrade.

[Lustfull]

Tried to upgrade from v1.3.1.1 to v.1.3.5.

Got several errors and I don't understand what to do.
Can I fix this or should I just use the "old" version 1.3.1.1?

Regards
Susanne

ERRORS:

SET NAMES ‘utf8’

SET NAMES ‘utf8’

ALTER TABLE `pps_order_detail` ADD `reduction_percent` DECIMAL NOT NULL AFTER `product_price`

(1060) Duplicate column name ‘reduction_percent’
ALTER TABLE `pps_order_detail` ADD `reduction_amount` DECIMAL NOT NULL AFTER `reduction_percent`

(1060) Duplicate column name ‘reduction_amount’
ALTER TABLE `pps_country` CHANGE `need_identification_number` `need_identification_number` TINYINT NOT NULL DEFAULT ‘0’

INSERT INTO `pps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES (‘PS_1_3_2_UPDATE_DATE’, NOW, NOW, NOW)

(1062) Duplicate entry ‘PS_1_3_2_UPDATE_DATE’ for key 2
ALTER TABLE `pps_search_index` CHANGE `weight` `weight` SMALLINT unsigned NOT NULL DEFAULT ‘1’

ALTER TABLE `pps_image` DROP INDEX `product_position`, ADD UNIQUE `product_position` (`id_product`, `position`)

ALTER TABLE `pps_zone` DROP `enabled`

(1091) Can’t DROP ‘enabled’; check that column/key exists
SET @id_hook = (SELECT id_hook FROM pps_hook WHERE name = ‘backOfficeHeader’)

SET position = (SELECT IFNULL(MAX(position),0)+1 FROM pps_hook_module WHERE id_hook = id_hook)

INSERT IGNORE INTO pps_hook_module (id_hook, id_module, position) VALUES (id_hook, (SELECT id_module FROM pps_module WHERE name = 'statsbestcustomers'), position)

SET position = position + 1

INSERT IGNORE INTO pps_hook_module (id_hook, id_module, position) VALUES (id_hook, (SELECT id_module FROM pps_module WHERE name = 'statsbestproducts'), position)

SET position = position + 1

INSERT IGNORE INTO pps_hook_module (id_hook, id_module, position) VALUES (id_hook, (SELECT id_module FROM pps_module WHERE name = 'statsbestvouchers'), position)

SET position = position + 1

INSERT IGNORE INTO pps_hook_module (id_hook, id_module, position) VALUES (id_hook, (SELECT id_module FROM pps_module WHERE name = 'statsbestcategories'), position)

SET position = position + 1

INSERT IGNORE INTO pps_hook_module (id_hook, id_module, position) VALUES (id_hook, (SELECT id_module FROM pps_module WHERE name = 'statsbestcarriers'), position)

SET NAMES ‘utf8’

ALTER TABLE `pps_state` CHANGE `iso_code` `iso_code` CHAR CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL

SET NAMES ‘utf8’

ALTER TABLE `pps_order_detail` ADD `group_reduction` DECIMAL NOT NULL AFTER `reduction_amount`

(1060) Duplicate column name ‘group_reduction’
ALTER TABLE `pps_order_detail` ADD `ecotax_tax_rate` DECIMAL NOT NULL AFTER `ecotax`

(1060) Duplicate column name ‘ecotax_tax_rate’
ALTER TABLE `pps_product` CHANGE `ecotax` `ecotax` DECIMAL NOT NULL DEFAULT ’0.00’

INSERT INTO `pps_configuration` (`name`, `value`, `date_add`, `date_upd`) SELECT ‘PS_LOCALE_LANGUAGE’, l.`iso_code`, NOW, NOW FROM `pps_configuration` c INNER JOIN `pps_lang` l ON (l.`id_lang` = c.`value`) WHERE c.`name` = ‘PS_LANG_DEFAULT’

(1062) Duplicate entry ‘PS_LOCALE_LANGUAGE’ for key 2
INSERT INTO `pps_configuration` (`name`, `value`, `date_add`, `date_upd`) SELECT ‘PS_LOCALE_COUNTRY’, co.`iso_code`, NOW, NOW FROM `pps_configuration` c INNER JOIN `pps_country` co ON (co.`id_country` = c.`value`) WHERE c.`name` = ‘PS_COUNTRY_DEFAULT’

(1062) Duplicate entry ‘PS_LOCALE_COUNTRY’ for key 2
SET NAMES ‘utf8’

SET NAMES ‘utf8’

[rocky]

It looks like you tried to upgrade your database more than once. The installer it trying to add new columns to the database, but it finding that they are already there. If an upgrade fails, you must restore a backup of the old version before attempting to upgrade again.