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 (1m) : @ESPNStatsInfo Last season, Aaron Rodgers threw 13 TD and 0 Int while going 5-0 in Dec./Jan. regular season games
FLORIDA PACKER88 (3h) : 12 12 12 12 12 12 12 12
buckeyepackfan (13h) : THAT BAAAAAAAAD MAN IS BACK!!!!!
cheeseheads123 (13h) : 12 is back baby lets go!!!
Zero2Cool (22h) : WR Davante Adams nominated for Clutch Performer of the Week
Zero2Cool (11-Dec) : lol coach with jokes MM: "If i don't know tomorrow, they'll be putting Pat McKenzie on IR."
Zero2Cool (11-Dec) : Rod of Airs here to fook you up!
Zero2Cool (11-Dec) : Packers gonna play coy until Saturday night and go SURPRISE BITCHES
Zero2Cool (11-Dec) : Mike McCarthy on Rodgers timetable: "This is in the hands of the experts. ... Let's just wait until the experts make their decision."
Zero2Cool (11-Dec) : You can freaking localize ads too to region. This is NOT hard. Lazy asses.
Zero2Cool (11-Dec) : I think so too, but it's time they get with it. You can have ads in streaming too.
Nonstopdrivel (11-Dec) : You've been able to stream postseason games for a few years now, I think.
Zero2Cool (11-Dec) : last 4 games played, Packers have worst pass efficency, Browns 2nd worst
Zero2Cool (11-Dec) : On @oath @YahooSports and @NFL Apps
Zero2Cool (11-Dec) : Good news for NFL fans: starting with this season’s playoffs you can stream games on your phone. All phones. All carriers. For free. On
Zero2Cool (11-Dec) : Verizon to pay NFL $500 million a year to stream games
beast (11-Dec) : Packers can't catch Eagles so it doesn't directly effect our playoff chances.
Nonstopdrivel (11-Dec) : yoffs?
Nonstopdrivel (11-Dec) : So . . . could in theory be a severe sprain. Which might still sideline him for the rest of the season, but perhaps he'd be back for the pla
Zero2Cool (11-Dec) : That's regarding Carson Wentz
Zero2Cool (11-Dec) : @AlbertBreer Doctors determined with manual test there was damage to ACL, extent unknown until MRI tomorrow.
Zero2Cool (11-Dec) : Read reports that's what is feared and yes, you're right, usually if that's the fear = done
Nonstopdrivel (11-Dec) : MRI would me mostly a formality. He walked off on his own power, so possibly just a sprain? But I doubt it.
Nonstopdrivel (11-Dec) : Provocative tests on scene are pretty sensitive. If they fear his ACL is torn, it probably is.
Zero2Cool (11-Dec) : He has an ACL? I only heard there were running tests ... tomorrow.
Nonstopdrivel (11-Dec) : Depends on which Nick Foles arises from the ashes. If it's the 2013 Foles, Eagles could still be a powerhouse.
gbguy20 (11-Dec) : carson wentz torn acl. is that good or bad for our playoff chances?
nerdmann (10-Dec) : It's definitive, Davante is BETTER than Janis.
Zero2Cool (10-Dec) : can't believe some don't want Adams re-signed... what is wrong with you!!
Zero2Cool (10-Dec) : @WesHod The #Packers turned to Davante Adams several times during the final series and he came through each time. The evolution of a playmak
buckeyepackfan (10-Dec) : Packer Fans will take over Stadium today!
Zero2Cool (10-Dec) : @AaronNagler Packers just took the field to cheers. No Browns fans here to boo yet.
buckeyepackfan (10-Dec) : DILLY DILLY!
Zero2Cool (10-Dec) : Williams though, to answer your question :D
Zero2Cool (10-Dec) : First snap of the day don't mean didly
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
8h / Green Bay Packers Talk / buckeyepackfan

11h / Green Bay Packers Talk / bboystyle

11h / Green Bay Packers Talk / beast

11h / Green Bay Packers Talk / Barfarn

12h / Green Bay Packers Talk / beast

12h / Green Bay Packers Talk / DoddPower

13h / Green Bay Packers Talk / Barfarn

13h / Green Bay Packers Talk / beast

15h / Green Bay Packers Talk / nerdmann

18h / Green Bay Packers Talk / beast

21h / Green Bay Packers Talk / Mucky Tundra

22h / Green Bay Packers Talk / beast

23h / Green Bay Packers Talk / Cheesey

12-Dec / Green Bay Packers Talk / Zero2Cool

12-Dec / Green Bay Packers Talk / hardrocker950

Headlines