Odoo OpenUpgrade from 14.0 to 15.0

Prepare

Set env vars.

export DATABASE=odoo
export COMPANY=mint-system
export ODOO_CURRENT_VERSION=14.0
export ODOO_TARGET_VERSION=15.0

Download the database.

odoo-backup -d $DATABASE -o tmp/$COMPANY/$DATABASE.zip ...

Checkout Odoo environment.

Start local development environment.

task checkout $ODOO_CURRENT_VERSION
task start db,native

Restore

Clear filestore and restore database.

task drop-db $DATABASE
task clear-filestore $DATABASE
odoo-restore -f tmp/$COMPANY/$DATABASE.zip

Login and check the Odoo log.

Remove Unsupported Modules > Odoo 15.0.

Upgrade

Checkout target Odoo environment.

task checkout $ODOO_TARGET_VERSION

Clone the OpenUpgrade scripts.

git clone git@github.com:OCA/OpenUpgrade.git tmp/openupgrade
cd tmp/openupgrade && git checkout $ODOO_TARGET_VERSION && git pull && ../..
sed -i -r 's/(addons_path.*)/\1,tmp\/openupgrade/' config/odoo-native.conf

Run the upgrade scripts.

source task source
./odoo/odoo-bin -d $DATABASE --config config/odoo-native.conf --update=all --stop-after-init --load=base,web,openupgrade_framework

Clear the assets and start the server.

task clear-assets $DATABASE
task start db,native

Login and check the Odoo log.

Update all modules.

task update-module $DATABASE all

Configure

Migrate custom modules.

Verify

Test the upgraded system.

Deploy

Export the database.

odoo-backup -d $DATABASE -o tmp/$COMPANY/$DATABASE-$ODOO_TARGET_VERSION.zip

Deploy the upgraded database.

odoo-restore -f tmp/$COMPANY/$DATABASE-$ODOO_TARGET_VERSION.zip -d $DATABASE -r ...

Troubleshooting

UndefinedColumn

Problem

When starting the Odoo database the following error is thrown:

UndefinedColumn: column res_company.scss_modif_timestamp does not exist

Solution

Update Web Company Color.

task init-module $DATABASE web_company_color