Maxwell count is wrong on MMs page - could be an issue with > versus >=

[MarkRBright]

I see what you did there Bok and it looks right to me. It's always better to avoid taking things away.

[Werinbert]

It is probably too late for me to comment on this but I prefer "ceiling" rather than "floor." I liked the idea of 1/2, but in my way of thinking 5 is not good enough for 5.5 and thus 6 would be needed to achieve at least 1/2 of 11.

[MarkRBright]

Hey Bok,
This thread may not be dead yet.
I just noticed that I get an additional Maxwell on stats6 compared to stats, and the only thing that can account for it in my numbers is the Subtriggls. In both cases it says I need five for a Maxwell, and in stats 6 I get it and stats I don't.
Basically as it stands stats6 rounds the number you need down (i.e. 5.5 -> 5) before comparison and stats rounds up (i.e. 5.5 ->6)
I am not complaining either way as before, but I thought you should know they were behaving differently. Stats is currently 'wrong' in the sense it says one thing but does another.
Just thought you should know.

[Bok]

fixed, it should correct overnight

[MarkRBright]

Excellent.
I don't know if this is worth knowing but I have found another slightly harder to explain discrepancy between stats and stats6 on the userbycpid page.
It may be nothing, but it may indicate something you might want to look at.
On stats, my line 98 shows NanoHub@home which shows the last 4 numbers on the row (Team Rank, Project Rank, Country Rank and Join Date Ranke) as
3 180 6 3
Yet on stats 6 the same line shows
3 133 5 1

I haven't done anything with NanoHub@Home for some time - as shown by the RAC and FDC-RAC both being zero.
I confess that I really don't care about this but I thought you might be interested to see why the numbers were different when all the others appear to be the same, in case it holds some deep, dark and extremely sinister weird secret thingy. ;-)

The two references, in case it saves you a millisecond, are as follows
https://stats.free-dc.org/userbycpid...617eb6b8903f8c
https://stats6.free-dc.org/userbycpi...617eb6b8903f8c

In the meantime I have this afternoon just collected (OK I'll need to wait for iThena to release the numbers) my final SubTrigggl and it's corresponding Maxwell, 10K, Nebber (in due course ;-)) and SquarePants and barring a few bits of tidying up I am mostly going to be out of here and out of your hair, so let me take a moment to just say thank you very much again Bok for making it much more fun than just merely crunching stuff for science. This site is quite simply excellent, and your efforts have been hugely appreciated. Thank you.

[Bok]

interesting. You may have found a rather interesting bug and it's probably not just manifesting there.

I think it's due to the mariadb server on stats6 being in strict mode. The nanhub updates were giving an error on stats6. This (amongst many other things) actually causes errors on columns when the value is too large for it, which is not that unusual for boinc. I should just change a lot of columns to max varchars but honestly I'd rather just truncate a lot of the time which is what it will do in non strict mode.

I've set it to non strict, let's see if that corrects it.

[MarkRBright]

I am glad you found it interesting.
This morning I found the two sets of numbers to be the same as they were yesterday. I'm not sure if you would have expected something to correct overnight or not, but I just wanted to let you know that I still have 2 rather different versions of NanoHub.
Perhaps more interesting though, is this morning I have on the mms page another odd discrepancy between stats and stats6. I have one more Vaio on stats6. So I have just spent a few moments tracking down the two userbycpid pages and found two things. 1) Rakesearch is also different and 2) I really need to get a life ;-)
Just FYI Rakesearch for the same last 4 digits (Team Rank, Project Rank, Country Rank and Join Date Rank) shows
on stats
7 737 60 6
on stats6
8 707 59 5

This time the different Join Date Ranks cause a difference in MMs Vaios otherwise I wouldn't have seen any difference, but at some point the difference in Rank it could easily effect Top 10's 100's etc for some people. Perhaps there is something slightly more major here.
Anyway good luck with finding whatever is causing these differences.