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

Missing LayoutFriendlyURL table when upgrade 6.1

    Details

      Description

       Steps:

      1. Start up a clean 6.1.30
      2. Create any asset (e.g. Blog)
      3. Shut down the portal
      4. Set up the related properties, then upgrade to Master

      Expected result: upgrade is successful

      Actual result: nonexisting tables in 6.1 are not created, exception is thrown > missing LayoutFriendlyURL DB table

      com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lportal.LayoutFriendlyURL' doesn't exist
      

       

      Temporary workaround: execute the following SQL (Mysql syntax) prior to perform the upgrade refer to --LPS-56232--:

      create table LayoutFriendlyURL (
       mvccVersion bigint default 0 not null,
       uuid_ varchar(75) null,
       layoutFriendlyURLId bigint not null primary key,
       groupId bigint,
       companyId bigint,
       userId bigint,
       userName varchar(75) null,
       createDate datetime(6) null,
       modifiedDate datetime(6) null,
       plid bigint,
       privateLayout tinyint,
       friendlyURL varchar(255) null,
       languageId varchar(75) null,
       lastPublishDate datetime(6) null
      ) engine InnoDB;

       

      Reproducible:

      • Ubuntu 14.04, MySQL 5.5
        • from 6.1.2 CE - Tomcat 7
        • to 7.1.x Master - Tomcat 9

      Fix priority: S3 + L3 = 3

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sharry.shi Sharry Shi
                Reporter:
                vitezslav.miech Vitezslav Miech
                Participants of an Issue:
                Recent user:
                Joyce Wang
              • 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.0.X
                  Master