Bug 4524 – Error adding tracks through Browse Music Folder

Bug 4524 - Error adding tracks through Browse Music Folder

Summary:

Error adding tracks through Browse Music Folder

Status:	RESOLVED DUPLICATE of bug 4744

Product:	Logitech Media Server
Classification:	Unclassified
Component:	Database
Version:	6.5.1
Platform:	PC Windows XP

Importance:	P2 normal (vote)
Target Milestone:	---
Assigned To:	Chris Owens

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2006-11-19 11:12 UTC by Mick
Modified:	2007-05-17 16:30 UTC (History)
CC List:	1 user (show)

See Also:
Category:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Mick 2006-11-19 11:12:26 UTC

Today after adding 2 albums using "Browse Music Folder" and browsing to the new album, I noticed the following.

I'm using SlimServer Version: 6.5.1 - 10719 - Windows XP - EN - cp1252

1) I don't get an image in New Music -> Thumbnail view. If I go into the actual album, I see the full size cover image.
2) When I do a Rescan - New & changed I get a crash.

ERROR: Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

ERROR: Backtrace follows:

Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
   frame 1: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 788)
   frame 2: DBIx::Class::Storage::DBI::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Row.pm line 75)
   frame 3: DBIx::Class::Row::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
   frame 4: DBIx::Class::PK::Auto::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/ResultSet.pm line 1335)
   frame 5: DBIx::Class::ResultSet::create (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 108)
   frame 6: Slim::Schema::Playlist::_addTracksToPlaylist (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 45)
   frame 7: Slim::Schema::Playlist::__ANON__ (/PerlApp/DBIx/Class/Schema.pm line 584)
   frame 8: (eval) (/PerlApp/DBIx/Class/Schema.pm line 572)
   frame 9: DBIx::Class::Schema::txn_do (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 46)
   frame 10: (eval) (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 39)
   frame 11: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Player/Playlist.pm line 757)
   frame 12: Slim::Player::Playlist::modifyPlaylistCallback (/PerlApp/Slim/Control/Request.pm line 1645)
   frame 13: Slim::Control::Request::notify (/PerlApp/Slim/Control/Request.pm line 751)
   frame 14: Slim::Control::Request::checkNotifications (slimserver.pl line 469)
   frame 15: main::idle (slimserver.pl line 35)
   frame 16: PerlSvc::Startup (perlsvc.pl line 1482)
   frame 17: PerlSvc::_startup (slimserver.pl line 0)
   frame 18: (eval) (slimserver.pl line 0)

ERROR: Carp::Clan::__ANON__(): Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

ERROR: Backtrace follows:

Backtrace:

   frame 0: Slim::Schema::throw_exception (/PerlApp/DBIx/Class/Schema.pm line 606)
   frame 1: DBIx::Class::Schema::txn_do (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 46)
   frame 2: (eval) (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 39)
   frame 3: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Player/Playlist.pm line 757)
   frame 4: Slim::Player::Playlist::modifyPlaylistCallback (/PerlApp/Slim/Control/Request.pm line 1645)
   frame 5: Slim::Control::Request::notify (/PerlApp/Slim/Control/Request.pm line 751)
   frame 6: Slim::Control::Request::checkNotifications (slimserver.pl line 469)
   frame 7: main::idle (slimserver.pl line 35)
   frame 8: PerlSvc::Startup (perlsvc.pl line 1482)
   frame 9: PerlSvc::_startup (slimserver.pl line 0)
   frame 10: (eval) (slimserver.pl line 0)

ERROR: Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

ERROR: Backtrace follows:

Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
   frame 1: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 788)
   frame 2: DBIx::Class::Storage::DBI::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Row.pm line 75)
   frame 3: DBIx::Class::Row::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
   frame 4: DBIx::Class::PK::Auto::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/ResultSet.pm line 1335)
   frame 5: DBIx::Class::ResultSet::create (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 108)
   frame 6: Slim::Schema::Playlist::_addTracksToPlaylist (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 45)
   frame 7: Slim::Schema::Playlist::__ANON__ (/PerlApp/DBIx/Class/Schema.pm line 584)
   frame 8: (eval) (/PerlApp/DBIx/Class/Schema.pm line 572)
   frame 9: DBIx::Class::Schema::txn_do (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 46)
   frame 10: (eval) (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 39)
   frame 11: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Player/Playlist.pm line 757)
   frame 12: Slim::Player::Playlist::modifyPlaylistCallback (/PerlApp/Slim/Control/Request.pm line 1645)
   frame 13: Slim::Control::Request::notify (/PerlApp/Slim/Control/Request.pm line 751)
   frame 14: Slim::Control::Request::checkNotifications (slimserver.pl line 469)
   frame 15: main::idle (slimserver.pl line 35)
   frame 16: PerlSvc::Startup (perlsvc.pl line 1482)
   frame 17: PerlSvc::_startup (slimserver.pl line 0)
   frame 18: (eval) (slimserver.pl line 0)

ERROR: Carp::Clan::__ANON__(): Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

ERROR: Backtrace follows:

Backtrace:

   frame 0: Slim::Schema::throw_exception (/PerlApp/DBIx/Class/Schema.pm line 606)
   frame 1: DBIx::Class::Schema::txn_do (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 46)
   frame 2: (eval) (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 39)
   frame 3: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Player/Playlist.pm line 757)
   frame 4: Slim::Player::Playlist::modifyPlaylistCallback (/PerlApp/Slim/Control/Request.pm line 1645)
   frame 5: Slim::Control::Request::notify (/PerlApp/Slim/Control/Request.pm line 751)
   frame 6: Slim::Control::Request::checkNotifications (slimserver.pl line 469)
   frame 7: main::idle (slimserver.pl line 35)
   frame 8: PerlSvc::Startup (perlsvc.pl line 1482)
   frame 9: PerlSvc::_startup (slimserver.pl line 0)
   frame 10: (eval) (slimserver.pl line 0)

ERROR: Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

ERROR: Backtrace follows:

Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
   frame 1: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 788)
   frame 2: DBIx::Class::Storage::DBI::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Row.pm line 75)
   frame 3: DBIx::Class::Row::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
   frame 4: DBIx::Class::PK::Auto::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/ResultSet.pm line 1335)
   frame 5: DBIx::Class::ResultSet::create (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 108)
   frame 6: Slim::Schema::Playlist::_addTracksToPlaylist (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 45)
   frame 7: Slim::Schema::Playlist::__ANON__ (/PerlApp/DBIx/Class/Schema.pm line 584)
   frame 8: (eval) (/PerlApp/DBIx/Class/Schema.pm line 572)
   frame 9: DBIx::Class::Schema::txn_do (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 46)
   frame 10: (eval) (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 39)
   frame 11: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Player/Playlist.pm line 757)
   frame 12: Slim::Player::Playlist::modifyPlaylistCallback (/PerlApp/Slim/Control/Request.pm line 1645)
   frame 13: Slim::Control::Request::notify (/PerlApp/Slim/Control/Request.pm line 751)
   frame 14: Slim::Control::Request::checkNotifications (slimserver.pl line 469)
   frame 15: main::idle (slimserver.pl line 35)
   frame 16: PerlSvc::Startup (perlsvc.pl line 1482)
   frame 17: PerlSvc::_startup (slimserver.pl line 0)
   frame 18: (eval) (slimserver.pl line 0)

ERROR: Carp::Clan::__ANON__(): Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

ERROR: Backtrace follows:

Backtrace:

   frame 0: Slim::Schema::throw_exception (/PerlApp/DBIx/Class/Schema.pm line 606)
   frame 1: DBIx::Class::Schema::txn_do (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 46)
   frame 2: (eval) (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 39)
   frame 3: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Player/Playlist.pm line 757)
   frame 4: Slim::Player::Playlist::modifyPlaylistCallback (/PerlApp/Slim/Control/Request.pm line 1645)
   frame 5: Slim::Control::Request::notify (/PerlApp/Slim/Control/Request.pm line 751)
   frame 6: Slim::Control::Request::checkNotifications (slimserver.pl line 469)
   frame 7: main::idle (slimserver.pl line 35)
   frame 8: PerlSvc::Startup (perlsvc.pl line 1482)
   frame 9: PerlSvc::_startup (slimserver.pl line 0)
   frame 10: (eval) (slimserver.pl line 0)

ERROR: Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

