Skip to Content
This question has been flagged
sqlbug17.0
2 Replies
2938 Views
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
Discard
Avatar
Bhushan vagh
Best Answer

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

Avatar
Discard
Avatar
Aore
Author 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
Discard
Related Posts Replies Views Activity
V17 Loyalty Points Issue / bug?
bug loyalty 17.0
Avatar
Avatar
1
जन॰ 25
1871
Duplication error thrown even though no duplicate exists.
sql bug duplication odoo
Avatar
Avatar
1
मई 23
4107
Odoo 17 Pos Js development
17.0
Avatar
Avatar
1
अग॰ 25
2478
How can I make the cost field on products readonly? Solved
17.0
Avatar
Avatar
Avatar
2
अग॰ 25
1003
bug in hte installation modul
bug
Avatar
Avatar
1
अप्रैल 25
1688