Passa al contenuto
È necessario essere registrati per interagire con la community.
Tutti gli articoli Persone Badge
Etichette (Mostra tutto)
odoo accounting v14 pos v15
Sul forum
La domanda è stata contrassegnata
restoredb
4 Risposte
9557 Visualizzazioni
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
Abbandona
Avatar
Waleed Ali Mohsen
Risposta migliore

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
Abbandona
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
Risposta migliore

here is video reference  you should try this 


Avatar
Abbandona
Avatar
iifast
Risposta migliore

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
Abbandona
Post correlati Risposte Visualizzazioni Attività
Odoo Database Restore Error Risolto
restoredb
Avatar
Avatar
Avatar
2
ago 24
4944
Database neutralized for testing purposes
restoredb
Avatar
Avatar
2
feb 24
5550
Missing app icons after neutralizing database Risolto
restoredb odoo18
Avatar
Avatar
1
nov 24
2678
Restore database problem Risolto
backup restoredb
Avatar
Avatar
Avatar
2
ago 24
11190
Question about odoo.sh import database backup Risolto
restoredb OdooSH
Avatar
Avatar
1
giu 24
2999