时间戳

首页 > 解决方案 > ProgrammingError：关系“hr_expense_id_seq”不存在。Odoo 10.0

python - ProgrammingError：关系“hr_expense_id_seq”不存在。Odoo 10.0

问题描述

尝试在 odoo 版本 10.0 中验证或提交新费用时，我收到以下错误。

此线程在 Odoo 论坛中表达

Traceback (most recent call last):
  File "/home/gloxon/odoo/http.py", line 642, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/home/gloxon/odoo/http.py", line 684, in dispatch
    result = self._call_function(**self.params)
  File "/home/gloxon/odoo/http.py", line 334, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/home/gloxon/odoo/service/model.py", line 101, in wrapper
    return f(dbname, *args, **kwargs)
  File "/home/gloxon/odoo/http.py", line 327, in checked_call
    result = self.endpoint(*a, **kw)
  File "/home/gloxon/odoo/http.py", line 942, in __call__
    return self.method(*args, **kw)
  File "/home/gloxon/odoo/http.py", line 507, in response_wrap
    response = f(*args, **kw)
  File "/home/gloxon/addons/web/controllers/main.py", line 892, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/home/gloxon/addons/web/controllers/main.py", line 884, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/home/gloxon/odoo/api.py", line 687, in call_kw
    return call_kw_model(method, model, args, kwargs)
  File "/home/gloxon/odoo/api.py", line 672, in call_kw_model
    result = method(recs, *args, **kwargs)
  File "/home/gloxon/addons/mail/models/mail_thread.py", line 228, in create
    thread = super(MailThread, self).create(values)
  File "/home/gloxon/odoo/models.py", line 3847, in create
    record = self.browse(self._create(old_vals))
  File "/home/gloxon/odoo/models.py", line 3942, in _create
    cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
  File "/home/gloxon/odoo/sql_db.py", line 154, in wrapper
    return f(self, *args, **kwargs)
  File "/home/gloxon/odoo/sql_db.py", line 231, in execute
    res = self._obj.execute(query, params)
ProgrammingError: relation "hr_expense_id_seq" does not exist
LINE 1: ...uid", "create_date", "write_date") VALUES(nextval('hr_expens...

我不知道该怎么做才能解决这个问题。

标签： pythonodooodoo-10

解决方案

我在 Odoo 12 CE 中遇到过类似的缺失序列的情况。事实证明，我正在将 Postgres 10.10 中的数据库转储恢复到 Postgres 9.6 中，但它们彼此不喜欢。

解决方案是安装 Postgres 10.10，在那里恢复数据库并重新启动 Odoo。

推荐阅读