[mythtv-users] MythMusic database upgrade failure

[Robin Gilks]

> I've just upgraded from 0.21-fixes to 0.22-fixes. I guess that over the
> last 4 years I've accumulated some cruft because each time I start the
> frontend I get the following:
>
> 2009-11-13 12:26:50.471 Current MythMusic Schema Version
> (MusicDBSchemaVer): 1013
> 2009-11-13 12:26:50.472 Timed out waiting.
> 2009-11-13 12:26:50.491 Backing up database with script:
> '/usr/local/share/mythtv/mythconverg_backup.pl'
> 2009-11-13 12:27:08.702 Database Backup complete.
> 2009-11-13 12:27:08.713 Backed up database to file:
> '/mnt/store/mythconverg-1244-20091113122650.sql.gz'
> 2009-11-13 12:27:22.344 Upgrading to MythMusic schema version 1014
> 2009-11-13 12:27:22.345 DB Error (Performing database upgrade):
> Query was: DROP TABLE musicmetadata;
> Error was: Driver error was [2/1051]:
> QMYSQL3: Unable to execute statement
> Database error was:
> Unknown table 'musicmetadata'
>
> new version: 1014
>
> After this, I'm still unable to enter MythMusic
>
> I'm quite happy to drop the music database tables to start from scratch,
> if someone could tell me how to do that, as all my files have tags so
> re-scanning shouldn't be a problem. I currently have the following tables:
>
> ls music*
> music_albumart.MYD  music_albums.frm       music_directories.MYI
> music_playlists.MYD  music_radios.frm
> music_smartplaylist_items.MYI  music_songs.MYD  music_stats.frm
> music_albumart.MYI  music_artists.MYD      music_directories.frm
> music_playlists.MYI  music_smartplaylist_categories.MYD
> music_smartplaylist_items.frm  music_songs.MYI
> music_albumart.frm  music_artists.MYI      music_genres.MYD
> music_playlists.frm  music_smartplaylist_categories.MYI
> music_smartplaylists.MYD       music_songs.frm
> music_albums.MYD    music_artists.frm      music_genres.MYI
> music_radios.MYD     music_smartplaylist_categories.frm
> music_smartplaylists.MYI       music_stats.MYD
> music_albums.MYI    music_directories.MYD  music_genres.frm
> music_radios.MYI     music_smartplaylist_items.MYD
> music_smartplaylists.frm       music_stats.MYI
>

Found this which seems to have worked...

http://www.gossamer-threads.com/lists/mythtv/users/329920

Not sure what the warning below is all about though!

2009-11-13 14:43:30.207 Music Scanner - Discarding APIC frame with size
less than 100 bytes


-- 
Robin Gilks