Problem: FILESTORE::DIR_ROOT: how change it for all?
By lord55
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
/mounted-storage/home74a/
and my new path is
/mounted-storage/home75a/
how can I change path for all? is there a query that I can run for all files/images/any others?
Elgg Technical Support
Get support from other Elgg users
- lord55@lord55
lord55 - 0 likes
- adayth@felfo
adayth - 0 likes
You must log in to post replies.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?