update 1.2.2 to 1.3.2 - SQL error - duplication

[adamus007p]

During update from 1.2.2 to 1.3.2 there is one mySQL error. duplication -details

part of log:
DELETE FROM `ps_search_word` WHERE `id_lang` NOT IN (SELECT `id_lang` FROM `ps_lang`)

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PRESTASTORE_LIVE', 1, NOW(), NOW()), ('PS_SHOW_ALL_MODULES', 0, NOW(), NOW()), ('PS_BACKUP_ALL', 0, NOW(), NOW()), ('PS_1_3_UPDATE_DATE', NOW(), NOW(), NOW()), ('PS_PRICE_ROUND_MODE', 2, NOW(), NOW())

(1062) Duplicate entry 'PRESTASTORE_LIVE' for key 2
INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`) VALUES ('createAccountTop', 'Block above the form for create an account', NULL , '1'), ('backOfficeHeader', 'Administration panel header', NULL , '0'), ('backOfficeTop', 'Administration panel top hover the tabs', NULL , '1'), ('backOfficeFooter', 'Administration panel footer', NULL , '1')


attached screen


please help me



EDIT:

same error during update 1.2.5. to 1.3.2 (the version from 1 Oct 2010 - latest version)


in another time I have similar message but:

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PRESTASTORE_LIVE', 1, NOW(), NOW()), ('PS_SHOW_ALL_MODULES', 0, NOW(), NOW()), ('PS_BACKUP_ALL', 0, NOW(), NOW()), ('PS_1_3_UPDATE_DATE', NOW(), NOW(), NOW()), ('PS_PRICE_ROUND_MODE', 2, NOW(), NOW())

(1062) Duplicate entry 'PRESTASTORE_LIVE' for key 'name'

[adamus007p]

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES (‘PRESTASTORE_LIVE’, 1, NOW, NOW), (‘PS_SHOW_ALL_MODULES’, 0, NOW, NOW), (‘PS_BACKUP_ALL’, 0, NOW, NOW), (‘PS_1_3_UPDATE_DATE’, NOW, NOW, NOW), (‘PS_PRICE_ROUND_MODE’, 2, NOW, NOW)

(1062) Duplicate entry ‘PRESTASTORE_LIVE’ for key 2


...

and

...



INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES (‘PRESTASTORE_LIVE’, 1, NOW, NOW), (‘PS_SHOW_ALL_MODULES’, 0, NOW, NOW), (‘PS_BACKUP_ALL’, 0, NOW, NOW), (‘PS_1_3_UPDATE_DATE’, NOW, NOW, NOW), (‘PS_PRICE_ROUND_MODE’, 2, NOW, NOW)

(1062) Duplicate entry ‘PRESTASTORE_LIVE’ for key ‘name’

[rocky]

Did you try to upgrade PrestaShop multiple times? It seems PrestaShop tried to add new configuration entries into the database, but found that they were already there, which generated the error. You should check that the following entries are in your ps_configuration table:

('PRESTASTORE_LIVE', 1, NOW, NOW)
('PS_SHOW_ALL_MODULES', 0, NOW, NOW)
('PS_BACKUP_ALL', 0, NOW, NOW)
('PS_1_3_UPDATE_DATE', NOW, NOW, NOW)
('PS_PRICE_ROUND_MODE', 2, NOW, NOW)

If any of these entries are missing, you will need to add them to prevent problems in PrestaShop.

[adamus007p]

I first time update database. I made it with database copy, before I will make a final update.

[IBICO]

I also got lot`s of error when upgrading my prestashop to latest.

Even when I do a fresh install I notice lot of error rapport in SQL.

Problems with indexes of table `ps_category_group`
More than one INDEX key was created for column `id_category`
Problems with indexes of table `ps_customer`
PRIMARY and INDEX keys should not both be set for column `id_customer`
UNIQUE and INDEX keys should not both be set for column `email`
Problems with indexes of table `ps_customer_group`
PRIMARY and INDEX keys should not both be set for column `id_customer`
Problems with indexes of table `ps_employee`
PRIMARY and INDEX keys should not both be set for column `id_employee`
Problems with indexes of table `ps_hook_module`
PRIMARY and INDEX keys should not both be set for column `id_module`
Problems with indexes of table `ps_image`
UNIQUE and INDEX keys should not both be set for column `id_product`
More than one INDEX key was created for column `id_product`
Problems with indexes of table `ps_image_lang`
UNIQUE and INDEX keys should not both be set for column `id_image`
Problems with indexes of table `ps_module_currency`
PRIMARY and INDEX keys should not both be set for column `id_module`
Problems with indexes of table `ps_order_detail`
More than one INDEX key was created for column `id_order`
Problems with indexes of table `ps_product_attribute`
PRIMARY and INDEX keys should not both be set for column `id_product_attribute`
More than one INDEX key was created for column `id_product`

[adamus007p]

IBICO same error like mine?

Look at my screens.

[IBICO]

IBICO same error like mine?

Look at my screens.

I had multiple errors. I had to rebuild the whole webshop from scratch. 3rd day and still working on it.

I got that error list I posted last when I did a FRESH install. Not while installing, but when I checked the SQL database from PhPMyAdmin.. so a bit strange..

[adamus007p]

rocky update from 1.2.2 to 1.2.5 work. There are no errors.

when I try to update from 1.2.2 or 1.2.5 to newest version there is one error


1. I was trying it in two different servers: local and web
2. This is my first shop update