Can cause issue if two tracker have the same label

[jan-henssler-intland]

custom-development/sql_scripts/field_index_report_and_fix.sql

Line 760 in b163fee

UPDATE object SET reference_id = (SELECT newlabelId from field_index_fix_log WHERE oldlabelId = fieldIndex) WHERE type_id = 25 AND parent_id = trackerId AND reference_id = fieldIndex;

custom-development/sql_scripts/field_index_report_and_fix.sql

Line 822 in b163fee

select NEWLABELID INTO new_field_id from FIELD_INDEX_FIX_LOG where OBJECT_TYPE = 'Field Index Change' AND OLDLABELID = nextField;

Please add the start_tracker_id as an additional attribute. Current query can have double or more results. It is not precise enough
(SELECT newlabelId from field_index_fix_log WHERE oldlabelId = fieldIndex AND tracker_id = start_tracker_id)