Pathologic relative path on multisite

Question

Old multisite subsite relative path to image (in block/Full HTML with CKeditor and on localhost/XAMPP):

/sites/site1.localhost/files/image.png

New multisite path (what I'm trying to achieve):

/sites/site2.localhost/files/image.png

So, in Full HTML input settings for Pathologic, we select the 3rd option Relative path and add lines:

/sites/site1.localhost/
/sites/site2.localhost/

And nothing happpens, it just strips the /sites/site1.localhost/ from path and now the path to image is just:

/files/image.png

How do I make it the /sites/site2.localhost/?

Optimus Prime · Accepted Answer · 2016-02-27 09:49:22Z

Solved running SQL query in phpMyAdmin

UPDATE field_data_body  SET body_value = REPLACE(body_value,'src="/olddirectory','src="/newdirectory');

1 Answer 1