Odoo 17 stopped working hours after installation

installation error 17.0

4 Antwoorden

5956 Weergaven

Alexandre

Firstly, I'm not by any means an expert at this - I might use some terms or expressions that might be slightly wrong.

Five days ago, Odoo 17 stopped working hours after installation on a VPS server. I followed a recently posted youtube guide with the title "How to Install Odoo 17 on Ubuntu 24.04 | 22.04" by ZacsTech. I also had ChatGPT by my side to check on everything that I was doing.

On first installation, I decided to install nginx and configure it to work with Odoo, but then later (much later) found out that this service uses the same ports as the apache2 service that my vps is using (80 and 443) and that might lead to conflicts.

I then proceeded to install some Odoo modules but didn’t know where to put them. I tried adding the downloaded modules’ folders to /odoo17/custom-addons/ but I wasn’t seeing these modules ready for installation in Odoo > Apps. Took me a while to see there was a filter being applied by default on this page. I ended up adding 2 more modules to custom-addons but these now weren’t showing up at all in Apps, unlike the first one. Soon after, I lost access to the Odoo application. It’s likely I restarted the service after I couldn’t see the recently added modules in Apps and that’s when it crashed.

This happened five days ago and ever since then I’ve tried reinstalling Odoo 3 times, I’ve checked config files multiple times, and so on. Postgresql is in an active (exited) state, which chatGPT says to be unusual. Odoo17 is in an active (running) state. I configured Webmin’s firewall to allow port 8069 (Odoo’s port) and now instead of getting a “connection timeout” error, I get a 500 – Internal Server Error.

Any help would be much appreciated. Thank you.

Bernard Wilmus

Hi,

I am facing the same error when I do a backup of a production database and I install it on an other server.

ERROR demo_9 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

Teubel Gábor

Hello Alexandre,

Did you managed to solve the issue? I'm facing the same.

Mauricio Alejandro Gonzalez

Hi, can you share your issue with more context and maybe logs?

This will help us to find what error you could be facing.

Teubel Gábor

For a better context, I use Odoo.sh, starting a new development branch from 16.0, upgrade it to 17.0. The upgrade goes well, however getting this issue:
2024-11-05 11:24:36,248 29 ERROR ? odoo.modules.loading: Database ubypass-dev-17-v1-16276144 not initialized, you can force it with `-i base`
2024-11-05 11:24:36,248 29 INFO ? odoo.modules.registry: Registry loaded in 0.013s
2024-11-05 11:24:36,266 29 ERROR ubypass-dev-17-v1-16276144 odoo.http: Exception during request handling.
Traceback (most recent call last):
File "/home/odoo/src/odoo/odoo/http.py", line 1782, in _serve_db
return service_model.retrying(self._serve_ir_http, self.env)
File "/home/odoo/src/odoo/odoo/service/model.py", line 133, in retrying
result = func()
File "/home/odoo/src/odoo/odoo/http.py", line 1794, in _serve_ir_http
ir_http = self.registry['ir.http']
File "/home/odoo/src/odoo/odoo/modules/registry.py", line 213, in __getitem__
return self.models[model_name]
KeyError: 'ir.http'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/home/odoo/src/odoo/odoo/http.py", line 2206, in __call__
response = request._serve_db()
File "/home/odoo/src/odoo/odoo/http.py", line 1786, in _serve_db
exc.error_response = self.registry['ir.http']._handle_error(exc)
File "/home/odoo/src/odoo/odoo/modules/registry.py", line 213, in __getitem__
return self.models[model_name]
KeyError: 'ir.http'
2024-11-05 11:24:36,267 29 INFO ubypass-dev-17-v1-16276144 werkzeug: 195.228.179.10 - - [05/Nov/2024 11:24:36] "GET /favicon.ico HTTP/1.0" 500 - 1 0.000 0.032
2024-11-05 11:25:36,317 29 ERROR ubypass-dev-17-v1-16276144 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
^
2024-11-05 11:25:36,317 29 WARNING ubypass-dev-17-v1-16276144 odoo.addons.base.models.ir_cron: Tried to poll an undefined table on database ubypass-dev-17-v1-16276144.
2024-11-05 11:25:37,335 29 ERROR ubypass-dev-17-v1-16276144 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
^
2024-11-05 11:25:37,335 29 WARNING ubypass-dev-17-v1-16276144 odoo.addons.base.models.ir_cron: Tried to poll an undefined table on database ubypass-dev-17-v1-16276144.
2024-11-05 11:26:36,377 29 ERROR ubypass-dev-17-v1-16276144 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
^
2024-11-05 11:26:36,377 29 WARNING ubypass-dev-17-v1-16276144 odoo.addons.base.models.ir_cron: Tried to poll an undefined table on database ubypass-dev-17-v1-16276144.
2024-11-05 11:26:38,406 29 ERROR ubypass-dev-17-v1-16276144 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
^

Alexandre

Auteur

2024-06-12 04:27:24,265 8491 ERROR odoo17 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
                         ^

2024-06-12 04:27:24,266 8491 WARNING odoo17 odoo.addons.base.models.ir_cron: Tried to poll an undefined table on database odoo17.
2024-06-12 04:27:57,732 8491 ERROR odoo17 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
                         ^

2024-06-12 04:27:57,732 8491 WARNING odoo17 odoo.addons.base.models.ir_cron: Tried to poll an undefined table on database odoo17.

This is the first time I ever see this error by the way. I reinstalled Odoo today and as it didn't work again I looked at database configurations and probably touched something I shouldn't have.

Niyas Raphy (Walnut Software Solutions)

Hi,
As you are getting 500 internal server error, can you check and see the odoo log for more information regarding the error.

Thanks

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
how to fix the problem during installing odoo 8 ?? installation error	0 mrt. 17	5735
Odoo Internal Server Error while installing on amazon web server EC2 installation error	1 jul. 15	7025
Odoo Masters install error on Debian 7 Wheezy [Solved] installation error	1 mrt. 15	6489
module 'lib' has no attribute 'X509_V_FLAG_CB_ISSUER_CHECK' error after installing pdfminer Opgelost installation error odoo16features	4 jun. 25	12118
Connection Lost error on Installation (v17 odoo online) of CENTRIC THEME installation themes 17.0	0 mei 24	2701

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!