Hi, I am having this same problem using the official 7.0 and nightly 7.0.1 builds of SqueezeCenter. I am using Windows XP and the MusicIP integration. I too have a message on the front screen stating
> 941 albums with 7397 songs by 0 artists. Is this a known issue, I can't believe I am the only one getting this?? Looking in the DB I can see that the contributor_album table is empty although all other are fine. This means I can't search by Artist but if I go to a song the artist/contribuotr shows up fine. >From my scanner.log: > [08-03-27 19:35:04.3564] Slim::Utils::SQLHelper::executeSQLFile (85) > Error: Couldn't execute SQL statement: [INSERT INTO contributor_album > (role,contributor,album) SELECT DISTINCT role,contributor,album FROM > contributor_track,tracks where tracks.id=contributor_track.track;] : > [DBD::mysql::db do failed: Cannot add or update a child row: a foreign > key constraint fails (`slimserver/contributor_album`, CONSTRAINT > `contributor_album_ibfk_1` FOREIGN KEY (`album`) REFERENCES `albums` > (`id`) ON DELETE CASCADE) at > /<E:\MUSICP~1\SQUEEZ~1\server\scanner.exe>Slim/Utils/SQLHelper.pm line > 83, <$fh> line 36. Thanks Rob -- robroe ------------------------------------------------------------------------ robroe's Profile: http://forums.slimdevices.com/member.php?userid=14248 View this thread: http://forums.slimdevices.com/showthread.php?t=38661 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/beta
