Hello Odoo Community,
Please help me solve this error; thanks a lot!
Odoo Server Error
Traceback (most recent call last):
File "C:\Program Files\Odoo 14.0.20220420\server\odoo\addons\base\models\ir_http\\.py",\\ line\\ 237,\\ in\\ _dispatch
\\ \\ \\ \\ result\\ =\\ request\\.dispatch\\(\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\http\\.py",\\ line\\ 696,\\ in\\ dispatch
\\ \\ \\ \\ result\\ =\\ self\\._call_function\\(\\*\\*self\\.params\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\http\\.py",\\ line\\ 370,\\ in\\ _call_function
\\ \\ \\ \\ return\\ checked_call\\(self\\.db,\\ \\*args,\\ \\*\\*kwargs\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\service\model\\.py",\\ line\\ 94,\\ in\\ wrapper
\\ \\ \\ \\ return\\ f\\(dbname,\\ \\*args,\\ \\*\\*kwargs\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\http\\.py",\\ line\\ 358,\\ in\\ checked_call
\\ \\ \\ \\ result\\ =\\ self\\.endpoint\\(\\*a,\\ \\*\\*kw\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\http\\.py",\\ line\\ 919,\\ in\\ __call__
\\ \\ \\ \\ return\\ self\\.method\\(\\*args,\\ \\*\\*kw\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\http\\.py",\\ line\\ 544,\\ in\\ response_wrap
\\ \\ \\ \\ response\\ =\\ f\\(\\*args,\\ \\*\\*kw\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\addons\web\controllers\main\\.py",\\ line\\ 1374,\\ in\\ call_button
\\ \\ \\ \\ action\\ =\\ self\\._call_kw\\(model,\\ method,\\ args,\\ kwargs\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\addons\web\controllers\main\\.py",\\ line\\ 1362,\\ in\\ _call_kw
\\ \\ \\ \\ return\\ call_kw\\(request\\.env\\[model\\],\\ method,\\ args,\\ kwargs\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\api\\.py",\\ line\\ 399,\\ in\\ call_kw
\\ \\ \\ \\ result\\ =\\ _call_kw_multi\\(method,\\ model,\\ args,\\ kwargs\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\api\\.py",\\ line\\ 386,\\ in\\ _call_kw_multi
\\ \\ \\ \\ result\\ =\\ method\\(recs,\\ \\*args,\\ \\*\\*kwargs\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\addons\base\models\res_config\\.py",\\ line\\ 623,\\ in\\ execute
\\ \\ \\ \\ self\\.set_values\\(\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\addons\sale_order_line_by_warehouse_app\models\sale_config_settings\\.py",\\ line\\ 12,\\ in\\ set_values
\\ \\ \\ \\ res\\ =\\ super\\(ResConfigSettings,\\ self\\)\\.set_values\\(\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\addons\product_bundle_pack\models\product\\.py",\\ line\\ 77,\\ in\\ set_values
\\ \\ \\ \\ super\\(ResConfigSettings,\\ self\\)\\.set_values\\(\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\addons\bi_sale_order_merge\models\res_config_settings\\.py",\\ line\\ 25,\\ in\\ set_values
\\ \\ \\ \\ super\\(ResConfigSettings,\\ self\\)\\.set_values\\(\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\addons\sale_management\models\res_config_settings\\.py",\\ line\\ 28,\\ in\\ set_values
\\ \\ \\ \\ return\\ super\\(ResConfigSettings,\\ self\\)\\.set_values\\(\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\addons\sale\models\res_config_settings\\.py",\\ line\\ 67,\\ in\\ set_values
\\ \\ \\ \\ super\\(ResConfigSettings,\\ self\\)\\.set_values\\(\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\addons\dp_purchase_warehouse\models\res_config_settings\\.py",\\ line\\ 21,\\ in\\ set_values
\\ \\ \\ \\ super\\(ResConfigSettings,\\ self\\)\\.set_values\\(\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\addons\cancel_stock_move\models\res_config_settings\\.py",\\ line\\ 20,\\ in\\ set_values
\\ \\ \\ \\ super\\(ResConfigSettings,\\ self\\)\\.set_values\\(\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\addons\purchase\models\res_config_settings\\.py",\\ line\\ 42,\\ in\\ set_values
\\ \\ \\ \\ super\\(ResConfigSettings,\\ self\\)\\.set_values\\(\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\addons\hr_expense\models\res_config_settings\\.py",\\ line\\ 27,\\ in\\ set_values
\\ \\ \\ \\ super\\(ResConfigSettings,\\ self\\)\\.set_values\\(\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\addons\website\models\res_config_settings\\.py",\\ line\\ 144,\\ in\\ set_values
\\ \\ \\ \\ super\\(ResConfigSettings,\\ self\\)\\.set_values\\(\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\addons\stock\models\res_config_settings\\.py",\\ line\\ 74,\\ in\\ set_values
\\ \\ \\ \\ res\\ =\\ super\\(ResConfigSettings,\\ self\\)\\.set_values\\(\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\addons\project\models\res_config_settings\\.py",\\ line\\ 33,\\ in\\ set_values
\\ \\ \\ \\ super\\(ResConfigSettings,\\ self\\)\\.set_values\\(\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\addons\crm\models\res_config_settings\\.py",\\ line\\ 114,\\ in\\ set_values
\\ \\ \\ \\ alias\\.write\\(\\{'alias_name':\\ self\\.crm_alias_prefix\\}\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\addons\mail\models\mail_alias\\.py",\\ line\\ 122,\\ in\\ write
\\ \\ \\ \\ return\\ super\\(Alias,\\ self\\)\\.write\\(vals\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\models\\.py",\\ line\\ 3702,\\ in\\ write
\\ \\ \\ \\ self\\.modified\\(vals\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\models\\.py",\\ line\\ 5839,\\ in\\ modified
\\ \\ \\ \\ for\\ field,\\ records,\\ create\\ in\\ tocompute:
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\models\\.py",\\ line\\ 5908,\\ in\\ _modified_triggers
\\ \\ \\ \\ records\\ \\|=\\ model\\.search\\(\\[\\(key\\.name,\\ 'in',\\ real_records\\.ids\\)\\],\\ order='id'\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\models\\.py",\\ line\\ 1713,\\ in\\ search
\\ \\ \\ \\ return\\ res\\ if\\ count\\ else\\ self\\.browse\\(res\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\models\\.py",\\ line\\ 5004,\\ in\\ browse
\\ \\ \\ \\ if\\ not\\ ids:
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\osv\query\\.py",\\ line\\ 172,\\ in\\ __bool__
\\ \\ \\ \\ return\\ bool\\(self\\._result\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\tools\func\\.py",\\ line\\ 26,\\ in\\ __get__
\\ \\ \\ \\ value\\ =\\ self\\.fget\\(obj\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\osv\query\\.py",\\ line\\ 165,\\ in\\ _result
\\ \\ \\ \ self\\._cr\\.execute\\(query_str,\\ params\\)
\\ \\ File\\ "",\\ line\\ 2,\\ in\\ execute
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\sql_db\\.py",\\ line\\ 101,\\ in\\ check
\\ \\ \\ \\ return\\ f\\(self,\\ \\*args,\\ \\*\\*kwargs\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\sql_db\\.py",\\ line\\ 301,\\ in\\ execute
\\ \\ \\ \\ res\\ =\ self\\._obj\\.execute\\(query,\\ params\\)
Exception
The\\ above\\ exception\\ was\\ the\\ direct\\ cause\\ of\\ the\\ following\\ exception:
Traceback\\ \\(most\\ recent\\ call\\ last\\):
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\http\\.py",\\ line\\ 652,\\ in\\ _handle_exception
\\ \\ \\ \\ return\\ super\\(JsonRequest,\\ self\\)\\._handle_exception\\(exception\\)
\\ \\ File\\ "C:\Program\\ Files\Odoo\\ 14\\.0\\.20220420\server\odoo\http\\.py",\\ line\\ 317,\\ in\\ _handle_exception
\\ \\ \\ \\ raise\\ exception\\.with_traceback\\(None\\)\\ from\\ new_cause
psycopg2.errors.UndefinedTable: Error: Relationship "mail_test_gateway_groups" Not exist
LINE 1: SELECT "mail_test_gateway_groups".id FROM "mail_test_gateway...
^
Elaborate your question like when you get the error ?
What is mail_test_gateway_groups?
Did you create a many2many field in settings ?
I think the error due to many2many declaration is wrong .