Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
sqlbug17.0
2 Odgovori
2921 Prikazi
Avatar
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?

Avatar
Opusti
Avatar
Bhushan vagh
Best Answer

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

Avatar
Opusti
Avatar
Aore
Avtor Best Answer 
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]:




Avatar
Opusti
Related Posts Odgovori Prikazi Aktivnost
V17 Loyalty Points Issue / bug?
bug loyalty 17.0
Avatar
Avatar
1
jan. 25
1862
Duplication error thrown even though no duplicate exists.
sql bug duplication odoo
Avatar
Avatar
1
maj 23
4099
Odoo 17 Pos Js development
17.0
Avatar
Avatar
1
avg. 25
2465
How can I make the cost field on products readonly? Solved
17.0
Avatar
Avatar
Avatar
2
avg. 25
998
bug in hte installation modul
bug
Avatar
Avatar
1
apr. 25
1686