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.

Related Posts	Odpovědi	Zobrazení
Cannot Overwrite Existing Terms in loading translation. Get error ON CONFLICT DO UPDATE. Vyřešeno translation odoo12	2 čvc 20	6559
Survey User odoo12	1 dub 26	4275
Translations for the top menu URL's translation	0 pro 24	3243
downloading the po file translation	2 úno 24	4803
Odoo Mail Sending Limit Vyřešeno odoo12	2 pro 23	18710

This question has been flagged

Enjoying the discussion? Don't just read, join in!