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.
Did you check that you aren't trying to translate the same thing twice in the same import file?
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
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.