Results 1 to 19 of 19

Thread: Data shifted

  1. #1

    Data shifted

    Reference: http://stats.free-dc.org/stats.php?p...eam=iHelpForum

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

    Thanks

  2. #2
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,450
    Blog Entries
    13
    the user table crashed on one of the databases. It's been repaired now.

  3. #3
    Senior Member Dirk Broer's Avatar
    Join Date
    Jun 2013
    Location
    Leiden, South Holland, Netherlands
    Posts
    368
    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.
    Last edited by Dirk Broer; 12-27-2016 at 06:52 AM.


  4. #4
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,450
    Blog Entries
    13
    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.

  5. #5
    Senior Member Dirk Broer's Avatar
    Join Date
    Jun 2013
    Location
    Leiden, South Holland, Netherlands
    Posts
    368
    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:


  6. #6
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,450
    Blog Entries
    13
    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.

  7. #7
    Senior Member Dirk Broer's Avatar
    Join Date
    Jun 2013
    Location
    Leiden, South Holland, Netherlands
    Posts
    368
    To the best of my knowledge it is still
    Quote Originally Posted by Dirk Broer View Post
    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.
    Last edited by Dirk Broer; 12-27-2016 at 07:41 PM.


  8. #8
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,450
    Blog Entries
    13
    That's your id (which won't change).

    Your verification code you gave me is https://www.worldcommunitygrid.org/v...aeae0&xml=true which fails now

  9. #9
    Senior Member Dirk Broer's Avatar
    Join Date
    Jun 2013
    Location
    Leiden, South Holland, Netherlands
    Posts
    368
    Quote Originally Posted by Bok View Post
    That's your id (which won't change).

    Your verification code you gave me is https://www.worldcommunitygrid.org/v...aeae0&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:

    http://www.worldcommunitygrid.org/ve...aeae0&xml=true
    Last edited by Dirk Broer; 12-28-2016 at 10:47 AM.


  10. #10
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,450
    Blog Entries
    13
    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.

  11. #11
    Senior Member Dirk Broer's Avatar
    Join Date
    Jun 2013
    Location
    Leiden, South Holland, Netherlands
    Posts
    368
    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
    Last edited by Dirk Broer; 12-28-2016 at 12:05 PM.


  12. #12
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,450
    Blog Entries
    13
    It's running now on everyone (that has given me a verification code). Script normally runs only twice per day.

  13. #13
    Senior Member Dirk Broer's Avatar
    Join Date
    Jun 2013
    Location
    Leiden, South Holland, Netherlands
    Posts
    368
    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)


  14. #14
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,450
    Blog Entries
    13
    Checked all 4 of them and the verification codes are bad

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

  16. #16
    Senior Member Dirk Broer's Avatar
    Join Date
    Jun 2013
    Location
    Leiden, South Holland, Netherlands
    Posts
    368
    Quote Originally Posted by Bok View Post
    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.


  17. #17
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,450
    Blog Entries
    13
    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.

  18. #18
    Junior Member
    Join Date
    Feb 2010
    Location
    Raleigh, North Carolina, United States
    Posts
    25
    Bok,
    When you are doing restores, SubsetSum@Home and Russian Words Compatibility are also missing data.

  19. #19
    Senior Member Yavanius's Avatar
    Join Date
    May 2015
    Location
    SoCal, USA
    Posts
    166
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •