Older stats issue

[Bok]

Let's give them a few days. Eliminating from overall would likely slow down the calculations actually, but I'm always hesitant to alter the exported data in any way unless a project refuses to fix their obvious snafu's.

Always better to get it fixed at the source...

Bok

[CanoeBeyond]

Let's give them a few days. Eliminating from overall would likely slow down the calculations actually, but I'm always hesitant to alter the exported data in any way unless a project refuses to fix their obvious snafu's.

Always better to get it fixed at the source...

Bok

I agree. It's been 5 more days...

[Fire$torm]

Well they did the rollback ---> http://aqua.dwavesys.com/forum_threa...rap=true#11777

I was wondering how long it will take to filter through the database? And since the next project export will have a large number of users in the negative, will this place an extra burden on your server?

[Bok]

Well they did the rollback ---> http://aqua.dwavesys.com/forum_threa...rap=true#11777

I was wondering how long it will take to filter through the database? And since the next project export will have a large number of users in the negative, will this place an extra burden on your server?

Nah, doesn't make any difference. The Aqua stats take less than a minute to fully parse and update into the database.

Biggest problem is the milestones, I'm going to have to manually go in and delete a lot of milestones which have been posted. It's probably just a few sql statements though to delete all where the milestone is > current_credit.

As for the moderated post, I've made a small settings change, will see if this helps.

[Fire$torm]

Nah, doesn't make any difference. The Aqua stats take less than a minute to fully parse and update into the database.

Biggest problem is the milestones, I'm going to have to manually go in and delete a lot of milestones which have been posted. It's probably just a few sql statements though to delete all where the milestone is > current_credit.

As for the moderated post, I've made a small settings change, will see if this helps.

First, For me this is nothing more than a minor nuisance issue with the Aqua@Home stats so low priority here.

Since the debacle Aqua had on the 7th of July, the Recent Milestones section on the main page of my Free-DC stats (User by CPID Stats) still show the following:

Thursday, 7 July 2011	400,000,000
Thursday, 7 July 2011	300,000,000
Thursday, 7 July 2011	200,000,000
Thursday, 7 July 2011	190,000,000
Thursday, 7 July 2011	180,000,000
Thursday, 7 July 2011	170,000,000
Thursday, 7 July 2011	160,000,000
Thursday, 7 July 2011	150,000,000
Thursday, 7 July 2011	140,000,000
Thursday, 7 July 2011	130,000,000

But on my Aqua@Home user stats page, the above are not listed, which is as it should be, not listed.

Sunday, 12 June 2011	7,000,000
Tuesday, 31 May 2011	6,500,000
Tuesday, 3 May 2011	6,000,000
Monday, 25 April 2011	5,500,000
Wednesday, 22 December 2010	5,000,000
Thursday, 11 November 2010	4,500,000
Tuesday, 26 October 2010	4,000,000
Monday, 11 October 2010	3,500,000
Wednesday, 8 September 2010	3,000,000
Friday, 20 August 2010	2,500,000
Sunday, 1 August 2010	2,000,000
Friday, 30 July 2010	1,900,000
Tuesday, 27 July 2010	1,800,000
Monday, 26 July 2010	1,700,000

So the question being, is there any chance you could zero out the Aqua@Home references for the 7th of July in regards to user by CPID Recent Milestones?

Or would trying to fix that end up FUBAR'ing all the Free-DC cumulative stats?

Thanks in advance,
Fire$torm

[Bok]

Should have it mostly done, certainly your's will be gone and the majority of the rest of them.

Can't do this in one fell swoop as the cases where there are split CPID's occur also, though we could argue they should be deleted too.

[Max Tractor]

Let's give them a few days. Eliminating from overall would likely slow down the calculations actually, but I'm always hesitant to alter the exported data in any way unless a project refuses to fix their obvious snafu's.

Always better to get it fixed at the source...

Bok

they are not fixing the huge credit awards

'Note that I am leaving alone the crazy credit assigned to returned tasks. Over time they will be removed from the DB.'

http://aqua.dwavesys.com/forum_threa...rap=true#11743