[mythtv-users] MythMusic database upgrade failure

[Michael T. Dean]

On 11/12/2009 06:37 PM, Robin Gilks wrote:
> 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: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:
>   

cat << "EOF" | mysql -umythtv -p mythconverg
DROP TABLE IF EXISTS musicmetadata;
DROP TABLE IF EXISTS musicplaylist;
DROP TABLE IF EXISTS smartplaylistcategory;
DROP TABLE IF EXISTS smartplaylist;
DROP TABLE IF EXISTS smartplaylistitem;
DROP TABLE IF EXISTS music_albums;
DROP TABLE IF EXISTS music_artists;
DROP TABLE IF EXISTS music_genres;
DROP TABLE IF EXISTS music_playlists;
DROP TABLE IF EXISTS music_songs;
DROP TABLE IF EXISTS music_stats;
DROP TABLE IF EXISTS music_smartplaylists;
DROP TABLE IF EXISTS music_smartplaylist_items;
DROP TABLE IF EXISTS music_smartplaylist_categories;
DROP TABLE IF EXISTS music_directories;
DROP TABLE IF EXISTS music_albumart;
DELETE FROM settings WHERE value = 'MusicDBSchemaVer';
EOF

then restart mythfrontend.

Mike