GNOME Bugzilla – Bug 548128
Smart Playlist filter: File Location contains /home/jochen/path/to/mymusic/metal doesn't work anymore
Last modified: 2009-04-22 07:57:40 UTC
When I create a smart playlist with the following settings, it doesn't contain any songs: * Match "all" of the following: * File Location contains /home/jochen/Audio/Music/Metal * Save - I have verified the file location and copy&pasted the $(pwd) output from the command line to make sure I have no typo in the path - This smart playlist works in banshee 0.13.2 (Ubuntu Hardy) - It doesn't work in banshee versions >= 1.0 - I use currently version 1.2.1-2~hardy on Ubuntu Hardy from the following repository "deb http://ppa.launchpad.net/banshee-team/ubuntu hardy main" Don't hesitate to ask if you need further information. regards, jochen
I guess your Music Library folder is "/home/jochen/Audio/Music" ? If yes, doing a search "File Location contains Metal" would probably work. It seems that banshee only searches on the URI field in the DB. But this field may contain the path relative to the Music Library folder, or the full path to the file, depending on the way it was added. This then leads to inconsistent search results. This should be fixed at the search level or we should only store full paths.
> I guess your Music Library folder is "/home/jochen/Audio/Music" ? Yes, that's correct. > It seems that banshee only searches on the URI field in the DB. > But this field may contain the path relative to the Music Library folder, or > the full path to the file, depending on the way it was added. This then leads > to inconsistent search results. > > This should be fixed at the search level or we should only store full paths. Thanks for the clarification. I've queried my db with "select URI from Tracks;" and it seems like every track has the full path (file:///home/jochen/Audio/Music/Metal/track_xy.mp3) in the URI. I was just a bit confused, by the different behaviour between banshee 0.13 and >= 1.x. When I put now only the word "Metal" in the filter, I see all my tracks from the Metal folder of the Music Library. So it works for me now. Thanks for your help.
(In reply to comment #2) > Thanks for the clarification. I've queried my db with "select URI from Tracks;" > and it seems like every track has the full path > (file:///home/jochen/Audio/Music/Metal/track_xy.mp3) in the URI. Just for clarification : looking at the query, you were querying the DB of banshee 0.13.x. The DB for banshee 1.x is "~/.config/banshee-1/banshee.db".
> Just for clarification : looking at the query, you were querying the DB of > banshee 0.13.x. The DB for banshee 1.x is "~/.config/banshee-1/banshee.db". I was querying the db of banshee 1.2.1 (~/.config/banshee-1/banshee.db). But when I do a query on ~/.config/banshee/banshee.db, the results are looking equal.
Banshee 1.x uses the CoreTracks table, so you should look into it. The "Tracks" table is just left as-is after migrating the data to the new structure.
(In reply to comment #5) > Banshee 1.x uses the CoreTracks table, so you should look into it. The "Tracks" > table is just left as-is after migrating the data to the new structure. > Ah ok thanks again ;-) There are a lot of tracks with a URI relative to my music library path. Now I understand, why my smartlist filter didn't match. best regards, jochen
Thanks for taking the time to report this bug. This particular bug has already been reported into our bug tracking system, but we are happy to tell you that the problem has already been fixed. It should be solved in the next software version. You may want to check for a software upgrade. *** This bug has been marked as a duplicate of 564355 ***