[mythtv-users] Mythmusic fail

[Stephen Worthington]

On Mon, 7 Nov 2022 10:54:09 -0800, you wrote:

>Hi, Stephen:
>
>>>This didn't go according to plan.
>>>The frontend did ask the question about upgrading the schema again, which
>>>it had stopped doing for a while.
>
>>That is definitely not what I expected. Especially errors saying
>>first that music_albumart exists, and then that it does not exist!
>
>>Do you do daily the database check and repair? (Do you have the
>>/etc/cron.daily/optimize_mythdb file?) Try manually running that file
>>as root and check the results, to make sure the database is not
>>corrupt
>
>It didn't find any corrupt tables.  However, there are no music tables
>found:
><snip>
>Repaired/Optimized: `mythconverg`.`livestream`
>Analyzed: `mythconverg`.`livestream`
>Repaired/Optimized: `mythconverg`.`logging`
>Analyzed: `mythconverg`.`logging`
>Repaired/Optimized: `mythconverg`.`movies_movies`
>Analyzed: `mythconverg`.`movies_movies`
>Repaired/Optimized: `mythconverg`.`movies_showtimes`
>Analyzed: `mythconverg`.`movies_showtimes`
>Repaired/Optimized: `mythconverg`.`movies_theaters`
>Analyzed: `mythconverg`.`movies_theaters`
>Repaired/Optimized: `mythconverg`.`mythlog`
>Analyzed: `mythconverg`.`mythlog`
>Repaired/Optimized: `mythconverg`.`mythweb_sessions`
>Analyzed: `mythconverg`.`mythweb_sessions`
>Repaired/Optimized: `mythconverg`.`netflix`
>Analyzed: `mythconverg`.`netflix`
>Repaired/Optimized: `mythconverg`.`networkiconmap`
>Analyzed: `mythconverg`.`networkiconmap`
><snip>
>
>Scratching my head (again)
>Thanks!
>Bob

So, no corrupt database, and no music_* tables.  I think then that you
need to now follow Paul's advice (he is the current MythMusic
maintainer).  Purge mythmusic, delete all the music_* tables, and
delete the MusicDBSchemaVer setting and see if that completely removes
MythMusic.  So:

sudo su
apt purge mythmusic
mysql mythconverg
drop table if exists music_albumart;
drop table if exists music_albums;
drop table if exists music_artists;
drop table if exists music_directories;
drop table if exists music_genres;
drop table if exists music_playlists;
drop table if exists music_radios;
drop table if exists music_smartplaylist_categories;
drop table if exists music_smartplaylist_items;
drop table if exists music_smartplaylists;
drop table if exists music_songs;
drop table if exists music_stats;
drop table if exists music_streams;
delete from settings where value='MusicDBSchemaVer';
quit
exit