search

twiceineverymoment / smashclub

A web app for managing Super Smash Bros. competitive leagues with tournaments, ELO ratings, and event management.
1 stars 1 forks source link

Tournament bracket does not clear old matches when starting a new tournament #87

Closed twiceineverymoment closed 6 years ago

twiceineverymoment commented 6 years ago

When starting a new tournament, either manually or via the auto-generator, the previous tournament matches and rounds will not be cleared, resulting in garbage being displayed on the bracket screen.

I cannot reproduce this in the testing environments, so this is likely caused by the production MySQL server not having permissions to TRUNCATE the tourney_round_list and tourney_match_order tables.

twiceineverymoment commented 6 years ago

Resolution: Grant DROP on tourney_match_order & tourney_round_list tables to the smashclub database account (root@localhost, utcsmash_test@lnwebsrv2, utcsmash_beta@lnwebsrv2, utcsmash_prod@lpwebsrv5)

Grant DROP on tourney_user_score once #81 is implemented to avoid causing this issue again.