Opened 18 years ago

Closed 18 years ago

#1195 closed defect (wontfix)

MySQL Error 1071 on Schema upgrading, when starting mythtv-setup in Gentoo

Reported by: magicmonty@… Owned by: Isaac Richards
Priority: minor Milestone: unknown
Component: mythtv Version: 0.18.1
Severity: high Keywords: Mysql 1071 mythtv-setup
Cc: Ticket locked: no

Description

I run a Gentoo (2005.1). After installing mythtv 0.18.1 and running mythtv-setup it stops with the MySQL-Error 1071 (KEY TOO LONG). The MySQL Version is 5.0.18-r30.

It is possible to solve the problem by changing 3 SQL statements ( the CREATE's for the tables settings, jumppoints and profilegroups) in libs/libmysql/dbcheck.c

The combination of the field hostname with the other fields (name, destination, value) is bigger than 333 bytes so the size of the key (length of all fields * 3) is bigger than the keylength of 1000 bytes.

I temporarily "solved" the problem by setting the length of the hostname-field to 205 instead of 255, so the sum of the fieldlengths is 333.

Change History (1)

comment:1 Changed 18 years ago by Isaac Richards

Resolution: wontfix
Status: newclosed

Won't fix, as such. You need to switch the myth database tables to latin-1 instead of utf-8. 'ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;' This is done in the database creation in svn/0.19.

Note: See TracTickets for help on using tickets.