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.

Post correlati	Risposte	Visualizzazioni
Inheritet Model's field can not be changed over method inheritance model	2 giu 25	5161
Odoo 11 : How to clear an ID field or allow an empty ID field inheritance model odoo11	0 set 19	4881
Can't inherit base.view_partner_form of res.partner inheritance	4 feb 25	6618
What's the difference between sale_order and sale_order_line? Risolto model	3 nov 24	34335
Include in inherit from JS class inheritance	1 ago 24	4534

La domanda è stata contrassegnata

Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!