Skip to Content
This question has been flagged
1 Reply
78 Views
Avatar
user 
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....
Avatar
Discard
Avatar
Nikhil Nakrani
Best Answer

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:

  1. Pre‑create the DB column (jsonb) in a pre‑migration step.
  2. 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.


Avatar
Discard