Hello, As I finished putting the stereo together, I wanted to set up the SqueezeServer again. To have a clean environment I made a clean scan of the library (Clear library and rescan everything). During the scanning process everything looked fine, but as soon as it had finished scanning, the song and album count were correct, but the artist count fell to 0.
If I: - click on artists, an empty list is displayed - browse by genres, the Artists will display, but when clicking on an Artist, the track list is empty. The import is done through MusicIP Mixer. My System specs as SC displays them: SqueezeCenter Version: 7.2 - 22900 @ Tue Aug 26 11:27:23 PDT 2008 - Windows Vista - EN - cp1252 Perl Version: 5.8.8 MSWin32-x86-multi-thread MySQL Version: 5.0.22-community-nt Platform Architecture: 586 Scan Details: MusicIP Import (63845 of 63845) Complete 03:45:58 Playlist Scan Complete 00:00:00 Merge Various Artists (4445 of 4445) Complete 00:03:08 Artwork Scan (4816 of 4816) Complete 00:36:21 Database Optimize Complete 00:01:53 SqueezeCenter has finished scanning your music collection. Total Time: 04:27:20 I presume it's the last line of log in scanner.log: [07:20:44.8700] 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. I've attached the full scanner.log containing exactly one clean scan with the default logging paramteres in the zip file. Setting the log levels of scanner and musicip didn't give more useful informations, but made the log size grow dramatically. I made several rescans, but the outcome was always the same. Hope someone will be able to help out. Cheers, Philippe +-------------------------------------------------------------------+ |Filename: scanner.zip | |Download: http://forums.slimdevices.com/attachment.php?attachmentid=5896| +-------------------------------------------------------------------+ -- taconaut ------------------------------------------------------------------------ taconaut's Profile: http://forums.slimdevices.com/member.php?userid=13426 View this thread: http://forums.slimdevices.com/showthread.php?t=52919 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
