jp00p / AGIMUS

Discord bot for Friends of Desoto
MIT License
10 stars 9 forks source link

LIMIT the Number of Wishlist Dismissals to Retrieve #454

Closed zmattingly closed 9 months ago

zmattingly commented 9 months ago

We got into a funky state with some broken Wishlist Dismissal and Revoke buttons recently, see: #453

This apparently created some duplicate rows in the wishlist_dismissals table, which the fetchone() call wasn't happy with because it was returning unread results.

Add a LIMIT 1 to the lookup and the rest should sort itself out when they perform the next /wishlist matches and get cleared out by db_delete_wishlist_dismissal() on mismatch.