Hello,
I am using Odoo16 Enterprise edition with postgresql version 14.8
and I am facing this error.
I am looking forward to your solutions.
Thank you.
self._cr.execute(f''' File "/opt/odoo16/odoo/odoo/sql_db.py", line 321, in execute res = self._obj.execute(query, params) psycopg2.errors.UndefinedFunction: function substring(jsonb, integer, integer) does not exist LINE 2: ... select am.id,am.invoice_date as ldate, SUBSTRING(... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- 客户关系管理
- e-Commerce
- 会计
- 库存
- PoS
- Project
- MRP
此问题已终结
1
回复
4890
查看
Hi,
You have to PostgreSQL version higher than 12 for odoo 16.
Thanks
I am using the PostgreSQL version 14.8 and still I am getting the Error.
| 相关帖文 | 回复 | 查看 | 活动 | |
|---|---|---|---|---|
|
1
5月 25
|
2458 | ||
|
1
4月 25
|
3475 | ||
|
1
4月 25
|
4304 | ||
|
1
4月 25
|
1780 | ||
|
4
3月 25
|
6892 |
