I’ve sent this in chat, but I’m unsure if you’ve seen it
What I have done in the past was extracting the SQL from each scorable and running those manually via Data Explorer in order to compare it with what you expect trying to isolate where the difference comes from.
It feels somewhat wrong that you’ve made a PM public without asking if it’s okay, but alright, that’s not the point.
I’ve picked a certain user.
|Scorable||Value from Data Query||Info from profile|
I have standard multipliers. Third column provided for reference. The sum in the second column is: 1559. The “Cheers” score in user profile is 1458.
UPD: Additional info: all categories are scorable, so it’s really hard to explain why “time_read” score is so low (or posts_read). But the initial concern is visible even without the data from 3rd column: the sum from Data Query is higher than what is shown in Leaderboard/Profile, and that explains why numbers go up after a rake command.
I had a user on my forum accuse me of taking points away from him directly! Needless to say, im also seeing a related issue.
The only thing I could think of that caused it is that i changed the points awarded for each scorable (but generally changed it to be higher) and also that was probably done 2 weeks ago.
Just wanted to follow this topic to see if it is a bug. I will also investigate so I will share any update here.
I accused @falco of a similar thing.
I do notice a dip in my points quite often, though tracking that is too complex for me to get my head round. Mine may just be deleted posts from the auto-timer topics, but I’ll add my bit anyway.
I thought (if there was something amiss) it could maybe be something to do with this:
The thing is, if the score drops for a reason – having some posts deleted or likes removed, you shouldn’t see the score going back up after you run
But in my case I do see an increase after running this command.
I’m running a forked version of the leaderboard that shows individual rankings as well as a summed score for a given set of groups. I have the timeframe set for all of August and some members started complaining that they were losing points as I mentioned earlier.
The rake command also restored the points for me too, so it does indicate to me that there could be an bug in the gamification code. I didn’t actually find the root cause (sorry!) but I did also want to update the topic here that the backfilling has corrected the issue!
There was also a backfill done here reasonably recently I think to extend ours back much further than was originally done, and I gained 4000 cheers from nowhere. Which I thought was unusual as I’ve only been on Meta for just over a year, and so I thought all mine would’ve been covered by the original timeframe. I had been losing a few hundred every week though.
This is a common theme for my users as well. The scores tend to slowly decrease and jump by ~300-400 with a rake.
One specific user on my site keeps dropping in points and I’m completely stumped. A couple days ago he said he lost 200 points and showed me a cached screenshot and that was true, none of the 10 or so other people in the screenshot were inconsistent. Now again today he’s down another 200, again no change for anyone else.
None of the point values have been adjusted (which you would think should affect others as well), no topics or posts are being deleted or moved into untracked categories. No users have been deleted.
The only thing this specific user does that no one else is is Thank hundreds of posts a day presumably spamming for points, which I don’t care about, but this is the only action he does that’s different then the average user. I can’t imagine how that would possibly make his points drop but something is doing it…any ideas? Also is there any plan to allow admins to arbitrary change individual users points, that would also solve this.
I can’t say for certainty if it’s affected anyone else since I nor most people actually care that much to ever notice, but this user is in the top 20 and the others around him that I can directly see the change from his screenshot have definitely not been affected. This is apparently deeply upsetting to him and something he’s monitoring
Edit: for reference I ran the rake command when I first installed it (which was shortly after the plugin was available). I just ran it again now, and EVERY user went up, a completely inconsistent amount. I went up 10k points. That user went up 1000. The #2 user went up 2k. The number #6 user went up 50. (not 50k, 50). EVERY user went up by something (everyone in the top 200 or so, people actively changing points those below that with 2-300 points didn’t change at all), but it’s WILDLY inconsistent how much. But the fact that points returned means it has nothing to do with anything being deleted/removed. Also if adjusting the point calculations adjusts the totals automatically without running the rake then users would go up/down when it was changed, not months later (I haven’t changed any of them for many months). If it only changed the points acquired after that point, then again no points should drop. If the only thing the rake does is readjust the points then it has to be a bug somehow because it wouldn’t pull back points lost to deleted topics right (which, I don’t have any, but theoretically)