Zum Inhalt springen
Menü
Sie müssen registriert sein, um mit der Community zu interagieren.
Diese Frage wurde gekennzeichnet
1 Antworten
1719 Ansichten

i have this new model that inherit the project.project model:

 

class RealEstateProject(models.Model):

    _name = 'real.estate.project.classical'

    _inherit = 'project.project'

    _description = 'Real Estate Projects'

 

after running it appears this problem of many2many fields  :

 

TypeError: Many2many fields real.estate.project.classical.favorite_user_ids and project.project.favorite_user_ids use the same table and columns


i added this field to my new model

 

favorite_user_ids = fields.Many2many(

        'res.users',

        'real_estate_project_favorite_user_rel',

        'project_id',

        'user_id',

        string='Favorite Users'

    )

 

then i have another field 

TypeError: Many2many fields real.estate.project.classical.type_ids and project.project.type_ids use the same table and columns

 

so i add it

 

type_ids = fields.Many2many(

        'project.task.type',

        'real_estate_type_rel', 

        'project_id',

        'type_id',

        string='Types'

    )

 

now after running i have this problem of foreign key:

psycopg2.errors.UndefinedColumn: column "real_estate_project_classical_id" referenced in foreign key constraint does not exist

 

How can i solve this please !!

Avatar
Verwerfen
Beste Antwort

When inherit a model in Odoo, it keeps the existing fields and their definitions, including Many2many fields. This means that if you're trying to define new Many2many fields in your inherited model that share the same database table and columns as those in the original model there will be conflict.

Avatar
Verwerfen

hi, thank you
so what can be the solution

Remove the redefinition of the favorite_user_ids and type_ids fields in your RealEstateProject model.

Verknüpfte Beiträge Antworten Ansichten Aktivität
2
Aug. 23
43078
1
März 15
10344
1
Apr. 24
2128
5
Aug. 23
57372
7
Dez. 23
26217