跳至内容
菜单
此问题已终结
1 回复
3520 查看

I just installed ODOO community version. 

Everything seems okay, but I cannot install app. When I attempted to install EMPLOYEE APP I got the following error. Any help will be appreciated. Thanks

Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/http\.py",\ line\ 1584,\ in\ _serve_db
\ \ \ \ return\ service_model\.retrying\(self\._serve_ir_http,\ self\.env\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/service/model\.py",\ line\ 134,\ in\ retrying
\ \ \ \ result\ =\ func\(\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/http\.py",\ line\ 1613,\ in\ _serve_ir_http
\ \ \ \ response\ =\ self\.dispatcher\.dispatch\(rule\.endpoint,\ args\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/http\.py",\ line\ 1810,\ in\ dispatch
\ \ \ \ result\ =\ self\.request\.registry\['ir\.http'\]\._dispatch\(endpoint\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_http\.py",\ line\ 149,\ in\ _dispatch
\ \ \ \ result\ =\ endpoint\(\*\*request\.params\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/http\.py",\ line\ 699,\ in\ route_wrapper
\ \ \ \ result\ =\ endpoint\(self,\ \*args,\ \*\*params_ok\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/web/controllers/dataset\.py",\ line\ 46,\ in\ call_button
\ \ \ \ action\ =\ self\._call_kw\(model,\ method,\ args,\ kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/web/controllers/dataset\.py",\ line\ 33,\ in\ _call_kw
\ \ \ \ return\ call_kw\(request\.env\[model\],\ method,\ args,\ kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/api\.py",\ line\ 461,\ in\ call_kw
\ \ \ \ result\ =\ _call_kw_multi\(method,\ model,\ args,\ kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/api\.py",\ line\ 448,\ in\ _call_kw_multi
\ \ \ \ result\ =\ method\(recs,\ \*args,\ \*\*kwargs\)
\ \ File\ "",\ line\ 2,\ in\ button_immediate_install
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_module\.py",\ line\ 76,\ in\ check_and_log
\ \ \ \ return\ method\(self,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_module\.py",\ line\ 491,\ in\ button_immediate_install
\ \ \ \ return\ self\._button_immediate_function\(type\(self\)\.button_install\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/addons/base/models/ir_module\.py",\ line\ 615,\ in\ _button_immediate_function
\ \ \ \ registry\ =\ modules\.registry\.Registry\.new\(self\._cr\.dbname,\ update_module=True\)
\ \ File\ "",\ line\ 2,\ in\ new
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/func\.py",\ line\ 87,\ in\ locked
\ \ \ \ return\ func\(inst,\ \*args,\ \*\*kwargs\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/modules/registry\.py",\ line\ 90,\ in\ new
\ \ \ \ odoo\.modules\.load_modules\(registry,\ force_demo,\ status,\ update_module\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/modules/loading\.py",\ line\ 487,\ in\ load_modules
\ \ \ \ processed_modules\ \+=\ load_marked_modules\(cr,\ graph,
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/modules/loading\.py",\ line\ 371,\ in\ load_marked_modules
\ \ \ \ loaded,\ processed\ =\ load_module_graph\(
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/modules/loading\.py",\ line\ 207,\ in\ load_module_graph
\ \ \ \ registry\.init_models\(cr,\ model_names,\ \{'module':\ package\.name\},\ new_install\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/modules/registry\.py",\ line\ 535,\ in\ init_models
\ \ \ \ self\.check_indexes\(cr,\ model_names\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/modules/registry\.py",\ line\ 596,\ in\ check_indexes
\ \ \ \ sql\.create_index\(cr,\ indexname,\ tablename,\ \[expression\],\ method,\ where\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/tools/sql\.py",\ line\ 290,\ in\ create_index
\ \ \ \ cr\.execute\(f'CREATE\ INDEX\ "\{indexname\}"\ ON\ "\{tablename\}"\ USING\ \{method\}\ \(\{args\}\)\{where\}'\)
\ \ File\ "/usr/lib/python3/dist\-packages/odoo/sql_db\.py",\ line\ 313,\ in\ execute
\ \ \ \ res\ =\ self\._obj\.execute\(query,\ params\)
psycopg2\.errors\.UndefinedFunction:\ function\ jsonb_path_query_array\(jsonb,\ unknown\)\ does\ not\ exist
LINE\ 1:\ \.\.\.INDEX\ "hr_job_name_index"\ ON\ "hr_job"\ USING\ gin\ \(\(jsonb_path\.\.\.
\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \^
HINT:\ \ No\ function\ matches\ the\ given\ name\ and\ argument\ types\.\ You\ might\ need\ to\ add\ explicit\ type\ casts\.


The\ above\ server\ error\ caused\ the\ following\ client\ error:
RPC_ERROR:\ Odoo\ Server\ Error
\ \ \ \ at\ makeErrorFromResponse\ \(http://45\.33\.198\.6:8069/web/assets/34\-7a5d6ad/web\.assets_backend\.min\.js:967:163\)
\ \ \ \ at\ XMLHttpRequest\.\ \(http://45\.33\.198\.6:8069/web/assets/34\-7a5d6ad/web.assets_backend.min.js:975:13)

形象
丢弃
编写者

Thank you so much for your advise. I have corrected my mistake. I tried to use postgre 10 with the latest ODOO. That was the source of my trouble. Thanks for correcting me. Cheers.

最佳答案

Hi,

You have to use PostgreSQL 12 or above for Odoo version 16. Seems you are using postgres version less than 12 and thus you are receiving this error.


Odoo 16 Installation


Thanks

形象
丢弃
相关帖文 回复 查看 活动
5
12月 19
6577
2
4月 17
7197
1
3月 15
4659
2
2月 24
1148
1
8月 23
2669