vagskal;504999 Wrote:
> I further tried to merge the two menues (Trackyear and Albumyear) into
> one ("All years"). I used a Custom Tag Albums menu and in the Tag name
> field in the form I wrote ALBUMYEAR since I did not think two tags were
> allowed or would give me the desired OR relationship. PS. I tried two
> write both tags in the Tag name field separated with the character
> designated as Default separator characters for header under settings,
> but it produced an empty menu.
>
> I replaced the resulting xml code with the following
> :
> ...
>
> etc. where I supplemented every occurrence of 'TRACKYEAR' with a
> corresponding OR statement containing instead 'ALBUMYEAR'.
>
> Unfortunately it did not work. Invoking the menu just choked SBS and
> eventually I received a connection error in iPeng.
>
> I have read the wiki and the tutorials but I have no clue what else I
> have to do to get the result I want. The OR statement does not result in
> an error in MySQL Query Browser.
>
Unfortunately, I think it will require more time than what I'm ready to
spend to investigate this, hopefully some other Custom Browse user is
able to help you.
It's probably a good idea that you post the complete xml (as an
attachement) if you want someone to help you.
If you use the web interface I think you will get a bit more detailed
error message, it should also be available in the server.log file.
Another thing to think about is that you may need to use parentheses
when mixing "and" and "or" statements in a SQL. If you enable debug
level logging on "plugin.custombrowse" you will also get more details
regarding exactly which SQL statements are executed and if they succeeds
or return an error.
It's important that the result columns contains the correction
information, if they don't it might explain why it works in a SQL tool
but not in the real system.
Also I'm not sure if the pathtypedata element is correct, it might be,
I'm just not sure how the keywords ({context.itemid}) should look like.
If you haven't done so, it might be worth comparing it with a working
menu.
--
erland
Erland Isaksson
'My homepage' (http://erland.isaksson.info) (Install my plugins through
Extension Downloader)
(Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse,
Custom Scan, Custom Skip, Multi Library, Title Switcher and Database
Query plugins'
(http://wiki.erland.isaksson.info/index.php/Category:SlimServer))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
