There are some discrepancies in counting solutions in Discourse where we were including topics and posts that have already been deleted.
Before the migration, we were indicating:
John has 27 solutions because people marked his post as solution 27 times.
This is stored in the UserActions table.
After the migration, we are now counting:
John has 20 solutions because there are 20 topics where his posts are solutions
This is stored in the SolvedTopics table, and has a direct link to an existing, non-deleted topic.
There’s a subtle difference here - in the first scenario there were no validations in checking if the solution post or its topic still existed.
I’ll check in with our team which is the better number to display. Personally I am leaning counting solutions for topics that still exist.