[mythtv] MythMusic problem(s)

[Robert Johnston]

I'm not sure exactly why, but today I've been having problems with MythMusic.

I tracked it down to the fact that MySQL was giving an error (Can't
open file: 'musicmetadata.MYI'). So I dropped the table in the hopes
that MythMusic would re-create it.

No such luck. No errors from MythMusic or MySQL, but when I turn on
trace-logging in MySQL I see that all mythmusic is trying to do is a
'Select NULL; Select from musicmetadata;insert into musicmetadata',
which obviously isn't working.

Furthermore, when MythMusic scans to "Update" the music database, it
gets to 87% and dies...

Any ideas?

Trimmed-down SQL Trace log attached
-- 
Robert "Anaerin" Johnston
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mysql.log
Type: application/octet-stream
Size: 19722 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-dev/attachments/20050414/48ef377d/mysql.obj