Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-147

Table names are too long for MySQL with UTF-8

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Fixed
    • 2.0
    • Database
    • None
    • SuSE Linux v10
      Caucho Resin v3
      MySQL v4.1 - UTF8 Database
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      I found the following in the logs:

      create table `REMOTEGROUPMEMBERS` (`REMOTEGROUPDIRECTORYID` bigint not null, `REMOTEGROUPNAME` varchar(255) not null, `REMOTEPRINCIPALDIRECTORYID` bigint not null, `REMOTEPRINCIPALNAME` varchar(255) not null, primary key (`REMOTEGROUPDIRECTORYID`, `REMOTEGROUPNAME`, `REMOTEPRINCIPALDIRECTORYID`, `REMOTEPRINCIPALNAME`))

      This never gets created - when I run it manually I get:

      Error 1071 - Specified key was too long; max key length is 1000 bytes

      I can't find a setting to change the max key length to work around this while a fix is found. Another work around would be useful as I cannot continue investigating using Crowd at this point.

      Attachments

        Issue Links

          Activity

            People

              justen.stepka@atlassian.com Justen Stepka [Atlassian]
              dhardiker Dan Hardiker
              Votes:
              8 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: