[mythtvnz] KM R5E50 out, and MythMusic problems

[AlanP]

At 03:02 p.m. 9/01/2007, you wrote:
>>Also, I tried deleting a few rows from the db for the music
>>collection, but it wouldn't pick up the songs I removed from the db. (On
>>reflection that's a bit strange, that the music is all in the database, but
>>isn't displaying in MythMusic at all.)
>Which table? musicmetadata is no longer used, AFAICT. Mythmusic now uses 
>music_songs, music_artists, music_albums, etc.

musicmetadata and musicplaylist are the only two tables there... it looks 
like your theory about the missing DB tables was on the money.

Here is the result of 'mythfrontend > log', and going into music.

-------------------------
2007-01-09 15:25:33.037 Registering MythMusic Media Handler 1/2 as a media 
handler ext()
2007-01-09 15:25:33.037 Registering MythMusic Media Handler 2/2 as a media 
handler ext(ogg,mp3,aac,flac)
2007-01-09 15:25:33.037 MonitorRegisterExtensions(0x40, ogg,mp3,aac,flac)
SIP listening on IP Address 192.168.0.50:5060 NAT address 192.168.0.50
SIP: Cannot register; proxy, username or password not set
2007-01-09 15:25:33.264 Starting media monitor.
2007-01-09 15:26:11.973 XMLParse::LoadTheme using 
/usr/share/mythtv/themes/default/phone-ui.xml
mythphone: Nothing in your Call History -- ok?
2007-01-09 15:26:27.991 New DB connection, total: 2
2007-01-09 15:26:27.992 Connected to database 'mythconverg' at host: 
192.168.0.50
2007-01-09 15:26:28.128 XMLParse::LoadTheme using 
/usr/share/mythtv/themes/G.A.N.T./music-ui.xml
2007-01-09 15:26:29.443 DB Error (Problem saving playlist):
Query was:
INSERT INTO music_playlists (playlist_name, playlist_songs, songcount, 
length, hostname) VALUES('default_playlist_storage', '', 0, 0, 'mythtv');
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.music_playlists' doesn't exist

2007-01-09 15:26:29.444 DB Error (Problem saving playlist):
Query was:
INSERT INTO music_playlists (playlist_name, playlist_songs, songcount, 
length, hostname) VALUES('backup_playlist_storage', '', 0, 0, 'mythtv');
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.music_playlists' doesn't exist

2007-01-09 15:26:45.986 DB Error (Problem saving playlist):
Query was:
INSERT INTO music_playlists (playlist_name, playlist_songs, songcount, 
length, hostname) VALUES('default_playlist_storage', '', 0, 0, 'mythtv');
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.music_playlists' doesn't exist

2007-01-09 15:26:45.987 DB Error (Problem saving playlist):
Query was:
INSERT INTO music_playlists (playlist_name, playlist_songs, songcount, 
length, hostname) VALUES('backup_playlist_storage', '', 0, 0, 'mythtv');
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.music_playlists' doesn't exist

2007-01-09 15:26:46.614 Connecting to backend server: 192.168.0.50:6543 
(try 1 of 5)
2007-01-09 15:26:46.615 Using protocol version 31
Destroying SipFsm object
--------------------------------

Well, it looks like the cause of the trouble is identified. Next order of 
business, to make the tables.

Uh...

Help? As I said, musicmetadata and musicplaylist are the only two present. 
It looks like upgrading from R5C7 to R5E50 is not without it's problems. 
The main being that it doesn't magically create missing tables.

>Cheers,
>Steve

--
Alan Podjursky                  ICQ 24423014
"Yay, evil evil! Happy torture!" -- Gwyneth
"When in doubt, use brute force." -- Ken Thompson
http://www.fanfiction.net/~mercva