[mythtv] Database upgrade failure
John Pilkington
johnpilk222 at gmail.com
Sun Jan 30 16:08:40 UTC 2022
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
More information about the mythtv-dev
mailing list