Hello I did upgrade from OpenERP Server 6.1-20121104-003211 to OpenERP Server 7.0-20131119-002500. No errors during this process.However I can not login to database via WEB interface.
OpenERP Server Error
Client Traceback (most recent call last): File "/usr/lib/pymodules/python2.6/openerp/addons/web/http.py", line 204, in dispatch response["result"] = method(self, **self.params) File "/usr/lib/pymodules/python2.6/openerp/addons/web/controllers/main.py", line 867, in authenticate req.session.authenticate(db, login, password, env) File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 118, in authenticate if uid: self.get_context() File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 170, in get_context self.context = self.model('res.users').context_get() or {} File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 42, in proxy result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw) File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 30, in proxy_method result = self.session.send(self.service_name, method, *args) File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 103, in send raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)
Server Traceback (most recent call last): File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 89, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/usr/lib/pymodules/python2.6/openerp/netsvc.py", line 292, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/usr/lib/pymodules/python2.6/openerp/service/web_services.py", line 626, in dispatch res = fn(db, uid, params) File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 188, in execute_kw return self.execute(db, uid, obj, method, *args, *kw or {}) File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 131, in wrapper return f(self, dbname, args, *kwargs) File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 197, in execute res = self.execute_cr(cr, uid, obj, method, args, *kw) File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 185, in execute_cr return getattr(object, method)(cr, uid, args, *kw) File "/usr/lib/pymodules/python2.6/openerp/tools/cache.py", line 18, in lookup r = self.lookup(self2, cr, args) File "/usr/lib/pymodules/python2.6/openerp/tools/cache.py", line 46, in lookup value = d[key] = self.method(self2, cr, *args) File "/usr/lib/pymodules/python2.6/openerp/addons/base/res/res_users.py", line 363, in context_get res = getattr(user,k) or False File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 486, in __getattr__ return self[name] File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 401, in __getitem__ field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write") File "/usr/lib/pymodules/python2.6/openerp/addons/base/res/res_users.py", line 810, in read res = super(users_view, self).read(cr, uid, ids, fields, context=context, load=load) File "/usr/lib/pymodules/python2.6/openerp/addons/base/res/res_users.py", line 272, in read result = super(res_users, self).read(cr, uid, ids, fields=fields, context=context, load=load) File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 3612, in read result = self._read_flat(cr, user, select, fields, context, load) File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 3664, in _read_flat cr.execute(query, [tuple(sub_ids)] + rule_params) File "/usr/lib/pymodules/python2.6/openerp/sql_db.py", line 161, in wrapper return f(self, *args, *kwargs) File "/usr/lib/pymodules/python2.6/openerp/sql_db.py", line 226, in execute res = self._obj.execute(query, params) ProgrammingError: column res_users.login_date does not exist LINE 1: SELECT res_users."menu_id",res_users."login_date",res_users.... ^
I checked password - all ok.
f325=# select login, password from res_users; login | password -------+----------- admin | xxx!4354398! (1 row)
####### Second part . Update to OpenERP Server 7.0-20131120-002454### Also can not login , but errors a bit diffrent.
OpenERP Server Error
Client Traceback (most recent call last): File "/usr/lib/pymodules/python2.6/openerp/addons/web/http.py", line 204, in dispatch response["result"] = method(self, **self.params) File "/usr/lib/pymodules/python2.6/openerp/addons/web/controllers/main.py", line 867, in authenticate req.session.authenticate(db, login, password, env) File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 118, in authenticate if uid: self.get_context() File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 170, in get_context self.context = self.model('res.users').context_get() or {} File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 42, in proxy result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw) File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 30, in proxy_method result = self.session.send(self.service_name, method, *args) File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 103, in send raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)
Server Traceback (most recent call last): File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 89, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/usr/lib/pymodules/python2.6/openerp/netsvc.py", line 292, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/usr/lib/pymodules/python2.6/openerp/service/web_services.py", line 626, in dispatch res = fn(db, uid, params) File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 188, in execute_kw return self.execute(db, uid, obj, method, *args, *kw or {}) File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 131, in wrapper return f(self, dbname, args, *kwargs) File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 197, in execute res = self.execute_cr(cr, uid, obj, method, args, *kw) File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 185, in execute_cr return getattr(object, method)(cr, uid, args, *kw) File "/usr/lib/pymodules/python2.6/openerp/tools/cache.py", line 18, in lookup r = self.lookup(self2, cr, args) File "/usr/lib/pymodules/python2.6/openerp/tools/cache.py", line 46, in lookup value = d[key] = self.method(self2, cr, *args) File "/usr/lib/pymodules/python2.6/openerp/addons/base/res/res_users.py", line 363, in context_get res = getattr(user,k) or False File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 486, in __getattr__ return self[name] File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 401, in __getitem__ field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write") File "/usr/lib/pymodules/python2.6/openerp/addons/base/res/res_users.py", line 810, in read res = super(users_view, self).read(cr, uid, ids, fields, context=context, load=load) File "/usr/lib/pymodules/python2.6/openerp/addons/base/res/res_users.py", line 272, in read result = super(res_users, self).read(cr, uid, ids, fields=fields, context=context, load=load) File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 3612, in read result = self._read_flat(cr, user, select, fields, context, load) File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 3664, in _read_flat cr.execute(query, [tuple(sub_ids)] + rule_params) File "/usr/lib/pymodules/python2.6/openerp/sql_db.py", line 161, in wrapper return f(self, *args, *kwargs) File "/usr/lib/pymodules/python2.6/openerp/sql_db.py", line 226, in execute res = self._obj.execute(query, params) ProgrammingError: column res_users.alias_id does not exist LINE 1: SELECT res_users."menu_id",res_users."alias_id",res_users."a... ^ Again - password for user is OK.
Thanks in advance
##more info ### It looks like my table res_users does not have alias_id column. See errors during login above ( I'm upgrading from 6.1 to 7.0 ) Could someone advice on how to create it correctly? ( type ,value , etc. ) Should be schema updated from 6.1 to 7.0 ? ########
mydatabase=# select * from res_users; id | name | active | login | password | email | context_tz | signature | context_lang | company_id | create_uid | create_date | write_date | write_uid | menu_id | menu_tips | date | action_id | user_email | context_project_id | context_section_id | context_department_id
########
3-rd stage. I added missing colomn as below : ALTER TABLE res_users ADD COLUMN login_date timestamp without time zone; ALTER TABLE res_users ADD COLUMN partner_id integer; ALTER TABLE res_users ADD COLUMN alias_id integer; ( I'm not sure about types , but i assume them from \d res_users; output .Are types correct ?) postgresql restart openerp restart
Now I'm hitting this during login : OpenERP Server Error
Client Traceback (most recent call last): File "/usr/lib/pymodules/python2.6/openerp/addons/web/http.py", line 204, in dispatch response["result"] = method(self, **self.params) File "/usr/lib/pymodules/python2.6/openerp/addons/web/controllers/main.py", line 867, in authenticate req.session.authenticate(db, login, password, env) File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 118, in authenticate if uid: self.get_context() File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 170, in get_context self.context = self.model('res.users').context_get() or {} File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 42, in proxy result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw) File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 30, in proxy_method result = self.session.send(self.service_name, method, *args) File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 103, in send raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)
Server Traceback (most recent call last): File "/usr/lib/pymodules/python2.6/openerp/addons/web/session.py", line 89, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/usr/lib/pymodules/python2.6/openerp/netsvc.py", line 292, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/usr/lib/pymodules/python2.6/openerp/service/web_services.py", line 626, in dispatch res = fn(db, uid, params) File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 188, in execute_kw return self.execute(db, uid, obj, method, *args, *kw or {}) File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 131, in wrapper return f(self, dbname, args, *kwargs) File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 197, in execute res = self.execute_cr(cr, uid, obj, method, args, *kw) File "/usr/lib/pymodules/python2.6/openerp/osv/osv.py", line 185, in execute_cr return getattr(object, method)(cr, uid, args, *kw) File "/usr/lib/pymodules/python2.6/openerp/tools/cache.py", line 18, in lookup r = self.lookup(self2, cr, args) File "/usr/lib/pymodules/python2.6/openerp/tools/cache.py", line 46, in lookup value = d[key] = self.method(self2, cr, *args) File "/usr/lib/pymodules/python2.6/openerp/addons/base/res/res_users.py", line 363, in context_get res = getattr(user,k) or False File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 494, in __getattr__ return self[name] File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 402, in __getitem__ field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write") File "/usr/lib/pymodules/python2.6/openerp/addons/base/res/res_users.py", line 810, in read res = super(users_view, self).read(cr, uid, ids, fields, context=context, load=load) File "/usr/lib/pymodules/python2.6/openerp/addons/base/res/res_users.py", line 272, in read result = super(res_users, self).read(cr, uid, ids, fields=fields, context=context, load=load) File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 3620, in read result = self._read_flat(cr, user, select, fields, context, load) File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 3696, in _read_flat res2 = self.pool.get(table).read(cr, user, [x[col] for x in res], cols, context, load) File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 3620, in read result = self._read_flat(cr, user, select, fields, context, load) File "/usr/lib/pymodules/python2.6/openerp/osv/orm.py", line 3672, in _read_flat cr.execute(query, [tuple(sub_ids)] + rule_params) File "/usr/lib/pymodules/python2.6/openerp/sql_db.py", line 161, in wrapper return f(self, *args, *kwargs) File "/usr/lib/pymodules/python2.6/openerp/sql_db.py", line 226, in execute res = self._obj.execute(query, params) File "/usr/lib/python2.6/dist-packages/psycopg2/extensions.py", line 124, in getquoted qobjs = [str(o.getquoted()) for o in pobjs] AttributeError: 'str' object has no attribute 'getquoted'
Could someone advise ?
Is there way to upgrade database schema , table structure during 6.1->7.0 upgrade process ? ( instead adding missing colomn into table )
####### Stage4 ######## I added around 20 missing column .. Info taken from web interface logon complain like below: "ProgrammingError: column res_partner.state_id does not exist".
So column added was : ALTER TABLE res_partner ADD COLUMN state_id integer;
( column type was taken from new database created on 7.0 , output from command like below : newdb=# \d res_partner; )
Hitting error during logon now :
ProgrammingError: relation "mail_alias" does not exist LINE 1: ...ts",mail_alias."alias_user_id",mail_alias.id FROM "mail_alia...
any idea ? Thanks.
Are you trying to use the same modules from OE6.1 in OE7?
Thanks for fast replay Grover. I did not changed modules. So yes , they the same . I can not login to web interface ,and double check modules installed.
Well I mean Custom modules. because custom modules of OE6.1 doesn't work on OE7 without some changes.