A bit of background first. I have a CustomBrowse menu based on "Works
by Composer" with the hierarchy:
COMPOSER
..WORK
....FIRSTARTIST
FIRSTARTIST is a virtual tag. The zipped xml for this menu is
attached.
To make this menu work well with iPeng, I've set the type of
FIRSTARTIST to "Playlist". This causes a playlist to pop up in iPeng
when tapping a "FIRSTARTIST" item. This works very well in iPeng,
whereas without the "Playlist" setting playing the wanted tracks is an
awkward set of steps. However, this "hack" causes the SQL error below
to show up in the web interface.
My hope is that CustomBrowse and iPeng can be made to play nicely
together without this hack causing errors in the web interface.
'Ax' below is an artist set in the ARTIST tag. I don't know why
CustomBrowse thinks it's a database column.
Code:
--------------------
Error:
Running: select tracks.id,tracks.title from tracks where tracks.id=Ax got
error:
Unknown column 'Ax' in 'where clause'Running: select
tracks.id,tracks.title,substr(tracks.titlesort,1,1) from tracks where
tracks.id=Ax order by tracks.titlesort asc got error:
Unknown column 'Ax' in 'where clause'Running: select 2,concat('Duration:
',sec_to_time(sum(tracks.secs))) from tracks,playlist_track where tracks.secs
is not null and tracks.url=playlist_track.track and playlist_track.playlist=Ax
group by playlist_track.playlist union select 5,concat('File Size:
',round(sum(playlisttracks.filesize)/1024/1024,1),' MB') from (select
tracks.id,tracks.filesize from tracks,playlist_track where tracks.filesize is
not null and tracks.url=playlist_track.track and playlist_track.playlist=Ax
group by tracks.id ) as playlisttracks got error:
Unknown column 'Ax' in 'where clause'Running: select
albums.id,albums.title,substr(albums.titlesort,1,1) from
albums,tracks,playlist_track where tracks.url=playlist_track.track and
playlist_track.playlist=Ax and tracks.album=albums.id group by albums.id order
by albums.titlesort asc,albums.disc asc got error:
Unknown column 'Ax' in 'where clause'Running: select
contributors.id,contributors.name,substr(contributors.namesort,1,1) from
contributors,contributor_track,tracks,playlist_track where
contributor_track.contributor=contributors.id and contributor_track.role in
(1,5) and contributor_track.track=tracks.id and tracks.url=playlist_track.track
and playlist_track.playlist=Ax group by contributors.id order by
contributors.namesort asc got error:
Unknown column 'Ax' in 'where clause'Running: select
genres.id,genres.name,substr(genres.namesort,1,1) from
genres,genre_track,tracks,playlist_track where genres.id=genre_track.genre and
genre_track.track=tracks.id and tracks.url=playlist_track.track and
playlist_track.playlist=Ax group by genres.id order by genres.namesort asc got
error:
Unknown column 'Ax' in 'where clause'
--------------------
--
Daverz
------------------------------------------------------------------------
Daverz's Profile: http://forums.slimdevices.com/member.php?userid=32335
View this thread: http://forums.slimdevices.com/showthread.php?t=74993
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
