Discussion Board
Welcome Guest! You can login or register. Login or Register.

Go to last post Go to first unread
#1 Posted : Sunday, April 29, 2012 1:32:19 PM(UTC)
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.
#2 Posted : Sunday, April 29, 2012 4:05:38 PM(UTC)
Zero2Cool said: 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.[grin1]

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

#3 Posted : Tuesday, May 1, 2012 11:51:16 AM(UTC)
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.
#4 Posted : Friday, May 4, 2012 6:38:30 AM(UTC)
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 ***
Rss Feed
Users browsing this topic
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.



Fan Shout
gbguy20 (9h) : doesn't the top 51 rule only count during the offseason? the way i understand it is everything counts once the season starts.
Smokey (10h) : Please start a thread in "Football Familiarity" and explain the Top 51 Rule, please.
Zero2Cool (15h) : Packers’ 2018 draft class will only take up about $2.9M in salary cap space thanks to the Top 51 rule
Porforis (17h) : Holy crap I'll be turning 9 in PackersHome years this year.
Zero2Cool (19h) : rock on!!
DarkaneRules (19h) : I'm celebrating 10 years at PackersHome this year.
Zero2Cool (19h) : Damn, Jared you one old ass dude.
Zero2Cool (19h) : Today's Birthdays: jdlax (115)
Zero2Cool (20h) : 1 year with Aaron Rodgers and having monster stats = GET PAID STRAIGHT CASH HOMIE
DarkaneRules (20h) : I doubt he'll take a deal like that. He wants to get paid like the other WRs have.
Zero2Cool (20h) : I would pay 2.99 million base, then incentives! INCENTIVES!!!
DarkaneRules (20h) : hah, funny how that happens in this sport. See what the market says. I wouldn't pay over 3mil.
Zero2Cool (20h) : What's the guys height Draft profile says six one, everything else says six three
Zero2Cool (20h) : You can do it!
Zero2Cool (20h) : PROVE IT
DarkaneRules (20h) : Not unless he'll take a 1-yr prove it deal on the cheap.
Zero2Cool (20h) : WR Allen Hurns will be released by the Jaguars. SIGN HIM
packerfanoutwest (20-Mar) : Burnett signing with the Steelers?
Zero2Cool (19-Mar) : Three years, $30 million could turn into one year, $13 million for Jimmy Graham
DarkaneRules (18-Mar) : to*
DarkaneRules (18-Mar) : Whatever happens, we've got to get Josh move near the LOS where he belongs.
TheKanataThrilla (18-Mar) : Would we consider trying Rollins a S?
gbguy20 (18-Mar) : so what's the deal then, are we to expect to see josh Jones in Morgan Burnetts spot this season? i guess I can't say I'm opposed to the idea.
Smokey (17-Mar) : BG is in no hurry to anounce a new Rodgers deal. Smart !
gbguy20 (17-Mar) : When is Rodgers signing that extension that was supposedly only awaiting Kirk? Typing on a phone makes things tough.
Nonstopdrivel (17-Mar) : That's what I was thinking: I wasn't aware that he was quitting.
Zero2Cool (17-Mar) : Hopefully not for a long time. We need him.
gbguy20 (17-Mar) : when is 12 resigning
Nonstopdrivel (17-Mar) : I have to say I like it, even if it means I have to put up with occasional ads for Maseratis. 😂
Nonstopdrivel (17-Mar) : Interestingly, since I blocked third-party cookies, ads I see tend to relate to the content of the page instead of my most recent Amazon searches.
TheKanataThrilla (17-Mar) : Mathieu to Texans? I thought he wanted to go to a play that was all about winning football games?
hardrocker950 (17-Mar) : Bears already matched
Zero2Cool (16-Mar) : Bears will certainly match it though. Maybe restructure after year one?
Zero2Cool (16-Mar) : but bears got lots of money, didn't think anyone would make the offer
Zero2Cool (16-Mar) : good question
Please sign in to use Fan Shout
2017 Packers Schedule
Sunday, Sep 10 @ 3:25 PM
Sunday, Sep 17 @ 7:30 PM
at Falcons
Sunday, Sep 24 @ 3:25 PM
Thursday, Sep 28 @ 7:25 PM
Sunday, Oct 8 @ 3:25 PM
at Cowboys
Sunday, Oct 15 @ 12:00 PM
at Vikings
Sunday, Oct 22 @ 12:00 PM
Sunday, Oct 29 @ 12:00 AM
- BYE -
Monday, Nov 6 @ 7:30 PM
Sunday, Nov 12 @ 12:00 PM
at Bears
Sunday, Nov 19 @ 12:00 PM
Sunday, Nov 26 @ 7:30 PM
at Steelers
Sunday, Dec 3 @ 12:00 PM
Sunday, Dec 10 @ 12:00 PM
at Browns
Sunday, Dec 17 @ 12:00 PM
at Panthers
Saturday, Dec 23 @ 7:30 PM
Sunday, Dec 31 @ 12:00 PM
at Lions
Think About It
Think About It
Recent Topics
7h / Green Bay Packers Talk / Smokey

7h / Green Bay Packers Talk / sschind

9h / Green Bay Packers Talk / Barfarn

13h / Random Babble / wpr

13h / Green Bay Packers Talk / KRK

14h / Green Bay Packers Talk / beast

14h / Green Bay Packers Talk / warhawk

20-Mar / Around The NFL / Smokey

19-Mar / Green Bay Packers Talk / isocleas2

19-Mar / Green Bay Packers Talk / gbguy20

18-Mar / Green Bay Packers Talk / nyrpack

18-Mar / Green Bay Packers Talk / Cheesey

17-Mar / Green Bay Packers Talk / Cheesey

16-Mar / Random Babble / Smokey

16-Mar / Green Bay Packers Talk / beast