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.

관련 게시물	답글	화면
Inheritet Model's field can not be changed over method inheritance model	2 6월 25	4026
Odoo 11 : How to clear an ID field or allow an empty ID field inheritance model odoo11	0 9월 19	3998
Can't inherit base.view_partner_form of res.partner inheritance	4 2월 25	4226
What's the difference between sale_order and sale_order_line? 해결 완료 model	3 11월 24	31710
Include in inherit from JS class inheritance	1 8월 24	2987

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!