| 2017-01-29 12:15:21 |
Kirue |
description |
Hello,
I found a bug when creating a new smart playlist. Whenever I create such a playlist with multiple rules and I set it, so that all of the rules need to be met it doesn't work as intended. I looked into the database a bit and figured out that the and_or field of the smart_playlists table stores this parameter. However, for every playlist I create, this field remains empty. Now, when I set this field manually to 1, voilà, the smart playlist worked!
Example / Reproduction of what I did:
- Create a smart playlist that contains all tracks of the 80's.
- Set two rules, both of which need to be met: year >= 1980 && year <= 1989
- Check whether the selected tracks fulfill those criteria, if not:
- Open the database in the folder ~/.local/share/noise/ with sqlite3
- run "SELECT * FROM smart_playlists;";
- Find the second field (and_or) of the 80's playlist empty :o
- Set the and_or field of this playlist to 1 by running "UPDATE smart_playlists SET and_or=1 WHERE rowid == whateveritisforyou;"
- exit the database and reopen noise
- Check the selected tracks...
It seems like an easy to fix bug, but I myself am not qualified enough to fix it, so it would be awesome if someone who is more experienced could push a fix for this. |
Hello,
I found a bug when creating a new smart playlist. Whenever I create such a playlist with multiple rules and I set it, so that all of the rules need to be met it doesn't work as intended. I looked into the database a bit and figured out that the and_or field of the smart_playlists table stores this parameter. However, for every playlist I create, this field remains empty. Now, when I set this field manually to 1, voilà, the smart playlist worked!
Example / Reproduction of what I did:
- Create a smart playlist that contains all tracks of the 80's.
- Set two rules, both of which need to be met: year >= 1980 && year <= 1989
- Check whether the selected tracks fulfill those criteria, if not:
- Open the database in the folder ~/.local/share/noise/ with sqlite3
- run "SELECT * FROM smart_playlists;";
- Find the second field (and_or) of the 80's playlist empty :o
- Set the and_or field of this playlist to 1 by running "UPDATE smart_playlists SET and_or=1 WHERE rowid == whateveritisforyou;"
- exit the database and reopen noise
- Check the selected tracks...
It seems like an easy to fix bug, but I myself am not qualified enough to fix it, so it would be awesome if someone who is more experienced could push a fix for this.
Edit: Noise version 0.4.0.2 on Elementary OS Loki |
|
| 2017-01-29 12:16:25 |
Kirue |
description |
Hello,
I found a bug when creating a new smart playlist. Whenever I create such a playlist with multiple rules and I set it, so that all of the rules need to be met it doesn't work as intended. I looked into the database a bit and figured out that the and_or field of the smart_playlists table stores this parameter. However, for every playlist I create, this field remains empty. Now, when I set this field manually to 1, voilà, the smart playlist worked!
Example / Reproduction of what I did:
- Create a smart playlist that contains all tracks of the 80's.
- Set two rules, both of which need to be met: year >= 1980 && year <= 1989
- Check whether the selected tracks fulfill those criteria, if not:
- Open the database in the folder ~/.local/share/noise/ with sqlite3
- run "SELECT * FROM smart_playlists;";
- Find the second field (and_or) of the 80's playlist empty :o
- Set the and_or field of this playlist to 1 by running "UPDATE smart_playlists SET and_or=1 WHERE rowid == whateveritisforyou;"
- exit the database and reopen noise
- Check the selected tracks...
It seems like an easy to fix bug, but I myself am not qualified enough to fix it, so it would be awesome if someone who is more experienced could push a fix for this.
Edit: Noise version 0.4.0.2 on Elementary OS Loki |
Hello,
I found a bug when creating a new smart playlist. Whenever I create such a playlist with multiple rules and I set it, so that all of the rules need to be met it doesn't work as intended. I looked into the database a bit and figured out that the and_or field of the smart_playlists table stores this parameter. However, for every playlist I create, this field remains empty. Now, when I set this field manually to 1, voilà, the smart playlist worked!
Example / Reproduction of what I did:
- Create a smart playlist that contains all tracks of the 80's.
- Set two rules, both of which need to be met: year >= 1980 && year <= 1989
- Check whether the selected tracks fulfill those criteria, if not:
- Open the database in the folder ~/.local/share/noise/ with sqlite3
- run "SELECT * FROM smart_playlists;"
- Find the second field (and_or) of the 80's playlist empty :o
- Set the and_or field of this playlist to 1 by running "UPDATE smart_playlists SET and_or=1 WHERE rowid == whateveritisforyou;"
- exit the database and reopen noise
- Check the selected tracks...
It seems like an easy to fix bug, but I myself am not qualified enough to fix it, so it would be awesome if someone who is more experienced could push a fix for this.
Edit: Noise version 0.4.0.2 on Elementary OS Loki |
|
