Welcome to your Green Bay Packers Online Community!

Since 2006, PackersHome has been providing a unique experience for fans.
Your participation is greatly anticipated!
Login or Register.
Options
View
Go to last post Go to first unread
Offline Zero2Cool  
#1 Posted : Sunday, April 29, 2012 1:32:19 PM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Posts: 25,675
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,846
Applause Received: 2,004

I've found a way to fix 179,300 posts from prior to the site platform switchover. I've been toying around with this for a few days. Maybe pussying around is more like it since I'm taking so many precautionary steps to ensure it's accuracy done correctly.

The reason for the 'fix' is because all of those posts prior to May 18th, 2011 have lost their formatting. It's been bugging me for a very long time. Sure, we could just delete them, but that's over 5 years of 'history' that I don't want to simply be gone with. Therefore, I've spent hours coding, testing and working out a plan to restore the posts.

I've made a mirror of the current database and been running tests against it, then making it the live database for the site to see if things work. So far, so good, but there's a lot more work to be done yet.

I'm only mentioning this so when you see weird things on the site, it's expected, no worries, I have it under control.

No posts are expected to be lost during this event and hoping to have it completed within two weeks. That's the goal.

UserPostedImage
Click here and find the LATEST Packers News!
thanks Post received 1 applause.
vikesrule on 4/29/2012(UTC)
Sponsor
Offline vikesrule  
#2 Posted : Sunday, April 29, 2012 4:05:38 PM(UTC)
vikesrule

Rank: 1st Round Draft Pick

Posts: 2,121
Joined: 8/4/2007(UTC)

Applause Given: 60
Applause Received: 193

Originally Posted by: Zero2Cool Go to Quoted Post
...when you see weird things on the site, it's expected...


That one is pretty much a given, what with all the freakin' cheeseheads that you have here.Big Grin


Seriously Kevin, you do one hell of fine job with this site....my hat's off to you.


I have noticed however, that you are pushing 19,000 posts here and that gives me great cause for concern, my young friend.
You really, really need to back away from the computer... find yourself a woman (a real one this time, no inflatables)..... and get laid. ThumpUp

Offline Zero2Cool  
#3 Posted : Tuesday, May 1, 2012 11:51:16 AM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Posts: 25,675
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,846
Applause Received: 2,004

Thanks vikesrule.


This is turning out to be more difficult than I had expected. It's keeping my mind busy, which is what I need at this time.

UserPostedImage
Click here and find the LATEST Packers News!
Offline Zero2Cool  
#4 Posted : Friday, May 4, 2012 6:38:30 AM(UTC)
Zero2Cool

Rank: Legend

Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Posts: 25,675
Joined: 10/13/2006(UTC)
Location: Green Bay, WI

Applause Given: 1,846
Applause Received: 2,004

Ugh, okay. After doing some more testing, there was about 4,885 posts that were not linked to a table. Some other posts that were floating around too have been deleted. Looks like the import post count will be around 174,411 that will be fixed.

*** you will see some weird stuff today while this occurs and the site will be down for a bit too ***

UserPostedImage
Click here and find the LATEST Packers News!
Rss Feed 
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error

Recent Topics
2h / Green Bay Packers Talk / Mucky Tundra

4h / Green Bay Packers Talk / uffda udfa

6h / Green Bay Packers Talk / Dexter_Sinister

7h / Green Bay Packers Talk / Dexter_Sinister

7h / Green Bay Packers Talk / Dexter_Sinister

7h / Green Bay Packers Talk / Dexter_Sinister

7h / Random Babble / dfosterf

7h / Green Bay Packers Talk / nerdmann

12h / Green Bay Packers Talk / Dulak

15h / Green Bay Packers Talk / StoicFire

15h / Green Bay Packers Talk / mi_keys

01-Aug / Green Bay Packers Talk / uffda udfa

31-Jul / Green Bay Packers Talk / DarkaneRules

31-Jul / Green Bay Packers Talk / DarkaneRules

31-Jul / Green Bay Packers Talk / nerdmann


Tweeter

Copyright © 2006-2014 PackersHome.com™. All Rights Reserved.