search

djong1 / gp3s

gps-speedsurfing and more
6 stars 1 forks source link

Duplicate entries in event rankings #9

Closed Logiqx closed 1 year ago

Logiqx commented 1 year ago

Sometimes there are duplicate entries in event rankings:

British Foil Speed Challenge 2022 - Average Speed - Michael George, Garry Connel, Sinon Chippington and Nic Dodd are listed twice.

This problem also exists in the overall rankings:

Overall Rankings by Country - UK, Average Speed - Richard Beaman (#11 and #12) and Alex Smith (#17 and #18) are listed twice.

These are just examples and the problem also exists elsewhere.

Logiqx commented 1 year ago

Further information which may be useful...

The rebuild of UID 2640 on event ID - 707 (BFSC 2022) removed the duplicate entry for Michael George.

The rebuild of user 2640 (Michael George) was done by @jhdebruin for issue #10.

jhdebruin commented 1 year ago

check, thnx , will do a rebuild for this users also

jhdebruin commented 1 year ago

Did the first rebuild of the event, all duplicates seems to be fixed now

British Foil Speed Challenge 2022 - Average Speed - Michael George, Garry Connel, Sinon Chippington and Nic Dodd are listed twice.

jhdebruin commented 1 year ago

@Logiqx Fixed also the country ranking

Logiqx commented 1 year ago

Thanks. Manual rebuild looks to have done the job.

I guess the original bug will also need fixing to avoid it re-occurring?

jhdebruin commented 1 year ago

@Logiqx Yes, but @djong1 already has deployed the permanent solution

Logiqx commented 1 year ago

Future duplicates (should they occur) can be seen on this page - https://logiqx.github.io/gp3s-query/events/

Just be sure to check "last refreshed" at the top of the page as the report does not refresh automatically.

Logiqx commented 1 year ago

@jhdebruin - duplicates remain on 2022 Funsport Makkum GPS Speed Challenge:

https://logiqx.github.io/gp3s-query/events/740.html

Due to the success of previous rebuilds, probably worth attempting a rebuild.