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

0 Members and 1 Guest are viewing this topic.

Offline Krash

  • Custom title
  • New folks
  • Posts: 29
  • Personal text
Re: Forum rebuild beginning 3 June '19
« Reply #60 on: June 17, 2019, 10:57:20 PM »
This is what I've found so far -

bmp - 2
png - 1400
jpg - 55248
jpeg - 2
gif - 101
txt - 8
pdf - 245
doc - 26
docx - 0
xls - 84
xlsx - 0

Can you think of any others?
Signature

Offline bobc

  • Administrator
  • Sr. Member
  • ***
  • Posts: 305
    • South Mt. Web Design
Re: Forum rebuild beginning 3 June '19
« Reply #61 on: June 17, 2019, 11:01:29 PM »
No, I can't come up with more

WAIT.... mpg is listed as permissible.  I can see an audio file, mp3 or something, but there'd be very few if any.

Ah, pma = PHPMyAdmin
« Last Edit: June 17, 2019, 11:12:02 PM by bobc »
Web Elf

Offline Peter Jack

  • Hero Member
  • *****
  • Posts: 3776
Re: Forum rebuild beginning 3 June '19
« Reply #62 on: June 17, 2019, 11:19:09 PM »
I would say yes there are but they're a very limited number. To be perfectly honest I don't really pay attention to what types the attachments are.

Pete

Offline Krash

  • Custom title
  • New folks
  • Posts: 29
  • Personal text
Re: Forum rebuild beginning 3 June '19
« Reply #63 on: June 17, 2019, 11:24:33 PM »
Checked all the allowed file types, there are also a couple of bmps, which are not on allowed list.

I'll run the queries now.
Signature

Offline bobc

  • Administrator
  • Sr. Member
  • ***
  • Posts: 305
    • South Mt. Web Design
Re: Forum rebuild beginning 3 June '19
« Reply #64 on: June 17, 2019, 11:26:55 PM »
Okeedokee.  I don't know how important it would be if we dropped a few 'other' file types.  Probably not very.
Web Elf

Offline Krash

  • Custom title
  • New folks
  • Posts: 29
  • Personal text
Re: Forum rebuild beginning 3 June '19
« Reply #65 on: June 17, 2019, 11:28:40 PM »
         

Ok, we're still here and missing avatars are back.  That should fix pretty much all missing attachments.
Signature

Offline bobc

  • Administrator
  • Sr. Member
  • ***
  • Posts: 305
    • South Mt. Web Design
Re: Forum rebuild beginning 3 June '19
« Reply #66 on: June 17, 2019, 11:29:29 PM »


That's scary!!!!!!!
Web Elf

Offline bobc

  • Administrator
  • Sr. Member
  • ***
  • Posts: 305
    • South Mt. Web Design
Re: Forum rebuild beginning 3 June '19
« Reply #67 on: June 17, 2019, 11:32:04 PM »
THANK YOU!   Did you put in mime types?  I'm wondering how you figured out what the file types were.  I can look at the database tomorrow (using PMA!)
Web Elf

Offline Krash

  • Custom title
  • New folks
  • Posts: 29
  • Personal text
Re: Forum rebuild beginning 3 June '19
« Reply #68 on: June 17, 2019, 11:35:48 PM »
Searched the table with this query for each file type -

Code: [Select]

SELECT id_attach FROM smf_attachments WHERE fileext='xls'


Here's the output from the queries -

Code: [Select]

8 rows affected. (Query took 0.0825 seconds.)
UPDATE `smf_attachments` SET `mime_type` = 'text/plain' WHERE `fileext` = 'txt' AND `mime_type` = ''
26 rows affected. (Query took 0.0627 seconds.)
UPDATE `smf_attachments` SET `mime_type` = 'application/msword' WHERE `fileext` = 'doc' AND `mime_type` = ''
245 rows affected. (Query took 0.0555 seconds.)
UPDATE `smf_attachments` SET `mime_type` = 'application/pdf' WHERE `fileext` = 'pdf' AND `mime_type` = ''
55244 rows affected. (Query took 1.3360 seconds.)
UPDATE `smf_attachments` SET `mime_type` = 'image/jpeg' WHERE `fileext` = 'jpg' AND `mime_type` = ''
101 rows affected. (Query took 0.0684 seconds.)
UPDATE `smf_attachments` SET `mime_type` = 'image/gif' WHERE `fileext` = 'gif' AND `mime_type` = ''
1385 rows affected. (Query took 0.0933 seconds.)
UPDATE `smf_attachments` SET `mime_type` = 'image/png' WHERE `fileext` = 'png' AND `mime_type` = ''
84 rows affected. (Query took 0.0482 seconds.)
UPDATE `smf_attachments` SET `mime_type` = 'application/vnd.ms-excel' WHERE `fileext` = 'xls' AND `mime_type` = ''
0 rows affected. (Query took 0.0438 seconds.)
UPDATE `smf_attachments` SET `mime_type` = 'image/jpeg' WHERE `fileext` = 'jpeg' AND `mime_type` = ''
2 rows affected. (Query took 0.0820 seconds.)
UPDATE `smf_attachments` SET `mime_type` = 'image/bmp' WHERE `fileext` = 'bmp' AND `mime_type` = ''

Signature

Offline bobc

  • Administrator
  • Sr. Member
  • ***
  • Posts: 305
    • South Mt. Web Design
Re: Forum rebuild beginning 3 June '19
« Reply #69 on: June 17, 2019, 11:36:54 PM »
I'm in IE and don't see Peter Jack's or Harold Bettes avatars....or Seldom Seen Slim's (that's Jon the site owner)

Thanks for the explanation.  fileext is the thing I didn't know was there.
« Last Edit: June 17, 2019, 11:42:30 PM by bobc »
Web Elf

Offline Krash

  • Custom title
  • New folks
  • Posts: 29
  • Personal text
Re: Forum rebuild beginning 3 June '19
« Reply #70 on: June 17, 2019, 11:45:33 PM »
I see all avatars in IE, clear browser cache and do a hard refresh.

While we're here, noticed some annoying things about how user options are configured, I believe they're default settings in 2.0, and really shouldn't be:

- Returns to message index after post, should return to topic.
- PMs are shown all, should be displayed as conversation, most recent on top.
- Sent PMs are not saved by default, they should be.

These are Profile options, but most users don't know (or care) that they're there.  They can be set for all members in Admin -> Current Theme -> Member Options.  These are my personal preferences, I use them on my production forums to make life easier for my members.

Signature

Offline bobc

  • Administrator
  • Sr. Member
  • ***
  • Posts: 305
    • South Mt. Web Design
Re: Forum rebuild beginning 3 June '19
« Reply #71 on: June 17, 2019, 11:55:42 PM »
Ok, I'll try IE again.
Update:  the hard refresh worked.

I'll look at those options, they make sense to me.  The hazards of not actually participating in the forum a lot.
« Last Edit: June 18, 2019, 12:01:04 AM by bobc »
Web Elf

Offline Krash

  • Custom title
  • New folks
  • Posts: 29
  • Personal text
Re: Forum rebuild beginning 3 June '19
« Reply #72 on: June 17, 2019, 11:57:53 PM »
You have to make the changes in two places to make them effective for all members -

- Configure guest and new user options for this theme (15 options currently set.)
- Change current options for all members using this theme


Signature

Offline bobc

  • Administrator
  • Sr. Member
  • ***
  • Posts: 305
    • South Mt. Web Design
Re: Forum rebuild beginning 3 June '19
« Reply #73 on: June 18, 2019, 12:03:37 AM »
Ok, I'll do that.

Sure do thank you!
BtWE

PS, used to show ages and a person's 'title' too.  Something else to look at, but it's GREAT that it's working!
« Last Edit: June 18, 2019, 12:10:41 AM by bobc »
Web Elf

Offline Krash

  • Custom title
  • New folks
  • Posts: 29
  • Personal text
Re: Forum rebuild beginning 3 June '19
« Reply #74 on: June 18, 2019, 12:27:40 AM »
used to show ages and a person's 'title' too.

That's two different things, believe age was displayed by a mod, I have a list somewhere..............

Yeah, it was - Display Age and Location next to posts 1.0, last updated to 1.1.3 twelve years ago.  Don't think there's a 2.0 mod that does that.  Might not be too difficult to custom code it. 

Not sure which title you're referring to, you should see membergroup (Admin) and post count group (New Folks).  What else was there?


You should also enable Quick Reply in member options, I use it all the time.
Signature