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

MBThread column differs on upgraded database

    Details

      Description

      Steps to Reproduce:

      1. Import attached 7.0.10.6 database to MySQL data-archive-portal-mysql.zip
      2. Upgrade this database to Master (with DXP profile)
        • tools/portal-tools-db-upgrade-client/db_upgrade.sh
      3. Connect Master to a different, empty database schema
      4. Start master against blank database schema
      5. Compare MBThread tables between upgraded and fresh database

      Expected Result:
      Columns match between the 2 databases.

      Actual Result:
      "title" column has different datatype and constraint

      Upgraded database

      `title` longtext 
      

      Fresh master database

      `title` varchar(75) DEFAULT NULL
      

      Slimmed down database dumps also attached
      fresh-master-sorted.sql upgraded-70106-sorted.sql

      Reproduced on 7.0.10.6 database, not reproducible on database from 7.1.10 or later.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jeremy.chen Jeremy Chen
              Reporter:
              victor.ware Victor Ware
              Participants of an Issue:
              Recent user:
              Yvonne Han
              Engineering Assignee:
              Alicia Garcia
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

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

                  Packages

                  Version Package
                  7.4.13 DXP GA1
                  7.4.3.4 CE GA4
                  Master