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

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

Avatar image
May 12, 2013
Yiannis 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.
Reply
9 Answers
Avatar image
May 12, 2013
Yiannis 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);
Avatar image
May 13, 2013
Andrii Yanosh 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.
Avatar image
May 20, 2013
Yiannis wrote
Thanks a lot!
Problem solved..
Avatar image
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 ?
Avatar image
Aug 31, 2015
Andrii Yanosh 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

Avatar image
Sep 03, 2015
Andrii Yanosh 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