Media Library it doesn’t show any of the uploaded images after updating wordpress 6.6.2

After a thorough inspection of the database, i saw that the post_type for the images had changed to “post” instead of “attachment“.

The solution Update Post mime type from “post_status = inherit” sql:

// Mime type – img/jpeg
UPDATE wp_posts SET post_type = ‘attachment’ WHERE wp_posts.post_status = ‘inherit’ and wp_posts.post_mime_type = ‘image/jpeg’;

// Mime type – img/png
UPDATE wp_posts SET post_type = ‘attachment’ WHERE wp_posts.post_status = ‘inherit’ and wp_posts.post_mime_type = ‘image/png’;

// Mime type – img/webp
UPDATE wp_posts SET post_type = ‘attachment’ WHERE wp_posts.post_status = ‘inherit’ and wp_posts.post_mime_type = ‘image/webp’;

// Mime type – video/mp4
UPDATE wp_posts SET post_type = ‘attachment’ WHERE wp_posts.post_status = ‘inherit’ and wp_posts.post_mime_type = ‘video/mp4’;