[22:57:07.3736] Slim::Schema::Debug::query_start (26) SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( audio = ? AND me.id = ? AND remote = ? ) GROUP BY me.id ORDER BY me.disc, me.tracknum, concat(me.titlesort, '0'): '1', '2340', '0' [22:57:07.3877] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ?, ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '1', '6', '2340' [22:57:07.3920] Slim::Schema::Debug::query_start (26) SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( ( me.id = ? ) ): '2340' [22:57:07.3998] Slim::Schema::Debug::query_start (26) DELETE FROM tracks WHERE ( id = ? ): '2340' [22:57:07.4386] Slim::Schema::Debug::query_start (26) SELECT me.role, me.contributor, me.track FROM contributor_track me WHERE ( me.track = ? ): '2340' [22:57:07.4413] Slim::Schema::Debug::query_start (26) SELECT me.id, me.track, me.value FROM comments me WHERE ( me.track = ? ): '2340' [22:57:07.4442] Slim::Schema::Debug::query_start (26) SELECT me.genre, me.track FROM genre_track me WHERE ( me.track = ? ): '2340' [22:57:07.5627] Slim::Schema::Debug::query_start (26) INSERT INTO tracks (audio, audio_offset, audio_size, bitrate, channels, content_type, drm, filesize, lossless, rating, remote, samplerate, secs, timestamp, title, titlesearch, titlesort, tracknum, url, vbr_scale, year) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): '1', '0', '59522289', '742562.393162393', '2', 'flc', '0', '59522289', '1', '0', '0', '44100', '641.16', '1184340732', 'The Chant', 'THE CHANT', 'THE CHANT', '5', 'file:///E:/flac%20A-N/Cannonball%20Adderley/Paris,%201960/05%20The%20Chant.flac', '1', '1997' [22:57:54.5627] Slim::Schema::Debug::query_start (26) SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( audio = ? AND me.id = ? AND remote = ? ) GROUP BY me.id ORDER BY me.disc, me.tracknum, concat(me.titlesort, '0'): '1', '4979', '0' [22:57:54.5773] Slim::Schema::Debug::query_start (26) SELECT contributor.id, contributor.name, contributor.namesort, contributor.musicmagic_mixable, contributor.namesearch, contributor.musicbrainz_id FROM contributor_track me JOIN contributors contributor ON ( contributor.id = me.contributor ) WHERE ( ( ( role IN ( ?, ? ) ) AND ( me.track = ? ) ) ) GROUP BY contributor.id ORDER BY role desc: '1', '6', '2340' [22:57:54.5810] Slim::Schema::Debug::query_start (26) SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( ( me.id = ? ) ): '2340' [22:57:54.5975] Slim::Schema::Debug::query_start (26) SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.disc, me.remote, me.audio, me.audio_size, me.audio_offset, me.year, me.secs, me.cover, me.vbr_scale, me.bitrate, me.samplerate, me.samplesize, me.channels, me.block_alignment, me.endian, me.bpm, me.tagversion, me.drm, me.musicmagic_mixable, me.musicbrainz_id, me.playcount, me.lastplayed, me.lossless, me.lyrics, me.rating, me.replay_gain, me.replay_peak FROM tracks me WHERE ( url = ? ): 'clientplaylist://00:04:20:05:d0:d4' [22:57:54.6038] Slim::Schema::Debug::query_start (26) DELETE FROM playlist_track WHERE ( playlist = ? ): '19036' [22:57:54.6069] Slim::Schema::Debug::query_start (26) INSERT INTO playlist_track (playlist, position, track) VALUES (?, ?, ?): '19036', '0', '2340' [22:57:54.6087] Slim::Schema::Storage::throw_exception (67) 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 (`slimserverdot3/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at C:\Program Files\SlimServer Dot3\server\CPAN/DBIx/Class/Storage/DBI.pm line 771. [22:57:54.6095] Slim::Schema::Storage::throw_exception (67) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (C:/Program Files/SlimServer Dot3/server/Slim/Schema/Storage.pm line 67) frame 1: Slim::Schema::Storage::throw_exception (C:\Program Files\SlimServer Dot3\server\CPAN/DBIx/Class/Storage/DBI.pm line 773) frame 2: DBIx::Class::Storage::DBI::_execute (C:\Program Files\SlimServer Dot3\server\CPAN/DBIx/Class/Storage/DBI.pm line 788) frame 3: DBIx::Class::Storage::DBI::insert (C:\Program Files\SlimServer Dot3\server\CPAN/DBIx/Class/Row.pm line 75) frame 4: DBIx::Class::Row::insert (C:\Program Files\SlimServer Dot3\server\CPAN/DBIx/Class/PK/Auto.pm line 43) frame 5: DBIx::Class::PK::Auto::insert (C:\Program Files\SlimServer Dot3\server\CPAN/DBIx/Class/ResultSet.pm line 1335) frame 6: DBIx::Class::ResultSet::create (C:/Program Files/SlimServer Dot3/server/Slim/Schema/Playlist.pm line 108) frame 7: Slim::Schema::Playlist::_addTracksToPlaylist (C:/Program Files/SlimServer Dot3/server/Slim/Schema/Playlist.pm line 45) frame 8: Slim::Schema::Playlist::__ANON__ (C:\Program Files\SlimServer Dot3\server\CPAN/DBIx/Class/Schema.pm line 584) frame 9: (eval) (C:\Program Files\SlimServer Dot3\server\CPAN/DBIx/Class/Schema.pm line 572) frame 10: DBIx::Class::Schema::txn_do (C:/Program Files/SlimServer Dot3/server/Slim/Schema/Playlist.pm line 46) frame 11: (eval) (C:/Program Files/SlimServer Dot3/server/Slim/Schema/Playlist.pm line 39) frame 12: Slim::Schema::Playlist::setTracks (C:/Program Files/SlimServer Dot3/server/Slim/Player/Playlist.pm line 811) frame 13: Slim::Player::Playlist::modifyPlaylistCallback (C:/Program Files/SlimServer Dot3/server/Slim/Control/Request.pm line 1890) frame 14: (eval) (C:/Program Files/SlimServer Dot3/server/Slim/Control/Request.pm line 1890) frame 15: Slim::Control::Request::notify (C:/Program Files/SlimServer Dot3/server/Slim/Control/Request.pm line 787) frame 16: Slim::Control::Request::checkNotifications (C:\Program Files\SlimServer Dot3\server\slimserver.pl line 481) frame 17: main::idle (C:\Program Files\SlimServer Dot3\server\slimserver.pl line 452) frame 18: main::main (C:\Program Files\SlimServer Dot3\server\slimserver.pl line 1002) [22:57:54.6374] Slim::Schema::throw_exception (217) 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 (`slimserverdot3/playlist_track`, CONSTRAINT `playlist_track_ibfk_1` FOREIGN KEY (`track`) REFERENCES `tracks` (`id`) ON DELETE CASCADE) at C:\Program Files\SlimServer Dot3\server\CPAN/DBIx/Class/Storage/DBI.pm line 771. [22:57:54.6380] Slim::Schema::throw_exception (217) Backtrace: frame 0: Slim::Utils::Log::logBacktrace (C:/Program Files/SlimServer Dot3/server/Slim/Schema.pm line 217) frame 1: Slim::Schema::throw_exception (C:\Program Files\SlimServer Dot3\server\CPAN/DBIx/Class/Schema.pm line 606) frame 2: DBIx::Class::Schema::txn_do (C:/Program Files/SlimServer Dot3/server/Slim/Schema/Playlist.pm line 46) frame 3: (eval) (C:/Program Files/SlimServer Dot3/server/Slim/Schema/Playlist.pm line 39) frame 4: Slim::Schema::Playlist::setTracks (C:/Program Files/SlimServer Dot3/server/Slim/Player/Playlist.pm line 811) frame 5: Slim::Player::Playlist::modifyPlaylistCallback (C:/Program Files/SlimServer Dot3/server/Slim/Control/Request.pm line 1890) frame 6: (eval) (C:/Program Files/SlimServer Dot3/server/Slim/Control/Request.pm line 1890) frame 7: Slim::Control::Request::notify (C:/Program Files/SlimServer Dot3/server/Slim/Control/Request.pm line 787) frame 8: Slim::Control::Request::checkNotifications (C:\Program Files\SlimServer Dot3\server\slimserver.pl line 481) frame 9: main::idle (C:\Program Files\SlimServer Dot3\server\slimserver.pl line 452) frame 10: main::main (C:\Program Files\SlimServer Dot3\server\slimserver.pl line 1002)