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

Contact_ table constraint differences on database upgrade from 6.2

    Details

    • Type: Bug
    • Status: Verified
    • Resolution: Unresolved
    • Affects Version/s: Master
    • Fix Version/s: None
    • Component/s: User Management
    • Labels:
      None
    • Fix Priority:
      3

      Description

      Steps to Reproduce:

      1. Import attached 6.2.10.21 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 Contact_ tables between upgraded and fresh database

      Expected Result:
      Columns match between the 2 databases.

      Actual Result:
      "prefixId" and "suffixId" columns have different datatype

      Upgraded database

      `prefixId` int(11) DEFAULT NULL
      `suffixId` int(11) DEFAULT NULL
      

      Fresh master database

      `prefixId` bigint(20) DEFAULT NULL
      `suffixId` bigint(20) DEFAULT NULL
      

      Slimmed down database dumps also attached
      fresh.sql upgraded.sql

      Not reproducible when upgrading a database from 7.x

        Attachments

        1. data-archive-portal-mysql.zip
          82 kB
        2. fresh.sql
          420 kB
        3. upgraded.sql
          438 kB

          Activity

            People

            Assignee:
            support-lep@liferay.com SE Support
            Reporter:
            victor.ware Victor Ware
            Participants of an Issue:
            Recent user:
            Victor Ware
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

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

                Packages

                Version Package