Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

ProgrammingError: column res_users.login_date does not exist

By
Konstantin Pobudzey
on 11/20/13, 8:23 PM 6,935 views

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?

GH Mediacloud, Grover Menacho
on 11/20/13, 9:17 PM

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.

Konstantin Pobudzey
on 11/20/13, 9:22 PM

Well I mean Custom modules. because custom modules of OE6.1 doesn't work on OE7 without some changes.

GH Mediacloud, Grover Menacho
on 11/22/13, 11:55 PM
0
akram
On 11/23/13, 1:45 AM

The error is for "login_date" column which is not showing in your select query result. i.e. login_date column is not present in database table. You might have added it in _columns of "res.users" table. To resolve it, upgrade base module.

If it still giving an error while log - in then do one thing open pgadmin and then add this column from there with your desired parameter, because OpenERP instance considering all columns at the time of login only so may be it will not allow you to login in the system if you have done any column addition in res_users table.

Hi, I got the same error when I started openerp v7 server and tried to login to database created using v6 addons.

akram
on 11/27/13, 10:04 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 11/20/13, 8:23 PM
Seen: 6935 times
Last updated: 3/16/15, 8:10 AM