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

Assign Users to This Site dialog is broken when enable Limit membership to members of the parent site

    Details

      Description

      Step to reproduce

      1. Add a new user
      2. Add a parent site
      3. Add a child site in parent site
      4. Enable Limit membership to members of the parent site
      5. Navigate to parent site
      6. Site admin > People > Memberships > Users tab
      7. Assign new user to parent site
      8. Navigate to child site
      9. Site admin > People > Memberships > Users tab
      10. Click add button

      Expected Results
      The available users are shown in dialog.

      Actual Results
      The dialog is broken. The alert message Memberships is temporarily unavailable.
      And the following error is thrown in browser console.

      Additonally, The following error is thrown in console.

      2020-03-11 13:34:22.972 ERROR [http-nio-8080-exec-9][PortletRequestDispatcherImpl:304] Unable to dispatch request: com.liferay.portal.kernel.exception.SystemException: java.lang.IllegalArgumentException: Positional parameter does not exist: 40 in query: SELECT COUNT(userId) AS COUNT_VALUE FROM ((  SELECT DISTINCT User_.userId AS userId FROM User_   INNER JOIN Users_Groups ON Users_Groups.userId = User_.userId  WHERE  Users_Groups.groupId = ?    AND  (User_.companyId = ?) AND (User_.defaultUser = ?) AND ((LOWER(User_.firstName) LIKE ? OR ? IS NULL) AND (LOWER(User_.middleName) LIKE ? OR ? IS NULL) AND (LOWER(User_.lastName) LIKE ? OR ? IS NULL) AND (LOWER(User_.screenName) LIKE ? OR ? IS NULL) AND (LOWER(User_.emailAddress) LIKE ? OR ? IS NULL)) AND (User_.status = ?)   ) UNION (  SELECT DISTINCT User_.userId AS userId FROM User_   INNER JOIN Users_Orgs ON Users_Orgs.userId = User_.userId INNER JOIN Groups_Orgs ON Groups_Orgs.organizationId = Users_Orgs.organizationId  WHERE  Groups_Orgs.groupId = 36213    AND  (User_.companyId = ?) AND (User_.defaultUser = ?) AND ((LOWER(User_.firstName) LIKE ? OR ? IS NULL) AND (LOWER(User_.middleName) LIKE ? OR ? IS NULL) AND (LOWER(User_.lastName) LIKE ? OR ? IS NULL) AND (LOWER(User_.screenName) LIKE ? OR ? IS NULL) AND (LOWER(User_.emailAddress) LIKE ? OR ? IS NULL)) AND (User_.status = ?)   ) UNION (  SELECT DISTINCT User_.userId AS userId FROM User_   INNER JOIN Users_UserGroups ON Users_UserGroups.userId = User_.userId INNER JOIN Groups_UserGroups ON Groups_UserGroups.userGroupId = Users_UserGroups.userGroupId  WHERE  Groups_UserGroups.groupId = 36213    AND  (User_.companyId = ?) AND (User_.defaultUser = ?) AND ((LOWER(User_.firstName) LIKE ? OR ? IS NULL) AND (LOWER(User_.middleName) LIKE ? OR ? IS NULL) AND (LOWER(User_.lastName) LIKE ? OR ? IS NULL) AND (LOWER(User_.screenName) LIKE ? OR ? IS NULL) AND (LOWER(User_.emailAddress) LIKE ? OR ? IS NULL)) AND (User_.status = ?)   )) userId
      

      Reproduced on:
      Tomcat 9.0.17 + MySQL 5.7. Portal master GIT ID: 763b60c77e5e5e449c1d5bb1e9617771e84ba37f.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              yang.cao Yang Cao
              Reporter:
              yang.cao Yang Cao
              Participants of an Issue:
              Recent user:
              Jason Pince
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                25 weeks, 1 day ago

                  Packages

                  Version Package
                  7.2.10 DXP FP8
                  7.2.10.2 DXP SP3
                  7.2.X
                  7.3.1 CE GA2
                  7.3.2 CE GA3
                  7.3.4 CE GA5
                  7.3.10 DXP GA1
                  Master