Hoppa till innehåll
Du måste vara registrerad för att kunna interagera med communityn.
Alla inlägg Personer Utmärkelser
Etiketter (Visa alla)
odoo accounting v14 pos v15
Om detta forum
Denna fråga har flaggats
sqlbug17.0
2 Svar
3990 Vyer
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
Avbryt
Avatar
OdooTech Solutions, Bhushan vagh
Bästa svar

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

Avatar
Avbryt
Avatar
Aore
Författare Bästa svar 
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
Avbryt
Relaterade inlägg Svar Vyer Verksamhet
V17 Loyalty Points Issue / bug?
bug loyalty 17.0
Avatar
Avatar
1
jan. 25
2955
Duplication error thrown even though no duplicate exists.
sql bug duplication odoo
Avatar
Avatar
1
maj 23
5253
Annoying odoo bug??
bug
Avatar
0
mars 26
34
in POS orderline is it possible to add background color to the discounted product line
17.0
Avatar
Avatar
1
nov. 25
1624
Odoo 17 Pos Js development
17.0
Avatar
Avatar
1
aug. 25
3989