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
回覆
4889
瀏覽次數
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 |
