Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Apskaita
Atsarga
PoS
Projektas
MRP

All apps

All Posts People Badges

Žymos (View all)

odoo accounting v14 pos v15

About this forum

Pagalba

Odoo v17 : Setup : Database creation error

sql bug 17.0

2 Replies

2904 Rodiniai

Aore

Hi there,

I'm attempting a fresh installation of Odoo v17 on Debian 12. I've ensured the Git repository is up-to-date and I'm using Python 3.10. I'm following the guide: rosehosting [DOT] com/blog/how-to-install-odoo-17-on-debian-12/

Everything seems to go smoothly until the database setup stage, which I'm trying to access via: odoo [DOT] domain [DOT] com/web/database/createHowever, I encounter this error:*Database creation error: relation "ir_model" does not exist LINE 1: SELECT , name->>'en_US' AS name FROM ir_model WHERE state =... ^Could you advise what I might be missing in my installation process?

Bhushan vagh

try using cmd -i base,web in terminal along with database

Aore

Autorius

Server log: 

Jul  1 06:39:26 pierrevm1 odoo17[7165]: 2024-07-01 04:39:26,226 7165 INFO odoo17 odoo.modules.loading: loading 1 modules...
Jul  1 06:39:26 pierrevm1 odoo17[7165]: 2024-07-01 04:39:26,247 7165 INFO odoo17 odoo.modules.loading: 1 modules loaded in 0.02s, 0 queries (+0 extra)
Jul  1 06:39:26 pierrevm1 odoo17[7165]: 2024-07-01 04:39:26,250 7165 ERROR odoo17 odoo.sql_db: bad query: SELECT *, name->>'en_US' AS name FROM ir_model WHERE state = 'manual'
Jul  1 06:39:26 pierrevm1 odoo17[7165]: ERROR: relation "ir_model" does not exist
Jul  1 06:39:26 pierrevm1 odoo17[7165]: LINE 1: SELECT *, name->>'en_US' AS name FROM ir_model WHERE state =...
Jul  1 06:39:26 pierrevm1 odoo17[7165]:                                               ^
Jul  1 06:39:26 pierrevm1 odoo17[7165]:
Jul  1 06:39:26 pierrevm1 odoo17[7165]: 2024-07-01 04:39:26,254 7165 WARNING odoo17 odoo.modules.loading: Transient module states were reset
Jul  1 06:39:26 pierrevm1 odoo17[7165]: 2024-07-01 04:39:26,255 7165 ERROR odoo17 odoo.modules.registry: Failed to load registry
Jul  1 06:39:26 pierrevm1 odoo17[7165]: Traceback (most recent call last):
Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/modules/registry.py", line 87, in __new__
Jul  1 06:39:26 pierrevm1 odoo17[7165]:     return cls.registries[db_name]
Jul  1 06:39:26 pierrevm1 odoo17[7165]:            ~~~~~~~~~~~~~~^^^^^^^^^
Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "", line 2, in __getitem__
Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/tools/func.py", line 87, in locked
Jul  1 06:39:26 pierrevm1 odoo17[7165]:     return func(inst, *args, **kwargs)
Jul  1 06:39:26 pierrevm1 odoo17[7165]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/tools/lru.py", line 34, in __getitem__
Jul  1 06:39:26 pierrevm1 odoo17[7165]:     a = self.d[obj]
Jul  1 06:39:26 pierrevm1 odoo17[7165]:         ~~~~~~^^^^^
Jul  1 06:39:26 pierrevm1 odoo17[7165]: KeyError: 'odoo17'
Jul  1 06:39:26 pierrevm1 odoo17[7165]: During handling of the above exception, another exception occurred:
Jul  1 06:39:26 pierrevm1 odoo17[7165]: Traceback (most recent call last):
Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/modules/registry.py", line 113, in new
Jul  1 06:39:26 pierrevm1 odoo17[7165]:     odoo.modules.load_modules(registry, force_demo, status, update_module)
Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/modules/loading.py", line 502, in load_modules
Jul  1 06:39:26 pierrevm1 odoo17[7165]:     registry.setup_models(cr)
Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "", line 2, in setup_models
Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/tools/func.py", line 87, in locked
Jul  1 06:39:26 pierrevm1 odoo17[7165]:     return func(inst, *args, **kwargs)
Jul  1 06:39:26 pierrevm1 odoo17[7165]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/modules/registry.py", line 306, in setup_models
Jul  1 06:39:26 pierrevm1 odoo17[7165]:     env['ir.model']._add_manual_models()
Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/addons/base/models/ir_model.py", line 468, in _add_manual_models
Jul  1 06:39:26 pierrevm1 odoo17[7165]:     cr.execute("SELECT *, name->>'en_US' AS name FROM ir_model WHERE state = 'manual'")
Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/sql_db.py", line 332, in execute
Jul  1 06:39:26 pierrevm1 odoo17[7165]:     res = self._obj.execute(query, params)

Jul  1 06:39:26 pierrevm1 odoo17[7165]:           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Jul  1 06:39:26 pierrevm1 odoo17[7165]: psycopg2.errors.UndefinedTable: relation "ir_model" does not exist