ERROR: Backtrace follows:

Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
   frame 1: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 788)
   frame 2: DBIx::Class::Storage::DBI::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Row.pm line 75)
   frame 3: DBIx::Class::Row::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
   frame 4: DBIx::Class::PK::Auto::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/ResultSet.pm line 1335)
   frame 5: DBIx::Class::ResultSet::create (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 108)
   frame 6: Slim::Schema::Playlist::_addTracksToPlaylist (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 45)
   frame 7: Slim::Schema::Playlist::__ANON__ (/PerlApp/DBIx/Class/Schema.pm line 584)
   frame 8: (eval) (/PerlApp/DBIx/Class/Schema.pm line 572)
   frame 9: DBIx::Class::Schema::txn_do (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 46)
   frame 10: (eval) (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 39)
   frame 11: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Player/Playlist.pm line 757)
   frame 12: Slim::Player::Playlist::modifyPlaylistCallback (/PerlApp/Slim/Control/Request.pm line 1645)
   frame 13: Slim::Control::Request::notify (/PerlApp/Slim/Control/Request.pm line 751)
   frame 14: Slim::Control::Request::checkNotifications (slimserver.pl line 469)
   frame 15: main::idle (slimserver.pl line 35)
   frame 16: PerlSvc::Startup (perlsvc.pl line 1482)
   frame 17: PerlSvc::_startup (slimserver.pl line 0)
   frame 18: (eval) (slimserver.pl line 0)

ERROR: Carp::Clan::__ANON__(): Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

ERROR: Backtrace follows:

Backtrace:

   frame 0: Slim::Schema::throw_exception (/PerlApp/DBIx/Class/Schema.pm line 606)
   frame 1: DBIx::Class::Schema::txn_do (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 46)
   frame 2: (eval) (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 39)
   frame 3: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Player/Playlist.pm line 757)
   frame 4: Slim::Player::Playlist::modifyPlaylistCallback (/PerlApp/Slim/Control/Request.pm line 1645)
   frame 5: Slim::Control::Request::notify (/PerlApp/Slim/Control/Request.pm line 751)
   frame 6: Slim::Control::Request::checkNotifications (slimserver.pl line 469)
   frame 7: main::idle (slimserver.pl line 35)
   frame 8: PerlSvc::Startup (perlsvc.pl line 1482)
   frame 9: PerlSvc::_startup (slimserver.pl line 0)
   frame 10: (eval) (slimserver.pl line 0)

ERROR: Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

ERROR: Backtrace follows:

Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
   frame 1: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 788)
   frame 2: DBIx::Class::Storage::DBI::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Row.pm line 75)
   frame 3: DBIx::Class::Row::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
   frame 4: DBIx::Class::PK::Auto::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/ResultSet.pm line 1335)
   frame 5: DBIx::Class::ResultSet::create (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 108)
   frame 6: Slim::Schema::Playlist::_addTracksToPlaylist (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 45)
   frame 7: Slim::Schema::Playlist::__ANON__ (/PerlApp/DBIx/Class/Schema.pm line 584)
   frame 8: (eval) (/PerlApp/DBIx/Class/Schema.pm line 572)
   frame 9: DBIx::Class::Schema::txn_do (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 46)
   frame 10: (eval) (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 39)
   frame 11: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Player/Playlist.pm line 757)
   frame 12: Slim::Player::Playlist::modifyPlaylistCallback (/PerlApp/Slim/Control/Request.pm line 1645)
   frame 13: Slim::Control::Request::notify (/PerlApp/Slim/Control/Request.pm line 751)
   frame 14: Slim::Control::Request::checkNotifications (slimserver.pl line 469)
   frame 15: main::idle (slimserver.pl line 35)
   frame 16: PerlSvc::Startup (perlsvc.pl line 1482)
   frame 17: PerlSvc::_startup (slimserver.pl line 0)
   frame 18: (eval) (slimserver.pl line 0)

ERROR: Carp::Clan::__ANON__(): Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

ERROR: Backtrace follows:

Backtrace:

   frame 0: Slim::Schema::throw_exception (/PerlApp/DBIx/Class/Schema.pm line 606)
   frame 1: DBIx::Class::Schema::txn_do (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 46)
   frame 2: (eval) (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 39)
   frame 3: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Player/Playlist.pm line 757)
   frame 4: Slim::Player::Playlist::modifyPlaylistCallback (/PerlApp/Slim/Control/Request.pm line 1645)
   frame 5: Slim::Control::Request::notify (/PerlApp/Slim/Control/Request.pm line 751)
   frame 6: Slim::Control::Request::checkNotifications (slimserver.pl line 469)
   frame 7: main::idle (slimserver.pl line 35)
   frame 8: PerlSvc::Startup (perlsvc.pl line 1482)
   frame 9: PerlSvc::_startup (slimserver.pl line 0)
   frame 10: (eval) (slimserver.pl line 0)

