Bug 3467 - Can't play playlists or New Music using remote
: Can't play playlists or New Music using remote
Status: RESOLVED DUPLICATE of bug 3458
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 6.5b1
: PC Debian Linux
: P2 major (vote)
: ---
Assigned To: Chris Owens
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-05-30 20:31 UTC by Chris Doherty
Modified: 2008-09-15 14:39 UTC (History)
0 users

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Chris Doherty 2006-05-30 20:31:10 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
---------------------------------
Comment 1 Chris Doherty 2006-06-10 21:23:36 UTC
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 ***