Hi.
Im leaving odoo sh and we are setting up our own cluster
I have installed odoo 15 EE and i have a backup of my odoo sh database 15 EE.
i restore to my server the restoration goest all the way to the end but when i navigate to the url i get Internal Server Error and the following error (Note that all custom apps are in the correct directory in the new server):
Here is the error in odoo-server.log
023-06-22 16:46:47,492 1176 INFO ? odoo.http: HTTP Configuring static files
2023-06-22 16:46:47,506 1176 INFO sandbox1 odoo\.modules\.loading:\ loading\ 1\ modules\.\.\.
2023\-06\-22\ 16:46:47,516\ 1176\ INFO\ sandbox1\ odoo\.modules\.loading:\ 1\ modules\ loaded\ in\ 0\.01s,\ 0\ queries\ \(\+0\ extra\)
2023\-06\-22\ 16:46:47,583\ 1176\ INFO\ sandbox1\ odoo\.modules\.loading:\ loading\ 225\ modules\.\.\.
2023\-06\-22\ 16:46:47,604\ 1176\ WARNING\ sandbox1\ odoo\.addons\.attachment_indexation\.models\.ir_attachment:\ Attachment\ indexation\ of\ PDF\ documents\ is\ unavailable\ because\ the\ 'pdfminer'\ Python\ library\ cannot\ be\ found\ on\ the\ system\.\ You\ may\ install\ it\ from\ https://pypi\.org/project/pdfminer\.six/\ \(e\.g\.\ `pip3\ install\ pdfminer\.six`\)
2023\-06\-22\ 16:46:48,532\ 1176\ WARNING\ sandbox1\ odoo\.models:\ The\ model\ report\.wcgsh_stock_barcode\.report_scanned_product_barcode\ has\ no\ _description
2023\-06\-22\ 16:46:49,004\ 1176\ INFO\ sandbox1\ odoo\.modules\.loading:\ 225\ modules\ loaded\ in\ 1\.42s,\ 0\ queries\ \(\+0\ extra\)
2023\-06\-22\ 16:46:49,394\ 1176\ WARNING\ sandbox1\ odoo\.fields:\ Field\ sale\.order\.line\.x_studio_related_field_vvkU6:\ unknown\ parameter\ 'tracking',\ if\ this\ is\ an\ actual\ parameter\ you\ may\ want\ to\ override\ the\ method\ _valid_field_parameter\ on\ the\ relevant\ model\ in\ order\ to\ allow\ it
2023\-06\-22\ 16:46:49,746\ 1176\ INFO\ sandbox1\ odoo\.modules\.loading:\ Modules\ loaded\.
2023\-06\-22\ 16:46:49,792\ 1176\ INFO\ sandbox1\ odoo\.modules\.registry:\ Registry\ loaded\ in\ 2\.296s
2023\-06\-22\ 16:46:49,793\ 1176\ INFO\ sandbox1\ odoo\.addons\.base\.models\.ir_http:\ Generating\ routing\ map\ for\ key\ None
2023\-06\-22\ 16:46:50,739\ 1176\ ERROR\ sandbox1\ odoo\.sql_db:\ bad\ query:\ SELECT\ "ir_attachment"\.id\ FROM\ "ir_attachment"\ WHERE\ \(\("ir_attachment"\."res_field"\ IS\ NULL\ \ AND\ \(unaccent\("ir_attachment"\."url"::text\)\ like\ unaccent\('/web/assets/%\-%/web\.assets_common\.min\.css'\)\)\)\ AND\ \(NOT\ \(\(unaccent\("ir_attachment"\."url"::text\)\ like\ unaccent\('/web/assets/%\-d1f27ed/%%%'\)\)\)\)\)\ ORDER\ BY\ \ "ir_attachment"\."id"\ DESC
ERROR:\ function\ unaccent_schema\.unaccent\(unknown,\ text\)\ does\ not\ exist
LINE\ 2:\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ SELECT\ unaccent_schema\.unaccent\('unaccent_sc\.\.\.
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \^
HINT:\ \ No\ function\ matches\ the\ given\ name\ and\ argument\ types\.\ You\ might\ need\ to\ add\ explicit\ type\ casts\.
QUERY:
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ SELECT\ unaccent_schema\.unaccent\('unaccent_schema\.unaccent',\ \$1\)
CONTEXT:\ \ SQL\ function\ "unaccent"\ during\ inlining
2023\-06\-22\ 16:46:50,740\ 1176\ ERROR\ sandbox1\ odoo\.sql_db:\ bad\ query:\ SELECT\ "ir_ui_view"\.id\ FROM\ "ir_ui_view"\ WHERE\ \(\("ir_ui_view"\."active"\ =\ true\)\ AND\ \("ir_ui_view"\."key"\ =\ 'web\.frontend_layout'\)\)\ ORDER\ BY\ \ "ir_ui_view"\."priority"\ ,"ir_ui_view"\."name"\ ,"ir_ui_view"\."id"\ \ \ LIMIT\ 1
ERROR:\ current\ transaction\ is\ aborted,\ commands\ ignored\ until\ end\ of\ transaction\ block
2023\-06\-22\ 16:46:50,995\ 1176\ INFO\ sandbox1\ werkzeug:\ 69\.21\.230\.116\ \-\ \-\ \[22/Jun/2023\ 16:46:50\]\ "GET\ /web/login\ HTTP/1\.0"\ 500\ \-\ 504\ 0\.120\ 3\.379
2023\-06\-22\ 16:46:51,015\ 1176\ ERROR\ sandbox1\ werkzeug:\ Error\ on\ request:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/cache\.py",\ line\ 85,\ in\ lookup
\ \ \ \ r\ =\ d\[key\]
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/func\.py",\ line\ 71,\ in\ wrapper
\ \ \ \ return\ func\(self,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/lru\.py",\ line\ 34,\ in\ __getitem__
\ \ \ \ a\ =\ self\.d\[obj\]
KeyError:\ \('ir\.qweb',\ ,\ 'web\.assets_common',\ True,\ False,\ '',\ False,\ False,\ False,\ \(None,\ 'en_US'\)\)
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 219,\ in\ render_template
\ \ \ \ yield\ from\ compiled_fn\(self,\ values,\ log\)
\ \ File\ "",\ line\ 43,\ in\ template_186
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 246,\ in\ _get_asset_nodes
\ \ \ \ return\ self\._generate_asset_nodes_cache\(bundle,\ css,\ js,\ debug,\ async_load,\ defer_load,\ lazy_load,\ media\)
\ \ File\ "",\ line\ 2,\ in\ _generate_asset_nodes_cache
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/cache\.py",\ line\ 90,\ in\ lookup
\ \ \ \ value\ =\ d\[key\]\ =\ self\.method\(\*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 255,\ in\ _generate_asset_nodes_cache
\ \ \ \ return\ self\._generate_asset_nodes\(bundle,\ css,\ js,\ debug,\ async_load,\ defer_load,\ lazy_load,\ media\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 266,\ in\ _generate_asset_nodes
\ \ \ \ return\ remains\ \+\ asset\.to_node\(css=css,\ js=js,\ debug=debug,\ async_load=async_load,\ defer_load=defer_load,\ lazy_load=lazy_load\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/assetsbundle\.py",\ line\ 147,\ in\ to_node
\ \ \ \ css_attachments\ =\ self\.css\(is_minified=not\ is_debug_assets\)\ or\ \[\]
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/assetsbundle\.py",\ line\ 435,\ in\ css
\ \ \ \ self\.save_attachment\(extension,\ css\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/assetsbundle\.py",\ line\ 354,\ in\ save_attachment
\ \ \ \ self\.clean_attachments\(extension\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/assetsbundle\.py",\ line\ 261,\ in\ clean_attachments
\ \ \ \ attachments\ =\ ira\.sudo\(\)\.search\(domain\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 1811,\ in\ search
\ \ \ \ return\ res\ if\ count\ else\ self\.browse\(res\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 5176,\ in\ browse
\ \ \ \ if\ not\ ids:
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 215,\ in\ __bool__
\ \ \ \ return\ bool\(self\._result\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/func\.py",\ line\ 26,\ in\ __get__
\ \ \ \ value\ =\ self\.fget\(obj\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 208,\ in\ _result
\ \ \ \ self\._cr\.execute\(query_str,\ params\)
\ \ File\ "",\ line\ 2,\ in\ execute
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 90,\ in\ check
\ \ \ \ return\ f\(self,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 311,\ in\ execute
\ \ \ \ res\ =\ self\._obj\.execute\(query,\ params\)
psycopg2\.errors\.UndefinedFunction:\ function\ unaccent_schema\.unaccent\(unknown,\ text\)\ does\ not\ exist
LINE\ 2:\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ SELECT\ unaccent_schema\.unaccent\('unaccent_sc\.\.\.
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \^
HINT:\ \ No\ function\ matches\ the\ given\ name\ and\ argument\ types\.\ You\ might\ need\ to\ add\ explicit\ type\ casts\.
QUERY:
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ SELECT\ unaccent_schema\.unaccent\('unaccent_schema\.unaccent',\ \$1\)
CONTEXT:\ \ SQL\ function\ "unaccent"\ during\ inlining
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 246,\ in\ _get_template
\ \ \ \ loaded\ =\ options\.get\('load',\ self\._load\)\(template,\ options\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 136,\ in\ _load
\ \ \ \ view_id\ =\ self\.env\['ir\.ui\.view'\]\.get_view_id\(name\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_ui_view\.py",\ line\ 1880,\ in\ get_view_id
\ \ \ \ view\ =\ self\.sudo\(\)\.search\(\[\('key',\ '=',\ template\)\],\ limit=1\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 1811,\ in\ search
\ \ \ \ return\ res\ if\ count\ else\ self\.browse\(res\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 5176,\ in\ browse
\ \ \ \ if\ not\ ids:
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 215,\ in\ __bool__
\ \ \ \ return\ bool\(self\._result\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/func\.py",\ line\ 26,\ in\ __get__
\ \ \ \ value\ =\ self\.fget\(obj\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 208,\ in\ _result
\ \ \ \ self\._cr\.execute\(query_str,\ params\)
\ \ File\ "",\ line\ 2,\ in\ execute
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 90,\ in\ check
\ \ \ \ return\ f\(self,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 311,\ in\ execute
\ \ \ \ res\ =\ self\._obj\.execute\(query,\ params\)
psycopg2\.errors\.InFailedSqlTransaction:\ current\ transaction\ is\ aborted,\ commands\ ignored\ until\ end\ of\ transaction\ block
The\ above\ exception\ was\ the\ direct\ cause\ of\ the\ following\ exception:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_http\.py",\ line\ 237,\ in\ _dispatch
\ \ \ \ result\ =\ request\.dispatch\(\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/http\.py",\ line\ 815,\ in\ dispatch
\ \ \ \ r\ =\ self\._call_function\(\*\*self\.params\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/http\.py",\ line\ 368,\ in\ _call_function
\ \ \ \ return\ checked_call\(self\.db,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/service/model\.py",\ line\ 94,\ in\ wrapper
\ \ \ \ return\ f\(dbname,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/http\.py",\ line\ 360,\ in\ checked_call
\ \ \ \ result\.flatten\(\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/http\.py",\ line\ 1241,\ in\ flatten
\ \ \ \ self\.response\.append\(self\.render\(\)\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/http\.py",\ line\ 1234,\ in\ render
\ \ \ \ return\ env\["ir\.ui\.view"\]\._render_template\(self\.template,\ self\.qcontext\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_ui_view\.py",\ line\ 1992,\ in\ _render_template
\ \ \ \ return\ self\.browse\(self\.get_view_id\(template\)\)\._render\(values,\ engine\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/web_editor/models/ir_ui_view\.py",\ line\ 29,\ in\ _render
\ \ \ \ return\ super\(IrUiView,\ self\)\._render\(values=values,\ engine=engine,\ minimal_qcontext=minimal_qcontext\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_ui_view\.py",\ line\ 2000,\ in\ _render
\ \ \ \ return\ self\.env\[engine\]\._render\(self\.id,\ qcontext\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/web_studio/models/ir_qweb\.py",\ line\ 47,\ in\ _render
\ \ \ \ return\ super\(IrQWeb,\ self\)\._render\(template,\ values=values,\ \*\*options\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/profiler\.py",\ line\ 292,\ in\ _tracked_method_render
\ \ \ \ return\ method_render\(self,\ template,\ values,\ \*\*options\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 76,\ in\ _render
\ \ \ \ result\ =\ super\(\)\._render\(template,\ values=values,\ \*\*compile_options\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 134,\ in\ _render
\ \ \ \ result\ =\ ''\.join\(rendering\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 221,\ in\ render_template
\ \ \ \ raise\ e
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 219,\ in\ render_template
\ \ \ \ yield\ from\ compiled_fn\(self,\ values,\ log\)
\ \ File\ "",\ line\ 171,\ in\ template_190
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 221,\ in\ render_template
\ \ \ \ raise\ e
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 219,\ in\ render_template
\ \ \ \ yield\ from\ compiled_fn\(self,\ values,\ log\)
\ \ File\ "",\ line\ 76,\ in\ template_189
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 223,\ in\ render_template
\ \ \ \ raise\ QWebException\("Error\ when\ render\ the\ template",\ self,\ options,
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 45,\ in\ __init__
\ \ \ \ element\ =\ qweb\._get_template\(template,\ options\)\[0\]
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/web_studio/models/ir_qweb\.py",\ line\ 22,\ in\ _get_template
\ \ \ \ element,\ document,\ ref\ =\ super\(IrQWeb,\ self\)\._get_template\(template,\ options\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 254,\ in\ _get_template
\ \ \ \ raise\ QWebException\("load\ could\ not\ load\ template",\ self,\ options,\ e,\ template\)
Exception
The\ above\ exception\ was\ the\ direct\ cause\ of\ the\ following\ exception:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/werkzeug/serving\.py",\ line\ 306,\ in\ run_wsgi
\ \ \ \ execute\(self\.server\.app\)
\ \ File\ "/usr/lib/python3/dist\-packages/werkzeug/serving\.py",\ line\ 294,\ in\ execute
\ \ \ \ application_iter\ =\ app\(environ,\ start_response\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/service/wsgi_server\.py",\ line\ 110,\ in\ application
\ \ \ \ return\ ProxyFix\(application_unproxied\)\(environ,\ start_response\)
\ \ File\ "/usr/lib/python3/dist\-packages/werkzeug/middleware/proxy_fix\.py",\ line\ 232,\ in\ __call__
\ \ \ \ return\ self\.app\(environ,\ start_response\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/service/wsgi_server\.py",\ line\ 87,\ in\ application_unproxied
\ \ \ \ result\ =\ odoo\.http\.root\(environ,\ start_response\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/http\.py",\ line\ 1305,\ in\ __call__
\ \ \ \ return\ self\.dispatch\(environ,\ start_response\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/http\.py",\ line\ 1271,\ in\ __call__
\ \ \ \ return\ self\.app\(environ,\ start_wrapped\)
\ \ File\ "/usr/lib/python3/dist\-packages/werkzeug/middleware/shared_data\.py",\ line\ 220,\ in\ __call__
\ \ \ \ return\ self\.app\(environ,\ start_response\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/http\.py",\ line\ 1500,\ in\ dispatch
\ \ \ \ result\ =\ ir_http\._dispatch\(\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/auth_signup/models/ir_http\.py",\ line\ 19,\ in\ _dispatch
\ \ \ \ return\ super\(Http,\ cls\)\._dispatch\(\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/web_editor/models/ir_http\.py",\ line\ 21,\ in\ _dispatch
\ \ \ \ return\ super\(IrHttp,\ cls\)\._dispatch\(\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/utm/models/ir_http\.py",\ line\ 29,\ in\ _dispatch
\ \ \ \ response\ =\ super\(IrHttp,\ cls\)\._dispatch\(\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/http_routing/models/ir_http\.py",\ line\ 519,\ in\ _dispatch
\ \ \ \ result\ =\ super\(IrHttp,\ cls\)\._dispatch\(\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_http\.py",\ line\ 241,\ in\ _dispatch
\ \ \ \ return\ cls\._handle_exception\(e\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/utm/models/ir_http\.py",\ line\ 34,\ in\ _handle_exception
\ \ \ \ response\ =\ super\(IrHttp,\ cls\)\._handle_exception\(exc\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/http_routing/models/ir_http\.py",\ line\ 620,\ in\ _handle_exception
\ \ \ \ return\ super\(IrHttp,\ cls\)\._handle_exception\(exception\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_http\.py",\ line\ 209,\ in\ _handle_exception
\ \ \ \ return\ request\._handle_exception\(exception\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/http\.py",\ line\ 759,\ in\ _handle_exception
\ \ \ \ return\ super\(HttpRequest,\ self\)\._handle_exception\(exception\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/http\.py",\ line\ 301,\ in\ _handle_exception
\ \ \ \ raise\ exception\.with_traceback\(None\)\ from\ new_cause
odoo\.addons\.base\.models\.qweb\.QWebException:\ current\ transaction\ is\ aborted,\ commands\ ignored\ until\ end\ of\ transaction\ block
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/cache\.py",\ line\ 85,\ in\ lookup
\ \ \ \ r\ =\ d\[key\]
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/func\.py",\ line\ 71,\ in\ wrapper
\ \ \ \ return\ func\(self,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/lru\.py",\ line\ 34,\ in\ __getitem__
\ \ \ \ a\ =\ self\.d\[obj\]
KeyError:\ \('ir\.qweb',\ ,\ 'web\.assets_common',\ True,\ False,\ '',\ False,\ False,\ False,\ \(None,\ 'en_US'\)\)
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 219,\ in\ render_template
\ \ \ \ yield\ from\ compiled_fn\(self,\ values,\ log\)
\ \ File\ "",\ line\ 43,\ in\ template_186
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 246,\ in\ _get_asset_nodes
\ \ \ \ return\ self\._generate_asset_nodes_cache\(bundle,\ css,\ js,\ debug,\ async_load,\ defer_load,\ lazy_load,\ media\)
\ \ File\ "",\ line\ 2,\ in\ _generate_asset_nodes_cache
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/cache\.py",\ line\ 90,\ in\ lookup
\ \ \ \ value\ =\ d\[key\]\ =\ self\.method\(\*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 255,\ in\ _generate_asset_nodes_cache
\ \ \ \ return\ self\._generate_asset_nodes\(bundle,\ css,\ js,\ debug,\ async_load,\ defer_load,\ lazy_load,\ media\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 266,\ in\ _generate_asset_nodes
\ \ \ \ return\ remains\ \+\ asset\.to_node\(css=css,\ js=js,\ debug=debug,\ async_load=async_load,\ defer_load=defer_load,\ lazy_load=lazy_load\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/assetsbundle\.py",\ line\ 147,\ in\ to_node
\ \ \ \ css_attachments\ =\ self\.css\(is_minified=not\ is_debug_assets\)\ or\ \[\]
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/assetsbundle\.py",\ line\ 435,\ in\ css
\ \ \ \ self\.save_attachment\(extension,\ css\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/assetsbundle\.py",\ line\ 354,\ in\ save_attachment
\ \ \ \ self\.clean_attachments\(extension\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/assetsbundle\.py",\ line\ 261,\ in\ clean_attachments
\ \ \ \ attachments\ =\ ira\.sudo\(\)\.search\(domain\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 1811,\ in\ search
\ \ \ \ return\ res\ if\ count\ else\ self\.browse\(res\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 5176,\ in\ browse
\ \ \ \ if\ not\ ids:
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 215,\ in\ __bool__
\ \ \ \ return\ bool\(self\._result\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/func\.py",\ line\ 26,\ in\ __get__
\ \ \ \ value\ =\ self\.fget\(obj\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 208,\ in\ _result
\ \ \ \ self\._cr\.execute\(query_str,\ params\)
\ \ File\ "",\ line\ 2,\ in\ execute
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 90,\ in\ check
\ \ \ \ return\ f\(self,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 311,\ in\ execute
\ \ \ \ res\ =\ self\._obj\.execute\(query,\ params\)
psycopg2\.errors\.UndefinedFunction:\ function\ unaccent_schema\.unaccent\(unknown,\ text\)\ does\ not\ exist
LINE\ 2:\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ SELECT\ unaccent_schema\.unaccent\('unaccent_sc\.\.\.
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \^
HINT:\ \ No\ function\ matches\ the\ given\ name\ and\ argument\ types\.\ You\ might\ need\ to\ add\ explicit\ type\ casts\.
QUERY:
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ SELECT\ unaccent_schema\.unaccent\('unaccent_schema\.unaccent',\ \$1\)
CONTEXT:\ \ SQL\ function\ "unaccent"\ during\ inlining
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 246,\ in\ _get_template
\ \ \ \ loaded\ =\ options\.get\('load',\ self\._load\)\(template,\ options\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 136,\ in\ _load
\ \ \ \ view_id\ =\ self\.env\['ir\.ui\.view'\]\.get_view_id\(name\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_ui_view\.py",\ line\ 1880,\ in\ get_view_id
\ \ \ \ view\ =\ self\.sudo\(\)\.search\(\[\('key',\ '=',\ template\)\],\ limit=1\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 1811,\ in\ search
\ \ \ \ return\ res\ if\ count\ else\ self\.browse\(res\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 5176,\ in\ browse
\ \ \ \ if\ not\ ids:
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 215,\ in\ __bool__
\ \ \ \ return\ bool\(self\._result\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/func\.py",\ line\ 26,\ in\ __get__
\ \ \ \ value\ =\ self\.fget\(obj\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 208,\ in\ _result
\ \ \ \ self\._cr\.execute\(query_str,\ params\)
\ \ File\ "",\ line\ 2,\ in\ execute
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 90,\ in\ check
\ \ \ \ return\ f\(self,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 311,\ in\ execute
\ \ \ \ res\ =\ self\._obj\.execute\(query,\ params\)
psycopg2\.errors\.InFailedSqlTransaction:\ current\ transaction\ is\ aborted,\ commands\ ignored\ until\ end\ of\ transaction\ block
load\ could\ not\ load\ template
InFailedSqlTransaction:\ current\ transaction\ is\ aborted,\ commands\ ignored\ until\ end\ of\ transaction\ block
Template:\ web\.login_layout\ \-\ \-\ \-
2023\-06\-22\ 16:46:51,201\ 1176\ INFO\ sandbox1\ odoo\.addons\.base\.models\.ir_attachment:\ _read_file\ reading\ /var/lib/odoo/\.local/share/Odoo/filestore/sandbox1/23/23fe89f51c8121f053a697a3dd79106f25aeeb52
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/cache\.py",\ line\ 85,\ in\ lookup
\ \ \ \ r\ =\ d\[key\]
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/func\.py",\ line\ 71,\ in\ wrapper
\ \ \ \ return\ func\(self,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/lru\.py",\ line\ 34,\ in\ __getitem__
\ \ \ \ a\ =\ self\.d\[obj\]
KeyError:\ \('res\.lang',\ \)
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/api\.py",\ line\ 886,\ in\ get
\ \ \ \ return\ field_cache\[record\._ids\[0\]\]
KeyError:\ 1
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/fields\.py",\ line\ 1082,\ in\ __get__
\ \ \ \ value\ =\ env\.cache\.get\(record,\ self\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/api\.py",\ line\ 889,\ in\ get
\ \ \ \ raise\ CacheMiss\(record,\ field\)
odoo\.exceptions\.CacheMiss:\ 'res\.lang\(1,\)\.flag_image_url'
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/api\.py",\ line\ 886,\ in\ get
\ \ \ \ return\ field_cache\[record\._ids\[0\]\]
KeyError:\ 1
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/fields\.py",\ line\ 1082,\ in\ __get__
\ \ \ \ value\ =\ env\.cache\.get\(record,\ self\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/api\.py",\ line\ 889,\ in\ get
\ \ \ \ raise\ CacheMiss\(record,\ field\)
odoo\.exceptions\.CacheMiss:\ 'res\.lang\(1,\)\.flag_image'
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/api\.py",\ line\ 886,\ in\ get
\ \ \ \ return\ field_cache\[record\._ids\[0\]\]
KeyError:\ 1
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/fields\.py",\ line\ 1082,\ in\ __get__
\ \ \ \ value\ =\ env\.cache\.get\(record,\ self\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/api\.py",\ line\ 889,\ in\ get
\ \ \ \ raise\ CacheMiss\(record,\ field\)
odoo\.exceptions\.CacheMiss:\ 'ir\.attachment\(1,\)\.datas'
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/api\.py",\ line\ 886,\ in\ get
\ \ \ \ return\ field_cache\[record\._ids\[0\]\]
KeyError:\ 1
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/fields\.py",\ line\ 1082,\ in\ __get__
\ \ \ \ value\ =\ env\.cache\.get\(record,\ self\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/api\.py",\ line\ 889,\ in\ get
\ \ \ \ raise\ CacheMiss\(record,\ field\)
odoo\.exceptions\.CacheMiss:\ 'ir\.attachment\(1,\)\.raw'
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_attachment\.py",\ line\ 119,\ in\ _file_read
\ \ \ \ with\ open\(full_path,\ 'rb'\)\ as\ f:
FileNotFoundError:\ \[Errno\ 2\]\ No\ such\ file\ or\ directory:\ '/var/lib/odoo/\.local/share/Odoo/filestore/sandbox1/23/23fe89f51c8121f053a697a3dd79106f25aeeb52'
2023\-06\-22\ 16:46:51,360\ 1176\ ERROR\ sandbox1\ odoo\.sql_db:\ bad\ query:\ SELECT\ "ir_attachment"\.id\ FROM\ "ir_attachment"\ WHERE\ \(\("ir_attachment"\."res_field"\ IS\ NULL\ \ AND\ \(unaccent\("ir_attachment"\."url"::text\)\ like\ unaccent\('/web/assets/%\-%/web\.assets_common\.min\.css'\)\)\)\ AND\ \(NOT\ \(\(unaccent\("ir_attachment"\."url"::text\)\ like\ unaccent\('/web/assets/%\-d1f27ed/%%%'\)\)\)\)\)\ ORDER\ BY\ \ "ir_attachment"\."id"\ DESC
ERROR:\ function\ unaccent_schema\.unaccent\(unknown,\ text\)\ does\ not\ exist
LINE\ 2:\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ SELECT\ unaccent_schema\.unaccent\('unaccent_sc\.\.\.
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \^
HINT:\ \ No\ function\ matches\ the\ given\ name\ and\ argument\ types\.\ You\ might\ need\ to\ add\ explicit\ type\ casts\.
QUERY:
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ SELECT\ unaccent_schema\.unaccent\('unaccent_schema\.unaccent',\ \$1\)
CONTEXT:\ \ SQL\ function\ "unaccent"\ during\ inlining
2023\-06\-22\ 16:46:51,361\ 1176\ ERROR\ sandbox1\ odoo\.sql_db:\ bad\ query:\ SELECT\ "ir_ui_view"\.id\ FROM\ "ir_ui_view"\ WHERE\ \(\("ir_ui_view"\."active"\ =\ true\)\ AND\ \("ir_ui_view"\."key"\ =\ 'web\.frontend_layout'\)\)\ ORDER\ BY\ \ "ir_ui_view"\."priority"\ ,"ir_ui_view"\."name"\ ,"ir_ui_view"\."id"\ \ \ LIMIT\ 1
ERROR:\ current\ transaction\ is\ aborted,\ commands\ ignored\ until\ end\ of\ transaction\ block
2023\-06\-22\ 16:46:51,362\ 1176\ ERROR\ sandbox1\ odoo\.sql_db:\ bad\ query:\ SELECT\ "ir_ui_view"\.id\ FROM\ "ir_ui_view"\ WHERE\ \(\("ir_ui_view"\."active"\ =\ true\)\ AND\ \("ir_ui_view"\."key"\ =\ 'http_routing\.http_error'\)\)\ ORDER\ BY\ \ "ir_ui_view"\."priority"\ ,"ir_ui_view"\."name"\ ,"ir_ui_view"\."id"\ \ \ LIMIT\ 1
ERROR:\ current\ transaction\ is\ aborted,\ commands\ ignored\ until\ end\ of\ transaction\ block
2023\-06\-22\ 16:46:51,386\ 1176\ INFO\ sandbox1\ werkzeug:\ 69\.21\.230\.116\ \-\ \-\ \[22/Jun/2023\ 16:46:51\]\ "GET\ /favicon\.ico\ HTTP/1\.0"\ 500\ \-\ 41\ 0\.030\ 0\.166
2023\-06\-22\ 16:46:51,404\ 1176\ ERROR\ sandbox1\ werkzeug:\ Error\ on\ request:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/cache\.py",\ line\ 85,\ in\ lookup
\ \ \ \ r\ =\ d\[key\]
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/func\.py",\ line\ 71,\ in\ wrapper
\ \ \ \ return\ func\(self,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/lru\.py",\ line\ 34,\ in\ __getitem__
\ \ \ \ a\ =\ self\.d\[obj\]
KeyError:\ \('ir\.qweb',\ ,\ 'web\.assets_common',\ True,\ False,\ '',\ False,\ False,\ False,\ \(None,\ 'en_US'\)\)
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 219,\ in\ render_template
\ \ \ \ yield\ from\ compiled_fn\(self,\ values,\ log\)
\ \ File\ "",\ line\ 43,\ in\ template_186
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 246,\ in\ _get_asset_nodes
\ \ \ \ return\ self\._generate_asset_nodes_cache\(bundle,\ css,\ js,\ debug,\ async_load,\ defer_load,\ lazy_load,\ media\)
\ \ File\ "",\ line\ 2,\ in\ _generate_asset_nodes_cache
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/cache\.py",\ line\ 90,\ in\ lookup
\ \ \ \ value\ =\ d\[key\]\ =\ self\.method\(\*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 255,\ in\ _generate_asset_nodes_cache
\ \ \ \ return\ self\._generate_asset_nodes\(bundle,\ css,\ js,\ debug,\ async_load,\ defer_load,\ lazy_load,\ media\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 266,\ in\ _generate_asset_nodes
\ \ \ \ return\ remains\ \+\ asset\.to_node\(css=css,\ js=js,\ debug=debug,\ async_load=async_load,\ defer_load=defer_load,\ lazy_load=lazy_load\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/assetsbundle\.py",\ line\ 147,\ in\ to_node
\ \ \ \ css_attachments\ =\ self\.css\(is_minified=not\ is_debug_assets\)\ or\ \[\]
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/assetsbundle\.py",\ line\ 435,\ in\ css
\ \ \ \ self\.save_attachment\(extension,\ css\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/assetsbundle\.py",\ line\ 354,\ in\ save_attachment
\ \ \ \ self\.clean_attachments\(extension\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/assetsbundle\.py",\ line\ 261,\ in\ clean_attachments
\ \ \ \ attachments\ =\ ira\.sudo\(\)\.search\(domain\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 1811,\ in\ search
\ \ \ \ return\ res\ if\ count\ else\ self\.browse\(res\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 5176,\ in\ browse
\ \ \ \ if\ not\ ids:
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 215,\ in\ __bool__
\ \ \ \ return\ bool\(self\._result\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/func\.py",\ line\ 26,\ in\ __get__
\ \ \ \ value\ =\ self\.fget\(obj\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 208,\ in\ _result
\ \ \ \ self\._cr\.execute\(query_str,\ params\)
\ \ File\ "",\ line\ 2,\ in\ execute
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 90,\ in\ check
\ \ \ \ return\ f\(self,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 311,\ in\ execute
\ \ \ \ res\ =\ self\._obj\.execute\(query,\ params\)
psycopg2\.errors\.UndefinedFunction:\ function\ unaccent_schema\.unaccent\(unknown,\ text\)\ does\ not\ exist
LINE\ 2:\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ SELECT\ unaccent_schema\.unaccent\('unaccent_sc\.\.\.
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \^
HINT:\ \ No\ function\ matches\ the\ given\ name\ and\ argument\ types\.\ You\ might\ need\ to\ add\ explicit\ type\ casts\.
QUERY:
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ SELECT\ unaccent_schema\.unaccent\('unaccent_schema\.unaccent',\ \$1\)
CONTEXT:\ \ SQL\ function\ "unaccent"\ during\ inlining
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 246,\ in\ _get_template
\ \ \ \ loaded\ =\ options\.get\('load',\ self\._load\)\(template,\ options\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 136,\ in\ _load
\ \ \ \ view_id\ =\ self\.env\['ir\.ui\.view'\]\.get_view_id\(name\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_ui_view\.py",\ line\ 1880,\ in\ get_view_id
\ \ \ \ view\ =\ self\.sudo\(\)\.search\(\[\('key',\ '=',\ template\)\],\ limit=1\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 1811,\ in\ search
\ \ \ \ return\ res\ if\ count\ else\ self\.browse\(res\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 5176,\ in\ browse
\ \ \ \ if\ not\ ids:
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 215,\ in\ __bool__
\ \ \ \ return\ bool\(self\._result\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/func\.py",\ line\ 26,\ in\ __get__
\ \ \ \ value\ =\ self\.fget\(obj\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 208,\ in\ _result
\ \ \ \ self\._cr\.execute\(query_str,\ params\)
\ \ File\ "",\ line\ 2,\ in\ execute
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 90,\ in\ check
\ \ \ \ return\ f\(self,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 311,\ in\ execute
\ \ \ \ res\ =\ self\._obj\.execute\(query,\ params\)
psycopg2\.errors\.InFailedSqlTransaction:\ current\ transaction\ is\ aborted,\ commands\ ignored\ until\ end\ of\ transaction\ block
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/http_routing/models/ir_http\.py",\ line\ 668,\ in\ _handle_exception
\ \ \ \ code,\ html\ =\ cls\._get_error_html\(env,\ code,\ values\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/http_routing/models/ir_http\.py",\ line\ 613,\ in\ _get_error_html
\ \ \ \ return\ code,\ env\['ir\.ui\.view'\]\._render_template\('http_routing\.%s'\ %\ code,\ values\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_ui_view\.py",\ line\ 1992,\ in\ _render_template
\ \ \ \ return\ self\.browse\(self\.get_view_id\(template\)\)\._render\(values,\ engine\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/web_editor/models/ir_ui_view\.py",\ line\ 29,\ in\ _render
\ \ \ \ return\ super\(IrUiView,\ self\)\._render\(values=values,\ engine=engine,\ minimal_qcontext=minimal_qcontext\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_ui_view\.py",\ line\ 2000,\ in\ _render
\ \ \ \ return\ self\.env\[engine\]\._render\(self\.id,\ qcontext\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/web_studio/models/ir_qweb\.py",\ line\ 47,\ in\ _render
\ \ \ \ return\ super\(IrQWeb,\ self\)\._render\(template,\ values=values,\ \*\*options\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/profiler\.py",\ line\ 292,\ in\ _tracked_method_render
\ \ \ \ return\ method_render\(self,\ template,\ values,\ \*\*options\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 76,\ in\ _render
\ \ \ \ result\ =\ super\(\)\._render\(template,\ values=values,\ \*\*compile_options\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 134,\ in\ _render
\ \ \ \ result\ =\ ''\.join\(rendering\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 221,\ in\ render_template
\ \ \ \ raise\ e
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 219,\ in\ render_template
\ \ \ \ yield\ from\ compiled_fn\(self,\ values,\ log\)
\ \ File\ "",\ line\ 20,\ in\ template_254
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 223,\ in\ render_template
\ \ \ \ raise\ QWebException\("Error\ when\ render\ the\ template",\ self,\ options,
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 45,\ in\ __init__
\ \ \ \ element\ =\ qweb\._get_template\(template,\ options\)\[0\]
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/web_studio/models/ir_qweb\.py",\ line\ 22,\ in\ _get_template
\ \ \ \ element,\ document,\ ref\ =\ super\(IrQWeb,\ self\)\._get_template\(template,\ options\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 254,\ in\ _get_template
\ \ \ \ raise\ QWebException\("load\ could\ not\ load\ template",\ self,\ options,\ e,\ template\)
odoo\.addons\.base\.models\.qweb\.QWebException:\ current\ transaction\ is\ aborted,\ commands\ ignored\ until\ end\ of\ transaction\ block
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/cache\.py",\ line\ 85,\ in\ lookup
\ \ \ \ r\ =\ d\[key\]
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/func\.py",\ line\ 71,\ in\ wrapper
\ \ \ \ return\ func\(self,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/lru\.py",\ line\ 34,\ in\ __getitem__
\ \ \ \ a\ =\ self\.d\[obj\]
KeyError:\ \('ir\.qweb',\ ,\ 'web\.assets_common',\ True,\ False,\ '',\ False,\ False,\ False,\ \(None,\ 'en_US'\)\)
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 219,\ in\ render_template
\ \ \ \ yield\ from\ compiled_fn\(self,\ values,\ log\)
\ \ File\ "",\ line\ 43,\ in\ template_186
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 246,\ in\ _get_asset_nodes
\ \ \ \ return\ self\._generate_asset_nodes_cache\(bundle,\ css,\ js,\ debug,\ async_load,\ defer_load,\ lazy_load,\ media\)
\ \ File\ "",\ line\ 2,\ in\ _generate_asset_nodes_cache
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/cache\.py",\ line\ 90,\ in\ lookup
\ \ \ \ value\ =\ d\[key\]\ =\ self\.method\(\*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 255,\ in\ _generate_asset_nodes_cache
\ \ \ \ return\ self\._generate_asset_nodes\(bundle,\ css,\ js,\ debug,\ async_load,\ defer_load,\ lazy_load,\ media\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 266,\ in\ _generate_asset_nodes
\ \ \ \ return\ remains\ \+\ asset\.to_node\(css=css,\ js=js,\ debug=debug,\ async_load=async_load,\ defer_load=defer_load,\ lazy_load=lazy_load\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/assetsbundle\.py",\ line\ 147,\ in\ to_node
\ \ \ \ css_attachments\ =\ self\.css\(is_minified=not\ is_debug_assets\)\ or\ \[\]
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/assetsbundle\.py",\ line\ 435,\ in\ css
\ \ \ \ self\.save_attachment\(extension,\ css\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/assetsbundle\.py",\ line\ 354,\ in\ save_attachment
\ \ \ \ self\.clean_attachments\(extension\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/assetsbundle\.py",\ line\ 261,\ in\ clean_attachments
\ \ \ \ attachments\ =\ ira\.sudo\(\)\.search\(domain\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 1811,\ in\ search
\ \ \ \ return\ res\ if\ count\ else\ self\.browse\(res\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 5176,\ in\ browse
\ \ \ \ if\ not\ ids:
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 215,\ in\ __bool__
\ \ \ \ return\ bool\(self\._result\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/func\.py",\ line\ 26,\ in\ __get__
\ \ \ \ value\ =\ self\.fget\(obj\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 208,\ in\ _result
\ \ \ \ self\._cr\.execute\(query_str,\ params\)
\ \ File\ "",\ line\ 2,\ in\ execute
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 90,\ in\ check
\ \ \ \ return\ f\(self,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 311,\ in\ execute
\ \ \ \ res\ =\ self\._obj\.execute\(query,\ params\)
psycopg2\.errors\.UndefinedFunction:\ function\ unaccent_schema\.unaccent\(unknown,\ text\)\ does\ not\ exist
LINE\ 2:\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ SELECT\ unaccent_schema\.unaccent\('unaccent_sc\.\.\.
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \^
HINT:\ \ No\ function\ matches\ the\ given\ name\ and\ argument\ types\.\ You\ might\ need\ to\ add\ explicit\ type\ casts\.
QUERY:
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ SELECT\ unaccent_schema\.unaccent\('unaccent_schema\.unaccent',\ \$1\)
CONTEXT:\ \ SQL\ function\ "unaccent"\ during\ inlining
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/qweb\.py",\ line\ 246,\ in\ _get_template
\ \ \ \ loaded\ =\ options\.get\('load',\ self\._load\)\(template,\ options\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_qweb\.py",\ line\ 136,\ in\ _load
\ \ \ \ view_id\ =\ self\.env\['ir\.ui\.view'\]\.get_view_id\(name\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_ui_view\.py",\ line\ 1880,\ in\ get_view_id
\ \ \ \ view\ =\ self\.sudo\(\)\.search\(\[\('key',\ '=',\ template\)\],\ limit=1\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 1811,\ in\ search
\ \ \ \ return\ res\ if\ count\ else\ self\.browse\(res\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 5176,\ in\ browse
\ \ \ \ if\ not\ ids:
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 215,\ in\ __bool__
\ \ \ \ return\ bool\(self\._result\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/func\.py",\ line\ 26,\ in\ __get__
\ \ \ \ value\ =\ self\.fget\(obj\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 208,\ in\ _result
\ \ \ \ self\._cr\.execute\(query_str,\ params\)
\ \ File\ "",\ line\ 2,\ in\ execute
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 90,\ in\ check
\ \ \ \ return\ f\(self,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 311,\ in\ execute
\ \ \ \ res\ =\ self\._obj\.execute\(query,\ params\)
psycopg2\.errors\.InFailedSqlTransaction:\ current\ transaction\ is\ aborted,\ commands\ ignored\ until\ end\ of\ transaction\ block
load\ could\ not\ load\ template
InFailedSqlTransaction:\ current\ transaction\ is\ aborted,\ commands\ ignored\ until\ end\ of\ transaction\ block
Template:\ 254
During\ handling\ of\ the\ above\ exception,\ another\ exception\ occurred:
Traceback\ \(most\ recent\ call\ last\):
\ \ File\ "/usr/lib/python3/dist\-packages/werkzeug/serving\.py",\ line\ 306,\ in\ run_wsgi
\ \ \ \ execute\(self\.server\.app\)
\ \ File\ "/usr/lib/python3/dist\-packages/werkzeug/serving\.py",\ line\ 294,\ in\ execute
\ \ \ \ application_iter\ =\ app\(environ,\ start_response\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/service/wsgi_server\.py",\ line\ 110,\ in\ application
\ \ \ \ return\ ProxyFix\(application_unproxied\)\(environ,\ start_response\)
\ \ File\ "/usr/lib/python3/dist\-packages/werkzeug/middleware/proxy_fix\.py",\ line\ 232,\ in\ __call__
\ \ \ \ return\ self\.app\(environ,\ start_response\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/service/wsgi_server\.py",\ line\ 87,\ in\ application_unproxied
\ \ \ \ result\ =\ odoo\.http\.root\(environ,\ start_response\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/http\.py",\ line\ 1305,\ in\ __call__
\ \ \ \ return\ self\.dispatch\(environ,\ start_response\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/http\.py",\ line\ 1271,\ in\ __call__
\ \ \ \ return\ self\.app\(environ,\ start_wrapped\)
\ \ File\ "/usr/lib/python3/dist\-packages/werkzeug/middleware/shared_data\.py",\ line\ 220,\ in\ __call__
\ \ \ \ return\ self\.app\(environ,\ start_response\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/http\.py",\ line\ 1500,\ in\ dispatch
\ \ \ \ result\ =\ ir_http\._dispatch\(\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/auth_signup/models/ir_http\.py",\ line\ 19,\ in\ _dispatch
\ \ \ \ return\ super\(Http,\ cls\)\._dispatch\(\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/web_editor/models/ir_http\.py",\ line\ 21,\ in\ _dispatch
\ \ \ \ return\ super\(IrHttp,\ cls\)\._dispatch\(\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/utm/models/ir_http\.py",\ line\ 29,\ in\ _dispatch
\ \ \ \ response\ =\ super\(IrHttp,\ cls\)\._dispatch\(\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/http_routing/models/ir_http\.py",\ line\ 516,\ in\ _dispatch
\ \ \ \ return\ cls\._handle_exception\(routing_error\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/utm/models/ir_http\.py",\ line\ 34,\ in\ _handle_exception
\ \ \ \ response\ =\ super\(IrHttp,\ cls\)\._handle_exception\(exc\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/http_routing/models/ir_http\.py",\ line\ 670,\ in\ _handle_exception
\ \ \ \ code,\ html\ =\ 418,\ env\['ir\.ui\.view'\]\._render_template\('http_routing\.http_error',\ values\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_ui_view\.py",\ line\ 1992,\ in\ _render_template
\ \ \ \ return\ self\.browse\(self\.get_view_id\(template\)\)\._render\(values,\ engine\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_ui_view\.py",\ line\ 1880,\ in\ get_view_id
\ \ \ \ view\ =\ self\.sudo\(\)\.search\(\[\('key',\ '=',\ template\)\],\ limit=1\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 1811,\ in\ search
\ \ \ \ return\ res\ if\ count\ else\ self\.browse\(res\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/models\.py",\ line\ 5176,\ in\ browse
\ \ \ \ if\ not\ ids:
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 215,\ in\ __bool__
\ \ \ \ return\ bool\(self\._result\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/func\.py",\ line\ 26,\ in\ __get__
\ \ \ \ value\ =\ self\.fget\(obj\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/osv/query\.py",\ line\ 208,\ in\ _result
\ \ \ \ self\._cr\.execute\(query_str,\ params\)
\ \ File\ "",\ line\ 2,\ in\ execute
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 90,\ in\ check
\ \ \ \ return\ f\(self,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 311,\ in\ execute
\ \ \ \ res\ =\ self\._obj\.execute\(query,\ params\)
psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block - - -
Im not really sure what the issue is
