Page 4 of 5

Re: Database Purge To Occur Soon-- Check Your Inbox

PostPosted: Sun Sep 26, 2010 9:05 am
by kamil
Yesterday I read in this or another thread that all is supposed to go that is more than 1 yr old, no matter inbox or archive. So I started the arduous proces of copying what's important to a word file...

Re: Database Purge To Occur Soon-- Check Your Inbox

PostPosted: Sun Sep 26, 2010 9:54 am
by hansw
kamil wrote:Yesterday I read in this or another thread that all is supposed to go that is more than 1 yr old, no matter inbox or archive. So I started the arduous proces of copying what's important to a word file...

A function to back up it all locally could be a suggestion for a future improvement.

Re: Database Purge To Occur Soon-- Check Your Inbox

PostPosted: Sun Sep 26, 2010 4:18 pm
by kamil
Haha, too late, already copied and deleted them, others may benefit from it though :)
Anyway, thanks for all the maintenance, Matt!

Re: Database Purge To Occur Soon-- Check Your Inbox

PostPosted: Sun Sep 26, 2010 7:31 pm
by kamil
Matt, that's good to know. If I wanna keep an old version for some reason, e.g. the as-adopted version of an adopted page, while editing I've got to remember to delete the intermediate versions so that the one to be kept won't be accidentally wiped out! I think this should be shouted aloud so that all page authors know.

Re: Database Purge To Occur Soon-- Check Your Inbox

PostPosted: Sun Sep 26, 2010 7:46 pm
by kamil
Can it be somehow highlighted? Everyone should know it...

Re: Database Purge To Occur Soon-- Check Your Inbox

PostPosted: Mon Sep 27, 2010 12:56 am
by Saintgrizzly
Montana Matt wrote:
borutb wrote:It was allready brought up, but I'm sure that space could be saved by deleting useless historical versions of a page (they appear by clicking the View History button).

There is already a script that runs every night that deletes all but the three most recent historical versions of a page. If you know of a page that has more than three historical versions, let me know and I'll look into why it has that many.


Here's a page that has WAY more than three. I'd be glad to delete the old historical versions, but it's in the "Gear" section, and there's no way to do it.

http://www.spgear.org/object_history.php?object_id=7345

Re: Database Purge To Occur Soon-- Check Your Inbox

PostPosted: Mon Sep 27, 2010 8:59 pm
by dadndave
Ahhh. I feel so much better for that.

- And thanks for your efforts, Matt.

Re: Database Purge To Occur Soon-- Check Your Inbox

PostPosted: Mon Sep 27, 2010 9:02 pm
by Lolli
It will be interesting when those who hasn't been online for awhile comes back and discovers it.
8)

Re: Database Purge To Occur Soon-- Check Your Inbox

PostPosted: Tue Sep 28, 2010 3:02 am
by Hotoven
Lolli wrote:It will be interesting when those who hasn't been online for awhile comes back and discovers it.
8)

It will be. They might not even notice it till they see this thread.

Re: Database Purge To Occur Soon-- Check Your Inbox

PostPosted: Tue Sep 28, 2010 3:15 pm
by isostatic
Montana Matt wrote:There actually aren't that many messages that people have archived, so I'll plan on sparing those for now. Initially I had planned to delete everything older than a year, but if you want to save the message, just archive it and I'll spare it.


Well, this did not work out!

Almost all of my archieved messages older that one year got deleted!

Re: Database Purge To Occur Soon-- Check Your Inbox

PostPosted: Tue Sep 28, 2010 4:25 pm
by Day Hiker
Montana Matt wrote:Hmmm, that shouldn't be the case. I just took a look at the script again and it's definitely checking if the message is archived and then skipping deleting it if it is. Anyone else have the same issue?


Not me. A few days ago, I archived some messages from 2007, and they're still there.

Re: Database Purge To Occur Soon-- Check Your Inbox

PostPosted: Tue Sep 28, 2010 7:47 pm
by rhyang
I still have 44 pages of messages in my archive box dating back to 2006 :oops: Perhaps I should clean that mess up some more :geek:

Re: Database Purge To Occur Soon-- Check Your Inbox

PostPosted: Tue Sep 28, 2010 10:32 pm
by isostatic
Montana Matt wrote:
isostatic wrote:Almost all of my archieved messages older that one year got deleted!

Hmmm, that shouldn't be the case. I just took a look at the script again and it's definitely checking if the message is archived and then skipping deleting it if it is. Anyone else have the same issue?


On Sunday, I had 11 pages of archived PMs. After the purge, only 2 pages remain. There are a total of 34 PMs left, 19 of which are from the last year, and 15 seemingly radomly taken from older years.

But don't worry, I distrust this kind of activities, so as a precaution I also saved all important PMs on my private computer! 8)


And by the way, there is an Archive Box on the Inbox table, but not on the SentBox table.

Are we not supposed to archive our sent PMs? :?

Re: Database Purge To Occur Soon-- Check Your Inbox

PostPosted: Tue Sep 28, 2010 10:50 pm
by isostatic
Montana Matt wrote:I should add that functionality. I'll add it to my list of things to do and get to it when I get a chance.


Thank you, Matt!

Re: Database Purge To Occur Soon-- Check Your Inbox

PostPosted: Tue Sep 28, 2010 10:54 pm
by isostatic
Montana Matt wrote:Hmmm, so far you're the only one reporting that issue. I've double and triple-checked the script and I'm nearly 100% certain that it won't delete anything in the Archive Box.


Don't worry, as I said I have copies on my private computer. But it would be interesting to hear if anyone else had this experience.

I did the archiving on Saturday and Sunday morning, so it didn't coincide with the purging.