I upgraded SBS, same problem.
Actually, after a fresh start of SBS, everything goes fine until I try
to launch this playlist :
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
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='SPEED'
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 customscan_track_attributes.value in ('lent')
group by tracks.id
order by rand()
limit 50;
--------------------
I get this error in the log :
Code:
--------------------
[10-07-24 23:28:47.8683] Plugins::SQLPlayList::Plugin::getPlayList (143)
Get playlist: randomforrating
[10-07-24 23:28:47.8689] Plugins::SQLPlayList::Plugin::replaceParametersInSQL
(888) Replacing 'PlaylistParameter1' with 20
[10-07-24 23:28:47.8694] Plugins::SQLPlayList::Plugin::replaceParametersInSQL
(888) Replacing 'PlaylistOffset' with 0
[10-07-24 23:28:47.8697] Plugins::SQLPlayList::Plugin::replaceParametersInSQL
(888) Replacing 'PlaylistActiveLibrary' with 0
[10-07-24 23:28:47.8700] Plugins::SQLPlayList::Plugin::replaceParametersInSQL
(888) Replacing 'PlaylistPlayer' with '00:04:20:06:92:87'
[10-07-24 23:28:47.8703] Plugins::SQLPlayList::Plugin::replaceParametersInSQL
(888) Replacing 'PlaylistLimit' with 15
[10-07-24 23:28:47.8710] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist
(1004) Executing: select tracks.url from tracks join track_statistics on
tracks.url=track_statistics.url join customscan_track_attributes
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='SPEED' left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='00:04:20:06:92:87' where audio=1 and
dynamicplaylist_history.id is null and track_statistics.rating>=(20-10) and
customscan_track_attributes.value in ('lent') group by tracks.id order by
rand() limit 50;
[10-07-24 23:28:47.8716] Slim::Schema::Storage::throw_exception (82) Error:
DBI Exception: DBD::mysql::st execute failed: Not unique table/alias: 'tracks'
[for Statement "select tracks.url from tracks join track_statistics on
tracks.url=track_statistics.url join customscan_track_attributes
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='SPEED' left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='00:04:20:06:92:87' where audio=1 and
dynamicplaylist_history.id is null and track_statistics.rating>=(20-10) and
customscan_track_attributes.value in ('lent') group by tracks.id order by
rand() limit 50;"]
[10-07-24 23:28:47.8854] Slim::Schema::Storage::throw_exception (82)
Backtrace:
frame 0: Slim::Utils::Log::logBacktrace
(/<C:\PROGRA~1\SQUEEZ~2\server\SQUEEZ~3.EXE>Slim/Schema/Storage.pm line 82)
frame 1: Slim::Schema::Storage::throw_exception
(/<C:\PROGRA~1\SQUEEZ~2\server\SQUEEZ~3.EXE>DBIx/Class/Storage/DBI.pm line 957)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (C:\Documents and Settings\All
Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/SQLPlayList/Plugin.pm line 1005)
frame 3: (eval) (C:\Documents and Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/SQLPlayList/Plugin.pm line 1002)
frame 4: Plugins::SQLPlayList::Plugin::executeSQLForPlaylist (C:\Documents
and Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/SQLPlayList/Plugin.pm line 910)
frame 5: Plugins::SQLPlayList::Plugin::getTracksForPlaylist (C:\Documents and
Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/SQLPlayList/Plugin.pm line 1203)
frame 6: Plugins::SQLPlayList::Plugin::getNextDynamicPlayListTracks
(C:\Documents and Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm line
3213)
frame 7: (eval) (C:\Documents and Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm line
3213)
frame 8: Plugins::DynamicPlayList::Plugin::getTracksForPlaylist (C:\Documents
and Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm line
340)
frame 9: Plugins::DynamicPlayList::Plugin::findAndAdd (C:\Documents and
Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm line
517)
frame 10: Plugins::DynamicPlayList::Plugin::playRandom (C:\Documents and
Settings\All Users\Application
Data\Squeezebox\Cache\InstalledPlugins/Plugins/DynamicPlayList/Plugin.pm line
2692)
frame 11: Plugins::DynamicPlayList::Plugin::handleWebMixParameters
(/<C:\PROGRA~1\SQUEEZ~2\server\SQUEEZ~3.EXE>Slim/Web/HTTP.pm line 1097)
frame 12: Slim::Web::HTTP::generateHTTPResponse
(/<C:\PROGRA~1\SQUEEZ~2\server\SQUEEZ~3.EXE>Slim/Web/HTTP.pm line 924)
frame 13: Slim::Web::HTTP::processURL
(/<C:\PROGRA~1\SQUEEZ~2\server\SQUEEZ~3.EXE>Slim/Web/HTTP.pm line 735)
frame 14: Slim::Web::HTTP::processHTTP
(/<C:\PROGRA~1\SQUEEZ~2\server\SQUEEZ~3.EXE>Slim/Networking/IO/Select.pm line
139)
frame 15: (eval)
(/<C:\PROGRA~1\SQUEEZ~2\server\SQUEEZ~3.EXE>Slim/Networking/IO/Select.pm line
123)
frame 16: Slim::Networking::IO::Select::__ANON__
(/<C:\PROGRA~1\SQUEEZ~2\server\SQUEEZ~3.EXE>Slim/Networking/IO/Select.pm line
183)
frame 17: (eval)
(/<C:\PROGRA~1\SQUEEZ~2\server\SQUEEZ~3.EXE>Slim/Networking/IO/Select.pm line
183)
frame 18: Slim::Networking::IO::Select::loop (slimserver.pl line 626)
frame 19: main::idle (slimserver.pl line 580)
frame 20: main::main (slimserver.pl line 99)
frame 21: PerlSvc::Interactive
(/<C:\PROGRA~1\SQUEEZ~2\server\SQUEEZ~3.EXE>PerlSvc.pm line 99)
frame 22: PerlSvc::_interactive (slimserver.pl line 0)
frame 23: (eval) (slimserver.pl line 0)
[10-07-24 23:28:47.8861] Plugins::SQLPlayList::Plugin::executeSQLForPlaylist
(1029) Database error: Not unique table/alias: 'tracks'
Carp::Clan::__ANON__(): DBI Exception: DBD::mysql::st execute failed: Not
unique table/alias: 'tracks' [for Statement "select tracks.url from tracks join
track_statistics on tracks.url=track_statistics.url join
customscan_track_attributes tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='SPEED' left join dynamicplaylist_history on
tracks.id=dynamicplaylist_history.id and
dynamicplaylist_history.client='00:04:20:06:92:87' where audio=1 and
dynamicplaylist_history.id is null and track_statistics.rating>=(20-10) and
customscan_track_attributes.value in ('lent') group by tracks.id order by
rand() limit 50;"] at
/<C:\PROGRA~1\SQUEEZ~2\server\SQUEEZ~3.EXE>Slim/Schema/Storage.pm line 86
--------------------
Then, if I try to validate any custom SQL Playlist, I get the error in
the SQL Plylist edit window.
--
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
