Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-69878

Field groupKey in Group table isn't create properly after upgrading to Liferay 7/DXP

    Details

    • Branch Version/s:
      7.0.x
    • Backported to Branch:
      Committed
    • Story Points:
      1.25
    • Fix Priority:
      3

      Description

      Steps to reproduce:

      1. Upgrade a 6.2 version to master/DXP
      2. After finishing the upgrade check the Group_ table

      Results:
      The type of the groupKey is longtext (mysql) or similar.

      Following indexes weren't created (just in mysql):

      create unique index IX_A729E3A6 on Group_ (companyId, classNameId, liveGroupId, groupKey);
      create unique index IX_ACD2B296 on Group_ (companyId, groupKey);
      create unique index IX_AACD15F0 on Group_ (companyId, liveGroupId, groupKey);

      Because mysql only supports a maximum of 255 characters for field indexes:

      com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: BLOB/TEXT column 'groupKey' used in key specification without a key length

      Expected results:
      The type of the field groupKey is VARCHAR(150)

      The previous indexes are created.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  1 year, 7 weeks, 1 day ago