The Aussie Pinball Arcade

Aussie Pinball Forums => General Discussion => News & Announcements => Topic started by: Strangeways on March 12, 2014, 10:58:11 PM

Title: Forum Upgrade !
Post by: Strangeways on March 12, 2014, 10:58:11 PM

The Admins would like to perform some preventative maintenance to the Forum so that we can mirror the site and then perform the site upgrades with the facility to "roll back" if needed. To facilitate this preparation stage, we need to reduce the 15 Gig of attachments to a more manageable level as they are using up valuable disk space. The downside to this is that OLDER threads will have the attachments stripped with a message "Attachment removed due to age post post". Old threads will NOT be removed. But valuable disk space will be returned to enable us to mirror the site as part of the upgrade.

From a technical aspect, the attachments are supposed to be managed by the forum software at a level of 2 Gig. This has failed and only been recently discovered. It has grown to 15 Gig. To mirror the site, we have to be under 10 Gig to afford the standard "cloud backup" product. Over 10 Gig is simply not affordable. We should be around the 4 Gig average.

What are attachments ?

Photos uploaded to the site. The limit is 2Meg per photo, but the site only displays 400 X 600. So it "shrinks" the 2 Meg photo but retains the original 2 Meg file. This resides "forever" in the "attachments" directory. The effect is the growing diskspace issue and also we cannot mirror the site in case of an outage.

Please be aware that during this phase of the upgrade, there will be no downtime. The only negative effect will be the older threads (starting in 2008) will be "stripped" of the attachments. The threads will remain.

Feel free to ask any questions regarding this process, and I'll do my best to answer them.
Title: Re: Forum Upgrade !
Post by: robm on March 12, 2014, 11:08:50 PM
Nino - are people better linking photos rather than attaching them. Eg: use the image link function within photobucket? Do these still come under 'attachments' in the 10GB limit?
Title: Re: Forum Upgrade !
Post by: Strangeways on March 12, 2014, 11:16:06 PM
Nino - are people better linking photos rather than attaching them. Eg: use the image link function within photobucket? Do these still come under 'attachments' in the 10GB limit?

Links to external sites won't be affected. The link button actually points to the photos hosted on picture sites. All my restorations are hosted on AP, and they take up 750 Meg. But they will all be moved and are not part of the attachments directory structure.

It is preferable for members to host their pictures externally if they want to keep the photos embedded in the threads. In my case, i have to move them and then edit every single post on all restoration threads. I'll do that once we have made it to the first stage - culling the attachment directory !

To answer your question - images hosted externally, and linked within the posts do not affect the attachments directory on the AP Host at all.
Title: Re: Forum Upgrade !
Post by: ddstoys on March 12, 2014, 11:21:16 PM
I wondered how this worked.  Any chance the Em rebuild thread photos be saved I do t feel like recreating them ?
Title: Re: Forum Upgrade !
Post by: ddstoys on March 12, 2014, 11:23:17 PM
Shit that will mean all my restore threads will be empty  ^&^
Title: Re: Forum Upgrade !
Post by: Marty Machine on March 12, 2014, 11:59:18 PM
The "[img]" command should be disabled to prevent uploading images, thus enforcing links to external image hosts.

my 2c.
Title: Re: Forum Upgrade !
Post by: Strangeways on March 13, 2014, 09:57:48 AM
I wondered how this worked.  Any chance the Em rebuild thread photos be saved I do t feel like recreating them ?

There's two ways of addressing the current problem ;

1 - Remove attachments older than X Days
2 - Remove attachments larger than X kbytes

We cannot select areas or members as part of the pruning criteria. As an example - we want to keep all the restoration attachments as the whole point of a restoration thread is to demonstrate and document using photos. We can't exempt "member name" or anyone else. My issue is that I have over 750MB of pictures - hundreds of them. All threads have to be edited - and I linked all of mine !

The answer is to host files on photo sites such as photobucket. I don't know what their policy regarding retention is, but they are set up to store and manage photos. Linking to photobucket removes the risk of the attachment pruning process within the forum software.

