[mythtv-users] Duplicate entries in mythmusic

[Phil Bridges]

On Tue, May 27, 2008 at 10:09 AM, Yan Seiner <yan at seiner.com> wrote:
> Paul Harrison wrote:
>> Yan Seiner wrote:
>>
>>> I've moved my mythmusic collection around. I changed the main music
>>> directory and restructured the music.
>>>
>>> I had to rescan the music tree to get my music to show up, which is what
>>> I would expect.
>>>
>>> But now I have duplicate entries - at least 2 per track.  Sometimes 4.
>>> Mythmusic will play each track at least two times.
>>>
>>> How do I clean out the database of all music and force a rescan to a
>>> clean table?
>>> Thanks,
>>>
>>> --Yan
>>>
>>>
>>>
>>
>> It would interesting to see what the DB entries look like for a
>> duplicated track but that isn't easy with the new DB schema. If you want
>> to take a look the music table all start with 'music_'.
>>
>> One way to clear the tables would be to temporarily point your music
>> directory to an empty directory do a rescan then point it back to the
>> correct directory and do another rescan but that shouldn't be necessary
>> if everything is working as it should.
>>
> Seems to be a bug in mythmusic - neither music_directories nor
> music_playlists are cleared when you scan an emply dir tree.  It seems
> that playlists and dirs are 'cumulative' and are never emptied.
>
> All of the other tables are empty as they should be.
>

Good to know this.  I've been updating all of my ID3 tags and cover
art, and will rescan when this is done.  I'm guessing I could just
truncate the music_* tables manually first?