Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I am trying to make the name field of the res.partner model translatable by overriding the name field and adding translate=True attr. I've done this in odoo 15 and it worked like a charm but in odoo 17 I encountered this error:
psycopg2.errors.UndefinedFunction: operator does not exist: character varying ->> unknown
LINE 1: ...Y "res_company"."sequence" , "res_company"."name"->>'en_US'...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
The error you're encountering occurs because the name field of res.partner is related to the name field of res.company, and in Odoo 17, the translation mechanism requires the related fields to explicitly support translations as well.
In Odoo 15, this wasn't as strict, but starting from Odoo 17, you need to ensure that any related fields that reference translatable fields also have the translate=True attribute.
In your case, the res.company model has a field like this:
name = fields.Char(related='partner_id.name', string='Company Name', required=True, store=True, readonly=False)
To fix the error, you need to override this field and add the translate=True attribute to it, like so:
name = fields.Char(related='partner_id.name', string='Company Name', required=True, store=True, readonly=False, translate=True)
By doing this, the translation mechanism will apply not only to the name field of res.partner but also to the name field in res.company, which is crucial for avoiding the PostgreSQL error related to the JSON extraction operator (->>). This adjustment ensures that both fields are handled correctly when translations are applied.
I found the solution.
There’s a related field for res.partner's name in res.company:
name = fields.Char(related='partner_id.name', string='Company Name', required=True, store=True, readonly=False)
This field needs to be overridden to include the translate=True attribute, like this:
name = fields.Char(related='partner_id.name', string='Company Name', required=True, store=True, readonly=False, translate=True)
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się| Powiązane posty | Odpowiedzi | Widoki | Czynność | |
|---|---|---|---|---|
|
Adding new rule in search bar
Rozwiązane
|
|
1
wrz 24
|
1516 | |
|
Set is_company to True by default
Rozwiązane
|
|
4
sie 24
|
2331 | |
|
0
gru 24
|
1673 | ||
|
0
lip 24
|
2623 | ||
|
2
lip 24
|
3133 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
