lowjumpingfrog
2008-12-12, 22:54
Just did an update to:
Version: 7.3 - 24282 @ Thu Dec 11 14:24:20 PST 2008
Operating system: Debian - EN - utf8
Platform Architecture: i686-linux
Perl Version: 5.8.8 - i486-linux-gnu-thread-multi
MySQL Version: 5.0.51a-3ubuntu5.4
Total Players Recognized: 1
After a scan, my Artist List, in Music Library, is empty. I would imagine it has something to do with this error that I found in the scanner log:
[08-12-12 22:42:28.1494] 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.
]
Is this a bug or did I screw something up? Anyone with this problem find a solution?
Thanks
John
Version: 7.3 - 24282 @ Thu Dec 11 14:24:20 PST 2008
Operating system: Debian - EN - utf8
Platform Architecture: i686-linux
Perl Version: 5.8.8 - i486-linux-gnu-thread-multi
MySQL Version: 5.0.51a-3ubuntu5.4
Total Players Recognized: 1
After a scan, my Artist List, in Music Library, is empty. I would imagine it has something to do with this error that I found in the scanner log:
[08-12-12 22:42:28.1494] 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.
]
Is this a bug or did I screw something up? Anyone with this problem find a solution?
Thanks
John