To "fix" your restoration threads, you will need to host the photos externally and edit your old threads. We can assist you in doing this.
Title: Re: Forum Upgrade !
Post by: Pop Bumper Pete on March 13, 2014, 10:10:08 AM
I have used photobucket for years (only paying once)
They have never deleted anything
Title: Re: Forum Upgrade !
Post by: ddstoys on March 13, 2014, 10:16:09 AM
Is there an easy way I can save all my photos?  As I'd never find the ones an know what treads and what order
Title: Re: Forum Upgrade !
Post by: Strangeways on March 13, 2014, 10:43:06 AM
Is there an easy way I can save all my photos?  As I'd never find the ones an know what treads and what order

Yes - Go to your thread, right click on the photo "save as" and then save it on your local PC. Upload the photo to a photo hosting site (Photobucket or skydrive etc) and then we can enable editing of the posts so you can update the individual posts.

We won't proceed with the "purge" until members have had a chance to update their threads - so we may enable "editing" of the threads to update links. The older the threads, the more chance the attachment(s) will be removed - so start backwards and let me know if you need a hand.
Title: Re: Forum Upgrade !
Post by: Belac on March 13, 2014, 10:51:39 AM
Nino you mentioned that the site only displays 400x600, does it actually resize the photo and keep the original 2Mb version as well as the 400x600 version? Or does it simply display the 2Mb file at 400x600 on the fly?

What i'm getting at is can the 2Mb version be removed/relocated while retaining the 400x600 copy? Better still the 2Mb version could be archived out to some other hosting facility.
Title: Re: Re: Forum Upgrade !
Post by: MartyJ on March 13, 2014, 11:12:34 AM
I have used Photo bucket for a while now and find it a much better alternative.  No size limits and less headaches for maintenance.
Just insert the img tag which photo bucket generates for you.
Title: Re: Forum Upgrade !
Post by: Strangeways on March 13, 2014, 11:14:03 AM
Nino you mentioned that the site only displays 400x600, does it actually resize the photo and keep the original 2Mb version as well as the 400x600 version? Or does it simply display the 2Mb file at 400x600 on the fly?

What i'm getting at is can the 2Mb version be removed/relocated while retaining the 400x600 copy? Better still the 2Mb version could be archived out to some other hosting facility.

2MB is the maximum size allowed in the attachments sub folder. You cannot upload a file larger. Some files are 20Kb. The forum software does make slight format changes, but I don't know the process behind it. I know it does not store the original and then make a copy that is presented withing the posts. It simply keeps the original, regardless of the size or quality.

The current attachment directory cannot be archived because it is tied in with the database. If I view the file structure in Filezilla, I can view the first 10,000 files, but if I download them, they are junk. Admins can see the attachment names and their details. There's over 1900 pages of photos - 17,898 to be exact ! It is currently 13.5 Gig on disk. The attachment management system was set to restrict and manage the size of the attachment directory, but it simply did not work from "day 1". So it has grown to such a size that out host cannot backup using the standard backup process. This is a huge problem.

Regarding site Backups - Hostgator won't backup any site that is over 4 Gig in size. Admin have to manually download using FTP. So if the site crashed and we had to restore, we would lose a lot of threads and we would be down for a long time for the site restore.

Regarding the technology we want to use - https://plugins.hostgator.com/codeguard/ (https://plugins.hostgator.com/codeguard/)

This effectively allows us to keep a backup of the site and also we can perform upgrades with the confidence of knowing we can "roll back" to a previous version if things fail. It also provides a backup that is managed by our host, instead of us.

The price for 10 Gig is US$100 per year
The price for 25 Gig is US$240 per year

That's a huge difference in price. The aim is to reduce our total space from 15 Gig (entire site that includes 13.5 Gig in attachments) to 7.5 Gig so we can allow for growth and pay US$100 for the 10 Gig Cloud Backup solution.
Title: Re: Forum Upgrade !
Post by: studley67 on March 13, 2014, 11:24:13 AM
Nino you mentioned that the site only displays 400x600, does it actually resize the photo and keep the original 2Mb version as well as the 400x600 version? Or does it simply display the 2Mb file at 400x600 on the fly?

