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

Odoo Version 8 - Adding Employees

By
Billie Mead
on 4/3/15, 10:14 AM 821 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)

^


0
Alan Luo
On 5/29/15, 5:17 AM

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

0
Gregory Dover
On 4/3/15, 10:21 AM

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

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

2 follower(s)

Stats

Asked: 4/3/15, 10:14 AM
Seen: 821 times
Last updated: 5/29/15, 5:17 AM