I spoke too soon. The server still becomes non-responsive and requires
me to Force Quit it.

This is the SQL that is generated that is supposed to produce my list
of playlists in my library. It never does.

"Server Log" Wrote: 
> 
> [11-12-08 22:47:22.7119]
> Plugins::CustomBrowse::MenuHandler::SQLHandler::getData (50) Preparing
> SQL: 
>                               select 
> tracks.id,tracks.title,substr(tracks.titlesort,1,1) from
> playlist_track,tracks,multilibrary_track,tracks librarytracks 
>                               where 
>                                       playlist_track.track=librarytracks.url 
> and
>                                       
> librarytracks.id=multilibrary_track.track and
>                                       multilibrary_track.library=7 and
>                                       
>                                       tracks.content_type!='cpl' and 
>                                       tracks.id=playlist_track.playlist 
>                               group by tracks.id 
>                               order by tracks.titlesort asc
>                       
> [11-12-08 22:47:22.7128]
> Plugins::CustomBrowse::MenuHandler::SQLHandler::_execute (72)
> Executing: select tracks.id,tracks.title,substr(tracks.titlesort,1,1)
> from playlist_track,tracks,multilibrary_track,tracks librarytracks 
>                               where 
>                                       playlist_track.track=librarytracks.url 
> and
>                                       
> librarytracks.id=multilibrary_track.track and
>                                       multilibrary_track.library=7 and
>                                       
>                                       tracks.content_type!='cpl' and 
>                                       tracks.id=playlist_track.playlist 
>                               group by tracks.id 
>                               order by tracks.titlesort asc
> 

I don't know SQL, but does anything look amiss in it?


-- 
prabbit
------------------------------------------------------------------------
prabbit's Profile: http://forums.slimdevices.com/member.php?userid=11142
View this thread: http://forums.slimdevices.com/showthread.php?t=91545

_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins

Reply via email to