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

Cannot create an Organization with a name with more than 75 characters in DB2

    Details

      Description

      Description:

      When attempting to create an Organization with a name over 75 characters, DB2 throws an error due to column length.  However, the name column in the Organization table is 100 characters, so there is no issue there.  The problem is with the User_ table, specifically the screenName column, which is only 75 characters.  When creating the Org, LR attempts to validate the friendlyURL against the Group and User tables.  This change was added over 10 years ago, and now when creating new users, they are added to the Group table as well, so the solution will be to not check against the User table as it is no longer needed.

      Steps to Reproduce
      1. Start up 7.0 on DB2
      2. Go to Control Panel > Users and Organizations > Organizations > Add Organization with more than 75 characters
      Expected Behavior: Names less than 100 characters will work
      Actual Behavior: Name with more than 75 characters fails

      Testing
      Reproduced in 7.0.x-private - e155e30109b919834298fde6de84400214025d94
      Reproduced in master-private - ae556a3047d963040004456b0c58d2eb6d15381d

        Attachments

          Activity

            People

            • Assignee:
              sharry.shi Sharry Shi
              Reporter:
              christopher.kian Christopher Kian
              Participants of an Issue:
              Recent user:
              Clarissa Velazquez
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                29 weeks ago

                Packages

                Version Package
                7.0.0 DXP FP80
                7.0.10.11 DXP SP11
                7.0.X
                7.1.10 DXP FP10
                7.1.10.2 SP2
                7.1.3 CE GA4
                7.1.X
                Master