Welcome to SP!  -
Areas & RangesMountains & RocksRoutesImagesArticlesTrip ReportsGearOtherPeoplePlans & PartnersWhat's NewForum

Database Purge To Occur Soon-- Check Your Inbox

Post general questions and discuss issues related to climbing.
 

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

Postby Montana Matt » Mon Sep 27, 2010 3:06 am

Saintgrizzly wrote: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

Right, the gear section is different code. I need to add that functionality to that part of the site as well, but it's much less pressing because there aren't nearly as many pages there.
User Avatar
Montana Matt
Site Admin
 
Posts: 1108
Joined: Sun Apr 11, 2004 10:06 pm
Location: Ashland, Oregon, United States
Thanked: 335 times in 181 posts

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

Postby Montana Matt » Mon Sep 27, 2010 7:38 pm

Purge is completed!
User Avatar
Montana Matt
Site Admin
 
Posts: 1108
Joined: Sun Apr 11, 2004 10:06 pm
Location: Ashland, Oregon, United States
Thanked: 335 times in 181 posts

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

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

Ahhh. I feel so much better for that.

- And thanks for your efforts, Matt.
What is this "scientific method" you speak of?
User Avatar
dadndave
Forum Moderator
 
Posts: 13375
Joined: Mon Nov 22, 2004 12:21 am
Location: Independent Republic of North Beerwah
Thanked: 1044 times in 704 posts

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

Postby 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
Lolli

 
Posts: 810
Joined: Mon Apr 05, 2010 7:56 pm
Location: Sweden
Thanked: 108 times in 67 posts

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

Postby 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
Hotoven

 
Posts: 1861
Joined: Mon Feb 09, 2009 8:06 pm
Location: Summit County, Colorado, United States
Thanked: 115 times in 87 posts

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

Postby 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
isostatic

 
Posts: 4285
Joined: Mon Mar 19, 2007 3:52 pm
Location: Göteborg, Västra Götaland, Sweden
Thanked: 51 times in 33 posts

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

Postby Montana Matt » Tue Sep 28, 2010 3:58 pm

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?
User Avatar
Montana Matt
Site Admin
 
Posts: 1108
Joined: Sun Apr 11, 2004 10:06 pm
Location: Ashland, Oregon, United States
Thanked: 335 times in 181 posts

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

Postby 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
Day Hiker

 
Posts: 3156
Joined: Fri Dec 26, 2003 2:57 am
Location: Henderson, Nevada, United States
Thanked: 61 times in 43 posts

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

Postby Montana Matt » Tue Sep 28, 2010 5:48 pm

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

Me too.
User Avatar
Montana Matt
Site Admin
 
Posts: 1108
Joined: Sun Apr 11, 2004 10:06 pm
Location: Ashland, Oregon, United States
Thanked: 335 times in 181 posts

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

Postby 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
rhyang

 
Posts: 8963
Joined: Wed Apr 28, 2004 8:55 pm
Location: San Jose, California, United States
Thanked: 58 times in 37 posts

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

Postby 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: 4285
Joined: Mon Mar 19, 2007 3:52 pm
Location: Göteborg, Västra Götaland, Sweden
Thanked: 51 times in 33 posts

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

Postby Montana Matt » Tue Sep 28, 2010 10:44 pm

isostatic wrote: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.

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.
isostatic wrote: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? :?

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.
User Avatar
Montana Matt
Site Admin
 
Posts: 1108
Joined: Sun Apr 11, 2004 10:06 pm
Location: Ashland, Oregon, United States
Thanked: 335 times in 181 posts

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

Postby 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: 4285
Joined: Mon Mar 19, 2007 3:52 pm
Location: Göteborg, Västra Götaland, Sweden
Thanked: 51 times in 33 posts

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

Postby 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.
User Avatar
isostatic

 
Posts: 4285
Joined: Mon Mar 19, 2007 3:52 pm
Location: Göteborg, Västra Götaland, Sweden
Thanked: 51 times in 33 posts

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

Postby Montana Matt » Tue Sep 28, 2010 11:19 pm

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

Ah, that explains some of it. Even though I didn't execute the deleting of the PMs until Monday, I ran the script to generate they mysql DELETE commands on Saturday night (I think). So if you didn't have them archived before then, they were marked for deletion.
User Avatar
Montana Matt
Site Admin
 
Posts: 1108
Joined: Sun Apr 11, 2004 10:06 pm
Location: Ashland, Oregon, United States
Thanked: 335 times in 181 posts

PreviousNext

Return to General

 


  • Related topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: No registered users and 0 guests

© 2006-2013 SummitPost.org. All Rights Reserved.