[mythtv] Database upgrade failure

[Gary Buhrmaster]

On Mon, Jan 24, 2022 at 4:59 PM John Pilkington <johnpilk222 at gmail.com> wrote:

> Database error was:
> Specified key was too long; max key length is 767 bytes
>
> 2022-01-24 15:58:50.844369 E  Database schema upgrade failed.
> 2022-01-24 15:58:50.844695 E  Couldn't upgrade database to new schema.

It is likely that your default storage engine
is innodb (that could be the default for your
version of the database, or you could be
explicitly specifying it), *and* you do not
have innodb_large_prefix set (typically
the default) along with the dynamic row
format (again, typically the default) that
one would get by specifying barracuda
as the innodb_file_format.

That said, the create table statement
for these sports extensions *should*
have explicitly set the engine to be
MYISAM(*), as the other create tables
do, in order to avoid the random issues
one otherwise can encounter with
different configurations.

I would suggest you open a github
issue against the failure to upgrade
(and the commit).






(*) MYISAM is problematic for
other reasons, but it is the MythTV
default default because it is well
known.