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

[Michael T. Dean]

On 06/11/2010 08:55 AM, Raymond Wagner wrote:
> On 6/11/2010 07:52, ryan patterson wrote:
>>>   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.
>> I don't mean to be a pain, but I don't understand why this has (again)
>> been marked invalid.
> When you access a MySQL database through PHP, all you are doing is 
> sending those query strings through to the server. He's showing you 
> that on his system, those same queries are case insensitive. I just 
> tested and they are on mine as well. If yours are not, then your 
> database is not configured in the manner that MythTV expects. This is 
> configuration error, and not a bug.

In other words, your database schema is corrupt.  This is one of the 
situations where a database partial restore is a good idea.

Back up your database, drop the existing database, create a new database 
schema by running mythtv-setup and then exiting mythtv-setup, then do a 
partial restore ( 
http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup 
) of the original backup.  Because you let mythtv-setup create the 
schema instead of using the broken schema in your backup, it will be a 
proper schema without the modifications/corruption that broke your 
original schema.  After the partial restore, you need to reconfigure 
/everything/ in mythtv-setup and mythfrontend settings for every single 
host in your system (because all you will have kept is the recordings, 
recording rules, and recording history data).

Mike