Skip to Content
Menu
This question has been flagged
1 Odpoveď
1866 Zobrazenia

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
Zrušiť
Best Answer

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
Zrušiť

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.

Related Posts Replies Zobrazenia Aktivita
2
aug 23
43321
1
mar 15
10461
1
apr 24
2265
5
aug 23
57560
7
dec 23
26341