What i'm getting at is can the 2Mb version be removed/relocated while retaining the 400x600 copy? Better still the 2Mb version could be archived out to some other hosting facility.

2MB is the maximum size allowed in the attachments sub folder. You cannot upload a file larger. Some files are 20Kb. The forum software does make slight format changes, but I don't know the process behind it. I know it does not store the original and then make a copy that is presented withing the posts. It simply keeps the original, regardless of the size or quality.

The current attachment directory cannot be archived because it is tied in with the database. If I view the file structure in Filezilla, I can view the first 10,000 files, but if I download them, they are junk. Admins can see the attachment names and their details. There's over 1900 pages of photos - 17,898 to be exact ! It is currently 13.5 Gig on disk. The attachment management system was set to restrict and manage the size of the attachment directory, but it simply did not work from "day 1". So it has grown to such a size that out host cannot backup using the standard backup process. This is a huge problem.

Regarding site Backups - Hostgator won't backup any site that is over 4 Gig in size. Admin have to manually download using FTP. So if the site crashed and we had to restore, we would lose a lot of threads and we would be down for a long time for the site restore.

Regarding the technology we want to use - https://plugins.hostgator.com/codeguard/ (https://plugins.hostgator.com/codeguard/)

This effectively allows us to keep a backup of the site and also we can perform upgrades with the confidence of knowing we can "roll back" to a previous version if things fail. It also provides a backup that is managed by our host, instead of us.

The price for 10 Gig is US$100 per year
The price for 25 Gig is US$240 per year

That's a huge difference in price. The aim is to reduce our total space from 15 Gig (entire site that includes 13.5 Gig in attachments) to 7.5 Gig so we can allow for growth and pay US$100 for the 10 Gig Cloud Backup solution.


looks like a call for donations is on the cards, for server storage space.i just need to sell a few more and i-m in for one.
Title: Re: Forum Upgrade !
Post by: Strangeways on March 13, 2014, 09:31:18 PM
Nino you mentioned that the site only displays 400x600, does it actually resize the photo and keep the original 2Mb version as well as the 400x600 version? Or does it simply display the 2Mb file at 400x600 on the fly?

What i'm getting at is can the 2Mb version be removed/relocated while retaining the 400x600 copy? Better still the 2Mb version could be archived out to some other hosting facility.

2MB is the maximum size allowed in the attachments sub folder. You cannot upload a file larger. Some files are 20Kb. The forum software does make slight format changes, but I don't know the process behind it. I know it does not store the original and then make a copy that is presented withing the posts. It simply keeps the original, regardless of the size or quality.

The current attachment directory cannot be archived because it is tied in with the database. If I view the file structure in Filezilla, I can view the first 10,000 files, but if I download them, they are junk. Admins can see the attachment names and their details. There's over 1900 pages of photos - 17,898 to be exact ! It is currently 13.5 Gig on disk. The attachment management system was set to restrict and manage the size of the attachment directory, but it simply did not work from "day 1". So it has grown to such a size that out host cannot backup using the standard backup process. This is a huge problem.

Regarding site Backups - Hostgator won't backup any site that is over 4 Gig in size. Admin have to manually download using FTP. So if the site crashed and we had to restore, we would lose a lot of threads and we would be down for a long time for the site restore.

Regarding the technology we want to use - https://plugins.hostgator.com/codeguard/ (https://plugins.hostgator.com/codeguard/)

This effectively allows us to keep a backup of the site and also we can perform upgrades with the confidence of knowing we can "roll back" to a previous version if things fail. It also provides a backup that is managed by our host, instead of us.

The price for 10 Gig is US$100 per year
The price for 25 Gig is US$240 per year

That's a huge difference in price. The aim is to reduce our total space from 15 Gig (entire site that includes 13.5 Gig in attachments) to 7.5 Gig so we can allow for growth and pay US$100 for the 10 Gig Cloud Backup solution.


looks like a call for donations is on the cards, for server storage space.i just need to sell a few more and i-m in for one.

Thanks Damien !

Title: Re: Forum Upgrade !
Post by: Homepin on March 13, 2014, 09:38:34 PM
How do you donate?
Title: Re: Forum Upgrade !
Post by: pinnies4me on March 13, 2014, 09:43:54 PM
How do you donate?

Just click the "Donations" tab, or just click this link - http://aussiepinball.com/index.php?action=treasury

Title: Re: Forum Upgrade !
Post by: pinnies4me on March 13, 2014, 09:44:28 PM
How do you donate?

Just click the "Donations" tab, or just click this link - http://aussiepinball.com/index.php?action=treasury



And I see you have found that already - thanks Mike!!  ^^^
Title: Re: Forum Upgrade !
Post by: Marty Machine on March 13, 2014, 10:08:33 PM
I left you guys a surprise, hope it helps things grow   (no, it's not fertilizer :lol :lol :lol :lol )
Title: Re: Forum Upgrade !
Post by: Pintoxicated on March 13, 2014, 10:27:23 PM
Well done Marty. 
Title: Re: Forum Upgrade !
Post by: Strangeways on March 14, 2014, 09:17:30 AM
The codeguard cloud backup will be purchased today and configured as soon as possible.

All historical threads and attachments will be retained. The response thus far has been amazing. Thanks to all that have donated. We are covered for the first 12 months easily. At this rate, we will be covered for 2 years  ^^^
Title: Re: Forum Upgrade !
Post by: pinnies4me on March 14, 2014, 10:57:06 AM



Thanks guys, really overwhelmed by the generosity of members.

As mentioned earlier, the cloud back up is stage one of the full software upgrade, allowing us a back up so that as we do the update, we can restore from back up if things don't go as planned.

The funds will enable us to back up things exactly as they are, and all historical threads will remain - I am particularly pleased by this, but more importantly, this has saved Strageways a huge amount of clean up work, so a big thanks for that to all!  @@*
Title: Re: Forum Upgrade !
Post by: Freiherr on March 14, 2014, 11:12:24 AM
At this rate, we will be covered for 2 years  ^^^

That's a relief. Pinball is once again starting to get interesting.
Title: Re: Forum Upgrade !
Post by: Strangeways on March 14, 2014, 01:30:08 PM

The Code Guard cloud backup is now active discovering our databases and file structures. It will take 24 hours until we have a full initial backup.

Thanks to the suggestions and donations, the site will retain all the older posts and attachments. The first step to the Forum Software update is almost over.

To mirror Nick's comments - My life just became a whole lot easier !

My own comment is that our little corner of the internet is VERY important to many people, and it's history is worth retaining for current and future members.
Title: Re: Forum Upgrade !
Post by: Freiherr on March 14, 2014, 02:05:13 PM

My own comment is that our little corner of the internet is VERY important to many people, and it's history is worth retaining for current and future members.

The history is priceless. I regret not taking any photos of arcades back in the 70s. Once the moment is gone, accurate historic preservation is extremely important.
Title: Re: Forum Upgrade !
Post by: Slash on March 14, 2014, 03:49:09 PM

My own comment is that our little corner of the internet is VERY important to many people, and it's history is worth retaining for current and future members.

Definitely, whilst a lot of the older posts may contain info that is now "common knowledge" for many older posters on the site or more experienced pin techs/restorers, I know for myself that searching thru and reading old topics is extremely valuable as someone relatively new to restorations and working on a pin in a more in-depth level.  Pics that go with those old posts obviously help tremendously too. 
Title: Re: Forum Upgrade !
Post by: pinnies4me on March 14, 2014, 04:02:01 PM

My own comment is that our little corner of the internet is VERY important to many people, and it's history is worth retaining for current and future members.

Definitely, whilst a lot of the older posts may contain info that is now "common knowledge" for many older posters on the site or more experienced pin techs/restorers, I know for myself that searching thru and reading old topics is extremely valuable as someone relatively new to restorations and working on a pin in a more in-depth level.  Pics that go with those old posts obviously help tremendously too. 

Spot on, I really am glad this is being preserved.
Title: Re: Forum Upgrade !
Post by: Retropin on March 14, 2014, 04:23:05 PM
Just as a helpful suggestion for those people who are looking for the older posts... the SEARCH function on the site is bloody awful. Makes digging up an old thread very very hard work.. could this at least be upgraded?
Title: Re: Forum Upgrade !
Post by: Strangeways on March 14, 2014, 04:54:52 PM
Just as a helpful suggestion for those people who are looking for the older posts... the SEARCH function on the site is bloody awful. Makes digging up an old thread very very hard work.. could this at least be upgraded?

We are on a software version circa 2008. A LOT of things don't work. The search function will work after a database maintenance, but they it quickly breaks again after a day or two. I have not even looked at the new features, but I'm sure it will be a whole lot better !
Title: Re: Forum Upgrade !
Post by: Pintoxicated on March 14, 2014, 07:23:34 PM
As they say, a picture tells a thousand words and in the world of pinrepair it is invaluable.  Great news that things will only get better.

I wouldn't mind a gentle reminder every year or whenever to send through a donation.  I didn't realise it had been so long since I had donated so I was more than happy to assist.  A request for a small donation to keep the forum top notch and up to date will never be an issue guys so if the forum needs a tweak just let us know, you have seen the sort of response you will get.
Title: Re: Forum Upgrade !
Post by: ddstoys on March 14, 2014, 07:24:49 PM
As they say, a picture tells a thousand words and in the world of pinrepair it is invaluable.  Great news that things will only get better.

I wouldn't mind a gentle reminder every year or whenever to send through a donation.  I didn't realise it had been so long since I had donated so I was more than happy to assist.  A request for a small donation to keep the forum top notch and up to date will never be an issue guys so if the forum needs a tweak just let us know, you have seen the sort of response you will get.
+1
Title: Re: Forum Upgrade !
Post by: Retropin on March 14, 2014, 07:27:18 PM
Just added up the donations... what a response!  @@* @@* @@*
Title: Re: Forum Upgrade !
Post by: Pop Bumper Pete on March 14, 2014, 07:42:49 PM
I am surprised Mike did not donate $54.321
Title: Re: Forum Upgrade !
Post by: Retropin on March 14, 2014, 07:44:04 PM
I am surprised Mike did not donate $54.321

Bet he wishes he had now he's seen it!
Title: Re: Forum Upgrade !
Post by: Strangeways on March 14, 2014, 08:48:45 PM
Just added up the donations... what a response!  @@* @@* @@*

Every time I stop work and come in for a breather, I see more member generosity. Just amazing  @@*
Title: Re: Forum Upgrade !
Post by: Strangeways on March 15, 2014, 06:40:34 PM

We are now covered by Code Guard cloud backup. Our first backup is complete. Thanks again to the many members that made this happen.

Next phase will be to upgrade the forum software, so there's a lot to look forward to.
Title: Re: Re: Forum Upgrade !
Post by: MartyJ on March 15, 2014, 06:46:33 PM
Great stuff.  Upgrading the SMF software will make a huge difference.
Title: Re: Forum Upgrade !
Post by: noj472 on March 15, 2014, 06:48:19 PM
Thanks for sacrificing your spare time to sort it out Nino @@*
Title: Re: Re: Forum Upgrade !
Post by: Strangeways on March 15, 2014, 06:53:12 PM
Great stuff.  Upgrading the SMF software will make a huge difference.

Apart from the obvious security benefits, there should be many new and cool features  ^^^

Thanks for sacrificing your spare time to sort it out Nino @@*

Thanks for the kind words. Both Nick and myself really enjoy running the forum. I have an IT background, so I put my hand up and ran with it. I don't know much about web stuff, but I don't mind looking after the "IT" side of things.
Title: Re: Forum Upgrade !
Post by: Crashramp on March 15, 2014, 08:03:03 PM
Thanks for sacrificing your spare time to sort it out Nino @@*

+1 Both you guys do a tremendous job. Myself and I'm sure everybody else here appreciate it.  ^^^
Title: Re: Forum Upgrade !
Post by: pinnies4me on March 16, 2014, 07:43:41 AM
I must say we'd be lost without Nino's  IT expertise. The initial backup is now completed, and will automatically be maintained mirroring the site. This does give us a real feeling of security and confidence to move on with the forum upgrade.