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

CRM
e-Commerce
Buchhaltung
Lager
PoS
Projekte
MRP

All apps

Alle Beiträge Personen Abzeichen

Stichwörter (Alle anzeigen)

odoo accounting v14 pos v15

Über dieses Forum

Hilfe

Odoo v17 : Setup : Database creation error

sql bug 17.0

2 Antworten

2908 Ansichten

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

Autor

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]:

Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!

Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!

Registrieren

Verknüpfte Beiträge	Antworten	Ansichten
V17 Loyalty Points Issue / bug? bug loyalty 17.0	1 Jan. 25	1858
Duplication error thrown even though no duplicate exists. sql bug duplication odoo	1 Mai 23	4098
Odoo 17 Pos Js development 17.0	1 Aug. 25	2451
How can I make the cost field on products readonly? Gelöst 17.0	2 Aug. 25	990
bug in hte installation modul bug	1 Apr. 25	1682

Diese Frage wurde gekennzeichnet

Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!