Cześć, mam taki problem aktualizowałem prestę z 1.3.1.1 na 1.3.3.0
Wszystko przebiegło fajnie ale na końcu mam
Update is finished!
Unfortunately, 8 SQL errors have occurred.
SET NAMES 'utf8'
SET NAMES 'utf8'
ALTER TABLE `ps_order_detail` ADD `reduction_percent` DECIMAL(10, 2) NOT NULL AFTER `product_price`
(1060) Duplicate column name 'reduction_percent'
ALTER TABLE `ps_order_detail` ADD `reduction_amount` DECIMAL(20, 6) NOT NULL AFTER `reduction_percent`
(1060) Duplicate column name 'reduction_amount'
ALTER TABLE `ps_country` CHANGE `need_identification_number` `need_identification_number` TINYINT(1) NOT NULL DEFAULT '0'
INSERT INTO `ps_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 'name'
ALTER TABLE `ps_search_index` CHANGE `weight` `weight` SMALLINT(4) unsigned NOT NULL DEFAULT '1'
ALTER TABLE `ps_image` DROP INDEX `product_position`, ADD UNIQUE `product_position` (`id_product`, `position`)
ALTER TABLE `ps_zone` DROP `enabled`
(1091) Can't DROP 'enabled'; check that column/key exists
SET @id_hook = (SELECT id_hook FROM ps_hook WHERE name = 'backOfficeHeader')
SET @position = (SELECT IFNULL(MAX(position),0)+1 FROM ps_hook_module WHERE id_hook = @id_hook)
INSERT IGNORE INTO ps_hook_module (id_hook, id_module, position) VALUES (@id_hook, (SELECT id_module FROM ps_module WHERE name = 'statsbestcustomers'), @position)
SET @position = @position + 1
INSERT IGNORE INTO ps_hook_module (id_hook, id_module, position) VALUES (@id_hook, (SELECT id_module FROM ps_module WHERE name = 'statsbestproducts'), @position)
SET @position = @position + 1
INSERT IGNORE INTO ps_hook_module (id_hook, id_module, position) VALUES (@id_hook, (SELECT id_module FROM ps_module WHERE name = 'statsbestvouchers'), @position)
SET @position = @position + 1
INSERT IGNORE INTO ps_hook_module (id_hook, id_module, position) VALUES (@id_hook, (SELECT id_module FROM ps_module WHERE name = 'statsbestcategories'), @position)
SET @position = @position + 1
INSERT IGNORE INTO ps_hook_module (id_hook, id_module, position) VALUES (@id_hook, (SELECT id_module FROM ps_module WHERE name = 'statsbestcarriers'), @position)
SET NAMES 'utf8'
ALTER TABLE `ps_state` CHANGE `iso_code` `iso_code` CHAR(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
SET NAMES 'utf8'
ALTER TABLE `ps_order_detail` ADD `group_reduction` DECIMAL(10, 2) NOT NULL AFTER `reduction_amount`
(1060) Duplicate column name 'group_reduction'
ALTER TABLE `ps_order_detail` ADD `ecotax_tax_rate` DECIMAL(5, 3) NOT NULL AFTER `ecotax`
(1060) Duplicate column name 'ecotax_tax_rate'
ALTER TABLE `ps_product` CHANGE `ecotax` `ecotax` DECIMAL(21, 6) NOT NULL DEFAULT '0.00'
INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) SELECT 'PS_LOCALE_LANGUAGE', l.`iso_code`, NOW(), NOW() FROM `ps_configuration` c INNER JOIN `ps_lang` l ON (l.`id_lang` = c.`value`) WHERE c.`name` = 'PS_LANG_DEFAULT'
(1062) Duplicate entry 'PS_LOCALE_LANGUAGE' for key 'name'
INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) SELECT 'PS_LOCALE_COUNTRY', co.`iso_code`, NOW(), NOW() FROM `ps_configuration` c INNER JOIN `ps_country` co ON (co.`id_country` = c.`value`) WHERE c.`name` = 'PS_COUNTRY_DEFAULT'
(1062) Duplicate entry 'PS_LOCALE_COUNTRY' for key 'name'
Teoretycznie wszystko działa, olać te błędy czy wracać do starszej wersji ? kombinowałem kilka razy ale nie idzie bez tych błędów zaktualizować.
//edit
Wywaliłem 1.3.3.0 i wróciłem do 1.3.1.1 poczekam na 1.4 bo jakoś słabo ta aktualizacja idzie.
