Skip to main content


I have some files (photos) in #Wordpress that somehow have a faulty file URL and I would like to change these URLs.
The wrong URL looks like this:
https://blog.utzer.de/wp-content//srv/www/vhosts/utzer.de/subdomains/blog/httpdocs/wp-content/2008/10/...

The correct one should look like this:
https://blog.utzer.de/wp-content/2008/10/... (this is also where the file actually is)

Can anyone tell me how to manually change this file URL?
@utzer [Friendica] It looks like your Wordpress configuration is wrong, the full install path is present in the relative path from the domain which should be empty in your case. Check the "WordPress Address (URL)" and the "Site Address (URL)" fields, they both should contains https://blog.utzer.de only.
@utzer [Friendica] @Alex Standiford :wordpress: A simple UPDATE table SET field = REPLACE(field, '/var/…', '') should be enough once you have located the relevant table/field holding the media records.
This entry was edited (1 year ago)