Skip ke Konten
Pertanyaan ini telah diberikan tanda
restoredb
4 Replies
9626 Tampilan
Avatar
Hawari Alzain

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 =... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.


can you advice please

Avatar
Buang
Avatar
Waleed Ali Mohsen
Jawaban Terbai

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

Upgrade — Odoo 16.0 documentation

If you don't have Enterprise subscription, you can use OCA  OpenUpgrade but unfortunately the version 16 is not available yet.


Note: The Odoo Enterprise upgrade to Odoo 16 is not available for production. 

Avatar
Buang
Robert Förster

Also - if you are running into this error when trying to import a v15 database to your v15 Instance like me. Double check if there is no v16 running concurrently that is blocking the server-ports - that had cost me a lot of time to figure out ;-).

Avatar
Md. Sajib Ali
Jawaban Terbai

here is video reference  you should try this 


Avatar
Buang
Avatar
iifast
Jawaban Terbai

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 ?

Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
Odoo Database Restore Error Diselesaikan
restoredb
Avatar
Avatar
Avatar
2
Agu 24
5000
Database neutralized for testing purposes
restoredb
Avatar
Avatar
2
Feb 24
5627
Missing app icons after neutralizing database Diselesaikan
restoredb odoo18
Avatar
Avatar
1
Nov 24
2734
Restore database problem Diselesaikan
backup restoredb
Avatar
Avatar
Avatar
2
Agu 24
11239
Question about odoo.sh import database backup Diselesaikan
restoredb OdooSH
Avatar
Avatar
1
Jun 24
3101