Details

      Description

      1. Add My Sites Directory to new page.

      Expected result:
      Users should not see any exception.

      Actual result:

      08:36:24,705 ERROR [http-bio-8080-exec-10][IncludeTag:129] Current URL /user/test/home generates exception: com.liferay.portal.kernel.exception.System
      Exception: java.lang.IllegalArgumentException: Positional parameter does not exist: 3 in query: (  SELECT DISTINCT Group_.groupId AS groupId, REPLACE(
      Group_.name, ' LFR_ORGANIZATION', '') AS groupName FROM Group_   INNER JOIN Users_Groups ON (Users_Groups.groupId = Group_.groupId)  WHERE  (Group_.si
      te = ?)    AND  (Group_.liveGroupId = 0) AND (Users_Groups.userId = ?)    AND  (Group_.companyId = ?) AND (Group_.classNameId = 10001 OR Group_.classN
      ameId = 10003) AND (Group_.liveGroupId = 0) AND (Group_.type_ != 4)   ) ORDER BY groupName ASC
      java.lang.IllegalArgumentException: Positional parameter does not exist: 3 in query: (  SELECT DISTINCT Group_.groupId AS groupId, REPLACE(Group_.name
      , ' LFR_ORGANIZATION', '') AS groupName FROM Group_   INNER JOIN Users_Groups ON (Users_Groups.groupId = Group_.groupId)  WHERE  (Group_.site = ?)
      AND  (Group_.liveGroupId = 0) AND (Users_Groups.userId = ?)    AND  (Group_.companyId = ?) AND (Group_.classNameId = 10001 OR Group_.classNameId = 100
      03) AND (Group_.liveGroupId = 0) AND (Group_.type_ != 4)   ) ORDER BY groupName ASC
              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:265)
              at com.liferay.portal.kernel.dao.orm.QueryPos.add(QueryPos.java:198)
              at com.liferay.portal.service.persistence.GroupFinderImpl.findByCompanyId(GroupFinderImpl.java:564)
              at com.liferay.portal.service.impl.GroupLocalServiceImpl.search(GroupLocalServiceImpl.java:2127)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:115)
              at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:62)
              at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:51)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
              at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:175)
              at com.liferay.portal.service.GroupLocalServiceUtil.search(GroupLocalServiceUtil.java:1796)
              at org.apache.jsp.html.portlet.directory.view_005fusers_jsp._jspService(view_005fusers_jsp.java:834)
              at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
              at com.liferay.portal.servlet.DirectRequestDispatcher.include(DirectRequestDispatcher.java:57)
              at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.doDispatch(ClassLoaderRequestDispatcherWrapper.java:78)
              at com.liferay.portal.servlet.ClassLoaderRequestDispatcherWrapper.include(ClassLoaderRequestDispatcherWrapper.java:53)
              at com.liferay.taglib.util.IncludeTag.include(IncludeTag.java:295)
              at com.liferay.taglib.util.IncludeTag.doInclude(IncludeTag.java:192)
      

        Attachments

          Activity

            People

            Assignee:
            eduardo.garcia Eduardo García
            Reporter:
            mark.jin Mark Jin (Inactive)
            Participants of an Issue:
            Recent user:
            Brian Wulbern
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              6 years, 33 weeks ago

                Packages

                Version Package
                7.0.0 M1