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

Site Memberships is missing for organization sites and throws console errors

    Details

    • Type: Regression Bug
    • Status: Closed
    • Resolution: No Longer Reproducible
    • Affects Version/s: 7.0.0 CE RC1
    • Fix Version/s: 7.0.0 CE RC1
    • Component/s: ~[Archived] WCM
    • Labels:
      None
    • Fix Priority:
      5

      Description

      Steps to reproduce:

      1. Add an Organization
      2. Add an Organization Site
      3. Manage the Org Site and enable "Allow Manual Membership Management"
      4. Go to Members > Site Memberships
      5. Assert the page is blank and the console errors below:
      Server startup in 101890 ms
      22:51:30,555 ERROR [http-nio-8080-exec-5][IncludeTag:128] Current URL /group/test-organization/~/control_panel/manage/-/site_memberships/members?p_p_auth=FkP0JPFf generates exception: com.liferay.portal.kernel.exception.SystemException: java.lang.IllegalArgumentException: Positional parameter does not exist: 14 in query: (  SELECT DISTINCT User_.userId AS userId, User_.screenName AS screenName, User_.firstName AS firstName, User_.middleName AS middleName, User_.lastName AS lastName FROM User_   INNER JOIN Users_Groups ON (Users_Groups.userId = User_.userId)  WHERE  (Users_Groups.groupId = ?)    AND  (User_.companyId = ?) AND (User_.defaultUser = ?) AND ( (User_.firstName LIKE ? OR ? IS NULL) AND (User_.middleName LIKE ? OR ? IS NULL) AND (User_.lastName LIKE ? OR ? IS NULL) AND (User_.screenName LIKE ? OR ? IS NULL) AND (User_.emailAddress LIKE ? OR ? IS NULL) ) AND (User_.status = ?)   ) UNION (  SELECT DISTINCT User_.userId AS userId, User_.screenName AS screenName, User_.firstName AS firstName, User_.middleName AS middleName, User_.lastName AS lastName FROM User_   INNER JOIN Users_Orgs ON (Users_Orgs.userId = User_.userId) INNER JOIN Organization_ ON (Organization_.organizationId = Users_Orgs.organizationId)    WHERE  ((Organization_.treePath LIKE '%/20974) AND  (User_.companyId = ?) AND (User_.defaultUser = ?) AND ( (User_.firstName LIKE ? OR ? IS NULL) AND (User_.middleName LIKE ? OR ? IS NULL) AND (User_.lastName LIKE ? OR ? IS NULL) AND (User_.screenName LIKE ? OR ? IS NULL) AND (User_.emailAddress LIKE ? OR ? IS NULL) ) AND (User_.status = ?)   )
      java.lang.IllegalArgumentException: Positional parameter does not exist: 14 in query: (  SELECT DISTINCT User_.userId AS userId, User_.screenName AS screenName, User_.firstName AS firstName, User_.middleName AS middleName, User_.lastName AS lastName FROM User_   INNER JOIN Users_Groups ON (Users_Groups.userId = User_.userId)  WHERE  (Users_Groups.groupId = ?)    AND  (User_.companyId = ?) AND (User_.defaultUser = ?) AND ( (User_.firstName LIKE ? OR ? IS NULL) AND (User_.middleName LIKE ? OR ? IS NULL) AND (User_.lastName LIKE ? OR ? IS NULL) AND (User_.screenName LIKE ? OR ? IS NULL) AND (User_.emailAddress LIKE ? OR ? IS NULL) ) AND (User_.status = ?)   ) UNION (  SELECT DISTINCT User_.userId AS userId, User_.screenName AS screenName, User_.firstName AS firstName, User_.middleName AS middleName, User_.lastName AS lastName FROM User_   INNER JOIN Users_Orgs ON (Users_Orgs.userId = User_.userId) INNER JOIN Organization_ ON (Organization_.organizationId = Users_Orgs.organizationId)    WHERE  ((Organization_.treePath LIKE '%/20974) AND  (User_.companyId = ?) AND (User_.defaultUser = ?) AND ( (User_.firstName LIKE ? OR ? IS NULL) AND (User_.middleName LIKE ? OR ? IS NULL) AND (User_.lastName LIKE ? OR ? IS NULL) AND (User_.screenName LIKE ? OR ? IS NULL) AND (User_.emailAddress LIKE ? OR ? IS NULL) ) AND (User_.status = ?)   )
      	at org.hibernate.impl.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:382)
      	at org.hibernate.impl.AbstractQueryImpl.setLong(AbstractQueryImpl.java:536)
      	at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.setLong(SQLQueryImpl.java:317)
      	at com.liferay.portal.kernel.dao.orm.QueryPos.add(QueryPos.java:198)
      	at com.liferay.portal.service.persistence.impl.UserFinderImpl.doFindByC_FN_MN_LN_SN_EA_S(UserFinderImpl.java:972)
      	at com.liferay.portal.service.persistence.impl.UserFinderImpl.countByC_FN_MN_LN_SN_EA_S(UserFinderImpl.java:437)
      	at com.liferay.portal.service.persistence.impl.UserFinderImpl.countByKeywords(UserFinderImpl.java:395)
      	at com.liferay.portal.service.impl.UserLocalServiceImpl.searchCount(UserLocalServiceImpl.java:3187)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:153)
      	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:85)
      	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:58)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:127)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:127)
      	at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:173)
      	at com.liferay.portal.kernel.service.UserLocalServiceUtil.searchCount(UserLocalServiceUtil.java:2179)
      	at org.apache.jsp.users_jsp._jspService(users_jsp:430)
      	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
      	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:411)
      22:51:35,221 ERROR [http-nio-8080-exec-9][IncludeTag:128] Current URL /group/test-organization/~/control_panel/manage/-/site_memberships/members?p_p_auth=FkP0JPFf generates exception: com.liferay.portal.kernel.exception.SystemException: java.lang.IllegalArgumentException: Positional parameter does not exist: 14 in query: (  SELECT DISTINCT User_.userId AS userId, User_.screenName AS screenName, User_.firstName AS firstName, User_.middleName AS middleName, User_.lastName AS lastName FROM User_   INNER JOIN Users_Groups ON (Users_Groups.userId = User_.userId)  WHERE  (Users_Groups.groupId = ?)    AND  (User_.companyId = ?) AND (User_.defaultUser = ?) AND ( (User_.firstName LIKE ? OR ? IS NULL) AND (User_.middleName LIKE ? OR ? IS NULL) AND (User_.lastName LIKE ? OR ? IS NULL) AND (User_.screenName LIKE ? OR ? IS NULL) AND (User_.emailAddress LIKE ? OR ? IS NULL) ) AND (User_.status = ?)   ) UNION (  SELECT DISTINCT User_.userId AS userId, User_.screenName AS screenName, User_.firstName AS firstName, User_.middleName AS middleName, User_.lastName AS lastName FROM User_   INNER JOIN Users_Orgs ON (Users_Orgs.userId = User_.userId) INNER JOIN Organization_ ON (Organization_.organizationId = Users_Orgs.organizationId)    WHERE  ((Organization_.treePath LIKE '%/20974) AND  (User_.companyId = ?) AND (User_.defaultUser = ?) AND ( (User_.firstName LIKE ? OR ? IS NULL) AND (User_.middleName LIKE ? OR ? IS NULL) AND (User_.lastName LIKE ? OR ? IS NULL) AND (User_.screenName LIKE ? OR ? IS NULL) AND (User_.emailAddress LIKE ? OR ? IS NULL) ) AND (User_.status = ?)   )
      java.lang.IllegalArgumentException: Positional parameter does not exist: 14 in query: (  SELECT DISTINCT User_.userId AS userId, User_.screenName AS screenName, User_.firstName AS firstName, User_.middleName AS middleName, User_.lastName AS lastName FROM User_   INNER JOIN Users_Groups ON (Users_Groups.userId = User_.userId)  WHERE  (Users_Groups.groupId = ?)    AND  (User_.companyId = ?) AND (User_.defaultUser = ?) AND ( (User_.firstName LIKE ? OR ? IS NULL) AND (User_.middleName LIKE ? OR ? IS NULL) AND (User_.lastName LIKE ? OR ? IS NULL) AND (User_.screenName LIKE ? OR ? IS NULL) AND (User_.emailAddress LIKE ? OR ? IS NULL) ) AND (User_.status = ?)   ) UNION (  SELECT DISTINCT User_.userId AS userId, User_.screenName AS screenName, User_.firstName AS firstName, User_.middleName AS middleName, User_.lastName AS lastName FROM User_   INNER JOIN Users_Orgs ON (Users_Orgs.userId = User_.userId) INNER JOIN Organization_ ON (Organization_.organizationId = Users_Orgs.organizationId)    WHERE  ((Organization_.treePath LIKE '%/20974) AND  (User_.companyId = ?) AND (User_.defaultUser = ?) AND ( (User_.firstName LIKE ? OR ? IS NULL) AND (User_.middleName LIKE ? OR ? IS NULL) AND (User_.lastName LIKE ? OR ? IS NULL) AND (User_.screenName LIKE ? OR ? IS NULL) AND (User_.emailAddress LIKE ? OR ? IS NULL) ) AND (User_.status = ?)   )
      	at org.hibernate.impl.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:382)
      	at org.hibernate.impl.AbstractQueryImpl.setLong(AbstractQueryImpl.java:536)
      	at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.setLong(SQLQueryImpl.java:317)
      	at com.liferay.portal.kernel.dao.orm.QueryPos.add(QueryPos.java:198)
      	at com.liferay.portal.service.persistence.impl.UserFinderImpl.doFindByC_FN_MN_LN_SN_EA_S(UserFinderImpl.java:972)
      	at com.liferay.portal.service.persistence.impl.UserFinderImpl.countByC_FN_MN_LN_SN_EA_S(UserFinderImpl.java:437)
      	at com.liferay.portal.service.persistence.impl.UserFinderImpl.countByKeywords(UserFinderImpl.java:395)
      	at com.liferay.portal.service.impl.UserLocalServiceImpl.searchCount(UserLocalServiceImpl.java:3187)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:153)
      	at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:85)
      	at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:58)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:127)
      	at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
      	at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:127)
      	at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:173)
      	at com.liferay.portal.kernel.service.UserLocalServiceUtil.searchCount(UserLocalServiceUtil.java:2179)
      	at org.apache.jsp.users_jsp._jspService(users_jsp:430)
      	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
      	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:411)
      

        Attachments

          Activity

            People

            Assignee:
            evan.nagayama Evan Nagayama (Inactive)
            Reporter:
            evan.nagayama Evan Nagayama (Inactive)
            Participants of an Issue:
            Recent user:
            Esther Sanz
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              4 years, 32 weeks, 1 day ago

                Packages

                Version Package
                7.0.0 CE RC1