Skip to Content
Вам необхідно зареєструватися, щоб взаємодіяти зі спільнотою.
All Posts Люди Значки
Мітки (View all)
odoo accounting v14 pos v15
Про цей форум
Це запитання позначене
1 Відповісти
100 Переглядів
Аватар
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....
Аватар
Відмінити
Аватар
Nikhil Nakrani
Найкраща відповідь

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.


Аватар
Відмінити