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: | 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.
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.