Error in inheritance a model with Many2many field

Question

Hello!
I am trying to create my first custom app in Odoo. The app name is 'fabrica3' with a model below:
class MRPWorkorder(models.Model):​
​_name = 'fabrica3.mrpworkorder'
​_inherit = 'mrp.workorder'
​employee = fields.Many2one('hr.employee')
​name = fields.Char(compute='_get_name', store=True) But when I try to activate this app I receive the message
TypeError: Many2many fields fabrica3.mrpworkorder.blocked_by_workorder_ids and mrp.workorder.blocked_by_workorder_ids use the same table and colu

Chathura Munasinghe · Accepted Answer

*Hello,
Use only _inherit,*
Remove the _name attribute and just extend the existing model. This is the most common approach when you just want to add fields to an existing model.
When you use both _name and _inherit, Odoo creates a new model that tries to use the same table names as the original model.
Many2many fields automatically generate table names based on the model names, causing conflicts.
Hope this helps!

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,

Remove _name = 'fabrica3.mrpworkorder' from your model
Keep only _inherit = 'mrp.workorder'
This way, you're extending the existing mrp.workorder model
The error happens because defining a new model with _name reuses internal Many2many fields incorrectly
Only use _name if you're creating a completely new model (not needed here)
After removing _name, your model will load without the Many2many field conflict

Hope it helps.

Relaterade inlägg	Svar	Vyer
Inheritet Model's field can not be changed over method inheritance model	2 juni 25	5163
Odoo 11 : How to clear an ID field or allow an empty ID field inheritance model odoo11	0 sep. 19	4883
Can't inherit base.view_partner_form of res.partner inheritance	4 feb. 25	6632
What's the difference between sale_order and sale_order_line? Löst model	3 nov. 24	34341
Include in inherit from JS class inheritance	1 aug. 24	4537

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!