Problem: FILESTORE::DIR_ROOT: how change it for all?

for many files and images my host changed my account path (I can't go back) so now I have a lot of files with a FILESTORE::DIR_ROOT in database started with


and my new path is 


how can I change path for all? is there a query that I can run for all files/images/any others?

  • UPDATE elgg_metastrings set string = '/mounted-storage/home75a/' WHERE id = (SELECT value_id from elgg_metadata where name_id = (SELECT * FROM (SELECT id FROM elgg_metastrings WHERE string = 'filestore::dir_root') as ms2) LIMIT 1) ;


    is this one correct?

  • I used this query succesfully to update the path of the filestore. I don't know how this path change wasn't taken into account. Maybe is a problem with old Filestore code?