O.k., this is bizarre. Although I am getting the failures in the log it
seems as though the import worked. When I play a random mix I can
seeing ratings against all tracks, even Aloe Blacc.
Dynamic Playlists seem bust though. Below is the playlost and the error
generated.
Code:
--------------------
-- PlaylistName:Paul\'s Singles Mix
-- PlaylistGroups:
select tracks.url from tracks
join track_statistics on
tracks.url=track_statistics.url
join comments on
tracks.id=comments.track and comments.value like 'single'
left join comments as excludecomments on
tracks.id=excludecomments.track and (excludecomments.value like
'%duplicate%' or excludecomments.value like '%live%'or excludecomments.value
like '%christmas%'or excludecomments.value like '%video%'or
excludecomments.value like '%spokenword%'or excludecomments.value like
'%nonsingle%'or excludecomments.value like '%acoustic%')
left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='PlaylistPlayer'
where
audio=1
and dynamicplaylist_history.id is null
and excludecomments.id is null
and tracks.secs<420
and (track_statistics.rating>=50)
and not exists (select * from tracks
t2,contributor_track,contributors
where
t2.id=tracks.id and
tracks.id=contributor_track.track and
contributor_track.contributor=contributors.id and
contributor_track.role
in (1,5) and
contributors.name in
('Jeff Wayne'))
and not exists (select * from tracks t2,genre_track,genres
where
t2.id=tracks.id and
tracks.id=genre_track.track and
genre_track.genre=genres.id and
genres.name in
('Children\'s Music','Comedy','Holiday'))
and
ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-2419200)
group by tracks.id
order by rand()
limit 10;
--------------------
Error is:
Error: near "s": syntax error
Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db prepare failed:
near "s": syntax error [for Statement "select tracks.url from tracks
join track_statistics on tracks.url=track_statistics.url join comments
on tracks.id=comments.track and comments.value like 'single' left join
comments as excludecomments on tracks.id=excludecomments.track and
(excludecomments.value like '%duplicate%' or excludecomments.value like
'%live%'or excludecomments.value like '%christmas%'or
excludecomments.value like '%video%'or excludecomments.value like
'%spokenword%'or excludecomments.value like '%nonsingle%'or
excludecomments.value like '%acoustic%') left join
dynamicplaylist_history on tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='00:04:20:1e:d4:74' where audio=1 and
dynamicplaylist_history.id is null and excludecomments.id is null and
tracks.secs<420 and (track_statistics.rating>=50) and not exists
(select * from tracks t2,contributor_track,contributors where
t2.id=tracks.id and tracks.id=contributor_track.track and
contributor_track.contributor=contributors.id and
contributor_track.role in (1,5) and contributors.name in ('Jeff
Wayne')) and not exists (select * from tracks t2,genre_track,genres
where t2.id=tracks.id and tracks.id=genre_track.track and
genre_track.genre=genres.id and genres.name in ('Children\'s
Music','Comedy','Holiday')) and
ifnull(track_statistics.lastplayed,0)<(unix_timestamp()-2419200) group
by tracks.id order by rand() limit 10;"] at /Slim/Schema/Storage.pm
line 123
CW
--
Chunkywizard
*Squeezebox:* Boom x2 (Lounge and Office), Radio (with battery)
*Server:* 7.6.0 for Windows Home Server (HP EX-490 MediaSmart Server)
*Plugins:* Dynamic Playlists 2.8.4 | SQL Playlist 2.5.3359 | Music
Information Screen 4.4.7 | Custom Scan 2.83378 | TrackStat 2.10.3366 |
Album Review 2.9.5 | Biography 2.9.4
*Remote:* iPod Touch Gen. 1 running 'iPeng'
(http://penguinlovesmusic.de/2008/11/25/ipeng-application-now-on-app-store/)
*Music: *'Last.fm' (http://www.last.fm/user/chunkywizard)
------------------------------------------------------------------------
Chunkywizard's Profile: http://forums.slimdevices.com/member.php?userid=25868
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
