On Mon, Apr 14, 2008 at 2:08 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;">
Looking at the mythmusic DB tables listing<br>
(<a href="http://svn.mythtv.org/trac/browser/trunk/mythplugins/mythmusic/mythmusic/dbcheck.cpp" target="_blank">http://svn.mythtv.org/trac/browser/trunk/mythplugins/mythmusic/mythmusic/dbcheck.cpp</a>)<br>
you could try this bruteforce method (although it might not work - so<br>
take backup of the DB beforehand).<br>
<br>
Close mythfrontend, shutdown mythbackend and edit the mythconverg DB:<br>
<br>
mysql> UPDATE `settings` SET 'MusicDBSchemaVer' = '';<br>
<br>
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>
<br>
This should clear out all mythmusic-related tables and reset the music<br>
DB version so that a future mythmusic DB update run should start from<br>
the very beginning, recreating all required tables in order.<br>
<br>
Let me know how it goes,<br>
Nick<br>
<br>
--<br>
Nick Morrott<br>
<br></blockquote></div><br>Thanks Nick, sorry about the delay. I tried the method you outline and I get the following message the first time I try to load mythfrontend:<br><br>2008-04-15 06:22:15.710 Upgrading to MythMusic schema version 1006<br>
2008-04-15 06:22:15.729 DB Error (Performing database upgrade):<br>
Query was: RENAME TABLE smartplaylist TO music_smartplaylists;<br>
Error was: Driver error was [2/1017]:<br>
QMYSQL: Unable to execute query<br>
Database error was:<br>
Can't find file: './mythconverg/smartplaylist.frm' (errno: 2)<br>
<br>
new version: 1006<br>
2008-04-15 06:22:15.729 Couldn't upgrade database to new schema, exiting.<br>
2008-04-15 06:22:15.730 Unable to initialize plugin 'mythmusic'.<br>
<br>
And on subsequent loads I see this:<br>
<br>
2008-04-15 06:23:03.749 Upgrading to MythMusic schema version 1006<br>
2008-04-15 06:23:03.750 DB Error (Performing database upgrade):<br>
Query was: CREATE TABLE music_albums ( album_id int(11) unsigned NOT
NULL auto_increment PRIMARY KEY, artist_id int(11) unsigned NOT NULL
default '0', album_name varchar(255) NOT NULL default '', year
smallint(6) NOT NULL default '0', compilation tinyint(1) unsigned
NOT NULL default '0', INDEX idx_album_name(album_name));<br>
Error was: Driver error was [2/1050]:<br>
QMYSQL: Unable to execute query<br>
Database error was:<br>
Table 'music_albums' already exists<br>
<br>
new version: 1006<br>
2008-04-15 06:23:03.750 Couldn't upgrade database to new schema, exiting.<br>
2008-04-15 06:23:03.750 Unable to initialize plugin 'mythmusic'.<br>
<br><br>-Greg