/quests top not working in mysql mode

[Dragsio]

What is your Quests version / build number (do not say "latest")?

5.1.5

Describe the problem and how to replicate it.

When I type the /quests top command (in mysql mode), it only shows the title but no players. However, in local storage mode, this command works.

Any console errors to share?

no console errors

If applicable, can you provide an example quest from quests.yml?

No response

[PikaMug]

Upon switching to mysql, data is not transferred automatically, so I assume you need to do so using https://www.spigotmc.org/resources/questsconverter.86165/

If this is not the case, please respond with a screenshot of some of your mysql table below.

[Dragsio]

Since I started using the Quests plugin, I've only been storing data in mysql.

Here's an excerpt from quest_players mysql table:

[PikaMug]

@Dragsio So the default questspoints value should be 0, not blank/null. I've just done some testing and couldn't narrow down a situation where that could occur. Maybe the structure on your table was changed? Here's what that should look like (via phpMyAdmin):

If it's the correct type of bigint(20), try setting some or all null values of questspoints to 0 then run /quests top again. You should at least get some users to appear with 0 Quest Points.

[Dragsio]

Strange, both the structure and the data in the table seem to be fine. The structure is the same as in your image and I didn't find any player that had blank/null instead of 0.