Bugzilla – Bug 3467
Can't play playlists or New Music using remote
Last modified: 2008-09-15 14:39:24 UTC
Debian unstable x86, 6.5 trunk at r7688. the Play button on the remote with a playlist fails to play music, and shows the following log output. I get similar results from New Music with the remote, but it then complains about an "age" column rather than "playlist". --------------------------------- 2006-05-30 20:22:55.5966 Playlist: newSongPlaylistCallback() writeCurTrackForM3U() 2006-05-30 20:22:55.5969 Playlist: Jumping to song index: 7 2006-05-30 20:22:55.5998 DBD::mysql::st execute failed: Unknown column 'playlist' in 'where clause' at /home/chris/slimdev/trunk/server/CPAN/DBIx/Class/Storage/DBI.pm line 525. 2006-05-30 20:22:55.6003 ERROR: Request: Error when trying to run function coderef: [DBIx::Class::ResultSet::all(): Error executing 'SELECT me.id, me.url, me.content_type, me.title, me.titlesort, me.titlesearch, me.album, me.tracknum, me.timestamp, me.filesize, me.tag, me.disc, me.thumb, 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.moodlogic_id, me.moodlogic_mixable, 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 ( playlist = ? ) ORDER BY me.disc, me.tracknum, me.titlesort' (`5447'): DBD::mysql::st execute failed: Unknown column 'playlist' in 'where clause' at /home/chris/slimdev/trunk/server/CPAN/DBIx/Class/Storage/DBI.pm line 525. ] 2006-05-30 20:22:55.6005 Request: Command [00:04:20:ff:ff:01->playlist loadtracks] (Bad dispatch!) 2006-05-30 20:22:55.6006 Param: [_what] = [playlist=5447] --------------------------------- by contrast, I can play the same playlist from the Default skin in the web UI, with the following log output: --------------------------------- 2006-05-30 20:23:41.7675 Playlist: Jumping to song index: 0 2006-05-30 20:23:41.7807 Playlist: Jumping to song index: 0 2006-05-30 20:23:41.8685 Playlist: Jumping to song index: 0 2006-05-30 20:23:41.9117 Playlist: modifyPlaylistCallback() savecurrsong is 1 2006-05-30 20:23:41.9550 Playlist: modifyPlaylistCallback() savecurrsong is 1 2006-05-30 20:23:42.2458 currentPlaylistChangeTime : Tue May 30 20:23:41 2006 2006-05-30 20:23:42.2460 currentPlaylistRender : Tue May 30 20:22:40 2006 2006-05-30 20:23:42.2461 currentPlaylistRenderSkin : Default 2006-05-30 20:23:42.2461 currentPlaylistRenderStart: 0 2006-05-30 20:23:42.2462 skinOverride: Default 2006-05-30 20:23:42.2463 start: 0 2006-05-30 20:23:42.4012 End playlist build. 11 items 2006-05-30 20:23:42.4021 Playlist: Jumping to song index: 0 2006-05-30 20:23:42.4489 Playlist: newSongPlaylistCallback() writeCurTrackForM3U() 2006-05-30 20:23:42.4499 Playlist: modifyPlaylistCallback() savecurrsong is 0 2006-05-30 20:23:47.5510 currentPlaylistChangeTime : Tue May 30 20:23:42 2006 2006-05-30 20:23:47.5512 currentPlaylistRender : Tue May 30 20:23:42 2006 2006-05-30 20:23:47.5512 currentPlaylistRenderSkin : Default 2006-05-30 20:23:47.5513 currentPlaylistRenderStart: 0 2006-05-30 20:23:47.5513 skinOverride: Default 2006-05-30 20:23:47.5514 start: 0 2006-05-30 20:23:47.6809 End playlist build. 11 items ---------------------------------
I would submit this is a dupe of bug 3458: this one was filed first, but 3458 has a better description of all the specific issues, and that's what Dan referenced when he fixed the problems I filed the bug about. *** This bug has been marked as a duplicate of 3458 ***