Skip to Content
Menu
This question has been flagged
4 Replies
11525 Views

Hi! I'm using Odoo 11 community version. It's running on Windows 10, and now I want to upgrade to Odoo 12 or 13. I was looking for some tutorial to make the upgrade, and I found some information, but things are not clear for me:

1.- I deduced I have to make a new installation of Odoo 12 or 13, create a backup from v11 database and then restore it (or import) into new Odoo installation.

2.- Database upgrade can be performed at https://upgrade.odoo.com/database/upload , but only for enterprise version, I suppose, so I can't use it. There is also a Github OpenUpgrade project to upgrade database, but I don't know how to install and use it (my Oddo is a windows version).

Can somebody tell me if I'm right about the main procedure, and if so how to use OpenUpgrade project to upgrade my Odoo 11 database in Windows? Thank you very much in advance!


Avatar
Discard
Best Answer

If you are not using any custom modules then you could use:
https://github.com/OCA/OpenUpgrade  

(there is no script for v13 yet)

In general, you need to migrate the custom modules and then migrate the data. For modules please see the following:
https://github.com/OCA/maintainer-tools/wiki/Migration-to-version-13.0
for data it is up to you - you can do db -> db migration using scripts so they will copy the records from old db and paste into new or export from old one and import to the new one manually (please note that this may not work in some cases)


Edit:
1) Please note that OCA does not work with all stock modules yet so you can contribute, support them or only migrate what is possible at the moment (you can for example remove not migrated modules and install on the latest Odoo version and migrate missing data by hand)
2) OCA script is not an Odoo module - you have to run it from the command line on your server

Avatar
Discard

Hey Piotr,

I'm trying to upgrade version 12 to version 13. I have custom one custom module, which I already migrated. So right now I need only to migrate the data from v12 to v 13. I'm using OpenUpgrade for version 13 where I'm restoring a db backed up from the v12 that I have.

Once the migration start I have the following errors in the console:

2020-07-07 23:53:56,217 20996 ERROR ll odoo.modules.loading: Some modules are not loaded, some dependencies or manifest may be missing: ['account', 'account_bank_statement_import', 'account_facturx', 'decimal_precision', 'delivery', 'delivery_hs_code', 'digest', 'event_sale', 'l10n_generic_coa', 'l10n_multilang', 'l10n_us', 'mass_mailing_sale', 'payment', 'payment_transfer', 'preyah_custom', 'procurement_jit', 'sale', 'sale_management', 'sale_stock', 'sms', 'snailmail_account', 'stock_account', 'sw_shop_style', 'web_settings_dashboard', 'website_event_sale', 'website_event_snippet_calendar', 'website_payment', 'website_sale', 'website_sale_delivery', 'website_sale_link_tracker', 'website_sale_management', 'website_sale_stock']

2020-07-07 23:53:56,709 20996 INFO ll odoo.modules.loading: Modules loaded.

2020-07-07 23:53:56,778 20996 INFO ll odoo.service.db: RESTORE DB: ll

2020-07-07 23:53:56,782 20996 INFO ll werkzeug: 127.0.0.1 - - [07/Jul/2020 23:53:56] "POST /web/database/restore HTTP/1.1" 303 - 48 0.623 9.805

2020-07-07 23:53:56,823 20996 INFO ll odoo.addons.base.models.ir_http: Generating routing map for key 1

2020-07-07 23:53:56,825 20996 ERROR ll odoo.sql_db: bad query: SELECT "website_rewrite".id FROM "website_rewrite" WHERE ((("website_rewrite"."active" = true) AND ("website_rewrite"."redirect_type" in ('308','404'))) AND ("website_rewrite"."website_id" IS NULL OR ("website_rewrite"."website_id" = 1))) ORDER BY "website_rewrite"."id"

ERROR: relation "website_rewrite" does not exist

LINE 1: SELECT "website_rewrite".id FROM "website_rewrite" WHERE (((...

Can you please tell me what I'm doing wrong ?

I do not have so many data in the v12. Actually is a test version that I have made some minor changes in the data - added some translations and 3 products in ht ecommerce module. (The installed modules in the v12 are basically website, ecommerce and events).

Can you please help ?

Best Answer

Hi Fernando,

I'm working like you with a Odoo CE in Windows without custom modules.

Could you do the migration?


Thanks in advance

Avatar
Discard
Author Best Answer

Thank you very much, Piotr.

I'm not using any custom modules, so I don't need to migrate them.

My question is... how to use OpenUpgrade to migrate DB? I have to install it as a module into my old Odoo 11 installation to use it? If so, how can I do it? Or how to install & use it?  

Avatar
Discard