Hi All,
I am trying to migrate my Odoo sh from Odoo 16 to Odoo 18, using the test upgrade button, while the migration process i get an error
2025-12-17 14:30:22,014 23 WARNING db_3587520 odoo.upgrade: New computed-stored field fleet.vehicle/vehicle_properties computed on 118627 records. Please consider writing an upgrade script. In a `pre-` script, use `util.create_column(cr, "fleet_vehicle", "vehicle_properties", "jsonb")` then (1) Fill the value in SQL using `util.explode_execute(cr, query)` (2) Alternatively, you can, in a `post-` or `end-` script, use `util.recompute_fields(cr, "fleet.vehicle", ["vehicle_properties"])` More info: https://www.odoo.com/r/upgrade-no-orm
What my question is that,
1- How do i solve this?
2 - To solve this where do i write this script?
3 - Since fleet is an existing module by Odoo , can i write the script?
Looking forward to your best answers....
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- 会計
- 在庫
- PoS
- プロジェクト
- MRP
この質問にフラグが付けられました
1
返信
102
ビュー
Hi User,
I hope you are doing well.
Please open a Ticket with Odoo Support:
https://www.odoo.com/help-form
In Odoo 18, the fleet.vehicle model has a stored computed field named vehicle_properties.
During upgrade, Odoo needs to (re)create the DB column and fill/recompute values. On big tables, this can be heavy.
Odoo suggests you:
- Pre‑create the DB column (jsonb) in a pre‑migration step.
- Fill it via SQL (fast path) or recompute after modules load
so that process from odoo side becuase you are upgrading on odoo.sh platform so just report issue.
