Hi,
i currently migrating our Odoo Instances to a newer Version using OpenUpgrade
The Upgrade running throw and the Website is running; But i still have two Problems:
Once im logged in this error appears in the logs:
ERROR odoo odoo.sql_db: bad query:
SELECT latest_version
FROM ir_module_module
WHERE name='base'
ERROR: relation "ir_module_module" does not exist
LINE 3: FROM ir_module_module
^
when i query it directly in postgres i get:
SELECT latest_version FROM ir_module_module WHERE name='base'; latest_version ---------------- 16.0.1.3 (1 row)
It looks like that the Whitespaces causing the error but i dont know how to debugg any further..
Second Problem is once i changing the template of the header/navigation the complete Site crashes.. not repairable and i need to restore the backup..
I know that odoo did not find some files but thats all...
2025-01-29 15:12:19,400 787 ERROR ************* odoo.http: Exception during request handling.
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/tools/cache.py", line 85, in lookup
r = d[key]
File "<decorator-gen-8>", line 2, in __getitem__
File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 87, in locked
return func(inst, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/tools/lru.py", line 34, in __getitem__
a = self.d[obj]
KeyError: ('ir.qweb', <function IrQWeb._generate_asset_nodes_cache at 0x7fe837c55870>, 'web.assets_frontend', True, False, '', False, False, False, False, ('de_DE', True, None, False, None, None, None, 1))
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/tools/cache.py", line 85, in lookup
r = d[key]
File "<decorator-gen-8>", line 2, in __getitem__
File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 87, in locked
return func(inst, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/tools/lru.py", line 34, in __getitem__
a = self.d[obj]
KeyError: ('ir.qweb', <function IrQWeb._get_asset_content at 0x7fe837c55a20>, 'web.assets_frontend', False, False, None, ('de_DE', True, None, False, None, None, None, 1))
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "<456>", line 1409, in template_456
File "<456>", line 1002, in template_456_content
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_qweb.py", line 2461, in _load_values
return get_value()
File "<456>", line 992, in template_456_t_cache_0_cache
File "<456>", line 426, in template_456_t_cache_0
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_qweb.py", line 122, in _get_asset_nodes
return super(IrQWeb, self_website)._get_asset_nodes(bundle, css=css, js=js, debug=debug, async_load=async_load, defer_load=defer_load, lazy_load=lazy_load, media=media)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_qweb.py", line 2433, in _get_asset_nodes
return self._generate_asset_nodes_cache(bundle, css, js, debug, async_load, defer_load, lazy_load, media)
File "<decorator-gen-71>", 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 2488, 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 2559, in _generate_asset_nodes
files, remains = self._get_asset_content(bundle, defer_load=defer_load, lazy_load=lazy_load, media=css and media or None)
File "<decorator-gen-72>", line 2, in _get_asset_content
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 2492, in _get_asset_content
asset_paths = self.env['ir.asset']._get_asset_paths(bundle=bundle, css=True, js=True)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 121, in _get_asset_paths
self._fill_asset_paths(bundle, addons, installed, css, js, asset_paths, [])
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 207, in _fill_asset_paths
process_path(directive, target, path_def)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 167, in process_path
self._fill_asset_paths(path_def, addons, installed, css, js, asset_paths, seen + [bundle])
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 207, in _fill_asset_paths
process_path(directive, target, path_def)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 167, in process_path
self._fill_asset_paths(path_def, addons, installed, css, js, asset_paths, seen + [bundle])
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 211, in _fill_asset_paths
process_path(asset.directive, asset.target, asset.path)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 179, in process_path
target_index = asset_paths.index(target_to_index, addon, bundle)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 389, in index
self._raise_not_found(path, bundle)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 422, in _raise_not_found
raise ValueError("File(s) %s not found in bundle %s" % (path, bundle))
ValueError: File(s) /website/static/src/scss/options/user_values.scss not found in bundle web._assets_primary_variables
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/http.py", line 2066, in __call__
response = request._serve_db()
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1653, in _serve_db
return service_model.retrying(self._serve_ir_http, self.env)
File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 133, in retrying
result = func()
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1681, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1795, in dispatch
return self.request.registry['ir.http']._dispatch(endpoint)
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_http.py", line 237, in _dispatch
response = super()._dispatch(endpoint)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 156, in _dispatch
result.flatten()
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1182, in flatten
self.response.append(self.render())
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1174, in render
return request.env["ir.ui.view"]._render_template(self.template, self.qcontext)
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_ui_view.py", line 419, in _render_template
return super()._render_template(template, values=values)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_ui_view.py", line 2129, in _render_template
return self.env['ir.qweb']._render(template, values)
File "/usr/lib/python3/dist-packages/odoo/tools/profiler.py", line 294, 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 588, in _render
result = ''.join(rendering)
File "<453>", line 39, in template_453
File "<453>", line 28, in template_453_content
File "<456>", line 1415, in template_456
odoo.addons.base.models.ir_qweb.QWebException: Error while render the template
ValueError: File(s) /website/static/src/scss/options/user_values.scss not found in bundle web._assets_primary_variables
Template: website.layout
Path: /t/html/head/t[9]
Node: <t t-call-assets="web.assets_frontend" t-js="false"/>
2025-01-29 15:12:19,402 787 INFO *********** werkzeug: ******** - - [29/Jan/2025 15:12:19] "GET / HTTP/1.1" 500 - 173 0.052 0.147
Hope anyone can Help!
Thanks!
