Re sure about the commit: yes, I'm pretty sure. I did ask Andy about it
at the time. I don't think I ever filed a bug about it when Andy told
me that it was a 'wontfix' issue.
And, full disclosure here, I've been saving my sanity since 2011 by
using a custom version of ./Slim/Schema/Genre.pm. When ever I pull a
git update, I run a script that modifies Genre.pm so that my genre
sorting ability still works. Here's a diff of the current LMS code (to
the left, Genre.pm.org) and the version I run (to the right, Genre.pm),
backing out Andy's changes in svn 32352.
Code:
--------------------
root@scserver:/usr/local/share/lms/server/Slim/Schema
diff Genre.pm.org Genre.pm
33c33
< $class->utf8_columns(qw/name namesort/);
---
> $class->utf8_columns(qw/name namesort namesearch/);
42c42
< return sprintf('db:genre.name=%s',
URI::Escape::uri_escape_utf8($self->name));
---
> return sprintf('db:genre.namesearch=%s',
URI::Escape::uri_escape_utf8($self->namesearch));
75,76c75,76
< my $sth = $dbh->prepare_cached( 'SELECT id FROM genres WHERE
name = ?' );
< $sth->execute( ucfirst($genreSub) );
---
> my $sth = $dbh->prepare_cached( 'SELECT id FROM genres WHERE
namesearch = ?' );
> $sth->execute($namesort);
87c87
< $sth->execute( $namesort, ucfirst($genreSub),
$namesearch );
---
> $sth->execute( $namesort, ucfirst($genreSub),
$namesort );
--------------------
------------------------------------------------------------------------
gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115
View this thread: http://forums.slimdevices.com/showthread.php?t=110138
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
