I've reported this as issue #106:

http://code.google.com/p/erlandplugins/issues/detail?id=106

Somewhere double quotes in menu items are getting escaped with
backslashes, which causes the SQL for the next menu level to fail, e.g.
queries like


Code:
--------------------
    
  select distinct 
customscan_track_attributes.extravalue,customscan_track_attributes.value,substr(customscan_track_attributes.value,1,1),ifnull(customscan_track_attributes.valuetype,'mixedtagWORK')
 from customscan_track_attributes 
                                                        where 
                                                                
module='mixedtag' and
                                                                attr='WORK' and
                                                                
extravalue='Symphony No. 3 \"Eroica\"'
  
--------------------


fail because of the extraneous backslashes.  I fixed this by brute
force by editing SQLHandler.pm so that '\"' is replaced with '"' in the
sql:

$sql =~ s/\\"/"/g;


-- 
Daverz
------------------------------------------------------------------------
Daverz's Profile: http://forums.slimdevices.com/member.php?userid=32335
View this thread: http://forums.slimdevices.com/showthread.php?t=86360

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

Reply via email to