madmaxoft / SkauTan

Music player for Skautské Tancování
https://skautske-tancovani.cz/
The Unlicense
1 stars 2 forks source link

Adding a file multiple times crashes #257

Closed madmaxoft closed 4 years ago

madmaxoft commented 4 years ago

When adding a file multiple times fast, SkauTan reports a DB failure:

Database::addSongFile: Cannot exec statement:  QSqlError("19", "Unable to fetch row", "UNIQUE constraint failed: NewFiles.FileName")

for SQL INSERT INTO NewFiles (FileName) VALUES(?).

SQL fix needed.