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
- Boekhouding
- Voorraad
- PoS
- Project
- MRP
Deze vraag is gerapporteerd
1
Beantwoorden
111
Weergaven
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.
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
Aanmelden