Database Purge To Occur Soon-- Check Your Inbox

Post general questions and discuss issues related to climbing.
User Avatar
kamil

 
Posts: 598
Joined: Mon Mar 07, 2005 1:31 pm
Thanked: 22 times in 17 posts

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

by kamil » Sun Sep 26, 2010 9:05 am

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...

User Avatar
hansw

 
Posts: 5346
Joined: Mon Oct 10, 2005 3:52 pm
Thanked: 22 times in 16 posts

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

by hansw » Sun Sep 26, 2010 9:54 am

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.
"I wonder why. I wonder why. I wonder why I wonder. I wonder why I wonder why. I wonder why I wonder!"
- Richard Feynman

User Avatar
kamil

 
Posts: 598
Joined: Mon Mar 07, 2005 1:31 pm
Thanked: 22 times in 17 posts

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

by kamil » Sun Sep 26, 2010 4:18 pm

Haha, too late, already copied and deleted them, others may benefit from it though :)
Anyway, thanks for all the maintenance, Matt!

User Avatar
kamil

 
Posts: 598
Joined: Mon Mar 07, 2005 1:31 pm
Thanked: 22 times in 17 posts

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

by kamil » Sun Sep 26, 2010 7:31 pm

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.
Last edited by kamil on Sun Sep 26, 2010 7:34 pm, edited 1 time in total.

User Avatar
kamil

 
Posts: 598
Joined: Mon Mar 07, 2005 1:31 pm
Thanked: 22 times in 17 posts

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

by kamil » Sun Sep 26, 2010 7:46 pm

Can it be somehow highlighted? Everyone should know it...

User Avatar
Saintgrizzly

 
Posts: 580
Joined: Tue May 13, 2003 9:38 am
Thanked: 0 time in 0 post

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

by Saintgrizzly » Mon Sep 27, 2010 12:56 am

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

User Avatar
dadndave
Forum Moderator
 
Posts: 15076
Joined: Mon Nov 22, 2004 12:21 am
Thanked: 2002 times in 1325 posts

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

by dadndave » Mon Sep 27, 2010 8:59 pm

Ahhh. I feel so much better for that.

- And thanks for your efforts, Matt.
The strawman is evil and must be punished,

User Avatar
Lolli

 
Posts: 810
Joined: Mon Apr 05, 2010 7:56 pm
Thanked: 112 times in 71 posts

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

by Lolli » Mon Sep 27, 2010 9:02 pm

It will be interesting when those who hasn't been online for awhile comes back and discovers it.
8)
Age is a matter of mind and if you don´t mind it does not matter!

User Avatar
Hotoven

 
Posts: 1864
Joined: Mon Feb 09, 2009 8:06 pm
Thanked: 118 times in 89 posts

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

by Hotoven » Tue Sep 28, 2010 3:02 am

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.
"Hey, careful, man, there's a beverage here!"
- The Dude, Lebowski

User Avatar
isostatic

 
Posts: 4284
Joined: Mon Mar 19, 2007 3:52 pm
Thanked: 73 times in 42 posts

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

by isostatic » Tue Sep 28, 2010 3:15 pm

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!

User Avatar
Day Hiker

 
Posts: 3156
Joined: Fri Dec 26, 2003 2:57 am
Thanked: 61 times in 43 posts

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

by Day Hiker » Tue Sep 28, 2010 4:25 pm

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.

User Avatar
rhyang

 
Posts: 8960
Joined: Wed Apr 28, 2004 8:55 pm
Thanked: 59 times in 38 posts

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

by rhyang » Tue Sep 28, 2010 7:47 pm

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:
Taaaake !

User Avatar
isostatic

 
Posts: 4284
Joined: Mon Mar 19, 2007 3:52 pm
Thanked: 73 times in 42 posts

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

by isostatic » Tue Sep 28, 2010 10:32 pm

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? :?
Last edited by isostatic on Tue Sep 28, 2010 10:48 pm, edited 1 time in total.

User Avatar
isostatic

 
Posts: 4284
Joined: Mon Mar 19, 2007 3:52 pm
Thanked: 73 times in 42 posts

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

by isostatic » Tue Sep 28, 2010 10:50 pm

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!

User Avatar
isostatic

 
Posts: 4284
Joined: Mon Mar 19, 2007 3:52 pm
Thanked: 73 times in 42 posts

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

by isostatic » Tue Sep 28, 2010 10:54 pm

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.

PreviousNext

Return to General

 


  • Related topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: No registered users and 0 guests