PennyDreadfulMTG/gatherling_fork

Deck 67191 has a duplicate match

Closed this issue · 2 comments

Describe the bug
Match that only happened once is listed twice.

To Reproduce
Steps to reproduce the behavior:

  1. Go to https://gatherling.one/deck.php?mode=view&id=67191
  2. View matches

Expected behavior
Game versus IAmVast should not be displayed twice.

Screenshots

Environment (please complete the following information):
n/a

Additional context
n/a

This was double-entered.
image

Fixed

Cleaned up prod db with

MariaDB [decksite]> SELECT * FROM `match` WHERE id IN (SELECT match_id FROM deck_match WHERE deck_id = 48039);
+-------+------------+-------+-------------+---------+
| id    | date       | round | elimination | mtgo_id |
+-------+------------+-------+-------------+---------+
| 71765 | 1556991000 |     4 |           0 |    NULL |
| 71767 | 1556991000 |     1 |           0 |    NULL |
| 71768 | 1556991000 |     2 |           0 |    NULL |
| 71769 | 1556991000 |     3 |           0 |    NULL |
| 71770 | 1556991000 |     3 |           0 |    NULL |
| 71771 | 1556991000 |     5 |           8 |    NULL |
+-------+------------+-------+-------------+---------+
6 rows in set (0.00 sec)

MariaDB [decksite]> DELETE FROM `match` WHERE id = 71770;
Query OK, 1 row affected (0.02 sec)