[mythtv] mythmusic column artist_id

[Jochen Kühner]

the database structure changed in svn... maybe you have any other 
patches installed wich already upgraded your version so you missed the 
chances...

try to decrease the value MusicDBSchemaVer in the settings table...


Wilhelm Eger schrieb:
> 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
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>
>
>