You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Impacted versions:
Migrating from ODOO online -> On premise
Steps to reproduce:
Take database dump on odoo online and import in on premise
--> Update module base
Current behavior:
Error. Does not complete
024-05-08 22:24:30,924 69 ERROR TEST odoo.sql_db: bad query:
UPDATE "res_groups" AS m
SET "name" = CASE WHEN False IS TRUE AND imd.noupdate IS FALSE
THEN m."name" || t.value
ELSE t.value || m."name"END
FROM (
VALUES ('product', 'group_sale_pricelist', '{"de_DE": "Erweiterte Preislisten", "es_ES": "Listas de precios avanzadas"}'::jsonb), ('product', 'group_product_pricelist', '{"de_DE": "Basispreisliste", "es_ES": "Lista de precios b\u00e1sicas"}'::jsonb), ('product', 'group_discount_per_so_line', '{"de_DE": "Rabatt auf Auftragspositionen", "es_ES": "Descuentos en l\u00edneas"}'::jsonb), ('product', 'group_stock_packaging', '{"de_DE": "Produktverpackungen verwalten", "es_ES": "Administrar empaquetado del producto"}'::jsonb), ('product', 'group_product_variant', '{"de_DE": "Produktvarianten verwalten", "es_ES": "Administrar Variantes de Productos"}'::jsonb)
) AS t(imd_module, imd_name, value)
JOIN "ir_model_data" AS imd
ON imd."model" = 'res.groups' AND imd.name = t.imd_name AND imd.module = t.imd_module
WHERE imd."res_id" = m."id"
ERROR: duplicate key value violates unique constraint "res_groups_name_uniq"
DETAIL: Key (category_id, name)=(14, {"de_DE": "Rabatt auf Auftragspositionen", "en_US": "Discount on lines", "es_ES": "Descuentos en líneas"}) already exists.
Expected behavior:
Update finished
I do not even understant that query. When I see: CASE WHEN False IS TRUE AND imd.noupdate IS FALSE I get confused.
What can I do?
Video/Screenshot link (optional):
Support ticket number submitted via odoo.com/help (optional):
The text was updated successfully, but these errors were encountered:
Impacted versions:
Migrating from ODOO online -> On premise
Steps to reproduce:
Take database dump on odoo online and import in on premise
--> Update module base
Current behavior:
Error. Does not complete
024-05-08 22:24:30,924 69 ERROR TEST odoo.sql_db: bad query:
UPDATE "res_groups" AS m
SET "name" = CASE WHEN False IS TRUE AND imd.noupdate IS FALSE
THEN m."name" || t.value
ELSE t.value || m."name"END
FROM (
VALUES ('product', 'group_sale_pricelist', '{"de_DE": "Erweiterte Preislisten", "es_ES": "Listas de precios avanzadas"}'::jsonb), ('product', 'group_product_pricelist', '{"de_DE": "Basispreisliste", "es_ES": "Lista de precios b\u00e1sicas"}'::jsonb), ('product', 'group_discount_per_so_line', '{"de_DE": "Rabatt auf Auftragspositionen", "es_ES": "Descuentos en l\u00edneas"}'::jsonb), ('product', 'group_stock_packaging', '{"de_DE": "Produktverpackungen verwalten", "es_ES": "Administrar empaquetado del producto"}'::jsonb), ('product', 'group_product_variant', '{"de_DE": "Produktvarianten verwalten", "es_ES": "Administrar Variantes de Productos"}'::jsonb)
) AS t(imd_module, imd_name, value)
JOIN "ir_model_data" AS imd
ON imd."model" = 'res.groups' AND imd.name = t.imd_name AND imd.module = t.imd_module
WHERE imd."res_id" = m."id"
ERROR: duplicate key value violates unique constraint "res_groups_name_uniq"
DETAIL: Key (category_id, name)=(14, {"de_DE": "Rabatt auf Auftragspositionen", "en_US": "Discount on lines", "es_ES": "Descuentos en líneas"}) already exists.
Expected behavior:
Update finished
I do not even understant that query. When I see: CASE WHEN False IS TRUE AND imd.noupdate IS FALSE I get confused.
What can I do?
Video/Screenshot link (optional):
Support ticket number submitted via odoo.com/help (optional):
The text was updated successfully, but these errors were encountered: