RunStats image paths are wrong for A2P1b-PlaGe-Caille
Even after the migration, the filepaths are still '/data_shortterm/' instead of '/data_seqoccin/'.
TODO:
UPDATE tx_nG6_result
SET rvalue = REPLACE(rvalue, '/data_shortterm/', '/data_seqoccin/')
WHERE analyze_id IN (
SELECT analyze_id FROM tx_nG6_run_analyze WHERE run_id IN (
SELECT run_id FROM tx_nG6_project_run WHERE project_id = xxx
)
);
UPDATE tx_nG6_result
SET rvalue = REPLACE(rvalue, '/data_shortterm/', '/data_seqoccin/')
WHERE analyze_id IN (
SELECT analyze_id FROM tx_nG6_project_analyze WHERE project_id = xxx
);
Edited by Romain Therville