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 7월 20	6563
Survey User odoo12	1 4월 26	4322
Translations for the top menu URL's translation	0 12월 24	3258
downloading the po file translation	2 2월 24	4819
Odoo Mail Sending Limit 해결 완료 odoo12	2 12월 23	18735

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!