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
