ON CONFLICT DO UPDATE problem

Question

Hi,
Trying to import translation in Odoo 12, i get the following error :
ERROR: ON CONFLICT DO UPDATE command cannot affect row a second time
HINT: Ensure that no rows proposed for insertion within the same command have duplicate constrained
values.  i did some research and found out that postgres included On Conflict to 'Upsert' a record.
That is to say : when you insert a new row into the table, PostgreSQL will update the row if it already exists, otherwise, PostgreSQL inserts the new row.
See

Ibrahim Boudmir · Accepted Answer

I found out that in the po file, a word was translated twice as Ray said. had to look carefully for each line to get the wrong one.

RAJAONARIVONY Rivo Lalaina · Answer

@ Ibrahim Boudmir [1]
To check for duplicate lines in your .po file, you can use P*oedit*  https://poedit.net/ [2] , which will alert you directly if there are any duplicates.

[1] https://www.odoo.com/fr_FR/forum/aide-1/user/598190?forum_origin=/forum/aide-1/on-conflict-do-update-problem-141853
[2] http://poedit.net/

marocsys, marocsys · Answer

hi @ibrahim
i had the same issue , its because i installed a module version 11 in 12 version , if it's your case try to adapt your file lang.po  with version 12

Samo Arko · Answer

Did you figure out how to fix it? I've updated odoo 12 to latest version. The 2 modules that I've migrated from odoo 10, I've exported the translation form odoo 12 and replaced the translation files in models.
But I still get the error when I want to add the language with override terms.

المنشورات ذات الصلة	الردود	أدوات العرض
Cannot Overwrite Existing Terms in loading translation. Get error ON CONFLICT DO UPDATE. تم الحل translation odoo12	2 يوليو 20	6562
Survey User odoo12	1 أبريل 26	4312
Translations for the top menu URL's translation	0 ديسمبر 24	3253
downloading the po file translation	2 فبراير 24	4811
Odoo Mail Sending Limit تم الحل odoo12	2 ديسمبر 23	18732

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!