Zum Inhalt springen
Menü
Sie müssen registriert sein, um mit der Community zu interagieren.
Diese Frage wurde gekennzeichnet
2 Antworten
3983 Ansichten

i backup db from odoo 15 and restored it in odoo 16 ..

At the time of restoring it gives error as follows

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.

Avatar
Verwerfen
Beste Antwort

Hi,

You cannot restore V 15 DB to V16 because there are many changes in the DB table structure between the versions.

You need to migrate your database 

If you are using Enterprise Edition 

Create an upgrade request to v16 migration

https://upgrade.odoo.com/

if you are using the community edition use Openupgrade scripts 

https://www.odoo.com/documentation/16.0/administration/upgrade.html

https://github.com/OCA/OpenUpgrade

Regards

Avatar
Verwerfen
Autor Beste Antwort

Thanks a million.

But in my case, i'm using docker for handling odoo and postgres

Avatar
Verwerfen
Verknüpfte Beiträge Antworten Ansichten Aktivität
3
Feb. 25
13692
6
Juni 25
14665
1
Apr. 24
2107
1
Mai 25
2410
1
Apr. 25
3426