>>Can you turn on debugging in the Custom Browse settings page and see if
>>there is something strange in the log ?
>>
>Okay, I will look into it.
>
I can't see any obvious problems, but I've copied a section from my log. The
first part was browse years, the second part was browse decades:
2006-10-02 09:07:26.3185 CustomBrowse: Preparing SQL:
select years.id,case when years.id>0 then
years.id else 'Unknown' end from years
order by years.id desc
2006-10-02 09:07:26.3214 CustomBrowse: Executing: select years.id,case when
years.id>0 then years.id else 'Unknown' end from years
order by years.id desc
2006-10-02 09:07:26.3262 CustomBrowse: Executing and collecting: select
years.id,case when years.id>0 then years.id else 'Unknown' end from years
order by years.id desc
2006-10-02 09:07:29.5074 CustomBrowse: Preparing SQL:
select
albums.id,albums.title,substr(albums.titlesort,1,1) from albums
where
albums.year={year}
order by albums.titlesort
2006-10-02 09:07:29.5101 CustomBrowse: Executing: select
albums.id,albums.title,substr(albums.titlesort,1,1) from albums
where
albums.year=0
order by albums.titlesort
2006-10-02 09:07:29.5140 CustomBrowse: Executing and collecting: select
albums.id,albums.title,substr(albums.titlesort,1,1) from albums
where
albums.year=0
order by albums.titlesort
2006-10-02 09:08:07.4517 CustomBrowse: Searching for custom browse
configuration in: M:\Music\SlimServer Playlists
2006-10-02 09:08:07.4521 CustomBrowse: Loading browse configuration from:
P:\Music\SlimServer\trunk\server\Plugins\CustomBrowse\Playlists
2006-10-02 09:08:07.8328 CustomBrowse: Loading browse configuration from:
M:\Music\SlimServer Playlists
2006-10-02 09:08:11.1974 CustomBrowse: Preparing SQL:
select floor(tracks.year/10)*10,case when
tracks.year>0 then concat(floor(tracks.year/10)*10,'s') else 'Unknown' end from
tracks
where
tracks.audio=1
group by floor(tracks.year/10)*10
order by tracks.year asc
2006-10-02 09:08:11.2000 CustomBrowse: Executing: select
floor(tracks.year/10)*10,case when tracks.year>0 then
concat(floor(tracks.year/10)*10,'s') else 'Unknown' end from tracks
where
tracks.audio=1
group by floor(tracks.year/10)*10
order by tracks.year asc
2006-10-02 09:08:11.3345 CustomBrowse: Executing and collecting: select
floor(tracks.year/10)*10,case when tracks.year>0 then
concat(floor(tracks.year/10)*10,'s') else 'Unknown' end from tracks
where
tracks.audio=1
group by floor(tracks.year/10)*10
order by tracks.year asc
2006-10-02 09:08:13.5835 CustomBrowse: Preparing SQL:
select
albums.id,albums.title,substr(albums.titlesort,1,1) from tracks,albums
where
tracks.audio=1 and
albums.id=tracks.album and
tracks.year>={year} and
tracks.year<{year}+10
group by albums.id
order by {orderby}
2006-10-02 09:08:13.5861 CustomBrowse: Executing: select
albums.id,albums.title,substr(albums.titlesort,1,1) from tracks,albums
where
tracks.audio=1 and
albums.id=tracks.album and
tracks.year>=0 and
tracks.year<0+10
group by albums.id
order by albums.titlesort asc
2006-10-02 09:08:13.6798 CustomBrowse: Executing and collecting: select
albums.id,albums.title,substr(albums.titlesort,1,1) from tracks,albums
where
tracks.audio=1 and
albums.id=tracks.album and
tracks.year>=0 and
tracks.year<0+10
group by albums.id
order by albums.titlesort asc
Phil
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
