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 (9h) : Try Fish
Porforis (11h) : Chicken 4 dayz!
gbguy20 (22-May) : Agreed
Smokey (21-May) : Yes, I like Chick-fil-a .
Smokey (21-May) : Rabid Chicken ? LOL
rabidgopher04 (21-May) : Chick fil a
Zero2Cool (20-May) : Penguins & Bad Guys Tied 2 apiece! LETS GO PENS!
Smokey (20-May) : Who sells the best Chicken Sandwich ? Wendy, the King, McD, etc. ?
Smokey (20-May) : Just Visiting ? Join and post today !
Zero2Cool (18-May) : Screw you. (signed Pens fan)
TheKanataThrilla (18-May) : Go Sens!!! Will be in the crowd for the Friday game.
Smokey (18-May) : E.Lacy makes weight in Seattle by 2 lbs. (253 lbs.)
buckeyepackfan (17-May) : Blount signs 1 year deal with Eagles.
DarkaneRules (14-May) : and still! Miocic & Jedrzejczyk
Zero2Cool (13-May) : RP ... you mean Go Pens ... I fix for you.
RaiderPride (13-May) : Gotta Love P.K. T.K.T. I agree.. Go Preds.
Smokey (12-May) : CB Kevin King signs 4 yr deal, no 5th year option .
TheKanataThrilla (12-May) : Go Nashville in the West
TheKanataThrilla (12-May) : My son is wearing his Mario Lemieux Pens shirt and my daughter is wearing he Sens shirt. We win no matter what.
Zero2Cool (11-May) : Aaron Nagler:Packers announce first training camp practice to be held Thursday, July 27
Zero2Cool (11-May) : Capitals are dirty weak trash.
Zero2Cool (11-May) : NHL is great! PENGUINS!!!!
yooperfan (10-May) : Screw the NBA and the NHL, neither are worth watching!
wpr (10-May) : hahaha. Poor Bettman. Worth the price to see it.
TheKanataThrilla (10-May) : Bettman would blow a gasket if it was an all-Canadian finals. I want Nashville as I am a huge Mike Fisher fan.
Smokey (10-May) : Cheap Shot ? I think not .
wpr (10-May) : Thrilla how about an all Canada Finals?
TheKanataThrilla (10-May) : Pens tomorrow. Screw you Caps for the cheap shot on Crosby.
TheKanataThrilla (10-May) : Go Sens. Want to see the Sens pull it out tomorrow.
DarkaneRules (9-May) : that's a good thing. means the players are staying out of trouble
DoddPower (9-May) : awfully quiet in here
DoddPower (3-May) : darn
Zero2Cool (3-May) : Bob McGinn is leaving and the Packers
DarkaneRules (1-May) : Cutting two RBs today! Now drafting 3 makes more sense!
buckeyepackfan (29-Apr) : Malachi Dupree wr LSU final pick.
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
Saturday, Dec 23 @ 7:30 PM
VIKINGS
Sunday, Dec 31 @ 12:00 PM
at Lions
Saturday, Dec 17 @ 12:00 PM
at Panthers
Think About It
Think About It
Recent Topics
5h / Green Bay Packers Talk / Barfarn

8h / Green Bay Packers Talk / nerdmann

9h / Green Bay Packers Talk / wpr

19h / Green Bay Packers Talk / nerdmann

22h / Green Bay Packers Talk / Smokey

21-May / Packers Draft Threads / Smokey

20-May / Green Bay Packers Talk / Smokey

19-May / Green Bay Packers Talk / sschind

19-May / Green Bay Packers Talk / sschind

18-May / Green Bay Packers Talk / Smokey

18-May / Green Bay Packers Talk / hardrocker950

18-May / Green Bay Packers Talk / Smokey

18-May / Around The NFL / Smokey

18-May / Green Bay Packers Talk / DakotaT

17-May / Green Bay Packers Talk / gbguy20

Headlines