benetherington / node-TOM-discord-bot

MIT License
2 stars 0 forks source link

Fix author/voter name bug in /vote #26

Closed benetherington closed 2 years ago

benetherington commented 2 years ago

During the show, it was noted that /vote buttons were displaying an incorrect, and inconsistent, name for the author.

This is due to src/sqlite.js:89 using an ambiguous column name in the JOIN for Authors. It winds up joining Authors on Suggestions.authorId, which results in a voter being selected, rather than the author.