OCA / operating-unit

Manage Operating Units in Odoo
GNU Affero General Public License v3.0
72 stars 237 forks source link

[15.0][FIX] stock_operating_unit: migration script to 15.0 #590

Closed AaronHForgeFlow closed 1 year ago

AaronHForgeFlow commented 1 year ago

Solves this issue:

2023-05-23 07:40:10,881 1 INFO mydb odoo.modules.migration: module stock_operating_unit: Running migration [>15.0.1.0.0] pre-migration 
2023-05-23 07:40:10,882 1 ERROR mydb odoo.sql_db: bad query: 
        UPDATE stock_quant
        SET operating_unit_id = sl.operating_unit_id
        FROM stock_location sl
        WHERE sl.id=location_id AND sl.operating_unit_id IS NOT NULL;

ERROR: column reference "location_id" is ambiguous
LINE 5:         WHERE sl.id=location_id AND sl.operating_unit_id IS ...
AaronHForgeFlow commented 1 year ago

/ocabot merge nobump

OCA-git-bot commented 1 year ago

This PR looks fantastic, let's merge it! Prepared branch 15.0-ocabot-merge-pr-590-by-AaronHForgeFlow-bump-nobump, awaiting test results.

OCA-git-bot commented 1 year ago

Congratulations, your PR was merged at 4d38753485dffa5162d54d5b300113bb7ae37d25. Thanks a lot for contributing to OCA. ❤️