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

Duplicate name entries get created in ListType on DXP

    Details

    • Type: Bug
    • Status: Verified
    • Resolution: Unresolved
    • Affects Version/s: 7.1.X, 7.2.X, Master
    • Fix Version/s: None
    • Component/s: User Management
    • Labels:
    • Fix Priority:
      4

      Description

      Duplicate entries for title get created for ListType 'com.liferay.portal.kernel.model.Contact.prefix' when an existing user is modified on DXP.

      Reproduction steps:

      1. Create a database using below query
        create database eportal charset utf8 collate utf8_bin;
      2. Run Vanilla 6.2 Liferay portal with eportal database on tomcat
      3. Login as admin and create a new user using Create User option
      4. Save and then update title of the user
      5. Check ListType table, no new row is created for updated title in ListType table column "name"
      6. Create a database using below query
        create database eportal_dxp charset utf8 collate utf8_bin;
      7. Run Vanilla 7.1 Liferay portal with eportal_dxp database on tomcat
      8. Login as admin and create a new user using Create User option
      9. Save and then update title of the user
      10. There is new/Duplicate entry created for newly chosen Title in ListType table column "name".

      e.g If the newly title chosen is "mr" then a new duplicate entry "Mr" gets created in the table ListType

      #14319:
      We do not think it can be considered a bug, as the binary collation utf8_bin is case sensitive, therefore it differentiates between capital and lower-case letters. To overcome the unwanted behaviour, you would need to change the collation of the existing database or involve customization.

      However we should investigate why the behavior was changed in Liferay DXP. In 6.2 ID's were passed as the value for prefix, but now in 7.1 instead of Ids actual values language specific Text are being set.

      Probably the same issue with 'com.liferay.portal.kernel.model.Contact.sufix'
      Could not test on master and 7.0.x yet as the bundles crashed, but please let me know if it is needed and I will get back to this as soon as possible.

      Addiotional note from the customer:

      If you inspect the dropdown element for title, you can see that
      In liferay 6.2, the mark of the dropdown is generated like this
      <select class="aui-field-select" id="_125_prefixId" name="_125_prefixId">
      <option class="" value="0"> </option>
      <option class="" value="11014"> Dr.</option>
      <option class="" value="11015"> Mr.</option>
      <option class="" value="11016"> Mrs.</option>
      <option class="" value="11017"> Ms.</option>
      </select>

      In 7.1 the markup is getting generated like this
      <select name="_com_liferay_users_admin_web_portlet_UsersAdminPortlet_prefixValue" class="form-control" id="_com_liferay_users_admin_web_portlet_UsersAdminPortlet_prefixValue">
      <option value=""> </option>
      <option value="Dr"> Dr </option>
      <option value="Mr"> Mr </option>
      <option value="Ms"> Ms </option>
      <option value="Mrs"> Mrs </option>
      </select>

      As you can see in the above snippets, in liferay 6.2, irrespective of the language chosen, the IDs were passed as the value for prefix, but now in 7.1 instead of Ids actual values language specific Text are being set.

        Attachments

          Activity

            People

            • Assignee:
              support-lep@liferay.com SE Support
              Reporter:
              norbert.kocsis Norbert Kocsis
              Participants of an Issue:
              Recent user:
              Liferay JIRA Bot
              Engineering Assignee:
              Norbert Kocsis
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Days since last comment:
                5 weeks, 6 days ago

                Packages

                Version Package