I had the same problem, for some reason "scan for new music" does not (completely) remove files in the database that have been moved. I have the impression that cleaning up also speeds up the Mythmusic "edit playlist" interface.<div>
<br></div><div>Regards,</div><div><br></div><div>Ronald<br><div><br><div class="gmail_quote">On Sat, Mar 24, 2007 at 11:27 PM, Tom Gutwin <span dir="ltr"><<a href="mailto:tgutwin@webarts.bc.ca">tgutwin@webarts.bc.ca</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">I had the same problem.<br>
<br>
I fixed it by deleting all the entries from the following table:<br>
music_albums<br>
<br>
Delete From music_artists<br>
Delete From music_genres<br>
Delete From music_songs<br>
<br>
I did not have any playlists setup so I got away with only those tables<br>
<br>
It worked perfectly. The next time I went to MythMusic it rescanned my files with the new<br>
names.<br>
<br>
tom<br>
<div><div></div><div class="Wj3C7c"><br>
David Campbell wrote:<br>
> matt lutz wrote:<br>
>><br>
>> Hey all,<br>
>><br>
>> I'm having a bit of a problem with the music database. I use iTunes to<br>
>> handle my music collection, and I recently had to re-install. When that<br>
>> happened, a new version of iTunes changed some of the filenames around.<br>
>> In order to update myth, I ran a "scan for new music", and it ended up<br>
>> showing a bunch of duplicates in there. I wanted to just start over, so<br>
>> I changed my music path to /tmp and then re-scanned. What's strange is<br>
>> that it won't remove all of the entries... there were still a bunch in<br>
>> there (but many were deleted). Then, if I restore to the correct path &<br>
>> rescan, there are even more duplicates.<br>
>><br>
>> How do I just start over? Can I just delete a table in the mythconverg<br>
>> database? Any help is greatly appreciated.<br>
><br>
> Deleting the table would be a bad thing if you wanted to use mythmusic<br>
> again.<br>
><br>
> I think you need to truncate the following tables to start afresh<br>
><br>
> music_albums<br>
> music_artists<br>
> music_genres<br>
> music_playlists<br>
> music_smartplaylist_categories<br>
> music_smartplaylist_items<br>
> music_smartplaylists<br>
> music_songs<br>
> music_stats<br>
> musicmetadata<br>
> musicplaylist<br>
><br>
> syntax is<br>
><br>
> DELETE FROM TABLENAME<br>
><br>
> to delete all the data but retain the table structure<br>
><br>
> TRUNCATE TABLE TABLENAME<br>
><br>
> would also work.<br>
><br>
> You might want to wait for someone a bit more knowledgable about the<br>
> mythmusic before doing this - your call.<br>
><br>
> Dave<br>
> _______________________________________________<br>
> mythtv-users mailing list<br>
> <a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
> <a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
><br>
<br>
</div></div>--<br>
--------------------- WebARTS Design ---------------------<br>
Tom Gutwin +1-604-626-9242<br>
<a href="mailto:tgutwin@webarts.bc.ca">tgutwin@webarts.bc.ca</a> <a href="http://www.webarts.bc.ca" target="_blank">http://www.webarts.bc.ca</a><br>
GPG/pgp Pub Key: <a href="http://www.webarts.bc.ca/docs/tbgGPGPubKey.gpg.asc" target="_blank">http://www.webarts.bc.ca/docs/tbgGPGPubKey.gpg.asc</a><br>
--------- Engineering Your Computer Solutions... ---------<br>
<br>
Try our Free Ogg Vorbis Player<br>
<a href="http://jOggPlayer.webarts.bc.ca" target="_blank">http://jOggPlayer.webarts.bc.ca</a><br>
<div><div></div><div class="Wj3C7c"><br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
</div></div></blockquote></div><br></div></div>