[Maintain-dev] [JIRA] Assigned: (MNT-1405) MySQL Key size too large
Frederic Wenzel (JIRA)
jira at osuosl.org
Tue Jun 20 09:48:51 PDT 2006
[ http://bugs.osuosl.org/browse/MNT-1405?page=history ]
Frederic Wenzel reassigned MNT-1405:
------------------------------------
Assign To: Frederic Wenzel (was: Michael Clay)
> MySQL Key size too large
> ------------------------
>
> Key: MNT-1405
> URL: http://bugs.osuosl.org/browse/MNT-1405
> Project: Maintain
> Type: Bug
> Components: Database
> Versions: 2.4.0, 3.0
> Environment: MySQL 4.1+ with UTF-8 Encoding
> Reporter: Danny Robert
> Assignee: Frederic Wenzel
> Fix For: 3.0
>
>
> The MySQL schema used in Maintain is invalid when the default tables are UTF-8 encoded. Since UTF-8 characters can be up to three bytes, the 1000-byte key limit is reached much more quickly. From an IRC conversation:
> maintain.sql: line 115: #1071 - Specified key was too long; max key length is 1000 bytes
> This is from the HOST table import, most likely due to this key:
> KEY `ha` (`ha`,`os`,`serial`,`last_seen`,`other_id`)
> Other keys should be checked as well.
> A temporary "solution" for this bug is to tell users to use latin encoding.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://bugs.osuosl.org/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
More information about the Maintain-dev
mailing list