Remove music directory & metadata causes invalid SQL
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mixxx |
Fix Committed
|
Critical
|
Unassigned |
Bug Description
Affected version(s):
---
Latest source build from main (commit bee21d8912c839d
Steps to reproduce:
---
I have been unable to reproduce this since the initial occurrence, but these are the steps I took:
1. Ensure that Mixxx is set up with multiple music directories as part of the library.
2. Open Mixxx, navigate to Preferences.
3. Remove one of the music directories
4. Choose option to delete track metadata.
In my case, I had ~15 different music directories that I needed to remove, and removing some of them caused this bug, whereas some did not. My (uneducated) guess would be that perhaps something about the nature of the tracks in each directory may be the trigger for the bug.
Expected behaviour:
---
Directory is deleted without fanfare, and without assertions failing.
Actual behaviour:
---
A critical debug assertion is raised:
```
critical [Main] FwdSqlQuery - Failed to prepare "UPDATE library SET timesplayed=
critical [Main] DEBUG ASSERT: "!query.hasError()" in function bool TrackDAO:
```
The SQL, when formatted better, looks like this:
```sql
UPDATE library
SET timesplayed=
last_
FROM (
SELECT PlaylistTracks.
FROM PlaylistTracks
JOIN Playlists ON PlaylistTracks.
WHERE Playlists.hidden=2
GROUP BY PlaylistTracks.
WHERE library.id=q.id
AND library.id IN (3391)
```
description: | updated |
Changed in mixxx: | |
status: | Confirmed → In Progress |
assignee: | nobody → Uwe Klotz (uklotzde) |
Changed in mixxx: | |
status: | In Progress → Fix Committed |
The above query is valid and executed without errors.
- Which schema version is your database?
- Which SQLite version do you use?