Migration from 5.4 to 5.6

Migration
1

Must

  • [SQL] update project status based on previous state

     UPDATE project_work SET status = db_id FROM ir_model_data WHERE module = 'project' AND fs_id = 'work_open_status' AND state = 'opened';
 UPDATE project_work SET status = db_id FROM ir_model_data WHERE module = 'project' and fs_id = 'work_done_status' AND state = 'done';

  • [SQL] before update, the foreign key of shipment_party of sale amendment must be recreated

    ALTER TABLE sale_amendment_line DROP CONSTRAINT sale_amendment_line_shipment_party_fkey;

  • [XML] Editable attribute of xml files is now of boolean type.

    <tree editable="1">

:arrow_forward: Migration from 5.6 to 5.8

2

Just to add:

For tree view with editable=“bottom” or editable=“top” are need to change to editable=“1”, else it will give compile error when update

3

A post was split to a new topic: How to apply SQL query on docker

4

The Company Administration and Employee Administration groups have been added. The access rights associated with these new groups were previously granted by the Party Administration group. In order to keep their access to Company and Employee views/forms/menus/data, the users belonging to the Party Administration group must be added to the new groups.

5

Since rev461aca9ea143 the previous production requests would not be deleted because don’t have origin ‘stock.order_point’ to solve this only the requests can be deleted:
delete from production where state = 'request';