Warning: mysqli_real_connect(): Headers and client library minor version mismatch. Headers:50625 Library:50543 in /sites/rockbox.org/flyspray/adodb/drivers/adodb-mysqli.inc.php on line 108 FS#10374 : Tagnavi conditionals



FS#10374 - Tagnavi conditionals

Attached to Project: Rockbox
Opened by Johan Oscarsson (Didgeridoohan) - Tuesday, 23 June 2009, 14:09 GMT
Last edited by sideral (sideral) - Thursday, 23 June 2011, 12:24 GMT
Task Type Bugs
Category Database
Status Closed
Assigned To No-one
Operating System All players
Severity Low
Priority Normal
Reported Version Daily build (which?)
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No


It seems it is impossible to sort the database using the tag albumartist as a conditional in a format line.

See this post for a good example: http://forums.rockbox.org/index.php?topic=6661.msg133978#msg133978
This task depends upon

Closed by  sideral (sideral)
Thursday, 23 June 2011, 12:24 GMT
Reason for closing:  Invalid
Additional comments about closing:  No clarifications received for more than one month
Comment by PaulJam (PaulJam) - Wednesday, 24 June 2009, 09:18 GMT
using r21486 on an H300 i can confirm this bug, but only if "Load To RAM" is not enabled. When the database is loaded to RAM, then everything works as expected.
I have attached a simplified tagnavi_custom.config using the examples from the linked thread for reproduction purposes.
Comment by sideral (sideral) - Thursday, 19 May 2011, 15:51 GMT
I'm not sure whether Didgeridoohan and PaulJam are talking about the same issue, but both do not seem like a bug to me. Perhaps you could clarify the issue with a more self-contained, more reproducible bug report?

Didgeridoohan writes:
> It seems it is impossible to sort the database using the tag
> albumartist as a conditional in a format line.

I'm probably misunderstanding something, but the conditional in a %format line is never consulted for sorting. Only the resulting sprintf'd strings are sorted.

Using PaulJam's example:
> %format "fmt_album" "%02d. %s - %s[%02d:%02d]" tracknum artist title Lm Ls ? albumartist = "Various Artists"

The albumartist is not used for sorting at all here, only for selecting this or the other %format line depending on the contents of the albumartist tag. Which aspect of this does not work?