Page 1 of 2

Missing photos

Posted: Wed Sep 18, 2019 4:28 am
by David Rosignoli
I noticed when searching for old photos, some of them exist and some of them do not.
Many of Richard Hull's photos no longer are present.
See the following for an example. Scroll down to Richard's images and they are not there. But the others are there. ... eas#p56102

Is this by intent (to keep the data storage down) or is it a quirk of the system?

Re: Missing photos

Posted: Wed Sep 18, 2019 5:20 am
by Richard Hull
Lots of photos and files in all forums are missing. Some are not. Read the admin forum's post on the move to understand more. They are trying to noodle out the issue. Give them time.


Richard Hull

Re: Missing photos

Posted: Wed Sep 18, 2019 10:03 am
by Frank Sanns
All Fotos are on my raid drive and also on the new site. They exist but some have been severed from their original locations within posts. There appears to be no good reason why this happened and so seemingly randomly.

While there were some unique challenges to the move, it should have been a relatively easy transition. It was FAR from that. In fact, it was really ludicrous on how complicated it was. I will expound upon only a small example of such.

MT, in mid stream, corrupted or lost around half of our site. It was not anything that we did for the move. It happened independent and just prior to our move. We had been working on getting the new hosting site all ready for the transition when it occurred. We then had to use my local backup that was around 15 days old. This should have not mattered except that the posts during that time period may have gone missing yet there were some other problems.

Looking back at it, there may have been some corrupting going on before my last "good" backup from MT or there might have been some corruption during the upgrade of the actual phpBB platform or it might be something else entirely.

It was a brutally and unnecessarily complex process. I have said before and I will say again, technology is NOT making our lives better. What should have been a sub one hour job turned into many long days and night over the course of a month. All of this to have a site that is missing the majority of the photos. Software people, you suck! Seriously. It should not be this complicated for a one to one move. I miss the days where an entire site could be moved via FTP and and all HTML code and files transferred perfectly with nothing more than a cut and paste (into same domain name). There is no reason why this should not be the way sites are constructed. Screw the specialty scripts and complex internal software code spread all over and in prolific multiple places within a structure. It is asinine, sloppy, verbose code and if you miss one character or punctuation ANYWHERE in megabytes of code, the site does not work at all. It is not just the platform of this site. It is in many softwares that we encounter every day.

So today, we have all of the photos that have ever been on the site. They, for some reason that Andrew and I have not figured out, are not being associated with the original posts. The pictures are there but are not loading in the thread or are not being thumbnails, or are there once they are clicked on. We are open to any expertise that might help us reconnect and properly format the photos with the posts.

Re: Missing photos

Posted: Wed Sep 18, 2019 4:39 pm
by David Rosignoli
Thank you Frank and Andrew for spending the many hours on this effort! It is greatly appreciated.

Re: Missing photos

Posted: Thu Sep 19, 2019 9:40 pm
by Bob Reite
What Operating system was on the old and new locations? Hopefully it was the same version of Linux on both. A couple of things I can think of:

Case Sensitivity. Things on Linux are case sensitive. Perhaps while copying something, somehow the original case was not preserved.

Lost file extensions or corruption of same when moving the photos over.

Corruption of the MySQL database.

Try running this MySQL query and see what you get:

Code: Select all

SELECT post_msg_id FROM phpbb_attachements WHERE 'real_filename' LIKE '{put the filename of one of the photos you have}'
Looking at the output of this query, you should see an integer value for 'post_msg_id'. There should be a entry in the phpbb_post table with a matching 'post_id' that is the message that the photo is supposed to be associated with.

Re: Missing photos

Posted: Sun Sep 22, 2019 3:36 am
by Bob Reite
I did some more playing around (What I can in "ordinary user" space) and found that one can view the full original photos now! It only seems that the thumbnail links are broken, but one can use this hack to see the images.

To view: Right Click on the link with the "broken picture" icon and choose "open link in new tab". The full sized photo will show in the new tab.

Re: Missing photos

Posted: Sun Sep 22, 2019 5:27 am
by Richard Hull
I went to the high voltage forum...FAQs..... and clicked on everyone of my original FAQs. I right clicked on the picture link and opened link in new tab. Clicking on the new tab, it still says"information not available".
I connect to via google.

Doesn't work using microsoft edge to sign into either.

Update: Is it just my photos?? Go to images du jour and go to page 4. Find the HEAS 2017 event pictures. Click on my images....They will not load, They will not respond to open in new tab. Just below my images are Jim Kovalchicks images. They all open fine by just clicking on the link!???

Richard Hull

Re: Missing photos

Posted: Sun Sep 22, 2019 11:24 am
by Rex Allers
Your thoughts about the database query seemed good. I think that's the level where there hopefully is a fix.

Frank says the images are all still there somewhere but I don't know how he knows that. There are multi levels to this problem. Bob's right-click doesn't work for the "does not exist" level.

My summary:
1) New posts seem to include pics inline most of the time. I think at least one of my post-site-move images has turned into a link. My recollection is it originally showed inline but not now. Pretty sure but not positive.

1a) I recently noticed that a small image I posted shows inline but it displays bigger than I created it. In the old days it would show as the original x by y size I sent.

2) Lots of images that used to display inline in the message now show as a link filename. You can click on them and they open as the image. As Bob has discovered, a better way is to right-click and open in a new tab or window.

3) The worst -- Some of those image links in some messages - if you click on them (or right-click etc) you get a window that says,
The selected attachment does not exist anymore.
Here's a link for the big problem (3)
Joe Gayo thread

If you click on those image links (or right-click open in...) you get the
"The selected attachment does not exist anymore" message.

Bob, take that link and try to get to the image. Actually, pretty much all of Joe's images in that thread from earlier this year. A really great thread. I hope the images are findable some way.

Frank, you say you still have all the images. Is there any way you can find some access to one of the (#3) images as in the Joe Gayo link I provided? By name or date maybe? That would be encouraging that this major "does not exist" problem can be fixed.

Re: Missing photos

Posted: Sun Sep 22, 2019 12:02 pm
by Rex Allers

No, it's not just your photos.

I tried to explain as much as I could about the "does not exist" problem in the
"FUSOR.NET v4 is now LIVE!" thread.
I haven't been able to find a pattern, but it does seem to be, at least in a thread locality, related to who posted.

Here's a thread from a while back as example:
Vacuum pump rebuild
Post by Tyler Meagher ยป Wed Mar 21, 2018 2:17 pm

If you go through that thread, all the images posted by Tyler Meagher seem to be "does not exist" but images in some of that thread's messages by myself and others do exist if you click on the links.

Who posted the image seems to play some part, but I don't know that all images from some users are excommunicated. Example, Richard has made posts with images since the site move and they are working, but many of his older posts with images have lost the link. Is it all of his pre-move images? That would take a while to figure out.

Re: Missing photos

Posted: Tue Sep 24, 2019 9:42 pm
by Bob Reite
It seems to be dependent on whether the item was originally an in-line photo (as mine were) or an "attachment", such as some of the .pdf files of manuals and such. the in-line photos work by right clicking and choosing "open in new tab", the attachments do not.

Admins: Any luck or results with the MySQL queries I suggested?

Another thought is that somehow the directory structure and/or permissions did not get preserved in the move, and phpBB is looking in the wrong place. I would lean more towards a directory location problem rather than a permissions issue, since the error message says "No longer exists" rather than something like "you aren't allowed to see this".