I see a similar problem. After I "Look for new and changed music" after having added music to my music folder, I get for example:
Your music library contains 4314 albums with 52620 songs by 0 artists. The scan log says: [08-04-01 19:10:53.1641] 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 /usr/share/perl5/Slim/Utils/SQLHelper.pm line 83, <$fh> line 36. ] I'm currently running the debian testing version of squeezecenter SqueezeCenter Version: 7.1 - 18236 - Debian - EN - utf8 Server IP address: xxx.xxx.xxx.xxx Perl Version: 5.8.8 x86_64-linux-gnu-thread-multi MySQL Version: 5.0.51a-3 but this is not a new issue. I saw this behavior with the previous version (7.0.1 I believe and updated in the hope that it would go away). I've done a clear and rescan, but that will take some time given the size of my library. Thanks -- michaeleroy ------------------------------------------------------------------------ michaeleroy's Profile: http://forums.slimdevices.com/member.php?userid=12379 View this thread: http://forums.slimdevices.com/showthread.php?t=44868 _______________________________________________ unix mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/unix
