PROBLEM: Ghost Playlists.
After many synchs, and resets, I ended up with many playlists on my android mobile phone with a "_1" at the end of them (Clearly duplicates).
I deleted all playlists from the phone again and again but the duplicates kept being transfered from MMW to the phone.
I could see them being generated by MMW in the task bar.
I deseleted all synch playlists, and synchronized just a single flat (no tree) playlist. Still, the same playlists were being sent over to the phone!!!
Where was MMW finding these OLD playlists/non existent playlists/deleted playlists/previously removed playlists/unselected playlists???
Where are all these OLD ORPHAN PLAYLISTS hiding? In the MMW database.
These are left over playlists that have lost their connection to their parent for a number of reasons... e.g. I forced MM to close before a playlist was moved completely from Playlists to some other collection node.I found the answer here and many thanks to the person that discovered it.http://www.mediamonkey.com/forum/viewto ... =1#p260638
Since they do not have a parent, they do not appear in the synch list, but they do get transfered.
To solve I used a tool like SQLite to run this code straight in the MMW DB.
Code: Select all
delete from playlists where parentplaylist not in (select idplaylist from playlists) and parentplaylist > 0Since this problem ADVERSLY affects performance and is a serious nuisance for all but the most tech savvy of users, I suggest MMW running the code automatically when it first starts, and just before an autosynch or manual synch is initiated.
This will be a very good solution to the problem.
Thank you for listening ))