Duplicate entry '0-0-7' for key 'PRIMARY'; INSERT INTO `ps_product

May 12, 2013

koutsoumpidis@yahoo.gr wrote

When I click to Post changes to Web I get the following errors.

1062; Duplicate entry '0-0-7' for key 'PRIMARY';INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (0, 0, 7, NULL, NULL, '', NULL, NULL, NULL, '', NULL, NULL);
1062; Duplicate entry '0-0-7' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (0, 0, 7, NULL, NULL, '', NULL, NULL, NULL, '', NULL, NULL);
1062; Duplicate entry '0-0-1' for key 'PRIMARY'; INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (0, 0, 1, NULL, NULL, '', NULL, NULL, NULL, '', NULL, NULL);

I tried to delete these entries from the database but it keeps repeating after a next update.
Can you help? Thanks.

9 Answers

May 12, 2013

koutsoumpidis@yahoo.gr wrote

I removed them from the sql log and it finished successfully

but at the next update I have the first sql that keeps producing, what should I change at the Prestashop Manager so it won't show up the next time? Thanks

1062; Duplicate entry '0-0-7' for key 'PRIMARY';INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) VALUES (0, 0, 7, NULL, NULL, '', NULL, NULL, NULL, '', NULL, NULL);

May 13, 2013

Dmytro Grycelyak agent wrote

Hello joss_54,

Thank you for contacting us.

The error you receive indicates, that Store Manager can not Post Changes to Web because some data may be duplicated.
Probably you have being doing some changes from PrestaShop back-end while making changes in Store Manager.

In order to fix the issue, please perform Get Data from Web (in order to synchronize the Store Manger with the actual data of your database), make changes once more and Post Changes to Web.

May 20, 2013

koutsoumpidis@yahoo.gr wrote

Thanks a lot!
Problem solved..

Jul 30, 2015

Oksana Semenyuk agent wrote

Hi to all,

We've written an article describing how to fix the Duplicated error and not to loose data:
https://support.emagicone.com/775744-Bridge-Connection---Duplicate-entry-error-Duplicated-data-also-it-may-look-like-Error-23000-Duplicate-entry-7650-for-key-PRIMARY-

It is a good solution if you've made a lot of changes to your products manually and retriving data is not an option (as you will loose too much work that was done manually).

Note that not all data can be recovered this way.

Hope it will help some users to get things up and running really fast

Aug 29, 2015

Renzo wrote

Hello Volodymyr and Oksana

I got this error : |1062; Duplicate entry '1-1-mandi' for key 'id_lang'

I follow your instructions but it doesn't work

Any suggestion ?

Aug 31, 2015

Dmytro Grycelyak agent wrote

Hello Renzo.

You have to make sure that no one is making changes from the back-end or another PC until you Post Changes to Web.

Aug 31, 2015

Renzo wrote

Thanks Volodymir

I talked to Roman by chat this morning
He is analyzing it and I´m waiting the slution.

Regards

Sep 03, 2015

Dmytro Grycelyak agent wrote

Hello.

The issue with Post Changes to Web after Rebuilt Entire Index has been fixed in the beta version of Store Manager for PrestaShop.

Sep 08, 2015

System wrote

Hello,

We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com

Maybe we are waiting for some information from your side? In this case please get back to us.

In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.

If you do not reply us back, the ticket will be automatically closed within 24 hours.

With kind regards,

The eMagicOne Administration Team