Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
1 Odpowiedz
112 Widoki
Awatar
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....
Awatar
Odrzuć
Awatar
Nikhil Nakrani
Najlepsza odpowiedź

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.


Awatar
Odrzuć