Data shifted

[Highlander_6596]

Reference: http://stats.free-dc.org/stats.php?page=userteamcomb&team=iHelpForum

The Yesterday totals should be the Today totals.
Something bumped all the data over one day, I think.

Thanks

[Bok]

the user table crashed on one of the databases. It's been repaired now.

[Dirk Broer]

Hurray for the fact there's a forum again!

But all is not well yet: WCG sub-project stats aren't updated for several days now. WCG Badges are though, so you see e.g. my diamond badge for MCM while -according to FreeDC- I still have 15 days to go for that badge. WCG have me clocked at 5:014:16:05:03 at the moment though.

[Bok]

The forum was only down very briefly, I just had to remove the VBAdvanced plugin as it was corrupted.

I think your verification code may have changed, which is why your subproject data is not updating. Mine has been updating just fine.

[Dirk Broer]

Why would my verification code have changed? There are lots of more people for whom the subproject data do not update. Look e.g. at MCM
Their 'Last Update' value for the WCG subprojects is frozen for almost a week now, they do not get extra credits, number of WUs or time values for their subprojects.
'Today' and 'Yesterday' values remain empty for them.

My MCM is now
at WCG 6,776,672/7= 968,096 credits 8,709 WUs 5:018:08:02:49 years:days:hours:minutes:seconds
at FreeDC 952,741 credits 8,571 WUs 4:350:3:19:42:

[Bok]

Send me your verification code again and I'll confirm, but when I tried to get to your data with the verification code in the db, it failed.

[Dirk Broer]

To the best of my knowledge it is still

User name: Dirk Broer
User ID: 749683

And it is just the subproject scores that are affected, the overall score does update and so do the badges.

BTW: the forum button on the stats page points to http://www.free-dc.org/forum/forum.php, which explains why I thought the forum was down for days.

[Bok]

That's your id (which won't change).

Your verification code you gave me is https://www.worldcommunitygrid.org/verifyMember.do?name=Dirk%2520Broer&code=7d4ab14de587043a11ef23d04e4aeae0&xml=true which fails now

[Dirk Broer]

That's your id (which won't change).

Your verification code you gave me is https://www.worldcommunitygrid.org/verifyMember.do?name=Dirk%2520Broer&code=7d4ab14de587043a11ef23d04e4aeae0&xml=true which fails now

What I gave you is exactly what is in the mail below as I included the original mail within. What does a verification code for WCG even look like?

edit: said code indeed is a string that is mentioned as 'verification code' on my https://www.worldcommunitygrid.org/ms/viewMyProfile.do

fact is that it will only update my badges, not my scores (there goes my #1 position in the subClank rankings)

The error lies between my name and my surname! You have 2520, while it should be 20:

www.worldcommunitygrid.org/verifyMember.do?name=Dirk%2520Broer&code=7d4ab14de587043a11ef23d04e4aeae0&xml=true

[Bok]

I'm not sure why it has changed, but on debugging it looks like the 'space' in your name was being treated differently when calling the url. I added some regexp to make it a '+' as that's what common user agents can handle it.

It works now and has updated your values.

[Dirk Broer]

It works with me. You might want to look at others who have values stuck in the 'last update' column as well, e.g.
alez [TSBTs Pirate] - The Scottish Boinc Team
KWSN-SpongeBob SquarePants - The Knights Who Say Ni!
branjo - The Knights Who Say Ni!
Gibson Praise - Picard

[Bok]

It's running now on everyone (that has given me a verification code). Script normally runs only twice per day.

[Dirk Broer]

There are a few people without a space in their name for whom the fix hasn't worked it seems:

branjo - The Knights Who Say Ni! (OpenZika, StopTB)
denim - SETI.USA (MCM, FAH)
Yavanius - Project Blue Book (MCM)
5TEVE - BlackOps (UGM)

[Bok]

Checked all 4 of them and the verification codes are bad :(

[tito]

After last crash 4 projects dissapeard from my stats:
BMG
Nanosurf
Gridcoin
Briseur de code

[Dirk Broer]

It's running now on everyone (that has given me a verification code). Script normally runs only twice per day.

Script has not run last 12 hours, it seems. I received WCG points in that period, but none of my subprojects did -nor with anybody else.

[Bok]

I'm out of town so this will have to wait till Sunday unfortunately. I thought some data loss may have occurred in the last user table crash, thanks for verifying. I will be able to restore those easily enough.

[Jeff17]

Bok,
When you are doing restores, SubsetSum@Home and Russian Words Compatibility are also missing data.

[Yavanius]

I just happened to be checking the forum and saw this message. It was working before so far as I know. I have a hazy memory about getting you a code one upon a time. Do you need a code from me again, Bok?