0

I just upgraded WP to 4.9.6. My WP installation is on Windows 10 in a XAMPP installation, running as a virtual server on my laptop.

I migrated this site from a remote LAMP server, with mostly identical results.

Here's a screen shot of the media library "before":

enter image description here

Here's a screen shot of the media library "after" upgrade:

enter image description here

I also upgraded to 4.9.6 on the remote server, which continues to work normally.

Any suggestions?


After investigating online, I learned that the gui field of the wp-posts table contains urls. I noticed that in my table, the urls pointed to a previous incarnation of this WP site. I did a bulk sql update so that the string values in the GUI field of the wp_posts table reflect the correct, current virtual server url on my localhost.

The basic sql statement to update a whole bunch of sub-strings is like this:

UPDATE your_table
SET your_field = REPLACE(your_field, 'articles/updates/', 'articles/news/')
WHERE your_field LIKE '%articles/updates/%' 

But that operation didn't solve the problem. However, on the media library page I noticed two little icons, one looks like a "list" icon, the other a "grid" icon. When I click on the "list" icon, all my media files show:

enter image description here

But when I click back to the "grid" display icon, same problem, "No media files found."

enter image description here

My ID columns in wp_posts and wp_postmeta were not set to auto increment (AI). Once I set these columns to AI from phpMyAdmin, the thumbnail grid immediately worked.

  • 1
    do you have debugging enabled? any php errors? any js errors in the console? – Milo May 21 '18 at 0:58
  • Does the admin footer of that page show? If it doesn’t the page did fatally error, check logs as mentioned above. Try disabling plugins one by one to find the culprit. – David Sword May 21 '18 at 2:29
  • Good question. The admin footer does show. The document loaded. I'll investigate the other suggestions, thx. I just deactivated the first plugin, Advanced Custom Fields PRO, and now it says "No media files found." Also, the blank gray "thumbnail" disappeared. Weird. – Galloway Grumblefield May 21 '18 at 3:05
  • Now that I look at the GUID values in the wp_posts table, I see a lot of url values pointing to a previous the url of a previous website. Going to have to do a bulk UPDATE operation. I'll report back. – Galloway Grumblefield May 21 '18 at 3:24
  • My ID columns in wp_posts and wp_postmeta were not set to auto increment (AI). One I set these columns to AI from phpMyAdmin, the thumbnail grid immediately worked. – Galloway Grumblefield May 21 '18 at 3:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.