-
Type:
Regression Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: 7.2.X, Master
-
Fix Version/s: 7.3.5 CE GA6, 7.3.10 DXP GA1, Master
-
Component/s: User Management
-
Labels:
-
Fix Priority:3
-
Last Working Version:
-
Sprint:U&SM| S03 Sprint 30 | 8.18-9.1
-
Git Pull Request:
Steps to reproduce:
- Configure users.search.with.index=false
- Start up the application server
- Login as Administrator
- Go to Liferay > People > Site Memberships and click in the Plus button
Expected result:
- Users are shown to be selected
Actual result:
- An error message appears in the modal: "Site Memberships Portlets is temporarily unavailable"
- An error message appears in the server logs:
2020-06-26 08:57:57.668 ERROR [http-nio-17280-exec-3][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:596) at com.liferay.portal.service.persistence.impl.UserFinderImpl.countByKeywords(UserFinderImpl.java:319) at com.liferay.portal.service.impl.UserLocalServiceImpl.searchCount(UserLocalServiceImpl.java:3357) at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:66) at com.liferay.portal.kernel.service.UserLocalServiceWrapper.searchCount(UserLocalServiceWrapper.java:2507) at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:66) 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:2330) at com.liferay.site.memberships.web.internal.display.context.SelectUsersDisplayContext.getUserSearchContainer(SelectUsersDisplayContext.java:188) at com.liferay.site.memberships.web.internal.display.context.SelectUsersManagementToolbarDisplayContext.<init>(SelectUsersManagementToolbarDisplayContext.java:40) at org.apache.jsp.select_005fusers_jsp._jspService(select_005fusers_jsp.java:345) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
- is caused by
-
LPS-105757 isGroupAdmin() checks for a non-existent groupId attribute in the SearchContext
- Closed
-
LPS-106935 Unable to assign new user to site under Membership
- Closed
- is duplicated by
-
LPS-112888 Memberships is temporarily unavailable
- Closed