Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
i want to make a relation betewen my wizard and purchase requisition and comes that error
class reporteadorcompraswizard(models.TransientModel):
_name = 'reporteadorcompraswizard'
requisiciones_ids = fields.Many2many('purchase_requisition.purchase.requisition', string='Requisiciones')
xml:
<field name="requisiciones_ids" widget="many2many_tags"
options="{'no_quick_create':True,'no_create_edit':True,'no_open': True}"/>
why is this error? if i use purchase.order doesn't pop the error
Hi,
The error "psycopg2.ProgrammingError: no existe la relación «_unknown»" when creating a many2many relationship in Odoo usually means the database table you're trying to access doesn't exist or isn't accessible. This can happen due to an incorrect model name, a missing or incorrectly created many2many relational table, database synchronization issues after module updates, or insufficient user permissions.
To fix this, first, ensure the model name in your Many2many field definition is absolutely correct and matches the _name attribute of the target model. Then, update your module to apply the changes to the database. If the issue persists, check if the relational table has been created correctly in the database. If not, try manually updating the database schema using the command line. Finally, verify that the user has the necessary access rights to both models involved in the relationship.
Hope it helps
this error pops
KeyError: 'purchase.requisition'
the target is purchase_requisition
i change
requisiciones_ids = fields.Many2many(
'purchase.requisition',
'reporteador_requisition_rel',
'wizard_id',
'requisition_id',
string='Requisiciones'
)
and pops KeyError: 'purchase.requisition'
i change for :
requisiciones_ids = fields.Many2many(
'purchase_requisition.purchase.requisition',
'reporteador_requisition_rel',
'wizard_id',
'requisition_id',
string='Requisiciones'
)
and pops same error psycopg2.ProgrammingError: no existe la relación «_unknown»
Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !
S'inscrire| Publications associées | Réponses | Vues | Activité | |
|---|---|---|---|---|
|
3
nov. 23
|
18589 | ||
|
3
nov. 24
|
26739 | ||
|
1
avr. 23
|
7045 | ||
|
2
déc. 22
|
7931 | ||
|
1
nov. 22
|
5017 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
It is due to wrong relation with the model
Try with this:
requisiciones_ids = fields.Many2many(
Hope it helps..
What is the target model name like sale.order, purchase.order etc.?
Can you please check dependency in manifest file and also ensure that the purchase.requisition is installed in your database?
if i write in the manifest from purchase
'depends': ['account', 'purchase_requisition'],
in the update module disappears and cant update
and in my data base yes it is the table and the model we have a lot of requisition captured
iwant in my wizard slect some requisitions and printed in an excel file that's all i need to do a compartive of prices from all purchases ordres form that reqisitions that uses selects
So the issue I understand is that if you don't put the purchase_requisition model and trying to declare m2m field for that and upgrade the module, you faced a key error, righ?
And if you add the model in dependency then you can't able to see your custom module, right?
Please confirm these things...
if i add the model in dependency
when i reset the service from odoo and i want to upgrade the module the upgrade option dissapear
in this wizard i have project, respartner, and i dont have added any dependency i don know only this module of purchase_requisition is giving me headache it is wiched!!!
Have you confirmed that your custom module is successfully installed? or can you provide the screenshot of the traceback if it is possible?
i dont understand what is a traceback?
Copy whole error which you have faced in Odoo.
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 656, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 314, 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 698, in dispatch
result = self._call_function(**self.params)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 346, 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 339, in checked_call
result = self.endpoint(*a, **kw)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 941, in __call__
return self.method(*args, **kw)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 519, 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 74, 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 622, 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 561, 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 296, in init_models
model._auto_init()
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\models.py", line 2412, in _auto_init
new = field.update_db(self, columns)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\fields.py", line 2627, in update_db
comodel = model.env[self.comodel_name]
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\api.py", line 821, in __getitem__
return self.registry[model_name]._browse((), self)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\modules\registry.py", line 176, in __getitem__
return self.models[model_name]
KeyError: 'purchase.requisition'
Based on information you provided, something is missing, but currently it is not figure out. Please wait for some time if anyone has able to solve this.
Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 656, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 314, 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 698, in dispatch
result = self._call_function(**self.params)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 346, 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 339, in checked_call
result = self.endpoint(*a, **kw)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 941, in __call__
return self.method(*args, **kw)
File "C:\Program Files (x86)\Odoo 12.0\server\odoo\http.py", line 519, 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 74, 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 622, 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 561, 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 2651, 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: no existe la relación «_unknown»
i did everything you wrote and nothing, y tried to do in any module in odoo and still same message error
Ok then for a test purpose restart the Odoo service and try with a fresh database..
i already did and nothing
i was thinking my last resourse it will be to create a new table were a pass all id, and name from requistion and when i create a new one stored the new one in taht table maybe that table doesnt show any errors, its maybe stupid but its all i can think, im too tired to try a solution of this i have 4 days with any result
it woked for me
create a new table with the principals fields i need, after that i imported all data to the new table with a query
and when a new requisition its created i will be created in the new table too, it worked, thanks a lot for the help in resume the table purchase.requisition it is witched!!!!! or maybe bad made it the think i noticed is that purchase and purchase_requisition doesnt have any dependency but if you compilated purchase it also compilated purchase_requistion why? i dont know ..... thanks a lot