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

Warning: BLOB/TEXT column 'referenceType' used in key specification without a key length

    Details

      Description

      Steps to reproduce:

      1. Populate data from the attached database of 7.2.0 GA1.
      2. Run upgrade client tool
      3. Search for "WARN - BLOB/TEXT column 'referenceType'"

      Expected results:
      The upgrade is successful without warning.
      Actual result:
      The upgrade completes successfully but throws the following warning error.

      [java] 2019-08-06 21:17:05.555 INFO  [main][BaseDB:109] create unique index IX_6B9E4A66 on DLOpenerFileEntryReference (referenceType, fileEntryId);
           [java] INFO - create unique index IX_6B9E4A66 on DLOpenerFileEntryReference (referenceType, fileEntryId);
           [java] 2019-08-06 21:17:05.556 WARN  [main][BaseDB:117] BLOB/TEXT column 'referenceType' used in key specification without a key length: create unique index IX_6B9E4A66 on DLOpenerFileEntryReference (referenceType, fileEntryId);
           [java] WARN - BLOB/TEXT column 'referenceType' used in key specification without a key length: create unique index IX_6B9E4A66 on DLOpenerFileEntryReference (referenceType, fileEntryId);
      

        Attachments

          Activity

            People

            Assignee:
            jeremy.chen Jeremy Chen
            Reporter:
            koor.gai Koor Gai
            Participants of an Issue:
            Recent user:
            Jason Pince
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

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

                Packages

                Version Package
                7.2.10 DXP FP2
                7.2.10.1 DXP SP1
                7.2.X
                7.2.1 CE GA2
                7.3.10 DXP GA1
                Master