search

stoolball-england / stoolball-org-uk

A rebuild of the Stoolball England website in Umbraco
Other
3 stars 0 forks source link

Duplicated teams on statistics tables #618

Closed sussexrick closed 2 years ago

sussexrick commented 2 years ago

This happens when PlayerRoute is NULL in StoolballPlayerInMatchStatistics, but how can it get to be NULL?

image

Currently affecting https://www.stoolball.org.uk/competitions/west-kent-ladies-league/2022/statistics/most-wickets

sussexrick commented 2 years ago

It was NULL when updating a batting scorecard and not completing the following pages. CompetitionId and ClubId were also missing. Change INSERT to query data where possible rather than relying on all data to be supplied by the calling method.