Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
viewsdbemployeesv13
2 Vastaukset
4114 Näkymät
Avatar
Philip Häderli

odoo 13, Ubuntu Server 18.04

the DB was exported via odoo DB Manager and imported to the new server, DB name is dap


The following commands were executed on the new server

- su - postgres

- /usr/bin/odoo -u all -d dap; takes about 30 minutes


when opening an employee in list or kanban I get the following error

Error:

Odoo Server Error


Traceback (most recent call last):

  File "/usr/lib/python3/dist-packages/odoo/api.py", line 745, in get

    value = self._data[field][record._ids[0]]

KeyError: 1154


During handling of the above exception, another exception occurred:


Traceback (most recent call last):

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1037, in __get__

    value = env.cache.get(record, self)

  File "/usr/lib/python3/dist-packages/odoo/api.py", line 751, in get

    raise CacheMiss(record, field)

odoo.exceptions.CacheMiss: ('hr.employee.public(1154,).company_id', None)


During handling of the above exception, another exception occurred:


Traceback (most recent call last):

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 624, in _handle_exception

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

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 310, in _handle_exception

    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])

  File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 14, in reraise

    raise value

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 669, in dispatch

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

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 350, in _call_function

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

  File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 94, in wrapper

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

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 339, in checked_call

    result = self.endpoint(*a, **kw)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 915, in __call__

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

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 515, in response_wrap

    response = f(*args, **kw)

  File "/usr/lib/python3/dist-packages/odoo/addons/hr_org_chart/controllers/hr_org_chart.py", line 55, in get_org_chart

    employee = self._check_employee(employee_id, **kw)

  File "/usr/lib/python3/dist-packages/odoo/addons/hr_org_chart/controllers/hr_org_chart.py", line 27, in _check_employee

    Employee.browse(employee_id).check_access_rule('read')

  File "/usr/lib/python3/dist-packages/odoo/models.py", line 3279, in check_access_rule

    invalid = self - self._filter_access_rules_python(operation)

  File "/usr/lib/python3/dist-packages/odoo/models.py", line 3348, in _filter_access_rules_python

    return self.sudo().filtered_domain(dom or [])

  File "/usr/lib/python3/dist-packages/odoo/models.py", line 5377, in filtered_domain

    data = rec.mapped(key)

  File "/usr/lib/python3/dist-packages/odoo/models.py", line 5307, in mapped

    recs = recs._mapped_func(operator.itemgetter(name))

  File "/usr/lib/python3/dist-packages/odoo/models.py", line 5266, in _mapped_func

    vals = [func(rec) for rec in self]

  File "/usr/lib/python3/dist-packages/odoo/models.py", line 5266, in <listcomp>

    vals = [func(rec) for rec in self]

  File "/usr/lib/python3/dist-packages/odoo/models.py", line 5731, in __getitem__

    return self._fields[key].__get__(self, type(self))

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 2366, in __get__

    return super().__get__(records, owner)

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1044, in __get__

    recs._fetch_field(self)

  File "/usr/lib/python3/dist-packages/odoo/models.py", line 2994, in _fetch_field

    self._read(fnames)

  File "/usr/lib/python3/dist-packages/odoo/models.py", line 3066, in _read

    cr.execute(query_str, params)

  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 173, in wrapper

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

  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 250, in execute

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

psycopg2.errors.InsufficientPrivilege: permission denied for view hr_employee_public

Avatar
Hylkää
Avatar
Philip Häderli
Tekijä Paras vastaus

all DB deleted on the server

Execute the following commands in the ADDONS directory

pwd */odoo/addons

chown -R postgres:postgres *

chmod 755 *

find. -type f -iname__*.py -exec chmod 664 {} \;


then DB exported on the old server and imported to the new server.

had no error message when I edited employee entries!

Avatar
Hylkää
Avatar
Ermin Trevisan
Paras vastaus

When copying Odoo addons to an instance, this is what I do (you may adapt the addons path):

sudo chown -R root:odoo /usr/lib/python3/dist-packages/odoo/custom/addons/
sudo find /usr/lib/python3/dist-packages/odoo/custom/addons/ -type d -exec chmod 755 {} \;
sudo find /usr/lib/python3/dist-packages/odoo/custom/addons/ -type f -exec chmod 644 {} \;

 Directories should be 755, files 644.

Avatar
Hylkää
Philip Häderli
Tekijä

thanks for specifying the command.

Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
attributes construct error
views employee company_id v13
Avatar
Avatar
1
marrask. 21
6594
Employees without Email Ratkaistu
employees
Avatar
Avatar
1
marrask. 25
2381
Select multiple elements with XPath Ratkaistu
views
Avatar
Avatar
Avatar
Avatar
Avatar
5
elok. 24
48522
E-Mail "Branding" in Odoo 13? How to remove Powered by / Sent by Odoo?
v13
Avatar
Avatar
Avatar
2
kesäk. 24
6330
Error login LinkedIn v13 enterprise
v13
Avatar
Avatar
2
maalisk. 24
1881