If you can do SQL manually then try:
UPDATE wp_posts p INNER JOIN wp_posts q ON p.post_type="attachment" AND p.post_mime_type LIKE 'image/%' AND (p.post_title IS NULL OR LENGTH(p.post_title) = 0) AND p.post_parent = q.ID SET p.post_title = q.post_title;
If you need a PHP function then try:
function set_image_without_title_to_post_title() { global $wpdb; $sql = sprintf( "UPDATE %s p INNER JOIN %s q " . "ON p.post_type="attachment" AND p.post_mime_type LIKE 'image/%%' " . "AND (p.post_title IS NULL OR LENGTH(p.post_title) = 0) " . "AND p.post_parent = q.ID " . "SET p.post_title = q.post_title", $wpdb->posts, $wpdb->posts ); $wpdb->get_results( $sql, ARRAY_A ); }
WARNING: As this will make massive changes to your database I would do a backup first!
I did run a small test and it appears to be correct but USE AT YOUR OWN RISK!
Related Posts:
- Upload images to remote server
- How to delete resized (cropped) image uploads and prevent future resizing?
- What’s the proper way to find and remove duplicate images from posts and the media library?
- Separate Media Library for each user
- Why is wp_get_attachment_image_src not working with my custom size (add_image_size)
- Images dont show in grid view, but do in list view
- How can I hide media library images from general users?
- How to rename an image attachment filename using php
- Remove duplicate images from media library.
- Use Media Library to manage galleries like Nextgen (with folders, albums, collections, tags, categories, terms…)
- WordPress function: limit size, only jpg, jpeg, limit of uploaded files per account
- Cannot access the thumbnails of attachment images… Cannot find the reason
- Why would image paths in wordpress suddenly change?
- Import Images from one self-hosted WordPress install to another
- Uploading images to Media Library fails with Memory Exhausted
- Why can’t I edit certain images from the WordPress Media library?
- Edit image preview is not displayed
- Uploading images: ‘ø’ get replaced with ‘ø’
- Regenerate missing _wp_attachment_metadata
- Upload thousands of images to WordPress without plugin?
- Best way to strip character entities (%20 etc)
- Different upload path per file type
- Display latest 12 images from media library
- Images are randomly deleted from server
- Get full image array
- HTTP Error when uploading files above 7mb unless using GD Image Editor
- Consolidating two websites into one, but migrated images not appearing in Image Library
- wordpress media library shows empty images
- Check if the image exists in WordPress media library
- unattached media files that should be attached
- How to output images as figure/figcaption
- Bulk edit of EXIF data for jpeg images uploaded in the media library?
- offload media to external services [closed]
- How to upload images in a specific folder using API
- AJAX – save an $_FILES picture in media library
- In Wordress one author can not see the other’s author uploaded images through media library
- How to open default wp image editor screen dynamically?
- How to prevent WordPress scaling large images down
- Is it possible to split Default WP Media directory to multiple Folder/Subdomain?
- Searching for any images in media library displays “no media found”
- How to get file URL from media library
- Images uploaded to the media library has strange colors. However, in the edit screen the color is ok
- Change media URL (images)
- Alter image meta fields in the Media Library
- Add custom text in the media library image meta area
- How to add images to a post without inserting them into the content area of the post editor?
- Unable to upload images to the Media Library. Getting this erron on the console wp-admin/async-upload.php 403 (Forbidden)
- What happened to the media manger?
- Why does WP allow to view and media item as a page
- Images are not showing up in “Uploaded to this post”
- Create a post from every image in my media gallery
- Images don’t update after being edited
- Is there a way in WordPress to convert images to WebP without a plugin?
- Change Image folder Locations
- Rebuild thumbnails via WP Cli – how?
- Auto delete pictures in media library by age
- Images not showing in media grid view (but showing in list view)
- Some Images Disappeared from Media Library?
- are unattached media files a problem?
- WordPress Attachments with old images
- How to get the title of the random images from media library?
- Large image not showing dimensions in Media Library
- How to change the value “uploaded to” in the media library (WordPress 4.0)
- Function to grab specific image IDs from media library.
- Fetching uploaded images using Link URL
- How can i sorting and display image order by siz in media library?
- Allow wp media library to check already selected images displayed in div
- WordPress append -1 to the image name
- Custom Image Widget
- Media Library Cleanup A Thought Exercise
- Do I need to re-register all my images in the media library after a migration?
- Could creation of various image sizes cause slow form submission response?
- unsharp thumbnails after uploading image
- imported post image as normal image instead encoded image
- still need help-images inside wp-content/ uploads/ are not showing up in my media library and uploaded using FTP protocol
- The image keep redirect to my previous URL after I moving my site
- WordPress Link To Image Missing Dropdown
- After moving a site to new hosting, not all images are showing in media library
- How to handle a lot of media files in the uploads folder? (+10.000)
- Edit image itself
- add titles to images in ad media in pages and posts
- Change the image for a certain URL
- Assign one featured image to multiple posts?
- Some images don’t get linked when setting link-to to media-image
- Missing Images in Uploads Directory (Server Only)
- How do I embed an image at actual size?
- Image media upload problem in page editing modus?
- Broken Media Library
- Transfered live site to new server and images are not showing
- Limit files uploaded per folder
- My image rotate 90 degree
- Media Library is not loading on grid view in admin panel
- Remote Image (from URL) as Media Library element
- WordPress can’t get image url but both the attachment and the actual file are there
- Why some images are not allowed to be edited only for thumbnails?
- What does WordPress media uploader do to image files on upload?
- Media Library shows default image instead of image preview
- Images have dissapeared from media library and site
- Is there a way to upscale a media library original image to the nearest whole pixel in WordPress?
- How to make Media Library files private?