This question has been flagged
2 Replies
3615 Views

Baffled. I have a brand new instance just installed and I cant add any employees. The first one was there (default administrator). I went to add a second employee and on save I get a big error .This is pretty discouraging to say the least.  

Do any of the master python developers here have an idea of what to look for based on the error? I can't thank you enough for even looking.

Billie

* * * * * * * * * * * 

Odoo Server Error

Traceback (most recent call last):

File "/opt/odoo/odoo-server/openerp/http.py", line 530, in _handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "/opt/odoo/odoo-server/openerp/http.py", line 567, in dispatch

result = self._call_function(**self.params)

File "/opt/odoo/odoo-server/openerp/http.py", line 303, in _call_function

return checked_call(self.db, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/service/model.py", line 113, in wrapper

return f(dbname, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/http.py", line 300, in checked_call

return self.endpoint(*a, **kw)

File "/opt/odoo/odoo-server/openerp/http.py", line 796, in __call__

return self.method(*args, **kw)

File "/opt/odoo/odoo-server/openerp/http.py", line 396, in response_wrap

response = f(*args, **kw)

File "/opt/odoo/odoo-server/addons/web/controllers/main.py", line 949, in call_kw

return self._call_kw(model, method, args, kwargs)

File "/opt/odoo/odoo-server/addons/web/controllers/main.py", line 941, in _call_kw

return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/addons/hr/hr.py", line 284, in create

employee_id = super(hr_employee, self).create(cr, uid, data, context=context)

File "/opt/odoo/odoo-server/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/addons/mail/mail_thread.py", line 377, in create

thread_id = super(mail_thread, self).create(cr, uid, values, context=context)

File "/opt/odoo/odoo-server/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/api.py", line 336, in old_api

result = method(recs, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/models.py", line 4025, in create

record = self.browse(self._create(old_vals))

File "/opt/odoo/odoo-server/openerp/api.py", line 239, in wrapper

return new_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/api.py", line 462, in new_api

result = method(self._model, cr, uid, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/models.py", line 4197, in _create

recs.modified(self._fields)

File "/opt/odoo/odoo-server/openerp/api.py", line 239, in wrapper

return new_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/models.py", line 5591, in modified

spec += self._fields[fname].modified(self)

File "/opt/odoo/odoo-server/openerp/fields.py", line 1401, in modified

spec = super(_Relational, self).modified(records)

File "/opt/odoo/odoo-server/openerp/fields.py", line 903, in modified

target = env[field.model_name].search([(path, 'in', records.ids)])

File "/opt/odoo/odoo-server/openerp/api.py", line 239, in wrapper

return new_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/api.py", line 462, in new_api

result = method(self._model, cr, uid, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/models.py", line 1637, in search

return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)

File "/opt/odoo/odoo-server/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/models.py", line 4587, in _search

query = self._where_calc(cr, user, args, context=context)

File "/opt/odoo/odoo-server/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/models.py", line 4410, in _where_calc

e = expression.expression(cr, user, domain, self, context)

File "/opt/odoo/odoo-server/openerp/osv/expression.py", line 646, in __init__

self.parse(cr, uid, context=context)

File "/opt/odoo/odoo-server/openerp/osv/expression.py", line 944, in parse

ids2 = select_from_where(cr, column._fields_id, comodel._table, 'id', ids2, operator)

File "/opt/odoo/odoo-server/openerp/osv/expression.py", line 424, in select_from_where

(select_field, from_table, where_field), (tuple(subids),))

File "/opt/odoo/odoo-server/openerp/sql_db.py", line 158, in wrapper

return f(self, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/sql_db.py", line 234, in execute

res = self._obj.execute(query, params)

ProgrammingError: column "user_id" does not exist

LINE 1: SELECT "user_id" FROM "hr_employee" WHERE "id" IN (10)

^


Avatar
Discard
Best Answer

I met the same problem, but my reason because I installed module call 'is_employee', after uninstalled that, no error

Avatar
Discard
Best Answer

Billie,

It appears that your Odoo server has lost connectivity to the database.  Please make sure your database instance is running.  If not, restart the postgresql instance and try to add employee again.


Greg

Avatar
Discard