This has plagued ubb in the past, In the early days
The one case where you can't find a post is probably due to deleted posts and the attachment becomes orphaned.
(not deleted) Either in the table and or file folder.
In the case where you do find a post missing an attachment could be any scenario.
Such as moving hosts and a file did not get transferred or the file got corrupted ,etc.
In past versions Rick never could come up with a method to clean them all up.
It probably should be added as a utility in the rebuilders section of the control panel.
But most people that find the issue are people that have used UBB over many versions and a couple of hosts.
Like yourself.
So probably current versions don't have this problematic issue as drastic as the very old versions.
I am sure that isaac and Gizmo are aware of the issue. But with all the coding cleanup they have been working on plus getting UBB compatible with php7 ,they probably have not revisited the issue to see if it can be addressed yet.
Their laundry list is probably a lot larger than ours.
As far as posts with missing attachment files go..
For now you could just manually edit the post and delete the code in the post for the attachment if in fact the image does not exist. Till you hear from the programmers.
If you just delete the bad row in the ubb_files table. The post body and post default body will still have a reference to the attachment.
Last edited by Ruben; 01/09/2019 11:46 AM. Reason: added comment
