Details

    • Type: Bug
    • Status: Resolved
    • Resolution: Duplicate
    • Affects Version/s: 7.3.1 CE GA2
    • Fix Version/s: None
    • Labels:
      None
    • Fix Priority:
      4

      Description

      I have a site with some few private pages and restricted access, manual . I add a user via Control Panel > Users > Users and Organizations +  Add. I navigate to the Site's > People > Memberships and click "Add". Then, Memberships is temporarily unavailable.

      Please find the logs below.

      Cross checking:

      Navigate to Control Panel > Users > Users and Organizations > click Edit for the same user. On its Memberships tab, select the site and save. Works as expected.User is added as a member to the site.

      My setup is liferay-ce-portal-7.3.1-ga2 and mariadb (10.2) on MS Server 2012 R2.

      Same behaviour with liferay-ce-portal-7.3.1-ga2 and mariadb (10.1.44) on Ubuntu 18.04 LTS.

      Logs:

      ERROR [http-nio-8080-exec-7][render_portlet_jsp:131] null
      java.lang.IllegalArgumentException: Positional parameter does not exist: 13 in query: SELECT COUNT(userId) AS COUNT_VALUE FROM (( SELECT DISTINCT User_.userId AS userId FROM User_ WHERE (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
       at org.hibernate.impl.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:382)
       at org.hibernate.impl.AbstractQueryImpl.setInteger(AbstractQueryImpl.java:531)
       at com.liferay.portal.dao.orm.hibernate.SQLQueryImpl.setInteger(SQLQueryImpl.java:304)
       at com.liferay.portal.kernel.dao.orm.QueryPos.add(QueryPos.java:179)
       at com.liferay.portal.service.persistence.impl.UserFinderImpl.countByC_FN_MN_LN_SN_EA_S(UserFinderImpl.java:593)
       at com.liferay.portal.service.persistence.impl.UserFinderImpl.countByKeywords(UserFinderImpl.java:316)
       at com.liferay.portal.service.impl.UserLocalServiceImpl.searchCount(UserLocalServiceImpl.java:3268)
       at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:66)
       at com.liferay.portal.kernel.service.UserLocalServiceWrapper.searchCount(UserLocalServiceWrapper.java:2479)
       at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:66)
       at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
       at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69)
       at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)
       at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:49)
       at com.liferay.portal.kernel.service.UserLocalServiceUtil.searchCount(UserLocalServiceUtil.java:2303)
       at com.liferay.site.memberships.web.internal.display.context.SelectUsersDisplayContext.getUserSearchContainer(SelectUsersDisplayContext.java:189)
       at com.liferay.site.memberships.web.internal.display.context.SelectUsersManagementToolbarDisplayContext.<init>(SelectUsersManagementToolbarDisplayContext.java:40)

       

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  2 days ago

                  Packages

                  Version Package