Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Updat base error #165008

Closed
AquaMCU opened this issue May 8, 2024 · 1 comment
Closed

Updat base error #165008

AquaMCU opened this issue May 8, 2024 · 1 comment

Comments

@AquaMCU
Copy link

AquaMCU commented May 8, 2024

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):

@AquaMCU
Copy link
Author

AquaMCU commented May 18, 2024

Issue resolves. I reinstalled the DB ....

@AquaMCU AquaMCU closed this as completed May 18, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant