News:

Create A Forum Installed

Author Topic: Database  (Read 217 times)

0 Members and 2 Guests are viewing this topic.

Offline IsacImages

  • Newbie
  • *
  • Posts: 3
  • Karma: 0
  • Gender: Male
  • Location: Wattle Grove WA
    • View Profile
    • Isac Images Digital Photography

Badges: (View All)
Level 2 Topic Starter First Post
Database
« on: April 09, 2021, 08:23:01 am »
I'm a newbie here and I have installed the free hosting version for SMF software to have a play and see how it performs. Happy so far (just a few days). I am an administrator on a a photography forum and looking to replace the vBulletin 5 software. I inherited the admin job because our regular admin passed away so I am flying blind. SMF looks to be OK for us and I have a couple of questions.
1. When posts are made that show an uploaded image, how can we limit the size of the image OR have it resized if it is outside of those limits. We would like the maximum dimensions in pixels to be 1200 on the longest side and no more than 400kb in size.
2. What type of storage system is used for posts (including images)? Is it a MySQL database or other type of database OR stored in a folder on the server? How much storage of data/images is allowed in the free hosted version?
3. If the database is MySQL, can it be transferred to SMF from vBulletin 5 or converted somehow to suit SMF?
4. Can you provide links to forums that have been using SMF for a period of time, so we can view them?

Many thanks for those responding, it's very much appreciated.
I hope to live forever - So far it's working great!

Share on Facebook Share on Twitter


Offline CreateAForum

  • Administrator
  • *****
  • Posts: 7186
  • Karma: 327
    • View Profile

Badges: (View All)
Avatar Linux User Tenth year Anniversary
Re: Database
« Reply #1 on: April 09, 2021, 12:48:26 pm »
For these questions please ask on http://simplemachines.org they can help better.
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

Offline IsacImages

  • Newbie
  • *
  • Posts: 3
  • Karma: 0
  • Gender: Male
  • Location: Wattle Grove WA
    • View Profile
    • Isac Images Digital Photography

Badges: (View All)
Level 2 Topic Starter First Post
Re: Database
« Reply #2 on: April 16, 2021, 08:06:19 am »
Thanks for that. I asked the same at SMF and they said Create a Forum should answer #2, which they do not have control over as they are related to your server.
2. What type of storage system is used for posts (including images)? Is it a MySQL database or other type of database OR stored in a folder on the server? How much storage of data/images is allowed in the free hosted version?
Cheers,
Greg
I hope to live forever - So far it's working great!

Offline CreateAForum

  • Administrator
  • *****
  • Posts: 7186
  • Karma: 327
    • View Profile

Badges: (View All)
Avatar Linux User Tenth year Anniversary
Re: Database
« Reply #3 on: April 16, 2021, 01:15:53 pm »
File system and MySQL.   There is no limit on number of members,posts and topics. File uploads/attachments is 25megs by default I believe but you can increase the storage space.
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

Offline IsacImages

  • Newbie
  • *
  • Posts: 3
  • Karma: 0
  • Gender: Male
  • Location: Wattle Grove WA
    • View Profile
    • Isac Images Digital Photography

Badges: (View All)
Level 2 Topic Starter First Post
Re: Database
« Reply #4 on: April 19, 2021, 06:56:14 am »
File system and MySQL.   There is no limit on number of members,posts and topics. File uploads/attachments is 25megs by default I believe but you can increase the storage space.
Many thanks, I will try and find that in admin. Just FYI, the reason we will be leaving vBulletin is because when we asked questions on their forum, we got replies from techies that assume that we were all highly skilled IT gurus, when in fact, we inherited the admin duties because our dear friend and boss passed away. They ignored the fact that we told them we were "newbies" on many occasions - which seemed to fall on deaf ears. We felt like morons. The reason we ask questions in help forums is because we don't know something that we would like to learn about. Being treated like a moron is humiliating and embarrassing. Our admin team is made up from highly qualified engineers in automotive, aviation and construction so we all have our areas of expertise. Forums and forum software is not one them.
Back to the above question: Where is it (that you believe) we can see and/or adjust the storage space for uploaded images?
Thanks again,
Greg
I hope to live forever - So far it's working great!

Offline CreateAForum

  • Administrator
  • *****
  • Posts: 7186
  • Karma: 327
    • View Profile

Badges: (View All)
Avatar Linux User Tenth year Anniversary
Re: Database
« Reply #5 on: April 19, 2021, 12:41:37 pm »
You can see them under Admin -> Attachments and Avatars
Like Create A Forum? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
605 Views
Last post September 16, 2010, 11:21:21 pm
by CreateAForum
2 Replies
691 Views
Last post October 09, 2011, 04:29:41 pm
by Justincase
3 Replies
602 Views
Last post May 20, 2012, 04:01:32 pm
by aIURbliS
5 Replies
529 Views
Last post June 06, 2012, 02:41:58 am
by Dr. Pa1N
3 Replies
359 Views
Last post February 01, 2013, 07:07:10 pm
by Willing to Help