<div> </div>
<div><br><br> </div>
<div><span class="gmail_quote">On 3/24/07, <b class="gmail_sendername">Tom Gutwin</b> <<a href="mailto:tgutwin@webarts.bc.ca">tgutwin@webarts.bc.ca</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">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><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">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>><br><br>--<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">http://www.webarts.bc.ca</a>
<br>GPG/pgp Pub Key: <a href="http://www.webarts.bc.ca/docs/tbgGPGPubKey.gpg.asc">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">http://jOggPlayer.webarts.bc.ca</a><br><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">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote></div>
<div> </div>
<div> </div>
<div>Thanks, that did the trick.</div>
<div> </div>
<div><br> </div>