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

UserName DB Schema not consistent cause data truncation issue

    Details

      Description

      in Liferay DB, in User_ table, there defined FirstName, MiddleName and LastName fields with varchar(75), and according to the default DefaultFullNameGenerator, User.GetFullName() will return [FirstName + " " + MiddleName + " " + LastName] as its value; the length of the FullName might be varchar(228);
      but in other tables, UserName field(or other field like StatusByUserName) are just defined as varchar(75) but filled with user's FullName value, This might cause data truncation problems if create a user with a long Name(firstname+MiddleName+Lastname);

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                5 years, 39 weeks, 1 day ago

                Packages

                Version Package
                6.2.0 CE B1
                6.2.X EE