Author Topic: Forum rebuild beginning 3 June '19  (Read 42992 times)

0 Members and 1 Guest are viewing this topic.

Offline Harold Bettes

  • Sr. Member
  • ****
  • Posts: 410
  • Firebase High Country
Re: Forum rebuild beginning 3 June '19
« Reply #45 on: June 17, 2019, 07:05:13 PM »
Thanx Bob!!! Good Job :cheers: :cheers:
Regards,
HB2 :-)
If it was easy, everybody would be doing it.

As iron sharpens iron, one man sharpens another.

Offline Peter Jack

  • Hero Member
  • *****
  • Posts: 3776
Re: Forum rebuild beginning 3 June '19
« Reply #46 on: June 17, 2019, 07:44:00 PM »
Now my avatar's disappeared. Maybe I'll just wait a few days and see if it finds its way back,  :-D :-D :-D

Pete

Offline bobc

  • Administrator
  • Sr. Member
  • ***
  • Posts: 305
    • South Mt. Web Design
Re: Forum rebuild beginning 3 June '19
« Reply #47 on: June 17, 2019, 08:22:33 PM »
Now my avatar's disappeared. Maybe I'll just wait a few days and see if it finds its way back,  :-D :-D :-D

Pete

I see it!  Another one is missing, and I can see it too.  This is weird.
Web Elf

Offline Peter Jack

  • Hero Member
  • *****
  • Posts: 3776
Re: Forum rebuild beginning 3 June '19
« Reply #48 on: June 17, 2019, 09:10:21 PM »
In some peoples eyes that description may fit me as well!  :-D :-D :-D

Pete

Offline Krash

  • Custom title
  • New folks
  • Posts: 29
  • Personal text
Re: Forum rebuild beginning 3 June '19
« Reply #49 on: June 17, 2019, 09:49:12 PM »
This it?
Signature

Offline Krash

  • Custom title
  • New folks
  • Posts: 29
  • Personal text
Re: Forum rebuild beginning 3 June '19
« Reply #50 on: June 17, 2019, 09:52:04 PM »
And this should be bobc's.
Signature

Offline bobc

  • Administrator
  • Sr. Member
  • ***
  • Posts: 305
    • South Mt. Web Design
Re: Forum rebuild beginning 3 June '19
« Reply #51 on: June 17, 2019, 09:58:31 PM »
I cleared my cache, and can still see 'em..... BUT looking at the 'attachments' directory, I do a 'save as' to get the file name, and can't find it.  avatar_753.png for Peter Jack.  Maybe it has one of the encrypted names?

Also, logged out and came in as a Guest... still could see them.

WAIT!  Krash got 51827.png as a filename.... there is an encrypted filename that starts with that:
51827_4eea9.... etc etc.  Downloading it, that's the avatar.  So it IS on the server.
« Last Edit: June 17, 2019, 10:03:56 PM by bobc »
Web Elf

Offline Krash

  • Custom title
  • New folks
  • Posts: 29
  • Personal text
Re: Forum rebuild beginning 3 June '19
« Reply #52 on: June 17, 2019, 10:02:15 PM »
File names are hashed for security reasons, yours is 58934_3d17fa28b42bb0b74da5396795e33d7c913c983b.  If you change it to 58934.png you can view it as a normal image file, that's how I posted it.  IIRC there was a database change around 2.0.6 (officially, there were none in 2.0 branch), something to do with mime_type in smf_attachments.  I'll try something .......

Can't get into pma at ionos, nothing I can do til it comes back up.
« Last Edit: June 17, 2019, 10:09:24 PM by Krash »
Signature

Offline bobc

  • Administrator
  • Sr. Member
  • ***
  • Posts: 305
    • South Mt. Web Design
Re: Forum rebuild beginning 3 June '19
« Reply #53 on: June 17, 2019, 10:05:20 PM »
Guys, Krash is the Real Good Guy that got this forum upgraded for us.    :cheers:

Duh, what's pma?
« Last Edit: June 17, 2019, 10:10:48 PM by bobc »
Web Elf

Offline Krash

  • Custom title
  • New folks
  • Posts: 29
  • Personal text
Re: Forum rebuild beginning 3 June '19
« Reply #54 on: June 17, 2019, 10:16:58 PM »
Crap, it's what I thought it was.  mime_type is blank for some attachments, that causes them to not display.  Just fixed yours by manually editing the field (I see it now).  Should be able to fix it by running mysql queries, but a little leery tinkering with your production db.  Can you do a quick backup via SSH?

You can see them because it only happens in IE (I think), you must be using different browser.  I see the missing avatars in FF.
« Last Edit: June 17, 2019, 10:32:53 PM by Krash »
Signature

Offline bobc

  • Administrator
  • Sr. Member
  • ***
  • Posts: 305
    • South Mt. Web Design
Re: Forum rebuild beginning 3 June '19
« Reply #55 on: June 17, 2019, 10:31:57 PM »
I'll go into Maintenance mode, but it only takes literally a couple minutes.
Web Elf

Offline Krash

  • Custom title
  • New folks
  • Posts: 29
  • Personal text
Re: Forum rebuild beginning 3 June '19
« Reply #56 on: June 17, 2019, 10:35:24 PM »
There are over 55,000 attachments.  Do you know offhand if any of them are other than image files, i.e., txt, pdf, etc.?
Signature

Offline bobc

  • Administrator
  • Sr. Member
  • ***
  • Posts: 305
    • South Mt. Web Design
Re: Forum rebuild beginning 3 June '19
« Reply #57 on: June 17, 2019, 10:42:23 PM »
Yes, XLS for sure, I do believe PDF's too.

Yes, I'm Firefox   I see what you mean about IE
« Last Edit: June 17, 2019, 10:50:38 PM by bobc »
Web Elf

Offline Peter Jack

  • Hero Member
  • *****
  • Posts: 3776
Re: Forum rebuild beginning 3 June '19
« Reply #58 on: June 17, 2019, 10:51:34 PM »
This it?

It is! Thank-you.   :cheers: :cheers: :cheers:

Pete

Offline bobc

  • Administrator
  • Sr. Member
  • ***
  • Posts: 305
    • South Mt. Web Design
Re: Forum rebuild beginning 3 June '19
« Reply #59 on: June 17, 2019, 10:53:57 PM »
Peter Jack, Sir,

We have attachments that are images.... you're on here a lot more than me.  Aren't there some spreadsheets (xls) or pdf's?
Web Elf