Image Hotlink Issues
-
Hi, back in 2014 I migrated from wordpress.com to self-hosted. I have noticed that many of the images in the posts migrated are still ‘hotlinked’ back to the domain.files.wordpress.com location.
Could someone help me with the following?
1. Can you help me write an SQL query I can use in PHPMyAdmin to pull a list of the posts/pages which have the string ‘eyecandypopper.files.wordpress.com’? This way I will be able to go through and adjust them manually if there is no quick way to do this. Here is an example post with images pointing to the wrong source http://www.eyecandypopper.com/cutest-farmers-market-table/
2. Is there some way to fix this (without a plugin ideally)? The images do exist on my self-hosted domain, is there an SQL query I could use to change the string ‘eyecandypopper.files.wordpress.com’ to just ‘www.eyecandypopper.com?
3. I also noticed that many of the old posts have images that still have a link in them, but when you click on the image it takes you to a page devouted to that image, as opposed to just displaying the image. How can I stop this? I just want all my posts to be like the ‘standard’ ones where the images have no link behind them. Here is an example of a post where the image is linked to an image ‘page’ http://www.eyecandypopper.com/multigrain-chocolate-chip-cookies-dairy-free/Thanks for the suggestions!
The blog I need help with is: (visible only to logged in users)
-
When we need Staff help with issues Volunteers cannot resolve like this one we type modlook into the sidebar tags on our forum threads. I did that for you. How do I get a Moderator/Staff reply for my question? https://en.support.wordpress.com/getting-help-in-the-forums/#how-do-i-get-a-moderatorstaff-reply-for-my-question Then we subscribe to this thread so we are notified when they respond. To subscribe look in the sidebar of this thread, find the subscribe to topics link and click it.
-
Hi there,
We’re not able to help with this issue on a self-hosted site. For something like an SQL query the users in the self-hosted forums are in a much better position to help you:
https://wordpress.org/support/
If you know how to use the command line interface in WordPress you might also be able to do this with a search-and-replace script, but again it’s better to get help with that from users who are experienced in doing that. Most users and staff in the WordPress.com forum, including me, only have experience with the WordPress.com version of WordPress, where making changes directly in the database is not possible at all.
3. I also noticed that many of the old posts have images that still have a link in them, but when you click on the image it takes you to a page devouted to that image, as opposed to just displaying the image.
This is a setting in the post editor in WP-Admin. If you click on an image in the editor and then click the edit button you’ll see an overlay with setting for the image. One of those are the image link settings. It sounds like you have some images set to the Attachment Page option instead of the Image URL option.
The way the editor is designed (on both WordPress.com and self-hosted) it remembers the last used setting and applies it automatically on subsequent images, so at one point you must have selected that option. I don’t know of any way to update that automatically across your site, so you’ll need to edit each post individually to update those images. However, the users in the self-hosted forum might know of a way to do this.
- The topic ‘Image Hotlink Issues’ is closed to new replies.
WordPress.com Forums 