The New And Improved Unofficial R65 Forum V2

General Category => Chit-Chat => Topic started by: Justin B. on October 11, 2020, 02:34:53 PM

Title: Attachments
Post by: Justin B. on October 11, 2020, 02:34:53 PM

Some of you have noticed, and brought to my attention, that a lot of attachments are missing.  I have made a duplicate installation and ran the conversion again and it seems to have converted a lot more attachment on this run.  There are two issues:

1.  Lots of duplicate attachments.  Seems most of them are repeated three times.

2.  I'm not 100% sure how to incorporate these into the "live" forum.  I'm asking around unless we have a MySQL expert among us...

Thanks for your patience.

Title: Re: Attachments
Post by: Justin B. on October 26, 2020, 10:45:32 AM

I cleaned up the attachments database on my "test" forum to get rid or dups and just incorporated what was left into the "real" forum.  My estimate is that I have recovered about 1/3 of the attachments from the YaBB forum but there are still quite a few missing.  Any attachments added to the forum since we went "live" on SMF are gone but I think it was just a few.  I am still trying to get help converting just the attachments from the old forum but so far not much is happening on this front.

Title: Re: Attachments
Post by: Tony Smith on October 27, 2020, 03:47:11 AM

Your efforts are appreciated

Title: Re: Attachments
Post by: Justin B. on October 27, 2020, 09:22:59 AM

Thanks, Tony, I try but I am not an SQL expert, I barely know how to spell it!  Check some of your threads that you know should have attachments and let's see where we're at...

Title: Re: Attachments
Post by: jp9094 on October 27, 2020, 01:46:14 PM

I notice that if I am NOT signed in, the attachments (Photos) do not appear. When I sign in they are there. COuld this be the problem?
Also, may thanks for your efforts to maintain the site!

Regards to all,

Title: Re: Attachments
Post by: Justin B. on October 27, 2020, 04:47:00 PM

jp - No, there are quite a few attachments that were not picked up during the data conversion.

Title: Re: Attachments
Post by: wilcom on October 27, 2020, 09:39:07 PM

I checked and Tony's JPS was not on his post! Luckily I had made a copy and put it next to the Playboy in the bathroom...................all is not lost. :clap:

Title: Re: Attachments
Post by: Justin B. on November 05, 2020, 08:39:44 PM

It doesn't look like I'm going to get any programming help with the attachment conversion issue even after expressing my willingness to pay for a conversion utility!  Soooo, I guess that mean the posts will need to be compared between the old and new forums and any missing attachments saved from the old and loaded onto the new.  I spent some time today doing this and made it page 6 of the old forum before starting to go cross-eyed  :stare: so maybe I'll do some more tomorrow.  Only 268 more pages of threads to go...  :mad:

If anybody would like to help I would not turn it down.

Title: Re: Attachments
Post by: wilcom on November 06, 2020, 01:37:37 PM

I'll give a hand if I have the capability. I'll get with you after the week end and see what all is entailed

Title: Re: Attachments
Post by: Justin B. on November 06, 2020, 02:33:34 PM

Thanks, Joe.