ERROR: Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

ERROR: Backtrace follows:

Backtrace:

   frame 0: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
   frame 1: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 788)
   frame 2: DBIx::Class::Storage::DBI::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Row.pm line 75)
   frame 3: DBIx::Class::Row::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
   frame 4: DBIx::Class::PK::Auto::insert (C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/ResultSet.pm line 1335)
   frame 5: DBIx::Class::ResultSet::create (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 108)
   frame 6: Slim::Schema::Playlist::_addTracksToPlaylist (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 45)
   frame 7: Slim::Schema::Playlist::__ANON__ (/PerlApp/DBIx/Class/Schema.pm line 584)
   frame 8: (eval) (/PerlApp/DBIx/Class/Schema.pm line 572)
   frame 9: DBIx::Class::Schema::txn_do (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 46)
   frame 10: (eval) (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 39)
   frame 11: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Player/Playlist.pm line 757)
   frame 12: Slim::Player::Playlist::modifyPlaylistCallback (/PerlApp/Slim/Control/Request.pm line 1645)
   frame 13: Slim::Control::Request::notify (/PerlApp/Slim/Control/Request.pm line 751)
   frame 14: Slim::Control::Request::checkNotifications (slimserver.pl line 469)
   frame 15: main::idle (slimserver.pl line 35)
   frame 16: PerlSvc::Startup (perlsvc.pl line 1482)
   frame 17: PerlSvc::_startup (slimserver.pl line 0)
   frame 18: (eval) (slimserver.pl line 0)

ERROR: Carp::Clan::__ANON__(): Error executing 'INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?)': DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`slimserver/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

ERROR: Backtrace follows:

Backtrace:

   frame 0: Slim::Schema::throw_exception (/PerlApp/DBIx/Class/Schema.pm line 606)
   frame 1: DBIx::Class::Schema::txn_do (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 46)
   frame 2: (eval) (C:\Program Files\SlimServer65\server/Slim/Schema/Playlist.pm line 39)
   frame 3: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Player/Playlist.pm line 757)
   frame 4: Slim::Player::Playlist::modifyPlaylistCallback (/PerlApp/Slim/Control/Request.pm line 1645)
   frame 5: Slim::Control::Request::notify (/PerlApp/Slim/Control/Request.pm line 751)
   frame 6: Slim::Control::Request::checkNotifications (slimserver.pl line 469)
   frame 7: main::idle (slimserver.pl line 35)
   frame 8: PerlSvc::Startup (perlsvc.pl line 1482)
   frame 9: PerlSvc::_startup (slimserver.pl line 0)
   frame 10: (eval) (slimserver.pl line 0)


I also noticed this when I enabled SQL debugging

ERROR: Scanner: Failed to update isScanning: [Can't call method "print" on an undefined value at C:\Program Files\SlimServer65\server\CPAN/DBIx/Class/Storage/Statistics.pm line 54.

Comment 1 Chris Owens 2007-01-31 18:07:27 UTC

Mick, what format are the albums in?  And the image?  Is that embedded or as a separate file?

Steven could you have a look at reproducing this when Mick replies?

Comment 2 Mick 2007-02-01 13:53:02 UTC

Files are always 224Kbs VBR MP3 - ReplayGained. Created using CDex running LAME.
The associated image is a cover.jpg file in the same directory.

I'm on SlimServer Version: 6.5.2 - 11298 - Windows XP - EN - cp1252 now, so I'm not sure if this issue still exists. 
I can't even remember what I was ading to the library at the time which caused the crash. But it wasn't anything unusual.

Comment 3 Spies Steven 2007-02-13 12:53:08 UTC

Chris, I was not able to reproduce.

Comment 4 Mick 2007-02-13 13:36:57 UTC

This could well have been fixed, as it was logged some time ago.
One related issue is that a full re-scan is needed to detect images added to the directories of existing albums.
a Look for New & Changed does ont bring in cover art.
I gues Windows isn't updating the timestamp on the directory when an image file is added.


Would it be possible to add a binary field to the album table - bHasCoverArt.

The scanner then includes the directories where belonging to Album's with bHasCoverArt=false in it's New & Changed scan, just searching for images.

Comment 5 KDF 2007-05-17 16:30:20 UTC

marking as a dupe of 4744 for the "foreign key" error.
artwork adding via non-wipe scan is within the scope of bug 2116, which I've reopened.

*** This bug has been marked as a duplicate of 4744 ***