| Summary: | Dynamic playlist pick up files not in the collection anymore | ||
|---|---|---|---|
| Product: | [Applications] amarok | Reporter: | Mikko C. <mikko.cal> |
| Component: | Playlists/Dynamic Playlists | Assignee: | Amarok Developers <amarok-bugs-dist> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | Andreas.Feldmann, arancox, brandon.rader, danielcjones, dimsuz, kdebugs, lydia, matthijs, maximilian.kossick, optiluca, pantazisnikolaos, schwarzer, xenoterracide |
| Priority: | NOR | ||
| Version: | 2.1-SVN | ||
| Target Milestone: | --- | ||
| Platform: | unspecified | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
|
Description
Mikko C.
2008-09-21 19:38:17 UTC
Still present after the migration to mysqle. Still valid with today's trunk. Probably entries aren't removed from the database? This reminds me a lot of the problems Nightrose was having. CC'ing her. Might be related but as I said on the mailinglist it is different. For me the files are outside of the collection and get picked up. They are definitely in my collection browser and get picked up by dynamic playlists. Still perfectly reproducible with today's trunk. With a *clean profile* I scanned a small part of my collection (10 albums). Then I moved 5 albums out of the collection. The collection browser is correctly updated, it doesn't show the albums I removed. The dynamic playlist instead keeps picking those non-existent files. Is this a regression or was it always buggy? I'm not sure, I opened this bug in September but I think I remember seeing it before then... Isn't there a way to query the mysqle database to check if there's still some leftover from removed tracks? Yeah, start the Script Console script, and then just use it like that: sql = Amarok.Collection.escape( "SELECT columns FROM tables" ) results = Amarok.Collection.query ( sql ) <click Execute> (replace it with the right query, of course) Sorry about my slow response on this. I commited a fix for 173776, but it seems this problem may be related. I'd appreciated if someone would check if this problem persists in the latest svn. Daniel, you're back! :D I checked yesterday and it's still present. However it's not a dynamic playlist specific problem: it seems that the entries are not completely removed from the database, so the dynamic playlist still picks them. sql = Amarok.Collection.escape( "SELECT dir FROM directories" ) results = Amarok.Collection.query ( sql ) will print also the directories that have been removed from the collection. Someone should CC the right person. The database query in comment #10 is irrelevant for this bug. A solution might be to drop the uid cache for dynamic playlists whenever a collection emits the updated() signal. *** Bug 174320 has been marked as a duplicate of this bug. *** *** Bug 177274 has been marked as a duplicate of this bug. *** *** Bug 177276 has been marked as a duplicate of this bug. *** Is there any update on this? :) Reproducable here on svn version from 05.01.2008. Steps to reproduce are the same: remove some files from music dir, rescan collection, turn on dynamic playlist => unexistant entries are inserted. *** Bug 180205 has been marked as a duplicate of this bug. *** *** Bug 180205 has been marked as a duplicate of this bug. *** Any updates on this bug? :) Isn't this a rather severe bug? It's bothered me for quite a while now as I use the dynamic playlists on a daily basis and I tend to add and remove music to/from my collection every once in a while. All the music I ever added gets placed into my playlists, so I have to manually remove them all the time. I'll try the workaround of removing collection.db but it would be great if someone actually tries looking at this bug. I think severity should be "major" because of the functionality being affected. *** Bug 185483 has been marked as a duplicate of this bug. *** Happening with the 2.1 beta over here, may I add it also manifests itself by simply dragging the "local collection" into the playlist pane. The playlist is populated with all tracks ever present in the collection, even though they do not appear in the collection itself... *** Bug 193774 has been marked as a duplicate of this bug. *** bump: this bug is also bugging me in version 2.0.2 in Ubuntu. It seems that this bug has been resolved in version 2.1.1. Can others confirm this? I don't have any non-existing titles in my playlist anymore since my upgrade to the new version. True, I can't see this anymore in 2.2-svn either. |