On Tue, Apr 15, 2008 at 6:46 AM, Nick Morrott <<a href="mailto:knowledgejunkie@gmail.com">knowledgejunkie@gmail.com</a>> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Greg,<br>
<br>
Apologies, I was asleep at the wheel. The first update will obviously fail.<br>
<br>
Try:<br>
<br>
mysql> UPDATE `settings` SET `data` = '' WHERE `value` = 'MusicDBSchemaVer';<br>
<div class="Ih2E3d">mysql> DROP TABLE IF EXISTS musicmetadata;<br>
mysql> DROP TABLE IF EXISTS musicplaylist;<br>
mysql> DROP TABLE IF EXISTS music_albumart;<br>
mysql> DROP TABLE IF EXISTS music_albums;<br>
mysql> DROP TABLE IF EXISTS music_artists;<br>
mysql> DROP TABLE IF EXISTS music_directories;<br>
mysql> DROP TABLE IF EXISTS music_genres;<br>
mysql> DROP TABLE IF EXISTS music_playlists;<br>
mysql> DROP TABLE IF EXISTS music_smartplaylists;<br>
mysql> DROP TABLE IF EXISTS music_smartplaylist_categories;<br>
mysql> DROP TABLE IF EXISTS music_smartplaylist_items;<br>
mysql> DROP TABLE IF EXISTS music_songs;<br>
mysql> DROP TABLE IF EXISTS music_stats;<br>
mysql> DROP TABLE IF EXISTS smartplaylistcategory;<br>
mysql> DROP TABLE IF EXISTS smartplaylist;<br>
mysql> DROP TABLE IF EXISTS smartplaylistitem;<br>
<br>
</div>Then re-run mythfrontend and post the results.<br>
<div><div></div><div class="Wj3C7c"><br>
--<br>
Nick Morrott<br>
</div></div></blockquote></div><br>YAY. That got me rollin'. Thanks Nick.<br><br>-Greg<br>