Dear players,

in order to track down the issues with league scoring / score display that still exist, let's please pool all observations into a single thread for Terry.

There currently seem to be two issues:

- There are pages that do not update until later in the day
- There also seem to be specific issues with the last day of the month.

If you have spotted discrepancies, please post your reports here, including as much detail as you can. In particular, we need:

Which pages (address/URL) are affected? If a page has more than one table, also clearly identify the one that seems off.
When does the issue occur? Especially for the daily late update one, can you please track down when exactly the update happens (daily maintenance? A different time?)
When wrong data is displayed, does it match any other data (such as the previous day) or is it an entirely different data set you can't track to anything?

We will have a much better chance to track down and fix this if we get accurate reports with players pooling their observations in one place and working together.

Please only contribute on this thread if you actually have confirmed, exact observations - "My teammate's score on an hourly did not match yesterday's" would mislead more than it can help. If you notice an issue only intermittently or once, please give as exact dates and times as you can for when you did and did not get it. The more exact the information, the better chances we have to get a quick and accurate fix.

I'll keep this as a sticky until we've found the problems.

Thanks!

Yes please, more info the better.

It's important to note that these issues are just DISPLAY issues. The data is completely fine and accurate behind the scenes. Some things are just not visually updating at the correct times.

I've noticed a discrepancy between the sum of each day's scores and the totals shown at month-end which seems to be more than a display issue. It is small but can be either less or more. For the last 2 months I have kept track of our daily scores for each game in a spreadsheet which I can forward if necessary.

During the month, until the 29th November, the sum of the individual days correctly matched the cumulative total (month points) for each game as shown in this example for Team Heroes:
https://www.funtrivia.com/heroes/tvt_thismonth.cfm#size1
This page resets on the 1st December so to get the results for the 30th November I went to
https://www.funtrivia.com/heroes/tvt_yesterdayinfo.cfm?gid=16732
(again using Team Heroes as the example)
When the score for the last day (30th) was added to the 29 day cumulative total, it differed slightly from the month's total as shown in the final score board:
https://www.funtrivia.com/templates/teamlistlast.cfm
Here are the results for Triviabiz (the columns v probably won’t line up very well but it should be fairly obvious):
Hero Dail Melt New Who Wrld FITB Fifty Total
To 29th 5885 5219 5911 7475 6251 7185 7004 7451 52381
30th Nov339 211 293 386 146 180 239 247 2041
Total 6224 5430 6204 7861 6397 7365 7243 7698 54422
Summary 6219 5410 6173 7879 6395 7393 7247 7668 54384 final score board
Diff -5 -20 -31 18 -2 28 4 -30 -38

And here for The Cat People to prove it isn’t just us:
Hero Dail Melt New Who Wrld FITB Fifty Total
To 29th 7353 6024 4721 6103 5313 7627 7145 6359 50645
30th Nov383 293 120 243 292 209 250 269 2059
Total 7736 6317 4841 6346 5605 7836 7395 6628 52704
Summary 7721 6277 4830 6366 5596 7872 7404 6613 52679 final score board
Diff -15 -40 -11 20 -9 36 9 -15 -25

The figures for the 30th were NOT a repeat of the figures for the 29th.

I hope this is clear but let me know if anything isn’t.
I can live with the minor difference which is unlikely to change the rankings but you know what those cat people are like, steal 25 points off them and you'll get a good scratching and lacerations :-)

The first issue relates to the scores showing on December 1st for the previous day.

The scores shown on our team page under the "Pts Yest" column didn't correspond with the total scores for each game. For instance, for the Daily Game, we showed 592 in the "Pts Yest" column but when I clicked that live link to go through to our individual top 8 scores, the number was actually 619 which was the correct score. The scores were incorrect for all of the games, daily and hourly. "Pts Yest" scores did not update for quite some time but I don't know when they actually updated. It could have been when the scores rolled over into the next day. I checked a few of the other team pages and they were also all incorrect.

The second issue is, once the above problem corrected itself, only the hourly games were not updating their scores until around 5:00 am FT time. The Dailies were fine. The total scores show correctly in "Pts Yest" on the team stats page but the actual scores for the top 8 team members lag behind and show our members' scores from the previous day until the update. I suspect it has something to do with the GMM game as it straddles the end of one FT day and the beginning of the next.

As for the links, just go to any team page and you'll be able to check but, to make it clearer, this is the section on the team page where the problems lie.

The Mossbacks are in League A. Here's how they rank league-wide across all games:
Game Pts Yest. Rank Yest. Monthly Pts Monthly Rank

I hope this has been helpful.

Between 12am and 5am FT time the team member's scores for all the hourly games show the scores from two days previous rather than yesterday's. The total score on the main team homepage though is correct.

https://www.funtrivia.com/hourly/tvt_yesterdayinfo.cfm?gid=14388 (Example link for Smartest game for Phoenix Rising)


On the first day of the month the same links (showing data for the last day of the previous month) for both hourly and daily games don't tally with the (correct) team total shown on the main team homepage. I think this is due to scores by players from promoted teams (who didn't actually play in that league) being slotted into the list and those in relegated teams being removed. Sorry, but I don't have any actual evidence/links to back up that theory - it's just based on having, for example, looked at the pages for a team promoted into League A on that day and seeing much smaller totals than what they actually achieved in League B.

