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
Smokey (10h) : Don't look back, I'm gaining beast ! LOL
beast (12h) : Thanks Smokey!
Zero2Cool (15h) : I'm not confident vs Steelers. But they are up/down a lot.
dhazer (15h) : I actually had a Steeler fan ask me why the stadium was still packed at the end of the game on Sunday. I said we back our team no matter wha
dhazer (15h) : Kevin we will beat that this week lol
Zero2Cool (17h) : Cowboys have one touchdown in 2 games. One TD in 22 possessions. One
Smokey (20h) : Nice Week 11 Pick'em beast , salute !
hardrocker950 (21-Nov) : No late game heroics for Seattle tonight
yinzer (21-Nov) : You can do much worse than having the Steelers as your favorite team... that being said, Go Steelers!
uffda udfa (21-Nov) : Gilbert is/was their starting RT.
Zero2Cool (20-Nov) : Steelers OT Marcus Gilbert suspended four games for violating performance-enhancing substance policy.
Zero2Cool (20-Nov) : and my 1st favorite team.
Zero2Cool (20-Nov) : Packers are my 2nd favorite team.
uffda udfa (20-Nov) : Are Steelers your 2nd favorite team? I know you live the Pens and are from there.
Zero2Cool (20-Nov) : Steelers are league-best 4-1 vs. teams who currently have a winning record.
uffda udfa (20-Nov) : Kenny Clark x-rays were negative. Says he's fine.
Zero2Cool (20-Nov) : "I believe in Brett Hundley," McCarthy conclude. Quick, check coach for concussion!
Zero2Cool (20-Nov) : RB Aaron Jones was arrested in October for marijuana, driving without a license, and speeding.
Zero2Cool (20-Nov) : NFL Receiver Terry Glenn Has Died in a Car Accident
Zero2Cool (20-Nov) : @BenFennell_NFL Not to be overlooked...
Zero2Cool (20-Nov) : Packers run defense lately has been outstanding Since Nov 1 (3 games)... 59.0 YPG (3rd in NFL) and 2.33 YPC (2nd in NFL)
beast (20-Nov) : See you are troll, your true colors are showing
uffda udfa (20-Nov) : Charles Manson dead at 83.
uffda udfa (20-Nov) : At least Cleveland was the road team when Baltimore shut them out.
uffda udfa (20-Nov) : We shouldn't feel bad about being shutout by BAL. CLE was shutout by them, too.
uffda udfa (20-Nov) : Davante was a huge surprise. Ravens are tough to throw it on.
beast (20-Nov) : I don't know... Mays and Spriggs did a good job of looking offensive too!
Zero2Cool (20-Nov) : Only offensive player to come out looking good is Davante Adams.
uffda udfa (20-Nov) : He ain't changing from Hundley. Trying way too hard to prove it was right to go with him all along.
greengold (19-Nov) : A HC would say that today even if he planned to start Callahan next week.
Nonstopdrivel (19-Nov) : Yeah, well, there are plenty of people who believe in fairies and leprechauns too.
uffda udfa (19-Nov) : MM sticking with Hundley. Said he believes in him.
TheKanataThrilla (19-Nov) : Hayward with another INT 2nd of the day
Zero2Cool (19-Nov) : Martellus quit on Packers and this week they followed his lead. Offense anyway.
Nonstopdrivel (19-Nov) : Clark left with an ankle injury apparently.
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
3h / Green Bay Packers Talk / bboystyle

3h / Green Bay Packers Talk / uffda udfa

5h / Green Bay Packers Talk / beast

6h / Green Bay Packers Talk / uffda udfa

7h / Green Bay Packers Talk / beast

8h / Green Bay Packers Talk / uffda udfa

8h / Green Bay Packers Talk / beast

8h / Green Bay Packers Talk / beast

14h / Green Bay Packers Talk / Zero2Cool

16h / Green Bay Packers Talk / bboystyle

16h / Green Bay Packers Talk / Zero2Cool

20h / Green Bay Packers Talk / MintBaconDrivel

20-Nov / Green Bay Packers Talk / nerdmann

20-Nov / Green Bay Packers Talk / beast

20-Nov / GameDay Threads / nerdmann

Headlines