PDA

View Full Version : Cant save playlists Help!



chris600
2007-04-09, 02:51
Hi all
after installing sserver on a new hard drive with a fresh install os winxp i am having a weird problem with saving playlists. If a compile a list on the ui and click save nothing appears on the left side of the screen to save apart from the playlist name. If i save this sserver sees the name in the playlist folder but the playlist shows as empty. This happens with bouth the ui and using the remote on my sb3. It gets weirder. if instead of clicking save i click download and send it to my musicmatch application i can save it with musicmatch then export it to the playlist folder, rescan and then if i open it with either my sb or the ui slimserver sees all of the tracks no problem. also if i open an existing playlist with the ui add tracks to it then click save the only tracks that appear on the left are the original playlist tracks and not the just added ones that are visible in the now playing window on the right. I have opened some of the playlists using notepad and the ones that are working in ss list all of the tracks just fine. ones that i am saving through sserver are just displaying #curtrack 0o#extm3uo and nothing else. any ideas !!

chris600
2007-04-09, 08:08
ok. i have been to the debugging page and checked d-playlist then tried to save a playlist. this is a section of what follows. Which i might add means absolutely nothing to me !

OGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-04-09 10:16:09.4029 ERROR: Backtrace follows:

2007-04-09 10:16:09.4033 Backtrace:

frame 0: Slim::Schema::throw_exception (/PerlApp/DBIx/Class/Schema.pm line 606)
frame 1: DBIx::Class::Schema::txn_do (C:\PROGRA~1\SLIMSE~1\server/Slim/Schema/Playlist.pm line 46)
frame 2: (eval) (C:\PROGRA~1\SLIMSE~1\server/Slim/Schema/Playlist.pm line 39)
frame 3: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Control/Commands.pm line 701)
frame 4: Slim::Control::Commands::playlistSaveCommand (/PerlApp/Slim/Control/Request.pm line 1483)
frame 5: (eval) (/PerlApp/Slim/Control/Request.pm line 1483)
frame 6: Slim::Control::Request::execute (/PerlApp/Slim/Control/Request.pm line 772)
frame 7: Slim::Control::Request::executeRequest (/PerlApp/Slim/Web/Pages/EditPlaylist.pm line 126)
frame 8: Slim::Web::Pages::EditPlaylist::saveCurrentPlaylis t (/PerlApp/Slim/Web/Pages/EditPlaylist.pm line 39)
frame 9: Slim::Web::Pages::EditPlaylist::editplaylist (/PerlApp/Slim/Web/HTTP.pm line 824)
frame 10: Slim::Web::HTTP::generateHTTPResponse (/PerlApp/Slim/Web/HTTP.pm line 690)
frame 11: Slim::Web::HTTP::processURL (/PerlApp/Slim/Web/HTTP.pm line 536)
frame 12: Slim::Web::HTTP::processHTTP (/PerlApp/Slim/Networking/Select.pm line 238)
frame 13: (eval) (/PerlApp/Slim/Networking/Select.pm line 238)
frame 14: Slim::Networking::Select::select (slimserver.pl line 492)
frame 15: main::idle (slimserver.pl line 445)
frame 16: main::main (slimserver.pl line 58)
frame 17: PerlSvc::Interactive (perlsvc.pl line 1486)
frame 18: PerlSvc::_interactive (slimserver.pl line 0)
frame 19: (eval) (slimserver.pl line 0)

2007-04-09 10:16:11.6125 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:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-04-09 10:16:11.6128 ERROR: Backtrace follows:

2007-04-09 10:16:11.6134 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 773)
frame 1: DBIx::Class::Storage::DBI::_execute (C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 788)
frame 2: DBIx::Class::Storage::DBI::insert (C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Row.pm line 75)
frame 3: DBIx::Class::Row::insert (C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/PK/Auto.pm line 43)
frame 4: DBIx::Class::PK::Auto::insert (C:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/ResultSet.pm line 1335)
frame 5: DBIx::Class::ResultSet::create (C:\PROGRA~1\SLIMSE~1\server/Slim/Schema/Playlist.pm line 108)
frame 6: Slim::Schema::Playlist::_addTracksToPlaylist (C:\PROGRA~1\SLIMSE~1\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:\PROGRA~1\SLIMSE~1\server/Slim/Schema/Playlist.pm line 46)
frame 10: (eval) (C:\PROGRA~1\SLIMSE~1\server/Slim/Schema/Playlist.pm line 39)
frame 11: Slim::Schema::Playlist::setTracks (/PerlApp/Slim/Control/Commands.pm line 701)
frame 12: Slim::Control::Commands::playlistSaveCommand (/PerlApp/Slim/Control/Request.pm line 1483)
frame 13: (eval) (/PerlApp/Slim/Control/Request.pm line 1483)
frame 14: Slim::Control::Request::execute (/PerlApp/Slim/Control/Request.pm line 772)
frame 15: Slim::Control::Request::executeRequest (/PerlApp/Slim/Web/Pages/EditPlaylist.pm line 126)
frame 16: Slim::Web::Pages::EditPlaylist::saveCurrentPlaylis t (/PerlApp/Slim/Web/Pages/EditPlaylist.pm line 39)
frame 17: Slim::Web::Pages::EditPlaylist::editplaylist (/PerlApp/Slim/Web/HTTP.pm line 824)
frame 18: Slim::Web::HTTP::generateHTTPResponse (/PerlApp/Slim/Web/HTTP.pm line 690)
frame 19: Slim::Web::HTTP::processURL (/PerlApp/Slim/Web/HTTP.pm line 536)
frame 20: Slim::Web::HTTP::processHTTP (/PerlApp/Slim/Networking/Select.pm line 238)
frame 21: (eval) (/PerlApp/Slim/Networking/Select.pm line 238)
frame 22: Slim::Networking::Select::select (slimserver.pl line 492)
frame 23: main::idle (slimserver.pl line 445)
frame 24: main::main (slimserver.pl line 58)
frame 25: PerlSvc::Interactive (perlsvc.pl line 1486)
frame 26: PerlSvc::_interactive (slimserver.pl line 0)
frame 27: (eval) (slimserver.pl line 0)

2007-04-09 10:16:11.6356 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:\PROGRA~1\SLIMSE~1\server\CPAN/DBIx/Class/Storage/DBI.pm line 771.

2007-04-09 10:16:11.6360 ERROR: Backtrace follows:
I takje it this error is the source of my problems but i dont know where to start. Uninstall then re-install maybe. i am using SlimServer Version: 6.5.1 - 11206 - Windows XP - EN - cp1252 by the way