Zum Inhalt springen
Sie müssen registriert sein, um mit der Community zu interagieren.
Alle Beiträge Personen Abzeichen
Stichwörter (Alle anzeigen)
odoo accounting v14 pos v15
Über dieses Forum
Diese Frage wurde gekennzeichnet
migrationenterprise
1 Antworten
2907 Ansichten
Avatar
Dinesh K

I have migrated the database form V15 to V18 using Odoo upgrade tool. after restoring the migrated database in test server facing some issues. Here is the error message. 


psycopg2.errors.UndefinedFunction: operator does not exist: character varying ->> unknown

LINE 1: SELECT "res_company"."id", "res_company"."name"->>'en_US', "...

                                                       ^

HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.


2025-05-08 10:30:19,295 165445 INFO uat_may5_test_1 werkzeug: 127.0.0.1 - - [08/May/2025 10:30:19] "GET /odoo?db=uat_may5_test_1 HTTP/1.0" 500 - 6 0.004 0.159

2025-05-08 10:30:19,778 165445 ERROR uat_may5_test_1 odoo.sql_db: bad query: b'SELECT "res_company"."id", "res_company"."name"->>\'en_US\', "res_company"."active", "res_company"."sequence", "res_company"."parent_id", "res_company"."parent_path", "res_company"."partner_id", "res_company"."report_header"->>\'en_US\', "res_company"."report_footer"->>\'en_US\', "res_company"."company_details"->>\'en_US\', "res_company"."uses_default_logo", "res_company"."currency_id", "res_company"."email", "res_company"."phone", "res_company"."mobile", "res_company"."paperformat_id", "res_company"."external_report_layout_id", "res_company"."font", "res_company"."primary_color", "res_company"."secondary_color", "res_company"."layout_background", "res_company"."create_uid", "res_company"."create_date", "res_company"."write_uid", "res_company"."write_date", "res_company"."social_twitter", "res_company"."social_facebook", "res_company"."social_github", "res_company"."social_linkedin", "res_company"."social_youtube", "res_company"."social_instagram", "res_company"."social_tiktok", "res_company"."nomenclature_id", "res_company"."resource_calendar_id", "res_company"."alias_domain_id", "res_company"."alias_domain_name", "res_company"."email_primary_color", "res_company"."email_secondary_color", "res_company"."partner_gid", "res_company"."iap_enrich_auto_done", "res_company"."snailmail_color




Thanks in advance

Avatar
Verwerfen
Avatar
D Enterprise
Beste Antwort

Hii,

The error means Odoo is using ->>'en_US' on a text field (name) that is no longer JSON in Odoo 18.

  1. Connect to your DB (via psql or pgAdmin).
  2. Run these commands:
    ALTER TABLE res_company ALTER COLUMN name TYPE varchar;
  3. ALTER TABLE res_company ALTER COLUMN report_header TYPE varchar;
  4. ALTER TABLE res_company ALTER COLUMN report_footer TYPE varchar;
  5. ALTER TABLE res_company ALTER COLUMN company_details TYPE varchar;
  6. Restart Odoo server.



Avatar
Verwerfen
Verknüpfte Beiträge Antworten Ansichten Aktivität
Migrating basic db from Online Free status to Locally hosted community based
migration enterprise Community
Avatar
0
Aug. 22
3997
I can't move my enterprise subscription to odoo.sh
migration enterprise odoo.sh
Avatar
Avatar
2
Juni 22
5237
Migrate Odoo 15 Enterprise version to odoo 17 Enterprise version with custom modules
migration enterprise v15 v17
Avatar
Avatar
1
Nov. 25
2290
odoo module migration from version 14 to 16 Gelöst
migration
Avatar
Avatar
1
Mai 25
3129
Error Uncaught Promise > models[resModel][fieldName] is undefined MIGRATING
migration
Avatar
0
Aug. 24
2994