Some more research to try to pin the problem down.
I tried to search using an Albums by Artist menu where the Artist
(O'Conor) has a single quote in the name. This uses the MixedTag
scanning module It had a similar error, as below. The menu follows.
Error:
Running: select
customscan_track_attributes.value,customscan_track_attributes.value,
substr(ifnull(customscan_track_attributes.valuesort,customscan_track_attributes.value),1,1)
from customscan_track_attributes join multilibrary_track on
customscan_track_attributes.track=multilibrary_track.track and
multilibrary_track.library=2 join customscan_track_attributes as attr1
on customscan_track_attributes.track=attr1.track and
attr1.module='mixedtag' and attr1.attr='ARTIST' and
attr1.value='O\'Conor, J' where
customscan_track_attributes.module='mixedtag' and
customscan_track_attributes.attr='ALBUM' group by
customscan_track_attributes.value order by
ifnull(customscan_track_attributes.valuesort,customscan_track_attributes.value)
asc got error:
near "Conor": syntax errorRunning: select distinct
customscan_track_attributes.value,customscan_track_attributes.value
from customscan_track_attributes where module='mixedtag' and
attr='ARTIST' and value='O\'Conor, J' got error:
near "Conor": syntax error
The Menu is:
<?xml version="1.0" encoding="utf-8"?>
<custombrowse>
<template>
<id>customscan_multiplecustomtagsalbums</id>
<parameter type="text" id="menuname"><value>Albums by
Artist</value></parameter>
<parameter type="text" id="menugroup"><value>Classical
Music</value></parameter>
<parameter type="text"
id="menuorder"><value>50</value></parameter>
<parameter type="text"
id="datasource"><value>mixedtag</value></parameter>
<parameter type="text"
id="limituppertags"><value>1</value></parameter>
<parameter type="text"
id="roles"><value>1</value><value>3</value><value>5</value><value>6</value></parameter>
<parameter type="text"
id="showartistwithalbum"><value>0</value></parameter>
<parameter type="text"
id="customtag1"><value>ARTIST</value></parameter>
<parameter type="text" id="customsorttag1"></parameter>
<parameter type="text"
id="customtag1artistsort"><value>0</value></parameter>
<parameter type="text"
id="customtag1numbersort"><value>0</value></parameter>
<parameter type="text"
id="customtag2"><value>ALBUM</value></parameter>
<parameter type="text"
id="level2name"><value>Albums</value></parameter>
<parameter type="text" id="customsorttag2"></parameter>
<parameter type="text"
id="customtag2artistsort"><value>0</value></parameter>
<parameter type="text"
id="customtag2numbersort"><value>0</value></parameter>
<parameter type="text" id="customtag3"></parameter>
<parameter type="text" id="level3name"></parameter>
<parameter type="text" id="customsorttag3"></parameter>
<parameter type="text"
id="customtag3artistsort"><value>0</value></parameter>
<parameter type="text"
id="customtag3numbersort"><value>0</value></parameter>
<parameter type="text" id="customtag4"></parameter>
<parameter type="text" id="level4name"></parameter>
<parameter type="text" id="customsorttag4"></parameter>
<parameter type="text"
id="customtag4artistsort"><value>0</value></parameter>
<parameter type="text"
id="customtag4numbersort"><value>0</value></parameter>
<parameter type="text" id="customtag5"></parameter>
<parameter type="text" id="level5name"></parameter>
<parameter type="text" id="customsorttag5"></parameter>
<parameter type="text"
id="customtag5artistsort"><value>0</value></parameter>
<parameter type="text"
id="customtag5numbersort"><value>0</value></parameter>
<parameter type="text"
id="playalltracks"><value>1</value></parameter>
<parameter type="text" id="library"><value>2</value></parameter>
<parameter type="text"
id="activelibrary"><value>0</value></parameter>
<parameter type="text" id="includedclients"></parameter>
<parameter type="text" id="excludedclients"></parameter>
<parameter type="text" id="includedlibraries"></parameter>
<parameter type="text" id="excludedlibraries"></parameter>
</template>
</custombrowse>
--
PasTim
------------------------------------------------------------------------
PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642
View this thread: http://forums.slimdevices.com/showthread.php?t=89159
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
