Skip to Content
This question has been flagged
installationerror17.0
4 Replies
4617 Views
Avatar
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.


Avatar
Discard
Avatar
Bernard Wilmus
Best Answer

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



Avatar
Discard
Avatar
Teubel Gábor
Best Answer

Hello Alexandre,

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

Avatar
Discard
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
^

Avatar
Alexandre
Author Best Answer 
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.

Avatar
Discard
Avatar
Niyas Raphy (Walnut Software Solutions)
Best Answer

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

Thanks

Avatar
Discard
Related Posts Replies Views Activity
how to fix the problem during installing odoo 8 ??
installation error
Avatar
0
Mar 17
4672
Odoo Internal Server Error while installing on amazon web server EC2
installation error
Avatar
Avatar
1
Jul 15
5824
Odoo Masters install error on Debian 7 Wheezy [Solved]
installation error
Avatar
1
Mar 15
5532
module 'lib' has no attribute 'X509_V_FLAG_CB_ISSUER_CHECK' error after installing pdfminer Solved
installation error odoo16features
Avatar
Avatar
Avatar
Avatar
Avatar
4
Jun 25
10287
Connection Lost error on Installation (v17 odoo online) of CENTRIC THEME
installation themes 17.0
Avatar
0
May 24
1913