Author Topic: Attachments  (Read 224 times)

Offline Justin B.

  • Administrator
  • *****
  • Posts: 5910
  • I love my Beemers
Attachments
« 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.
Justin B.

2004 BMW R1150RT
1981 R100RT - Summer bike, NEKKID!!!

Offline Justin B.

  • Administrator
  • *****
  • Posts: 5910
  • I love my Beemers
Re: Attachments
« Reply #1 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.
Justin B.

2004 BMW R1150RT
1981 R100RT - Summer bike, NEKKID!!!

Offline Tony Smith

  • Posts: 2274
  • Graduate, Wallace and Gromit School of Engineering
Re: Attachments
« Reply #2 on: October 27, 2020, 03:47:11 AM »
Your efforts are appreciated
1978 R100RS| 1981 R100RS (JPS) | 1984 R65 | 1992 KLE500 | 2002 R1150GSA |

Offline Justin B.

  • Administrator
  • *****
  • Posts: 5910
  • I love my Beemers
Re: Attachments
« Reply #3 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...
Justin B.

2004 BMW R1150RT
1981 R100RT - Summer bike, NEKKID!!!

Offline jp9094

  • Posts: 146
  • I Love YaBB 2!
Re: Attachments
« Reply #4 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,
"It's what you learn, after you know it all, that counts"

Offline Justin B.

  • Administrator
  • *****
  • Posts: 5910
  • I love my Beemers
Re: Attachments
« Reply #5 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.
Justin B.

2004 BMW R1150RT
1981 R100RT - Summer bike, NEKKID!!!

Offline wilcom

  • Posts: 1485
Re: Attachments
« Reply #6 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:
Joe Wilkerson
Telephone man with a splash of Data
Menifee, CA

Present:
1984 BMW R65LS "Herr Head"
1982 BMW R65LS 
past:
1979 R65
1980 R65
1982 R80RT
1974 R90/6
1972 R75
1964 R50/2
19xx R27
ZX-11

Offline Justin B.

  • Administrator
  • *****
  • Posts: 5910
  • I love my Beemers
Re: Attachments
« Reply #7 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.
Justin B.

2004 BMW R1150RT
1981 R100RT - Summer bike, NEKKID!!!

Offline wilcom

  • Posts: 1485
Re: Attachments
« Reply #8 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
Joe Wilkerson
Telephone man with a splash of Data
Menifee, CA

Present:
1984 BMW R65LS "Herr Head"
1982 BMW R65LS 
past:
1979 R65
1980 R65
1982 R80RT
1974 R90/6
1972 R75
1964 R50/2
19xx R27
ZX-11

Offline Justin B.

  • Administrator
  • *****
  • Posts: 5910
  • I love my Beemers
Re: Attachments
« Reply #9 on: November 06, 2020, 02:33:34 PM »
Thanks, Joe.
Justin B.

2004 BMW R1150RT
1981 R100RT - Summer bike, NEKKID!!!