Installed latest package from debian.slimdevices.com stable main: SqueezeCenter Version: 7.0 - 17793 - Debian - EN - iso-8859-1
Pointed library scanner at collection (mostly MP3s, some FLAC and WAVs). Scanner proceeded to find & categorize all music. Server streams songs fine, and individual songs appear to have artist info, but the DB is missing all artist references. Scanner log reveals odd-looking error: [08-04-06 12:24:10.4696] 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. ] Anybody know what's up? This looks like a real bug. SlimServer v6 from the gOS package server correctly processed artist info on the same collection. Short of waiting for a bug fix, is there anything I can do in the meantime to fix my collection DB? Thanks! -- bugmenot ------------------------------------------------------------------------ bugmenot's Profile: http://forums.slimdevices.com/member.php?userid=15664 View this thread: http://forums.slimdevices.com/showthread.php?t=45918 _______________________________________________ unix mailing list unix@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/unix
