Skip to Content
This question has been flagged
urgentodooV12
4 Replies
12400 डेटा देखने का तरीका
अवतार
Ramla

Hi

class AnimaleSouche(models.Model):
    _name = 'animale.souche'
    _description ="Les souches des animaux"

    name = fields.Char(string='Nom de la souche', required=True)
    image = fields.Binary(string='Image')
    description = fields.Char(string='Description')
programme_norme = fields.Many2many('animale.programme.norme', 'animale.souche', string='Programme de norme', ondelete='cascade', required=True)
    programme_production = fields.Many2many('animale.programme.production', 'animale.souche', string='Programme de production', ondelete='cascade', required=True)
अवतार
खारिज करें
Mitul Shingala

you want many2many of same model or different model.

Ramla
लेखक

same model

अवतार
Mitul Shingala
Best Answer

Hello

for given many2many of same model you have to pass the table/relationship table name into the definition of the field.

for eg

partner_ids1 = fields.Many2many('res.partner', 'relation_table_one', 'col1', 'col2', string="Line1")
partner_ids2 = fields.Many2many('res.partner', 'relation_table_two', 'col1', 'col2', 'string="Line2") 
try like this, may this will helps you.

अवतार
खारिज करें
Ramla
लेखक

Hi,

programme_norme = fields.Many2many('animale.souche', 'animale.programme.norme', 'animale_souche_id', 'animale_programme_norme_id', string='Programme de norme')

programme_production = fields.Many2many('animale.souche', 'animale.programme.production', 'animale_souche_id', 'animale_programme_production_id', string='Programme de production')

Erreur:

Odoo Server Error

Traceback (most recent call last):

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 654, in _handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 312, in _handle_exception

raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\pycompat.py", line 87, in reraise

raise value

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 696, in dispatch

result = self._call_function(**self.params)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 344, in _call_function

return checked_call(self.db, *args, **kwargs)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\service\model.py", line 97, in wrapper

return f(dbname, *args, **kwargs)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 337, in checked_call

result = self.endpoint(*a, **kw)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 939, in __call__

return self.method(*args, **kw)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 517, in response_wrap

response = f(*args, **kw)

File "c:\program files (x86)\odoo 12.0\server\odoo\addons\web\controllers\main.py", line 966, in call_button

action = self._call_kw(model, method, args, {})

File "c:\program files (x86)\odoo 12.0\server\odoo\addons\web\controllers\main.py", line 954, in _call_kw

return call_kw(request.env[model], method, args, kwargs)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 749, in call_kw

return _call_kw_multi(method, model, args, kwargs)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 736, in _call_kw_multi

result = method(recs, *args, **kwargs)

File "<decorator-gen-67>", line 2, in button_immediate_upgrade

File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_module.py", line 73, in check_and_log

return method(self, *args, **kwargs)

File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_module.py", line 614, in button_immediate_upgrade

return self._button_immediate_function(type(self).button_upgrade)

File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_module.py", line 553, in _button_immediate_function

modules.registry.Registry.new(self._cr.dbname, update_module=True)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\modules\registry.py", line 86, in new

odoo.modules.load_modules(registry._db, force_demo, status, update_module)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\modules\loading.py", line 417, in load_modules

force, status, report, loaded_modules, update_module, models_to_check)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\modules\loading.py", line 313, in load_marked_modules

perform_checks=perform_checks, models_to_check=models_to_check

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\modules\loading.py", line 195, in load_module_graph

registry.init_models(cr, model_names, {'module': package.name})

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\modules\registry.py", line 301, in init_models

func()

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 2629, in update_db_foreign_keys

sql.add_foreign_key(cr, self.relation, self.column2, comodel._table, 'id', 'cascade')

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\sql.py", line 158, in add_foreign_key

cr.execute(query.format(tablename1, columnname1, tablename2, columnname2, ondelete))

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\sql_db.py", line 148, in wrapper

return f(self, *args, **kwargs)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\sql_db.py", line 225, in execute

res = self._obj.execute(query, params)

psycopg2.ProgrammingError: ERREUR: la relation « _unknown » n'existe pas

Mitul Shingala

programme_production = fields.Many2many('animale.souche', 'animale_programme_production', 'animale_souche_id', 'animale_programme_production_id', string='Programme de production')

give the relation name with underscore. and make sure that the name is not exist into the system. so give the name like "table_rel_animale_programme_production"

Ramla
लेखक

sorry, I'm not understand

Ramla
लेखक

can you give me an example

Mitul Shingala

see my above answer, i have make the text bold.

for make the many2many of same model you need to give the relationship table name. in example i have given like "relation_table_one".

Ramla
लेखक

programme_norme_ids = fields.Many2many('animale.programme.norme', 'animale_programme_norme_animale_souche_rel', 'animale_souche_id', 'animale_programme_norme_id', string='Programmes de norme')

programme_production_ids = fields.Many2many('animale.programme.production', 'animale_programme_production_animale_souche_rel', 'animale_souche_id', 'animale_programme_production_id', string='Programmes de production')

"programme_production_ids" works but "programme_norme_ids" no

Ramla
लेखक

Erreur:

Odoo Server Error

Traceback (most recent call last):

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 654, in _handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 312, in _handle_exception

raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\pycompat.py", line 87, in reraise

raise value

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 696, in dispatch

result = self._call_function(**self.params)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 344, in _call_function

return checked_call(self.db, *args, **kwargs)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\service\model.py", line 97, in wrapper

return f(dbname, *args, **kwargs)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 337, in checked_call

result = self.endpoint(*a, **kw)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 939, in __call__

return self.method(*args, **kw)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 517, in response_wrap

response = f(*args, **kw)

File "c:\program files (x86)\odoo 12.0\server\odoo\addons\web\controllers\main.py", line 966, in call_button

action = self._call_kw(model, method, args, {})

File "c:\program files (x86)\odoo 12.0\server\odoo\addons\web\controllers\main.py", line 954, in _call_kw

return call_kw(request.env[model], method, args, kwargs)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 749, in call_kw

return _call_kw_multi(method, model, args, kwargs)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 736, in _call_kw_multi

result = method(recs, *args, **kwargs)

File "<decorator-gen-67>", line 2, in button_immediate_upgrade

File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_module.py", line 73, in check_and_log

return method(self, *args, **kwargs)

File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_module.py", line 614, in button_immediate_upgrade

return self._button_immediate_function(type(self).button_upgrade)

File "c:\program files (x86)\odoo 12.0\server\odoo\addons\base\models\ir_module.py", line 553, in _button_immediate_function

modules.registry.Registry.new(self._cr.dbname, update_module=True)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\modules\registry.py", line 86, in new

odoo.modules.load_modules(registry._db, force_demo, status, update_module)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\modules\loading.py", line 417, in load_modules

force, status, report, loaded_modules, update_module, models_to_check)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\modules\loading.py", line 313, in load_marked_modules

perform_checks=perform_checks, models_to_check=models_to_check

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\modules\loading.py", line 195, in load_module_graph

registry.init_models(cr, model_names, {'module': package.name})

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\modules\registry.py", line 301, in init_models

func()

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 2629, in update_db_foreign_keys

sql.add_foreign_key(cr, self.relation, self.column2, comodel._table, 'id', 'cascade')

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\tools\sql.py", line 158, in add_foreign_key

cr.execute(query.format(tablename1, columnname1, tablename2, columnname2, ondelete))

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\sql_db.py", line 148, in wrapper

return f(self, *args, **kwargs)

File "C:\Program Files (x86)\Odoo 12.0\server\odoo\sql_db.py", line 225, in execute

res = self._obj.execute(query, params)

psycopg2.ProgrammingError: ERREUR: la relation « _unknown » n'existe pas

अवतार
TenthPlanet Technologies Pvt Ltd, Subbarao Singalla
Best Answer

Hi Ramla,

please read the many2many field declaration syntax 

https://www.odoo.com/documentation/12.0/reference/orm.html#odoo.fields.Many2many

अवतार
खारिज करें
Related Posts Replies डेटा देखने का तरीका ऐक्टिविटी
Problem to add a new attribute in model Odoo Community Version 12
urgent odooV12
अवतार
अवतार
1
मार्च 19
5247
How to give access rights? Odoo Community Version 12
security urgent odooV12
अवतार
अवतार
1
अप्रैल 19
10102
How to display the name of the record in relation Many2many Odoo Community Version 12 (Tree View) Solved
urgent many2many odooV12
अवतार
अवतार
3
मार्च 19
10443
install odoo17
urgent
अवतार
अवतार
अवतार
2
नव॰ 25
4272
Hello everyone, sorry for the inconvenience, is it possible to import a password-protected Excel file into Odoo? Solved
urgent
अवतार
अवतार
1
जुल॰ 24
3399