Bugzilla – Bug 3832
Play All Songs on Player search
Last modified: 2008-09-15 14:39:24 UTC
If using the remote, I search songs for a title that returns say 6 titles, scroll up to All Songs then press play, nothing happens. This also applies to Album and Artist search but it all works OK if I'm using Lazysearch. This may be related to bug 3793.
I also see this behavior.
error log shows: 2006-07-28 10:42:21.1575 DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= '% A%' ) )' at line 1 at D:\slim\server\CPAN/DBIx/Class/Storage/DBI.pm line 743. 2006-07-28 10:42:21.1584 ERROR: 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 ( ( A% = ? ) )': DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= '% A%' ) )' at line 1 at D:\slim\server\CPAN/DBIx/Class/Storage/DBI.pm line 743. This was search 'A->' on Artists, PLAY on All Albums. $search appears to contain [ 'A%', '% A%']
Fixed in change 8729