Error when updating the database, table tx_nG6_result
When trying to update some filepaths, I made the following mistake:
UPDATE tx_nG6_result
SET rvalue = REPLACE(rvalue, '/data_get/', '/data_seqoccin/');
Instead of:
UPDATE tx_nG6_result
SET rvalue = REPLACE(rvalue, '/data_get/', '/data_seqoccin/')
WHERE analyze_id = 77699;
Result:
All the analysis filepaths were wrong for projects in the longterm_get space.