Page 1 of 1

Home Score Board Fixes - UPDATE - 27/03/2010

Posted: Fri Mar 26, 2010 11:36 am
by Garth Kay
Just a reminder that sometime after lunch all Home Game score boards and results will disappear from the website for a period of up to 4 hours, it could be possibly longer.

We are just testing some technical processes and once we are happy with these and see no damage to the data; we will delete all of our results database and import all Home Game results once more.

Re: Away and Home Score Boards will be down today!

Posted: Sat Mar 27, 2010 11:17 am
by Garth Kay
Hi Guys,

I'm gutted right now, and can only empathise with player's frustrations, that the process that ran last night did not work.

I worked through the night until 6.30am finding ever game and little results that wasn't in our system and should have been, i hand constructed an import file of 10,000 data lines and I was hoping to wake up this morning, import the file and find all score boards correct, all accounts linked and showing all Home Game results for players and the missing games results from Jan/Feb and March now on the website.

Alas, it was not to be, and it seems to have actually made the situation worse. I have contacted our programmers and they are looking at it. I will not rest this weekend until we have this problem sorted or until I hit the wall and every reasonable possible solution has been exhausted.

Once again, I am very sorry for the terrible inconvenience and the problems that have been caused with score boards and results this season.

Re: Home Score Board Fixes - UPDATE - 27/03/2010

Posted: Sat Mar 27, 2010 5:50 pm
by Garth Kay
Hi Guys,

Just updating you on where we are at.

I have worked all day and am running on three hours sleep and on the fumes of very potent tequilla and V cans! The later is a joke.

I have overhauled completely all of our results and gone through the database with a fine tooth comb. I have reports from 888 on every single tournament conducted this season.

So I have discovered that we were missing 282 results or games from our systems after the re boot last night. I have since found all of those games and linked them to our games in the DB (Once again!). I am now just finishing up the import file for these 282 games and that means finishing off 16,000 lines of incomplete data (This should take another 2 to three hours).

I will then import these results (some will go live almost immediately, barring any issues with the import process) the score boards and system will re synch and be re calculated tonight, then tomorrow morning all games and results will be registered in the system.

NOW the only other concern I then have is to ensure that all 888 usernames are linked to the correct accounts and game results are flowing to the correct players.

So that's where I am at with it all. A lot more games going live tonight, and tomorrow morning all HOME GAME results will be correct up until the end of the 26th of March.