I'm using version 7.0 of SqueezeCenter server on Windows Server 2003 (32-bit). When I perform a scan, it picks up all my music but shows 0 artists. When I check the scan log I see this entry:
[08-05-11 04:09:36.2337] 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 /<C:\PROGRA~1\SQUEEZ~1\server\scanner.exe>Slim/Utils/SQLHelper.pm line 83, <$fh> line 36. Any ideas why this is happening? -- track2 ------------------------------------------------------------------------ track2's Profile: http://forums.slimdevices.com/member.php?userid=664 View this thread: http://forums.slimdevices.com/showthread.php?t=47532 _______________________________________________ discuss mailing list discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss