restore database

Question

Hello there
I try to restore database from 15 version to 16 version I got this error

Database restore error: operator does not exist: character varying ->> unknown LINE 1: SELECT *, name->>'en_US' AS name FROM ir_model WHERE state =... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.

Database restore error: operator does not exist: character varying ->> unknown LINE 1: SELECT *, name->>'en_US' AS name FROM ir_model WHERE state =... ^ HIN

Waleed Ali Mohsen · Answer

You cannot restore V 15 DB to V16 because there is many changes in the DB table structure between the versions, To do that you need to upgrade the DB from 15 to 16. If you have Enterprise  subscription you can do use it to upgrade your DB and you will find more details in the below links:

Upgrade Homepage | Odoo Upgrade [1]

Upgrade — Odoo 16.0 documentation [2]
If you don't have Enterprise subscription, you can use OCA
OpenUpgrade [3]  but unfortunately the version 16 is not available yet.

No

Viktor Vorobjov · Answer

"name"->>'en_US'. That problem wrong SQL some module generate.
SELECT *, name->>'en_US' AS name FROM ir_model WHERE.

Md. Sajib Ali · Answer

here is video reference  you should try this

iifast · Answer

if I'm on version 14 community , can I upgrade to version 16 community ( not enterprise ) is that possible to jump from 14 to 16 or do I have to go through (by 15) 14->15->16 ?

関連投稿	返信	ビュー
Odoo Database Restore Error 解決済 restoredb	2 8月 24	3619
Database neutralized for testing purposes restoredb	2 2月 24	3284
Missing app icons after neutralizing database 解決済 restoredb odoo18	1 11月 24	1071
Restore database problem 解決済 backup restoredb	2 8月 24	9294
Question about odoo.sh import database backup 解決済 restoredb OdooSH	1 6月 24	1219

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！