Hi!
I really like Erland's SQL Playlist plugin, but I get this error when
creating a playlist ('advanced with lots of options').
Any advice on what to do?
Error:
Illegal mix of collations (utf8_general_ci,IMPLICIT) and
(utf8_unicode_ci,IMPLICIT) for operation '='
DBD::mysql::st execute failed: Illegal mix of collations
(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation
'=' at Plugins/SQLPlayList/Plugin.pm line 848.
___________________________________________________________________________
-- PlaylistName:test
-- PlaylistGroups:
select tracks.url from tracks
join track_statistics on
tracks.url=track_statistics.url
join contributor_track on
tracks.id=contributor_track.track
join contributors on
contributor_track.contributor=contributors.id and
contributor_track.role in (1,5)
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id
where
audio=1
and dynamicplaylist_history.id is null
and track_statistics.rating>=50
and contributors.name in ('Aimee Mann')
and
ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-2419200)
group by tracks.id
order by rand()
limit 10;
--
sand
2* Squeezebox 3 with Audioengine 5 speakers
1* QNAP TS-109
Seagate ES 500GB
Squeezecenter 7.0.1
------------------------------------------------------------------------
sand's Profile: http://forums.slimdevices.com/member.php?userid=9856
View this thread: http://forums.slimdevices.com/showthread.php?t=51719
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
