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.

Powiązane posty	Odpowiedzi	Widoki
Inheritet Model's field can not be changed over method inheritance model	2 cze 25	3968
Odoo 11 : How to clear an ID field or allow an empty ID field inheritance model odoo11	0 wrz 19	3942
Can't inherit base.view_partner_form of res.partner inheritance	4 lut 25	4134
What's the difference between sale_order and sale_order_line? Rozwiązane model	3 lis 24	31624
Include in inherit from JS class inheritance	1 sie 24	2949

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!