[mythtv] mythmusic column artist_id

Wilhelm Eger c9egwi at uni-jena.de
Wed Aug 30 16:32:42 UTC 2006


Hello,

current svn of mythtv and mythmusic let my songs disappear. So I started
a new music search without any success. This is what my logs say:

metadata.o: You don't seem to have any tracks. That's ok with me if it's
ok with you.

2006-08-30 18:29:12.503 MSqlQuery: SELECT artist_id FROM music_artists
WHERE artist_name = 'Vanessa Mae' ;
2006-08-30 18:29:12.504 MSqlQuery: SELECT artist_id FROM music_artists
WHERE artist_name = 'Vanessa Mae' ;
2006-08-30 18:29:12.505 MSqlQuery: SELECT album_id FROM music_albums
WHERE artist_id = 670  AND album_name = 'The Original Four Seasons' ;
2006-08-30 18:29:12.505 DB Error (music select album id):
Query was:
SELECT album_id FROM music_albums WHERE artist_id = 670  AND album_name
= 'The Original Four Seasons' ;
Driver error was [2/1054]:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'artist_id' in 'where clause'

There is something wrong with the database. I could manually add this
column but wanted to let you know about this.

Best regards,

Wilhelm


More information about the mythtv-dev mailing list