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

      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

              Assignee:
              linda.sui Linda Sui
              Reporter:
              alberto.chaparro Alberto Chaparro
              Participants of an Issue:
              Recent user:
              Csaba Turcsan
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                3 years, 47 weeks, 3 days ago

                  Packages

                  Version Package
                  7.0.0 DXP FP10
                  7.0.0 DXP SP2
                  7.0.3 CE GA4
                  7.1.X
                  Master