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 (9h) : Elizabeeth ... good bye
Zero2Cool (9h) : Saturday, August 19, 2017
Zero2Cool (9h) : That's dedicated spammng!
Nonstopdrivel (9h) : For some reason, I had to flush my DNS cache to access this site from my laptop today.
Nonstopdrivel (10h) : I prefer toads to frogs, Smokey, thank you very much.
Rockmolder (12h) : My girlfriends says thanks, Rourke.
Smokey (19h) : Nonstopdrivel that you most likely say to all the frogs you meet .
Nonstopdrivel (19-Feb) : Rockmolder's avatar is so fucking sexy.
gbguy20 (19-Feb) : never seen the interview before. tough to listen to. can't believe it was 7 years ago
gbguy20 (19-Feb) : just watched a nick Collins tribute on yourube. the end featured an interview with nick reflecting on his injury
buckeyepackfan (17-Feb) : Saints De'Vante Harris nothing but a POS!!!!! Look up his tweetes on Florida killings!!
Nonstopdrivel (17-Feb) : They're laying new gas line near my house. The trucks are all from a company in Madison.
Smokey (14-Feb) : 2018 Hall o Fame Game/Aug.2,2018/Ravens vs Bears
Zero2Cool (13-Feb) : Based off 2017 records, Packers have toughest schedule for 2018
Smokey (13-Feb) : Wow, tough new 2018 Packer Schedule !
Zero2Cool (12-Feb) : I don't know anything about him though. He good? Bad?
Zero2Cool (12-Feb) : Free Agent CB David Amerson ... bring him in!
Smokey (11-Feb) : Coffee time .
Smokey (11-Feb) : Watching girls olympic Hockey.
Rockmolder (10-Feb) : They'd have to give up half their draft. Cousins seems more likely.
Rockmolder (10-Feb) : I've read that somewhere. Wasn't anything more than speculation. Can't imagine it'll happen.
Smokey (10-Feb) : Might Denver trade with Cleveland for the #1 draft pick ?
Cheesey (10-Feb) : Zero is having fun yanking some chains!LOL!
Porforis (9-Feb) : KAPERNICK! jay kay
Zero2Cool (9-Feb) : Sign Case Keenum, trade Aaron Rodgers. Bring us a winner! (haha0
Zero2Cool (9-Feb) : in other words, it wasn't going against the salary cap, that's the point here.
Zero2Cool (9-Feb) : Favre wasn't offered $25 to stay retired! My lord, he was offered 10 year merchandising deal.
Zero2Cool (9-Feb) : Packers should be leaders, not followers. Set the trend, don't be the trend.
Zero2Cool (9-Feb) : Just because 49ers overpaid, doesn't mean other teams should be stupid.
gbguy20 (9-Feb) : wouldn't hurt the cap, just the bottom line. we offered favre 25 mill to stay retired.
gbguy20 (9-Feb) : or get him to take a team friendly number now while promising him a massive marketing contract in retirement to make up for it
gbguy20 (9-Feb) : jimmy g set the record after 7 starts. you really think Rodgers value goes down? sign him now and make it cap friendly for the next 2 years. get him for 28.5 per now instead of 34 per year a year or 2
Zero2Cool (9-Feb) : He has multiple years left, he can wait until final year, like the process goes
Zero2Cool (9-Feb) : he didn't play like a Superstar vs Panthers, he doesn't deserve new deal.
Porforis (9-Feb) : This assumes Rodgers continues to play like a superstar and doesn't miss additional seasons, lowering his value entering the mid to tail end of his career.
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 / Cheesey

1h / Random Babble / Cheesey

14h / Green Bay Packers Talk / Smokey

19-Feb / Green Bay Packers Talk / Cheesey

18-Feb / Green Bay Packers Talk / Smokey

17-Feb / Green Bay Packers Talk / Rockmolder

16-Feb / Around The NFL / Cheesey

15-Feb / Green Bay Packers Talk / Cheesey

14-Feb / Green Bay Packers Talk / wpr

13-Feb / Football Familiarity / Smokey

12-Feb / Green Bay Packers Talk / Zero2Cool

11-Feb / Green Bay Packers Talk / wpr

8-Feb / Random Babble / Smokey

8-Feb / Green Bay Packers Talk / Smokey

8-Feb / Green Bay Packers Talk / sschind

Headlines