Cory Ander wrote: ↑
Mon Nov 18, 2019 9:38 am
The attachments are actually there in the correct posts (i.e. they display correctly if opened in a new window). But they no longer display correctly in the post (as per my screen shot above).
This seems potentially consistent with "the thumbnail generated for this image attachment is no longer present in the /files folder", or that the thumbnail file is zero-length or corrupt.
You might want to isolate one of these problem files and test that theory. Hover over one of the broken image displays, and you will see a link similar to "file.php?id=3&mode=view"
. Take that file ID value ("3" in this example) and use phpMyAdmin or whatever database tool you have available to look for the entry with this ID as it's "attach_id" value in your phpbb_attachments table in the database.
Once you find that entry, make note of the "physical_filename" field for that attachment ID. It will be some generated number like "2_a7d8367a1bd1997ae8d3132e9750beb9", instead of the original attachment file name. Then also confirm the value in the "thumbnail" field for that attachment, which we're assuming should be a value of "1".
Looking in your backup files and/or on your live site, first verify that you can find "2_a7d8367a1bd1997ae8d3132e9750beb9" as a file in your /files folder, and that is has a non-zero size. We're assuming this file is correctly present as expected and fine, since the attachment does display for you once you click on it.
But then look in the /files folder for the same file name but with "thumb_" prefixed on it. e.g. "thumb_2_a7d8367a1bd1997ae8d3132e9750beb9". This will be the file phpBB is attempting to display for the image that actually appears in the post, using an image source URL such as "file.php?id=3&t=1"
. This is the URL that retrieves just the thumbnail image ("thumb_2_a7d8367a1bd1997ae8d3132e9750beb9"), as opposed to "file.php?id=3&mode=view"
which retrieves the actual attachment ("2_a7d8367a1bd1997ae8d3132e9750beb9").
So the questions are "does the database still indicate that a thumbnail should exist?" ("thumbnail" is "1" in the database for this file ID.) And does the corresponding "thumb_" file exist in the /files directory, in addition to the actual attachment file? And if the "thumb_" file does exist as expected, is the "thumb_" file a non-zero-length file?
Did you possibly have an extension installed which provided some kind of enhancement attachment or thumbnail functionality? Based on how you described your update process, presumably that extension is still present and installed, but maybe there are some additional expectations due to the extension's presence. You'll have to judge that, or provide the actual list of installed extensions in the SRT that was posted.