Details
-
Bug
-
Resolution: Fixed
-
Blocker
-
11.5
-
Unknown
-
N/A
-
N/A
-
Description
When viewing e.g. the "Children" view of the "Sandbox.WebHome", typing in a filter character in the "Title" or "Location" field removes all results and displays an error in the log:
Caused by: org.xwiki.query.QueryException: Exception while executing query. Query statement = [WHERE 1=1 AND doc.fullName LIKE ?1 AND doc.fullName <> ?2 AND LOWER(doc.fullName) LIKE LOWER(?2) ESCAPE '!' order by doc.fullName asc] at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:182) at org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72) at org.xwiki.query.internal.SecureQueryExecutorManager.execute(SecureQueryExecutorManager.java:67) at org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:306) at org.xwiki.query.internal.ScriptQuery.execute(ScriptQuery.java:252) at sun.reflect.GeneratedMethodAccessor317.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:395) at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:384) at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:173) ... 70 common frames omitted Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:826) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:889) at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:170) ... 80 common frames omitted Caused by: java.lang.IllegalArgumentException: Could not locate ordinal parameter [3], expecting one of [1, 2] at org.hibernate.query.internal.ParameterMetadataImpl.getOrdinalParameterDescriptor(ParameterMetadataImpl.java:154) at org.hibernate.query.internal.ParameterMetadataImpl.getQueryParameter(ParameterMetadataImpl.java:204) at org.hibernate.query.internal.QueryParameterBindingsImpl.getBinding(QueryParameterBindingsImpl.java:182) at org.hibernate.query.internal.AbstractProducedQuery.setParameter(AbstractProducedQuery.java:515) at org.hibernate.query.internal.AbstractProducedQuery.setParameter(AbstractProducedQuery.java:110) at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.populateParameters(HqlQueryExecutor.java:378) at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.createHibernateQuery(HqlQueryExecutor.java:208) at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.lambda$execute$0(HqlQueryExecutor.java:171) at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:820) ... 82 common frames omitted
Also filtering by date is ineffective, though it does not create an error.
Attachments
Issue Links
- is related to
-
XWIKI-8286 Upgrade to Hibernate 5.4.3
- Closed