[mythtv-users] Bug related to ignoring the and a in title ordering

[Bill Meek]

On Sunday 19 March 2023 11:38:44 AM (-05:00), Stephen Worthington wrote:

 > On Sun, 19 Mar 2023 15:33:12 +0100, you wrote:
 > 
 > >Hoi Hika,
 > >
 > >Sunday, March 19, 2023, 12:48:56 PM, you wrote:
 > 
 > >>>> Does anybody know!
 > >
 > >Setup ->>> General -> General -> Remove Prefixes when Sorting (*)
 > >
 > >>> MythTV never actually removes the prefix from the title, it just
 > >>> ignores the prefix when sorting names.  It sounds like something 
else
 > >>> is going on that is causing "Dark Heart" and "The Dark Heart" to be
 > >>> confused.
 > >
 > >>> David
 > >
 > >>> * That label needs to be updated to "Ignore Prefixes when Sorting". 
The
 > >>> description also needs to be updated.
 > >
 > >> Thanks.
 > >> Either that option was added after 0.27 or it is not present in
 > >> MythCenter-wide. On the indicated page I only have "Use line edit
 > >> virtual keyboard" and "Screen shot path"
 > >
 > >
 > >I rechecked everywhere, I even checked the settings table for any
 > >setting name starting with remove or ignore.
 > >I guess it was added after 0.27.
 > >
 > >I thing I will rename the series to its original Scandinavian name.
 > 
 > I think the setting is SortStripPrefixes:
 > 
 > MariaDB [mythconverg]> select * from settings where value like
 > '%prefixes%';
 > +-------------------+------+----------+
 > | value             | data | hostname |
 > +-------------------+------+----------+
 > | SortStripPrefixes | 0    | NULL     |
 > +-------------------+------+----------+

Or in frontend settings: "Remove prefixes when sorting" (from a commit on 
3/5/2017.)
There's also the semicolon separated list: "Names exempt from prefix 
removal".
-- 
Bill