hi all , i am trying to start my server already had this issue which was resolved \https://www.odoo.com/nl_NL/forum/help-1/question/odoo-12-server-not-starting-171353 but iam getting different error after starting my odoo 12 server also its shows , when ai select the database it shows this database may not be compatible
when i give ./odoo-bin --addons=addons,odoo/addons,crm_internal_new --xmlrpc-port=8070 -d LYRACRM_12 -u crm_extended iam getting this error , someone help me with this
ERROR :
2020-06-02 10: 49: 41,924 28010 ERROR LYRACRM_12 odoo.sql_db: bad query: SELECT "res_users". "Id" as "id", "res_users". "Login" as "login", "res_users". " share "as" share "," res_users "." company_id "as" company_id "," res_users "." create_date "as" create_date "," res_users "." active "as" active "," res_users "." action_id " as "action_id", "res_users". "write_uid" as "write_uid", "res_users". "write_date" as "write_date", "res_users". "partner_id" as "partner_id", "res_users". "signature" as " signature "," res_users "." create_uid "as "create_uid" FROM "res_users" WHERE "res_users" .id IN (1)
ERROR: relation "res_users" does not exist
LINE 1: ... re "," res_users "." Create_uid "as" create_uid "FROM" res_users ...
^
2020-06-02 10: 49: 41,926 28010 WARNING LYRACRM_12 odoo.modules.loading: Transient module states were reset
2020-06-02 10: 49: 41,926 28010 ERROR LYRACRM_12 odoo.modules.registry: Failed to load registry
Traceback (most recent call last):
File "/opt/odoo/odoo-12.0/odoo/api.py", line 1049, in get
value = self._data [key] [field] [record._ids [0]]
KeyError: 1
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/odoo/odoo-12.0/odoo/fields.py", line 1005, in __get__
value = record.env.cache.get (record, self)
File "/opt/odoo/odoo-12.0/odoo/api.py", line 1051, in get
raise CacheMiss (record, field)
odoo.exceptions.CacheMiss: ('res.users (1,). login', None)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/odoo/odoo-12.0/odoo/modules/registry.py", line 86, in new
odoo.modules.load_modules (registry._db, force_demo, status, update_module)
File "/opt/odoo/odoo-12.0/odoo/modules/loading.py", line 378, in load_modules
Module.update_list ()
File "<decorator-gen-71>", line 2, in update_list
File "/opt/odoo/odoo-12.0/odoo/addons/base/models/ir_module.py", line 69, in check_and_log
log_data = (method .__ name__, self.sudo (). mapped ('name'), user.login, user.id, origin)
File "/opt/odoo/odoo-12.0/odoo/fields.py", line 1009, in __get__
self.determine_value (record)
File "/opt/odoo/odoo-12.0/odoo/fields.py", line 1112, in determine_value
record._prefetch_field (self)
File "/opt/odoo/odoo-12.0/odoo/models.py", line 2860, in _prefetch_field
result = records.read ([f.name for f in fs], load = '_ classic_write')
File "/opt/odoo/odoo-12.0/odoo/addons/base/models/res_users.py", line 1235, in read
res = super (UsersView, self) .read (other_fields, load = load)
File "/opt/odoo/odoo-12.0/odoo/addons/base/models/res_users.py", line 451, in read
return super (Users, self) .read (fields = fields, load = load)
File "/opt/odoo/odoo-12.0/odoo/models.py", line 2798, in read
self._read_from_database (stored, inherited)
File "/opt/odoo/odoo-12.0/odoo/addons/base/models/res_users.py", line 369, in _read_from_database
super (Users, self) ._ read_from_database (field_names, inherited_field_names)
File "/opt/odoo/odoo-12.0/odoo/models.py", line 2925, in _read_from_database
cr.execute (query_str, params)
File "/opt/odoo/odoo-12.0/odoo/sql_db.py", line 148, in wrapper
return f (self, * args, ** kwargs)
File "/opt/odoo/odoo-12.0/odoo/sql_db.py", line 225, in execute
res = self._obj.execute (query, params)
psycopg2.ProgrammingError: relation "res_users" does not exist
LINE 1: ... re "," res_users "." Create_uid "as" create_uid "FROM" res_users ...
^
2020-06-02 10: 49: 41,931 28010 CRITICAL LYRACRM_12 odoo.service.server: Failed to initialize database `LYRACRM_12`.
Traceback (most recent call last):
File "/opt/odoo/odoo-12.0/odoo/api.py", line 1049, in get
value = self._data [key] [field] [record._ids [0]]
KeyError: 1
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/odoo/odoo-12.0/odoo/fields.py", line 1005, in __get__
value = record.env.cache.get (record, self)
File "/opt/odoo/odoo-12.0/odoo/api.py", line 1051, in get
raise CacheMiss (record, field)
odoo.exceptions.CacheMiss: ('res.users (1,). login', None)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/odoo/odoo-12.0/odoo/service/server.py", line 1162, in preload_registries
registry = Registry.new (dbname, update_module = update_module)
File "/opt/odoo/odoo-12.0/odoo/modules/registry.py", line 86, in new
odoo.modules.load_modules (registry._db, force_demo, status, update_module)
File "/opt/odoo/odoo-12.0/odoo/modules/loading.py", line 378, in load_modules
Module.update_list ()
File "<decorator-gen-71>", line 2, in update_list
File "/opt/odoo/odoo-12.0/odoo/addons/base/models/ir_module.py", line 69, in check_and_log
log_data = (method .__ name__, self.sudo (). mapped ('name'), user.login, user.id, origin)
File "/opt/odoo/odoo-12.0/odoo/fields.py", line 1009, in __get__
self.determine_value (record)
File "/opt/odoo/odoo-12.0/odoo/fields.py", line 1112, in determine_value
record._prefetch_field (self)
File "/opt/odoo/odoo-12.0/odoo/models.py", line 2860, in _prefetch_field
result = records.read ([f.name for f in fs], load = '_ classic_write')
File "/opt/odoo/odoo-12.0/odoo/addons/base/models/res_users.py", line 1235, in read
res = super (UsersView, self) .read (other_fields, load = load)
File "/opt/odoo/odoo-12.0/odoo/addons/base/models/res_users.py", line 451, in read
return super (Users, self) .read (fields = fields, load = load)
File "/opt/odoo/odoo-12.0/odoo/models.py", line 2798, in read
self._read_from_database (stored, inherited)
File "/opt/odoo/odoo-12.0/odoo/addons/base/models/res_users.py", line 369, in _read_from_database
super (Users, self) ._ read_from_database (field_names, inherited_field_names)
File "/opt/odoo/odoo-12.0/odoo/models.py", line 2925, in _read_from_database
cr.execute (query_str, params)
File "/opt/odoo/odoo-12.0/odoo/sql_db.py", line 148, in wrapper
return f (self, * args, ** kwargs)
File "/opt/odoo/odoo-12.0/odoo/sql_db.py", line 225, in execute
res = self._obj.execute (query, params)
psycopg2.ProgrammingError: relation "res_users" does not exist
LINE 1: ... re "," res_users "." Create_uid "as" create_uid "FROM" res_users ...
Guess Custom Module/Code where you made changes in res.model is Missing ,
Hope this tips will helps: https://goo.gl/8HgnCF