Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
translationodoo12
4 Vastaukset
33642 Näkymät
Avatar
Ibrahim Boudmir

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 http://www.postgresqltutorial.com/postgresql-upsert/ for more details. 

In my case, what should i do so that i can import translation successfully ?

Thank you.

Avatar
Hylkää
Ray Carnes (ray)

Did you check that you aren't trying to translate the same thing twice in the same import file?

faOtools

I experience the same issue if the option 'Overwrite existing terms' is turned on. It seems that the bug https://github.com/odoo/odoo/issues/27268 is not fully fixed

Ibrahim Boudmir
Tekijä

Hi @Ray,

Yes, i'm not translating the same thing twice in the same import file.

@Odoo Tools,

Thanks for the link. Altough in moylop260's scenario, ``Overwrite existing terms`` is not checked.

In my example, it is indeed checked and get the same problem.

Avatar
Ibrahim Boudmir
Tekijä Paras vastaus

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.

Avatar
Hylkää
User TUS

Okay, how we can find duplicates? I have more than 3000 translation terms.

Avatar
RAJAONARIVONY Rivo Lalaina
Paras vastaus

@Ibrahim Boudmir

To check for duplicate lines in your .po file, you can use Poedit https://poedit.net/, which will alert you directly if there are any duplicates.

Avatar
Hylkää
Avatar
marocsys, marocsys
Paras vastaus

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

Avatar
Hylkää
Avatar
Samo Arko
Paras vastaus

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.


Avatar
Hylkää
Samo Arko

after that you cloud just run load translation with option Overwrite existing terms or did you have to remove the module first? Thanks

Ibrahim Boudmir
Tekijä

overwrite existing terms won't delete redundant translations from your po file.

you need to figure out what translation is declared twice or more in it.

Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
Cannot Overwrite Existing Terms in loading translation. Get error ON CONFLICT DO UPDATE. Ratkaistu
translation odoo12
Avatar
Avatar
2
heinäk. 20
6573
Survey User
odoo12
Avatar
1
huhtik. 26
4459
Translations for the top menu URL's
translation
Avatar
0
jouluk. 24
3329
downloading the po file
translation
Avatar
Avatar
Avatar
2
helmik. 24
4880
Odoo Mail Sending Limit Ratkaistu
odoo12
Avatar
Avatar
Avatar
2
jouluk. 23
18835