Ir al contenido
Menú
Se marcó esta pregunta
2 Respuestas
1744 Vistas

Hi odoo community I have a problem, this is my model:

from odoo import api, fields, models
class SaleOrderRepli(models.Model):
_inherit = "sale.order"
_name = "sale.order.repli"

but i have this error TypeError: Many2many fields sale.order.repli.transaction_ids and sale.order.transaction_ids use the same table and columns
how can i solve that? I need replicate the sale.order model but need independency in my custom model with the original model (sale.order)

Avatar
Descartar
Mejor respuesta

To resolve the error you're facing regarding the Many2many field in your custom model sale.order.repli, you can use the copy=True attribute when defining the field. This will create a separate table and columns for the Many2many relationship in your custom model. Here's an updated version of your code:

from odoo import api, fields, models

class SaleOrderRepli(models.Model):
_inherit = "sale.order"
_name = "sale.order.repli"

transaction_ids = fields.Many2many('sale.transaction', 'sale_order_repli_transaction_rel', 'order_id', 'transaction_id', copy=True)
In the above code, we added the copy=True attribute to the transaction_ids field definition. This will ensure that a separate table and columns are created for the Many2many relationship in your sale.order.repli model, avoiding conflicts with the same field in the original sale.order model.

After making this change, you should be able to create and use the sale.order.repli model independently without encountering the "TypeError: Many2many fields use the same table and columns" error.

Avatar
Descartar
Mejor respuesta

I had the same issue when inheriting res.partner it got fixed somehow my uninstall my custom module and rerun my code somehow it worked somehow. I dont know exact reason how it got fixed

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
2
nov 21
7548
1
mar 17
7768
2
abr 15
9875
0
mar 15
4862
1
may 25
453