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

Options
Go to last post Go to first unread
Zero2Cool  
#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.
vikesrule  
#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

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

Fan Shout
Zero2Cool (13h) : Yes!!!!!
Porforis (14h) : "I said that too. Why don't you quote me?? I'm famous!" - Zero2Cool
Zero2Cool (17h) : I said that too. Why don't you quote me?? I'm famous!
uffda udfa (17h) : @ProFootballDoc says Rodgers could return Week 14 at earliest, and surgery speeds up return timeline.
Zero2Cool (18h) : McCarthy dropped a "bullshit" on packers.com stream. No delay apparently lol
Zero2Cool (18h) : @AaronNagler One thing is crystal clear: McCarthy is pissed at the way his team played yesterday.
Smokey (18h) : 2017 Packers are done , time to focus on the 2018 NFL Draft .
Zero2Cool (18h) : Mike McCarthy says Aaron Rodgers "suffered a significant injury". Will require surgery. Potentially season could be over.
Zero2Cool (18h) : McCarthy --Rodgers will have surgery. Potentially season is over.
Zero2Cool (18h) : NaVaorro Bowman will get his full-year salary from the 49ers AND get another $3 million from the Raiders.
Smokey (18h) : COOL !
Zero2Cool (19h) : added a links dropdown with some misc web links
Zero2Cool (19h) : Today's Birthdays: Laser Gunns (26)
Zero2Cool (20h) : #Packers have placed CB Quinten Rollins (ankle) on injured reserve to make room for QB Joe Callahan. Rollins was carted off yesterday.
Zero2Cool (22h) : ... no
Nonstopdrivel (16-Oct) : Are you predicting a midseason collapse for the Eagles, Panthers, and Falcons?
Zero2Cool (16-Oct) : Rodgers comes back week 16 to beat Vikings and secure home field advantage. It has been said, it will be done.
Nonstopdrivel (16-Oct) : Romo's back wouldn't hold out two games behind the Green Bay line.
Zero2Cool (16-Oct) : No one wants Tony Romo on Packers. Can we please stop this? It's already old.
uffda udfa (16-Oct) : Tony Romo among those bandied about to replace Rodgers
beast (15-Oct) : Brit Favre is a lawyer now http://bleacherreport.com/articles/2481306-brittany-favre-mallion-daughter-of-a-qb-legend-creates-her-own-greatne
Zero2Cool (15-Oct) : dneedles12 I have covered the Packers for 30 years, watched them for almost 50. Never seen a game with this many injuries. #dontblametrainin
Smokey (15-Oct) : Where's Brit Favre , he's still got it .
Nonstopdrivel (15-Oct) : There's some speculation on Twitter that Green Bay might try to re-sign Bart Starr.
Zero2Cool (15-Oct) : Maybe having the starting OL intact wasn't so good.
Mucky Tundra (15-Oct) : BAKH AND BULAGA!
Zero2Cool (15-Oct) : Michael Beller ? @MBeller
Zero2Cool (15-Oct) : Jordy Nelson six TDs on 19 catches? That can’t help but slow down.
Zero2Cool (15-Oct) : OUT: CB Kevin King CB Davon House LB Ahmad Brooks OL Adam Pankey DT Montravious Adams LB Joe Thomas S Morgan Burnett
Zero2Cool (15-Oct) : First time this season that Aaron Rodgers will have both starting tackles Bryan Bulaga and David Bakhtiari..
buckeyepackfan (15-Oct) : GO! PACK! GO!
buckeyepackfan (15-Oct) : GOOD Mornimg Packer Fans! Gameday!
buckeyepackfan (15-Oct) : Brown us the new black!
Smokey (15-Oct) : Your just wrong Nerd, and you don't even know it .
nerdmann (15-Oct) : Blue is neutral.
Please sign in to use Fan Shout
2017 Packers Schedule
Sunday, Sep 10 @ 3:25 PM
SEAHAWKS
Sunday, Sep 17 @ 7:30 PM
at Falcons
Sunday, Sep 24 @ 3:25 PM
BENGALS
Thursday, Sep 28 @ 7:25 PM
BEARS
Sunday, Oct 8 @ 3:25 PM
at Cowboys
Sunday, Oct 15 @ 12:00 PM
at Vikings
Sunday, Oct 22 @ 12:00 PM
SAINTS
Sunday, Oct 29 @ 12:00 AM
- BYE -
Monday, Nov 6 @ 7:30 PM
LIONS
Sunday, Nov 12 @ 12:00 PM
at Bears
Sunday, Nov 19 @ 12:00 PM
RAVENS
Sunday, Nov 26 @ 7:30 PM
at Steelers
Sunday, Dec 3 @ 12:00 PM
BUCCANEERS
Sunday, Dec 10 @ 12:00 PM
at Browns
Sunday, Dec 17 @ 12:00 PM
at Panthers
Saturday, Dec 23 @ 7:30 PM
VIKINGS
Sunday, Dec 31 @ 12:00 PM
at Lions
Think About It
Think About It
Recent Topics
1h / Green Bay Packers Talk / PackFanWithTwins

1h / Green Bay Packers Talk / nerdmann

2h / Green Bay Packers Talk / MintBaconDrivel

4h / Around The NFL / PackFanWithTwins

10h / Green Bay Packers Talk / musccy

12h / Green Bay Packers Talk / nerdmann

12h / Green Bay Packers Talk / nerdmann

12h / Green Bay Packers Talk / nerdmann

13h / Green Bay Packers Talk / PackFanWithTwins

13h / Green Bay Packers Talk / Porforis

13h / Green Bay Packers Talk / Porforis

13h / Green Bay Packers Talk / nerdmann

17h / Green Bay Packers Talk / DoddPower

21h / Green Bay Packers Talk / Smokey

21h / Green Bay Packers Talk / wpr

Headlines