[mythtv] Database upgrade failure

[John Pilkington]

On 30/01/2022 15:14, David Hampton via mythtv-dev wrote:

>> I just tried again, but no luck:
>> {{{
>> 2022-01-30 09:53:18.551453 C  mythtv-setup version: HEAD
>> [v32-Pre-fd4b8e3487] www.mythtv.org
>> 2022-01-30 09:53:18.551459 C  Qt version: compile: 5.9.7, runtime:
>> 5.9.7
>> 2022-01-30 09:53:18.562244 I  Scientific Linux 7.9 (Nitrogen)
>> (x86_64)
>>
>>
>> 2022-01-30 09:54:20.094519 C  Upgrading to MythTV schema version 1371
>> 2022-01-30 09:54:20.095828 E  DB Error (Performing MythtTV database
>> upgrade):
>> Query was: CREATE TABLE sportsapi (
>>                 id INT UNSIGNED PRIMARY KEY,
>>                 provider TINYINT UNSIGNED DEFAULT 0,
>>                 name VARCHAR(128) NOT NULL,
>>                 key1 VARCHAR(256) NOT NULL,
>>                 key2 VARCHAR(256) NOT NULL,
>>                 UNIQUE(provider,key1,key2)
>>                 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
>> Error was: Driver error was [2/1071]:
>> QMYSQL: Unable to execute query
>> Database error was:
>> Specified key was too long; max key length is 1000 bytes
>> }}}
> 
> Hi John,
> 
> Can you give the attached patch a try before I commit it?  I've reduced
> the size of the two keys, and pared down the index even further by
> looking at the statistical lengths of the data. Thanks.
> 
> David

Hi David:  I'll try, but there will be some delay.  I haven't used 
patches recently, and need to do other things.  It's probably not a 
widespread problem anyway... :-)

John