<div dir="ltr"><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">Stephen:</div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">>So, no corrupt database, and no music_* tables.  I think then that you <br>>need to now follow Paul's advice (he is the current <b style="color:black;background-color:rgb(255,255,128)">MythMusic</b> <br>>maintainer).  Purge <b style="color:black;background-color:rgb(255,255,128)">mythmusic</b>, delete all the music_* tables, and <br>>delete the MusicDBSchemaVer setting and see if that completely removes <br><b style="color:black;background-color:rgb(255,255,128)">>MythMusic</b>.  So: <br> <br>>sudo su <br>>apt purge <b style="color:black;background-color:rgb(255,255,128)">mythmusic</b> <br>>mysql mythconverg <br>>drop table if exists music_albumart; <br>>drop table if exists music_albums; <br>>drop table if exists music_artists; <br>>drop table if exists music_directories; <br>>drop table if exists music_genres; <br>>drop table if exists music_playlists; <br>>drop table if exists music_radios; <br>>drop table if exists music_smartplaylist_categories; <br>>drop table if exists music_smartplaylist_items; <br>>drop table if exists music_smartplaylists; <br>>drop table if exists music_songs; <br>>drop table if exists music_stats; <br>>drop table if exists music_streams; <br>>delete from settings where value='MusicDBSchemaVer'; <br>>quit <br>>exit</div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">Done.</div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">None of the tables existed<br></div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">(mysql> drop table if exists music_xxxxxx;<br>Query OK, 0 rows affected, 1 warning (0.00 sec)).</div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">The field containing the mythmusic schema level was deleted, hgwever<br></div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">(mysql> delete from settings where value='MusicDBSchemaVer'; <br>Query OK, 1 row affected (0.01 sec)).</div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">So, if I reinstall Mythmusic, will it re-create the tables properly?</div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">I tried it once before, when we first started trying to diagnose this; it didn't change anything.</div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small"><br></div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">Thanks for all your help!</div><div class="gmail_default" style="font-family:arial,sans-serif;font-size:small">Bob <br></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><br><div><b>__________________________________</b></div><div><font face="garamond, times new roman, serif"><b>Bob Sully</b></font></div><div><br></div></div></div></div>