Skip to Content
This question has been flagged
restoredb
4 Replies
7899 Views
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
Discard
Avatar
Waleed Ali Mohsen
Best 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

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
Discard
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
Viktor Vorobjov
Best Answer

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

Avatar
Discard
Avatar
Md. Sajib Ali
Best Answer

here is video reference  you should try this 


Avatar
Discard
Avatar
iifast
Best 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 ?

Avatar
Discard
Related Posts Replies Views Activity
Odoo Database Restore Error Solved
restoredb
Avatar
Avatar
Avatar
2
Aug 24
3834
Database neutralized for testing purposes
restoredb
Avatar
Avatar
2
Feb 24
3501
Missing app icons after neutralizing database Solved
restoredb odoo18
Avatar
Avatar
1
Nov 24
1281
Restore database problem Solved
backup restoredb
Avatar
Avatar
Avatar
2
Aug 24
9686
Question about odoo.sh import database backup Solved
restoredb OdooSH
Avatar
Avatar
1
Jun 24
1394