Thanks for this -- I was able to track down the issue and hopefully fix it. Please let me know if it looks good going forward!

Fascinating... trying to work out what on earth could be causing this. The code at first glance looks correct. It calculates all of the scores as usual on the final day just as it does on any other day. Then once it has completed that it saves the final values in a "last month" record for each game.

Where on earth are those discrepancies coming from........

samak / barbarini:

On the 1st of each month, do you have more confidence in the "Points yesterday" number that is listed on the scoreboard screen for each game, or the value you get when you click through?

Im trying to determine which of the two numbers is wrong.

There are two options:

1. The scoreboard is completely correct. It's the details page that is the wrong number.

2. The yesterday's details page is wrong. The scoreboard is therefore off.

After considerable thought, this is my current theory:

- At the end of the month divisions are rebalanced. This throws some players from one division into a different one for the coming month. Before this is done we "settle" the scoreboard... yesterdays scores for everything are calculated and placed on the main overview scoreboard.

- The "yesterdays scores" pages show you data based on the divisions *right now*. So when you view yesterdays scores on the 1st, it's showing you data based on the now rebalanced divisions. So, the calculations are ignoring a few players who did score and were considered in the "real result" but arent any more, and have added a few players who weren't playing yesterday, bringing their scores from yesterday because they are now in your current division.

If this is the case (and Im thinking it is), then the results in the "yesterday's scores" are unreliable on the 1st because it's not using the right data.

I think this is what is happening... if so, I can add an exception on the 1st to calculate details based not on "current division" (which have changed from last month / yesterday), but instead use last month's division for all teams. That should in theory keep both counters consistent.

It also would mean that the "final scoreboard results" are 100% correct and always have been, since those are all calculated and settled before division changes are performed.

Please delete this post, I'm checking something else

AHA ! I think we've cracked it. When you look at
https://www.funtrivia.com/heroes/tvt_yesterdayinfo.cfm?gid=16732
on the 1st of the month, the results are calculated including the 3 promoted teams from League B and exclude the 3 teams relegated from League A.
So it looks like the final score board at:
https://www.funtrivia.com/templates/teamlistlast.cfm
is correct but the "yesterday" results on the first link are incorrect on the first day of the month.

This would also explain why the discrepancies are not very large.

Bingo. An easy fix that I'll have to verify Jan 1.

Will that correct the hourly games which aren't updating scores until 5:00 am or will you need to do a separate fix for that? I'm not sure when this started happening - probably many months ago but, previous to that, the scores for daily and hourly games would always update just after the end of the FT day.

Yes, that is already fixed. Please verify tonight if you can. Thx.

Should be able to tell right after the daily changeover...I'll try to stay awake... Thanks T!

"Yes, that is already fixed. Please verify tonight if you can. Thx."

Looks good to me.

Thanks samak, I didn't make it to midnight.

So looks like everything's found and fixed now except that we need to verify that one page on Jan 1?

Correct. Please remind me on the morning of Jan 1, since there are likely more tweaks I will have to make to get it to be consistent.

Difference in score for people who score zero on a quiz, and still part of the scoring team.
On the list with team members days total includes those scoring zero (tvt_yesterdayinfo), where as the Team info page scores the scores without them.
No examples for our team today, but if you're looking today, then "Old Farts" Fill Me In shows this (league 3).

Great news about the 0500 fix - thank you.

I had been about to attempt to start to debug a longstanding issue with division A/B/C/D override hyperlinks and with highlighting of the wrong team as my team in some of the lists. However, this seems to be working OK today. So, whether directly related, or indirectly, or nothing to do with this, thank you too - fingers crossed!

I noticed something else odd. Having had the highest score in Piece of Cake last hour, I was correctly listed in the section under last hour scores
"Top scores over all divisions last hour:

1. samak [D6] (976 pts) 2. nautilator [D5] (976 pts)"

This is correct as I took 23.75 seconds and nautilator took 24.08 seconds.

However, when I look at my team's scores for Piece of Cake at
https://www.funtrivia.com/hourly2/myteam.cfm
it shows me in second position:
Piece of Cake Last Hour
113 players played.
Rank. Player Correct Seconds Score
2. samak 10 23.75 976

I assume this issue could lead to the wrong number of team points being allocated at the end of the day. Maybe not but it needs to be checked.
The only thing I can think of at the moment that might be causing this is if the program is looking at the rounded scores (both 976 points) and ranking based on who played first (I played after nautilator).

Having had a look at the final daily scores for December, it looks like it is working correctly for the daily games (scores on this page: https://www.funtrivia.com/heroes/tvt_yesterdayinfo.cfm?gid=14388 match the total listed on the team homepage for each game), but the hourly games totals are still showing a discrepancy.

Agree. It worked correctly for Team Heroes, Mind Melt, Who am I? and Pot of Gold but had the same problem (picking up the promoted teams instead of the relegated ones) for Mixed, Smartest, Expert and Word Wizard.

I went to check our Heroes scores for yesterday here....

https://www.funtrivia.com/heroes/tvt_thismonth.cfm?yest=1

and got a blank page.

Terry, can you please allow yesterday's scores to be shown. I'm sure it's just a month-end glitch and todays' scores will show up there without a problem tomorrow.