PDA

View Full Version : Forum Attachments Cleanup -- Please Help

Keith A
10-13-2010, 10:13 AM
Dear forum members,

We have identified one area that needs some special attention and that is with the forum attachments. We are very close to the limit that the database can handle, which is why people have had problems trying to add new attachments.

So what I'd like for everyone to do is to cleanup some of their unnecessary attachments. You can do this by going to the "User CP" link on the top control bar and then click on last link on the left side of the screen labeled "Attachments". This will show you all the attachments you have added to the forum. You might want to start at the end of this list by clicking "Last" which will show you the oldest files.

Obvious images that could be deleted are things that were posted in the classified section which have already sold or are no longer for sale.

You are more than welcome to keep any attachments that you would like to stay out there, but I would imagine there are plenty of images that are no longer valuable.

Thanks in advance for your help.
-Keith A
rice rocket
10-13-2010, 10:28 AM
Maybe you should unsticky all the other stuff for now so people will actually read this; there's too much clutter on the top of the forum page.
fourflys
10-13-2010, 10:40 AM
hey, I read it and got rid of my 600kb of pics... ;)
Keith A
10-13-2010, 10:40 AM
Good point...stuff has been un-stuck for now.
Smiley
10-13-2010, 12:43 PM
Hey Keith, thanks for the heads up just cleaned up 4 pages of junk :)
Frankwurst
10-13-2010, 12:52 PM
That was painless enough. Even a computer illiterate moron such as myself can handle that procedure. :beer:
Keith A
10-13-2010, 01:32 PM
Thanks for your help in doing some house keeping :banana:
fiamme red
10-13-2010, 01:36 PM
What about forum members who are no longer here? I think Viper wasted more bandwidth than anyone else in the history of this forum with his endless attachments. :rolleyes:
Volant
10-13-2010, 01:41 PM
Done. Thanks for letting us know a little house-cleaning was in order. :)
PaulE
10-13-2010, 01:46 PM
Took out all classified pictures and other nonsense. I can hit the gallery too if necessary.
Keith A
10-13-2010, 01:50 PM
Took out all classified pictures and other nonsense. I can hit the gallery too if necessary.Thanks! I'd say leave the stuff in the gallery. We are just trying to get some breathing room so that we can make some improvements in the way the attachments are managed.
SpeedyChix
10-13-2010, 02:20 PM
Done. Amazing how it starts to add up, even with small pics.
gone
10-13-2010, 02:25 PM
Done! I've removed about 20 old attachments.

A suggestion: you might want to edit the first post in this thread to give a status update and/or goals for the cleanup.
maximus
10-13-2010, 02:36 PM
Nice - was actually fun to go back and see what stuff I have posted in the past. Many photos deleted.

Thanks for looking into the attachment issues.
Straz
10-13-2010, 02:41 PM
Done. Thank you for the heads up. Glad to free up the space.

Tim
deechee
10-13-2010, 02:49 PM
I had some weird attachments... haha.
It took a while (more than a minute) for the attachment page to load fyi.
54ny77
10-13-2010, 02:57 PM
Can't you automatically dump the files without user action?

Perhaps just require pictures be hosted externally and that people put in [img] links accordingly.

Attachment hosting (and supporting) is a luxury I'd venture most could care less about.
Keith A
10-13-2010, 03:13 PM
<snip>A suggestion: you might want to edit the first post in this thread to give a status update and/or goals for the cleanup.Good suggestion, we were at the limit of the database which is 4GB for the attachments and I didn't capture the total number when we started the cleanup, but our current status is
Total Attachments 57,109
Disk Space Used 3.87 GB
Keith A
10-13-2010, 03:17 PM
Can't you automatically dump the files without user action?

Perhaps just require pictures be hosted externally and that people put in [img] links accordingly.

Attachment hosting (and supporting) is a luxury I'd venture most could care less about.Our plan is to move the attachments out of the database which will provide us with as many attachments that the physical hard disk will allow, rather than the limit of the database size. Before we can do this, we needed to get the size down since the attachment database was having some corruption issues because we were at the limit of its capabilities. So we wanted to have a good backup of the forum database before making any significant changes.
bobswire
10-13-2010, 03:48 PM
15.6 MB dumped. Didn't realize how many I had wasting space.
bike22
10-13-2010, 04:45 PM
Here's a suggestion, which has probably already been made- allow linking of images from external sites, via the and tags- that way people can add images, such as an item for sale without straining or draining any of the database.
Keith A
10-13-2010, 05:03 PM
Here's a suggestion, which has probably already been made- allow linking of images from external sites, via the and tags- that way people can add images, such as an item for sale without straining or draining any of the database.This is already available and I recently opened this up for the classified section which previously didn't allow linked images.
sokyroadie
10-13-2010, 06:02 PM
15.6 MB dumped. Didn't realize how many I had wasting space.

I got that topped 18.64MB deleted :banana:

Jeff
chuckroast
10-13-2010, 07:30 PM
done
SoCalSteve
10-13-2010, 07:31 PM
Ok, I did my part...

Lots of classified pictures deleted.
William
10-18-2010, 04:19 AM
Ummmm......I think I found the problem.


I'm using 98.89 megs on 63 pages of attachments. :crap: Either I've been around a while or I post a lot of junk. Any one top that? :D




William
ericspin
10-18-2010, 04:51 AM
Done
dekindy
10-18-2010, 06:23 PM
I deleted 4 or 5 attachments.
BumbleBeeDave
10-18-2010, 06:54 PM
I had no idea . . . I just got rid of over 50mb. I had almost 1500 pics going back to 2003.

Sorry about that! :rolleyes:

BBD
Keith A
10-23-2010, 02:27 PM
Even though we have resolved the attachments problem, feel free to continue to delete any old images that aren't needed/important anymore.

Thanks.
rice rocket
10-30-2010, 01:06 PM
You should consider nixing attachments in the classifieds, since they're only really up there for a one-time sale, and then people forget about it, and it wastes space. There are plenty of other sites' space to waste for that (imgur, tinypic, etc). It makes sense for the Gallery and General Discussion because of the discussion surrounding the image may make or break a discussion, but not as much for the classifieds.
William
11-02-2010, 03:28 AM
Photobucket (or similar hosting site.) is easy to use and then you're just linking to the photo.




William
SpeedyChix
11-02-2010, 08:47 AM
Photobucket (or similar hosting site.) is easy to use and then you're just linking to the photo.




William

This would be great. Simpler as well than shrinking the files to make them small enough to attach. Linking to a photo hosting site is easy and won't load up the servers with attachments.
Keith A
11-02-2010, 09:33 AM
Using image links is a great way to offload the image hosting from the Serotta forum. However, not everyone has a photo/image account; and doing the image link may be challenging for some users...so I wouldn't want to turn off the ability to attach images to a message post.
thwart
11-02-2010, 10:32 AM
Remember that a large number of folks here work for 'less than enlightened' employers that block all photo websites. So if you're on a break or lunch hour, you can see nothing but text---unless the image is loaded on Serotta's server as it is with photo attachments.
RPS
11-08-2010, 04:48 PM
It appears I can't delete pictures from threads that are closed or locked; is that the way it works? :confused:
Keith A
11-08-2010, 05:48 PM
It appears I can't delete pictures from threads that are closed or locked; is that the way it works? :confused:Not sure about this one. I'll have a look and find out for you.