[mythtv] Ticket #8215: MythWeb hostname/setting hostname comparison is not case-insensitive

[ryan patterson]

On Thu, Jun 10, 2010 at 8:48 PM, MythTV <mythtv at cvs.mythtv.org> wrote:
> #8215: MythWeb hostname/setting hostname comparison is not case-insensitive
> ------------------------------+---------------------------------------------
>  Reporter:  anonymous         |        Owner:  kormoc
>     Type:  defect            |       Status:  closed
>  Priority:  minor             |    Milestone:  unknown
> Component:  Plugin - MythWeb  |      Version:  head
>  Severity:  low               |   Resolution:  invalid
>  Mlocked:  0                 |
> ------------------------------+---------------------------------------------
> Changes (by kormoc):
>
>  * status:  new => closed
>  * resolution:  => invalid
>
> Comment:
>
>  We control this via the database:
>  {{{
>  mysql> SELECT DISTINCT hostname FROM settings\G
>  *************************** 1. row ***************************
>  hostname: jessica
>
>  mysql> SELECT COUNT(0) FROM settings WHERE hostname = 'JESSICA'\G
>  *************************** 1. row ***************************
>  COUNT(0): 340
>
>  mysql> SELECT COUNT(0) FROM settings WHERE hostname = 'JeSsIcA'\G
>  *************************** 1. row ***************************
>  COUNT(0): 340
>  }}}
>
>  So in short, fix the database and all should be wel.
>
> Ticket URL: <http://svn.mythtv.org/trac/ticket/8215#comment:10>

I don't mean to be a pain, but I don't understand why this has (again)
been marked invalid.

-Ryan