Currency Leaderboard showing many duplicate entries

PhantomBot Version: 3.1.2 (stable) (Revision: 992c8752)
OS Version: Linux Mint
Java Version: 11.0.4+10-LTS
Stock PhantomBot: Yes

Let us know what help you need:
Noticed during my stream yesterday when a viewer used the !top command and his name was shown for all 10 of the top spots.

Checked the leaderboard in the control panel this morning and his name occupies the top 52 spots. My name is duplicated for the next 48 spots of the top 100.

Will need to delete duplicate rows and setup a unique index with DB Browser for SQLite

Run this query

delete   from phantombot_points
where    rowid not in
         (
         select  min(rowid)
         from    phantombot_points
         group by
                 section, variable
         );
CREATE UNIQUE INDEX points_idx on phantombot_points (section, variable);
1 Like

That worked perfectly! Thank you very much