Jul  1 06:39:26 pierrevm1 odoo17[7165]: LINE 1: SELECT *, name->>'en_US' AS name FROM ir_model WHERE state =...

Jul  1 06:39:26 pierrevm1 odoo17[7165]:                                               ^

Jul  1 06:39:26 pierrevm1 odoo17[7165]: 2024-07-01 04:39:26,259 7165 ERROR odoo17 odoo.http: Exception during request handling.

Jul  1 06:39:26 pierrevm1 odoo17[7165]: Traceback (most recent call last):

Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/modules/registry.py", line 87, in __new__

Jul  1 06:39:26 pierrevm1 odoo17[7165]:     return cls.registries[db_name]

Jul  1 06:39:26 pierrevm1 odoo17[7165]:            ~~~~~~~~~~~~~~^^^^^^^^^

Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "", line 2, in __getitem__

Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/tools/func.py", line 87, in locked

Jul  1 06:39:26 pierrevm1 odoo17[7165]:     return func(inst, *args, **kwargs)

Jul  1 06:39:26 pierrevm1 odoo17[7165]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^

Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/tools/lru.py", line 34, in __getitem__

Jul  1 06:39:26 pierrevm1 odoo17[7165]:     a = self.d[obj]

Jul  1 06:39:26 pierrevm1 odoo17[7165]:         ~~~~~~^^^^^

Jul  1 06:39:26 pierrevm1 odoo17[7165]: KeyError: 'odoo17'

Jul  1 06:39:26 pierrevm1 odoo17[7165]: During handling of the above exception, another exception occurred:

Jul  1 06:39:26 pierrevm1 odoo17[7165]: Traceback (most recent call last):

Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/http.py", line 2189, in __call__

Jul  1 06:39:26 pierrevm1 odoo17[7165]:     response = request._serve_db()

Jul  1 06:39:26 pierrevm1 odoo17[7165]:                ^^^^^^^^^^^^^^^^^^^

Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/http.py", line 1743, in _serve_db

Jul  1 06:39:26 pierrevm1 odoo17[7165]:     self.registry = Registry(self.db).check_signaling()

Jul  1 06:39:26 pierrevm1 odoo17[7165]:                     ^^^^^^^^^^^^^^^^^

Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/modules/registry.py", line 89, in __new__

Jul  1 06:39:26 pierrevm1 odoo17[7165]:     return cls.new(db_name)

Jul  1 06:39:26 pierrevm1 odoo17[7165]:            ^^^^^^^^^^^^^^^^

Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "", line 2, in new

Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/tools/func.py", line 87, in locked

Jul  1 06:39:26 pierrevm1 odoo17[7165]:     return func(inst, *args, **kwargs)

Jul  1 06:39:26 pierrevm1 odoo17[7165]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^

Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/modules/registry.py", line 113, in new

Jul  1 06:39:26 pierrevm1 odoo17[7165]:     odoo.modules.load_modules(registry, force_demo, status, update_module)

Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/modules/loading.py", line 502, in load_modules

Jul  1 06:39:26 pierrevm1 odoo17[7165]:     registry.setup_models(cr)

Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "", line 2, in setup_models

Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/tools/func.py", line 87, in locked

Jul  1 06:39:26 pierrevm1 odoo17[7165]:     return func(inst, *args, **kwargs)

Jul  1 06:39:26 pierrevm1 odoo17[7165]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^

Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/modules/registry.py", line 306, in setup_models

Jul  1 06:39:26 pierrevm1 odoo17[7165]:     env['ir.model']._add_manual_models()

Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/addons/base/models/ir_model.py", line 468, in _add_manual_models

Jul  1 06:39:26 pierrevm1 odoo17[7165]:     cr.execute("SELECT *, name->>'en_US' AS name FROM ir_model WHERE state = 'manual'")

Jul  1 06:39:26 pierrevm1 odoo17[7165]:   File "/opt/odoo17/odoo17/odoo/sql_db.py", line 332, in execute

Jul  1 06:39:26 pierrevm1 odoo17[7165]:     res = self._obj.execute(query, params)

Jul  1 06:39:26 pierrevm1 odoo17[7165]:           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Jul  1 06:39:26 pierrevm1 odoo17[7165]: psycopg2.errors.UndefinedTable: relation "ir_model" does not exist

Jul  1 06:39:26 pierrevm1 odoo17[7165]: LINE 1: SELECT *, name->>'en_US' AS name FROM ir_model WHERE state =...

Jul  1 06:39:26 pierrevm1 odoo17[7165]:

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Registracija

Related Posts	Replies	Rodiniai
V17 Loyalty Points Issue / bug? bug loyalty 17.0	1 saus. 25	1854
Duplication error thrown even though no duplicate exists. sql bug duplication odoo	1 geg. 23	4094
Odoo 17 Pos Js development 17.0	1 rugp. 25	2448
How can I make the cost field on products readonly? Solved 17.0	2 rugp. 25	987
bug in hte installation modul bug	1 bal. 25	1678

This question has been flagged

Enjoying the discussion? Don't just read, join in!