Hi guys,
I have just spent three days creating a beautiful website for my business, and setting up my accounts and things, and I backed the database up using the database manager, and had to reinstall odoo and a few other things due to another system issue (in Ubuntu).
My issue is - I've restored the database, and when I select the database I get an error 500 (but odoo is the same version both backed up and restoring). I checked the journal log and it shows this error.
I am absolutely desperate to correct this so I don't have to redesign everything! :(
root@mail:/var/log/apache2# sudo journalctl -u odoo
May 31 14:24:48 mail.labworx.au odoo[19417]: 2025-05-31 14:24:48,325 19417 ERROR goneflying2 odoo.http: Exception during request handling.
May 31 14:24:48 mail.labworx.au odoo[19417]: Traceback (most recent call last):
May 31 14:24:48 mail.labworx.au odoo[19417]: File "<186>", line 51, in template_web_login_layout_186
May 31 14:24:48 mail.labworx.au odoo[19417]: File "<186>", line 40, in template_web_login_layout_186_content
May 31 14:24:48 mail.labworx.au odoo[19417]: File "<545>", line 5, in not_found_template
May 31 14:24:48 mail.labworx.au odoo[19417]: ValueError: Element '<xpath expr="//header//nav">' cannot be located in parent view
May 31 14:24:48 mail.labworx.au odoo[19417]: The above exception was the direct cause of the following exception:
May 31 14:24:48 mail.labworx.au odoo[19417]: Traceback (most recent call last):
May 31 14:24:48 mail.labworx.au odoo[19417]: File "/opt/odoo/odoo/odoo/http.py", line 2480, in __call__
May 31 14:24:48 mail.labworx.au odoo[19417]: response = request._serve_db()
May 31 14:24:48 mail.labworx.au odoo[19417]: ^^^^^^^^^^^^^^^^^^^
May 31 14:24:48 mail.labworx.au odoo[19417]: File "/opt/odoo/odoo/odoo/http.py", line 1983, in _serve_db
May 31 14:24:48 mail.labworx.au odoo[19417]: return self._transactioning(
May 31 14:24:48 mail.labworx.au odoo[19417]: ^^^^^^^^^^^^^^^^^^^^^
May 31 14:24:48 mail.labworx.au odoo[19417]: File "/opt/odoo/odoo/odoo/http.py", line 2047, in _transactioning
May 31 14:24:48 mail.labworx.au odoo[19417]: return service_model.retrying(func, env=self.env)
May 31 14:24:48 mail.labworx.au odoo[19417]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
May 31 14:24:48 mail.labworx.au odoo[19417]: File "/opt/odoo/odoo/odoo/service/model.py", line 176, in retrying
May 31 14:24:48 mail.labworx.au odoo[19417]: result = func()
May 31 14:24:48 mail.labworx.au odoo[19417]: ^^^^^^
May 31 14:24:48 mail.labworx.au odoo[19417]: File "/opt/odoo/odoo/odoo/http.py", line 2014, in _serve_ir_http
May 31 14:24:48 mail.labworx.au odoo[19417]: response = self.dispatcher.dispatch(rule.endpoint, args)
May 31 14:24:48 mail.labworx.au odoo[19417]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
May 31 14:24:48 mail.labworx.au odoo[19417]: File "/opt/odoo/odoo/odoo/http.py", line 2183, in dispatch
May 31 14:24:48 mail.labworx.au odoo[19417]: return self.request.registry['ir.http']._dispatch(endpoint)
May 31 14:24:48 mail.labworx.au odoo[19417]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
May 31 14:24:48 mail.labworx.au odoo[19417]: File "/opt/odoo/odoo/odoo/addons/base/models/ir_http.py", line 356, in _dispatch
May 31 14:24:48 mail.labworx.au odoo[19417]: result.flatten()
M
Is there something I can do (please) that I can fix this issue without having to lose my entire backed up database? :(
I've just jumped into command line, and noticed this:
(but how do I find out what the dependencies are to reinstall them? :/
you should try to stop your Odoo server, and run
python /path/to/odoo-bin --config=/path/to/odoo.conf -d name_of_your_database -u all
to make sure everything gets upgrade at once and in the correct sequence (make sure you use the correct python env).
It's likely however that this isn't working because i doubt your issue is with the fact that you've dumped and re-imported your database, but that you've deleted some crucial template elements while modifying your website which could lead to this behavior as well.
Hi Chris, thank you so much for your reply.
I used the shell commandline to install module html_builder and viola, the website started working again (thank goodness).
However, now when I attempt to install/active a module for example eCommerce (which was activated before I backed up the database previously), I receive the following RPC error: