Oooh, I swear I double-checked before posting this example... It seems
it was far too late.
Sorry, and don't worry this one was not generated, but I had an alias
there and I must have deleted "on" when trying to simplify the
request.
Nonetheless, once you have such an error in the code, the SQL Playlist
edit page won't let you save it even if it's corrected (nor any other
list).
You have to restart SBS.
I really can't remember what I've done in the first place, but the
first error I got was not the one with the alias, but just an "You've
got an error in your SQL code", and my code was always truncated after
an accented letter...
I try to reproduce the behaviour this morning, but everything's fine.
The problem was, when I put in something like this :
Code:
--------------------
-- PlaylistName:test carac multiple
-- PlaylistGroups:_Perso
-- PlaylistParameter1:list:Select rating:20:* (10-29),40:** (30-49),60:***
(50-69),80:**** (70-89),100:***** (90-100)
-- PlaylistStartAction1:cli:customskip setsecondaryfilter
advancedrandom.cs.xml
-- PlaylistStopAction1:cli:customskip clearsecondaryfilter
select tracks.url from tracks
join track_statistics on
tracks.url=track_statistics.url
join customscan_track_attributes as cust_speed on
tracks.id=cust_speed.track and cust_speed.module='customtag'
and cust_speed.attr='SPEED'
join customscan_track_attributes as cust_instr on
tracks.id=cust_instr.track and cust_instr.module='customtag'
and cust_instr.attr='INSTRUMENTS'
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 track_statistics.rating>=('PlaylistParameter1'-10)
and cust_speed.value in ('modéré','lent')
and cust_instr.value in ('instrumental')
group by tracks.id
order by rand()
limit 50;
--------------------
I could save it once, but when launching the list I got the SQL error
in the log.
Then, editing the list shows this :
Code:
--------------------
-- PlaylistName:test carac multiple
-- PlaylistGroups:_Perso
-- PlaylistParameter1:list:Select rating:20:* (10-29),40:** (30-49),60:***
(50-69),80:**** (70-89),100:***** (90-100)
-- PlaylistStartAction1:cli:customskip setsecondaryfilter
advancedrandom.cs.xml
-- PlaylistStopAction1:cli:customskip clearsecondaryfilter
select tracks.url from tracks
join track_statistics on
tracks.url=track_statistics.url
join customscan_track_attributes as cust_speed on
tracks.id=cust_speed.track and cust_speed.module='customtag'
and cust_speed.attr='SPEED'
join customscan_track_attributes as cust_instr on
tracks.id=cust_instr.track and cust_instr.module='customtag'
and cust_instr.attr='INSTRUMENTS'
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 track_statistics.rating>=('PlaylistParameter1'-10)
and cust_speed.value in ('mod
--------------------
and I got the same symptom as above : can't correct or validate any
list.
Anyway, thanks for your quick answer, I'll let you know if something
happens again...
(but again, it was late, maybe it was just me...)
--
Stan Pulsar
------------------------------------------------------------------------
Stan Pulsar's Profile: http://forums.slimdevices.com/member.php?userid=6669
View this thread: http://forums.slimdevices.com/showthread.php?t=80666
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
