Se rendre au contenu
Cette question a été signalée
restoredb
4 Réponses
9508 Vues
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
Ignorer
Avatar
Waleed Ali Mohsen
Meilleure réponse

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
Ignorer
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
Meilleure réponse

here is video reference  you should try this 


Avatar
Ignorer
Avatar
iifast
Meilleure réponse

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
Ignorer
Publications associées Réponses Vues Activité
Odoo Database Restore Error Résolu
restoredb
Avatar
Avatar
Avatar
2
août 24
4904
Database neutralized for testing purposes
restoredb
Avatar
Avatar
2
févr. 24
5453
Missing app icons after neutralizing database Résolu
restoredb odoo18
Avatar
Avatar
1
nov. 24
2620
Restore database problem Résolu
backup restoredb
Avatar
Avatar
Avatar
2
août 24
11142
Question about odoo.sh import database backup Résolu
restoredb OdooSH
Avatar
Avatar
1
juin 24
2941