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.
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 install-module $DATABASE web_company_color