Back To Announcements & Rules

Warning - Read Tracking is being cleared Nov 2, 2003

  • PluTunium
  • Professor
  • Professor
  • User avatar
  • Joined: Jul 10, 2003
  • Posts: 812
  • Loc: Touring the USA
  • Status: Offline

Post November 2nd, 2003, 11:35 am

Well, Hopefully the board is performs better!
http://www.silverringthing.com
http://www.xxxchurch.com
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post November 2nd, 2003, 11:35 am

  • PluTunium
  • Professor
  • Professor
  • User avatar
  • Joined: Jul 10, 2003
  • Posts: 812
  • Loc: Touring the USA
  • Status: Offline

Post November 2nd, 2003, 11:36 am

OK, it does! That post was REALLY quick. It's not slow anymore!
http://www.silverringthing.com
http://www.xxxchurch.com
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8934
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post November 2nd, 2003, 11:40 am

Yup everything seems much faster now :)
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Post November 2nd, 2003, 6:10 pm

Tremendous improvement! I was a little concerned earlier when I kept getting database connection errors, but this was an excellent move. //*Breathes in the fresh air.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8934
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post November 15th, 2003, 11:35 am

Sorry guys, I had to clear read history again without warning. The pruning feature didn't work too great.
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • Cuerock
  • Expert
  • Expert
  • No Avatar
  • Joined: Sep 30, 2003
  • Posts: 540
  • Loc: My cubical
  • Status: Offline

Post November 15th, 2003, 1:46 pm

No problem. I know that logged in this morning and i had about 40 nad didnt really have time to read them....... Came back and was like WOW i only have 5 WOOWHOO! :D
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8934
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post November 23rd, 2003, 5:48 pm

Sorry again guys, read tracking had to be cleared again :(
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Post November 23rd, 2003, 5:59 pm

Figured that as soon as I came back to the board and all was blank. *lol
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • b_heyer
  • Web Master
  • Web Master
  • User avatar
  • Joined: Jun 15, 2003
  • Posts: 4583
  • Loc: Maryland
  • Status: Offline

Post November 23rd, 2003, 5:59 pm

Heheh nah you read everthing, don't you remember?!
Pixel Acres V2
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8934
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post November 23rd, 2003, 6:01 pm

Yeah, figures haha. I tried the read_history pruning script again today, and the same thing happened. All data in the read history table was lost. At first I thought the bug was due to the table getting too big, but I just tried it again on barely any data in the table and the same thing happened, all data was lost in the table. So now I am working on debugging the pruning script to figure out what the problem is. Hopefully we won't lose any more read tracking after this.
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Post November 23rd, 2003, 6:04 pm

Look for "null" -- sounds to me like the portion of the script that executes the query is updating all fields to null Should be pretty easy to spot.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8934
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post November 23rd, 2003, 6:08 pm

Nope just found the bug. The bug is here:

Code: [ Select ]
  // Convert the days param into seconds
  // Subtract the number of days from the current day to get a epoch
  // date to prune before
  //
  $time_to_prune = $current_time - ($day_to_prune * 86400);
  1.   // Convert the days param into seconds
  2.   // Subtract the number of days from the current day to get a epoch
  3.   // date to prune before
  4.   //
  5.   $time_to_prune = $current_time - ($day_to_prune * 86400);


That code looks fine, however the problem is that $day_to_prune is turning up to be 0. In the admin area I select how many days old a post has to be to prune it from it read history. I just tested it by putting 31 in the admin area and it isn't getting passed for some reason. So the problem happened because the last two times it was pruning everything older than 0 days! No wonder it wipes everything.
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Joined: Dec 20, 2002
  • Posts: 8934
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Post November 23rd, 2003, 6:11 pm

Here was the fix:

Code: [ Select ]
  // Convert the days param into seconds
  // Subtract the number of days from the current day to get a epoch
  // date to prune before
  //
  $time_to_prune = $current_time - ($days_to_prune * 86400);
  1.   // Convert the days param into seconds
  2.   // Subtract the number of days from the current day to get a epoch
  3.   // date to prune before
  4.   //
  5.   $time_to_prune = $current_time - ($days_to_prune * 86400);


Whoever wrote that script used $day_to_prune when it should have been $days_to_prune. Small mistake, huge problem. Problem now resolved.
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Post November 23rd, 2003, 6:14 pm

*lol shows the impotance of attention to detail -- just that one little "s" caused all that problem! Good job!
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Post November 23rd, 2003, 6:15 pm

Of course using spell check works too -- I can't believe I just typed that last post like that. *lol impotance=importance
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post November 23rd, 2003, 6:15 pm

1, 2, 3, 4

Post Information

  • Total Posts in this topic: 46 posts
  • Users browsing this forum: No registered users and 3 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.