Перейти к содержимому
Чтобы взаимодействовать с сообществом, необходимо зарегистрироваться.
Все посты Люди Значки
Теги (Смотреть все)
odoo accounting v14 pos v15
Об этом форуме
Этот вопрос был отмечен
1 Ответить
103 Представления
Аватар
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.


Аватар
Отменить