<div dir="ltr">Hi Sean , thanks for answering<div> </div><div>>> is your database definitely using UTF-8 as its default collation? </div><div> </div><div style>>>> yes , but the default server collation is latin1 (don't think it matter but ...) </div> <div style> </div><div style>>> Is the locale being translated definitely enabled</div> for the project in question?<div> </div><div style>>>> Yes </div> <div style> </div><div style> </div><div style>>> And this happens with any search string</div> you try to use?<div> </div><div>>>> Yes </div><div> </div><div> </div><div style>i'm very sure this is a configuration or system specification error (this is a too big issue for not being mentionned before ) , but can't see where is the problem ..</div> <div style> </div><div style>each request to make a search raise this error , </div><div style>- if you just try to use the check box (translated, need review ,untranslated) in workspace , you get the message .. </div> <div style>- if you try to search from the search box , idem </div><div style>- if you try a global search/remplace .. the same </div><div style> </div><div style> </div><div style> </div><div> </div><div> </div><div> <div> </div></div></div><div class="gmail_extra"> <div class="gmail_quote">2013/4/15 Sean Flanigan <<a href="mailto:sflaniga@redhat.com" target="_blank">sflaniga@redhat.com</a>> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Gregoire, We haven't seen that error before, and we're having trouble working out what might be causing it. It's a long shot, but is your database definitely using UTF-8 as its default collation? Is the locale being translated definitely enabled for the project in question? And this happens with any search string you try to use? Regards Sean. <div class="im"> On 2013-04-12 06:25, Gregoire Henry wrote: > Hello Zanata Folks. > > I've just updated to 2.2.2 from 2.0.3 > (Win 2008 server / MySql 5.2 / jdk 1.6.31) > > Each time i try to make a search in translation workspace an exception > is raised (see below) and the search didn't return values ... > > Any idea ? > > FYI : this bug was also present in my 2.0.3 version (same environment) > > > Thanks for answering .. > > > Regards > > Exception below : > > 2013-04-11 22:17:01,280 ERROR [org.zanata.webtrans.server.SeamDispatch] > (http-0.0.0.0-80-3) Error dispatching action: > org.hibernate.hql.ast.InvalidWithClauseException: with-clause > expressions did not reference from-clause element to which the > with-clause was associated [SELECT distinct tf FROM > org.zanata.model.HTextFlow tf LEFT JOIN tf.targets tfts WITH > index(tfts)=:locale WHERE (tf.obsolete=0 AND <a href="http://tf.document.id" target="_blank">tf.document.id</a> </div>> <<a href="http://tf.document.id" target="_blank">http://tf.document.id</a>>=:docId AND ((lower(tf.content0) like <div class="im">> :searchString or lower(tf.content1) like :searchString or > lower(tf.content2) like :searchString or lower(tf.content3) like > :searchString or lower(tf.content4) like :searchString or > lower(tf.content5) like :searchString) OR EXISTS ( FROM > org.zanata.model.HTextFlowTarget WHERE (textFlow=tf and locale=:locale > and (lower(content0) like :searchString or lower(content1) like > :searchString or lower(content2) like :searchString or lower(content3) > like :searchString or lower(content4) like :searchString or > lower(content5) like :searchString))))) ORDER BY tf.pos] > org.hibernate.hql.ast.InvalidWithClauseException: with-clause > expressions did not reference from-clause element to which the > with-clause was associated [SELECT distinct tf FROM > org.zanata.model.HTextFlow tf LEFT JOIN tf.targets tfts WITH > index(tfts)=:locale WHERE (tf.obsolete=0 AND <a href="http://tf.document.id" target="_blank">tf.document.id</a> </div>> <<a href="http://tf.document.id" target="_blank">http://tf.document.id</a>>=:docId AND ((lower(tf.content0) like <div><div class="h5">> :searchString or lower(tf.content1) like :searchString or > lower(tf.content2) like :searchString or lower(tf.content3) like > :searchString or lower(tf.content4) like :searchString or > lower(tf.content5) like :searchString) OR EXISTS ( FROM > org.zanata.model.HTextFlowTarget WHERE (textFlow=tf and locale=:locale > and (lower(content0) like :searchString or lower(content1) like > :searchString or lower(content2) like :searchString or lower(content3) > like :searchString or lower(content4) like :searchString or > lower(content5) like :searchString))))) ORDER BY tf.pos] > at > org.hibernate.hql.ast.HqlSqlWalker.handleWithFragment(HqlSqlWalker.java:359) > at > org.hibernate.hql.ast.HqlSqlWalker.createFromJoinElement(HqlSqlWalker.java:338) > at > org.hibernate.hql.antlr.HqlSqlBaseWalker.joinElement(HqlSqlBaseWalker.java:3275) > at > org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3067) > at > org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2945) > at > org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688) > at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544) > at > org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281) > at > org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229) > at > org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:251) > at > org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183) > at > org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:134) > at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101) > at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80) > at > org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94) > at > org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156) > at > org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135) > at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1650) > at > org.hibernate.search.impl.FullTextSessionImpl.createQuery(FullTextSessionImpl.java:313) > at sun.reflect.GeneratedMethodAccessor444.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.jboss.seam.persistence.HibernateSessionInvocationHandler.handleCreateQueryWithString(HibernateSessionInvocationHandler.java:113) > at > org.jboss.seam.persistence.HibernateSessionInvocationHandler.invoke(HibernateSessionInvocationHandler.java:76) > at $Proxy478.createQuery(Unknown Source) > at > org.zanata.dao.TextFlowDAO.getTextFlowByDocumentIdWithConstraint(TextFlowDAO.java:299) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.jboss.seam.util.Reflections.invoke(Reflections.java:22) > at > org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32) > at > org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56) > at > org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28) > at > org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) > at > org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:77) > at > org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) > at > org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44) > at > org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) > at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107) > at > org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:185) > at > org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:103) > at > org.zanata.dao.TextFlowDAO_$$_javassist_seam_68.getTextFlowByDocumentIdWithConstraint(TextFlowDAO_$$_javassist_seam_68.java) > at > org.zanata.webtrans.server.rpc.GetTransUnitListHandler.getTextFlows(GetTransUnitListHandler.java:119) > at > org.zanata.webtrans.server.rpc.GetTransUnitListHandler.execute(GetTransUnitListHandler.java:97) > at > org.zanata.webtrans.server.rpc.GetTransUnitListHandler.execute(GetTransUnitListHandler.java:53) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.jboss.seam.util.Reflections.invoke(Reflections.java:22) > at > org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32) > at > org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56) > at > org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28) > at > org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) > at > org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:77) > at > org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) > at > org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44) > at > org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) > at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107) > at > org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:185) > at > org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:103) > at > org.zanata.webtrans.server.rpc.GetTransUnitListHandler_$$_javassist_seam_66.execute(GetTransUnitListHandler_$$_javassist_seam_66.java) > at org.zanata.webtrans.server.SeamDispatch.doExecute(SeamDispatch.java:164) > at org.zanata.webtrans.server.SeamDispatch.execute(SeamDispatch.java:136) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.jboss.seam.util.Reflections.invoke(Reflections.java:22) > at > org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32) > at > org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56) > at > org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28) > at > org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) > at > org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44) > at > org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) > at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107) > at > org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:185) > at > org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:103) > at > org.zanata.webtrans.server.SeamDispatch_$$_javassist_seam_11.execute(SeamDispatch_$$_javassist_seam_11.java) > at > org.zanata.webtrans.server.DispatchServiceImpl.execute(DispatchServiceImpl.java:22) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.jboss.seam.util.Reflections.invoke(Reflections.java:22) > at > org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32) > at > org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56) > at > org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28) > at > org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) > at > org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:77) > at > org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) > at > org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44) > at > org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) > at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107) > at > org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:185) > at > org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:103) > at > org.zanata.webtrans.server.DispatchServiceImpl_$$_javassist_seam_58.execute(DispatchServiceImpl_$$_javassist_seam_58.java) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.jboss.seam.remoting.gwt.GWTToSeamAdapter.callWebRemoteMethod(GWTToSeamAdapter.java:100) > at > org.jboss.seam.remoting.gwt.GWTService.RPC_invokeAndEncodeResponse(GWTService.java:544) > at org.jboss.seam.remoting.gwt.GWTService.processCall(GWTService.java:206) > at org.jboss.seam.remoting.gwt.GWTService$1.process(GWTService.java:120) > at > org.jboss.seam.servlet.ContextualHttpServletRequest.run(ContextualHttpServletRequest.java:65) > at org.jboss.seam.remoting.gwt.GWTService.getResource(GWTService.java:105) > at > org.jboss.seam.servlet.SeamResourceServlet.service(SeamResourceServlet.java:80) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176) > at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145) > at > org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92) > at > org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:389) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83) > at > org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:73) > at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64) > at > org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) > at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:206) > at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290) > at > org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388) > at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515) > at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56) > at > org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) > at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60) > at > org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) > at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.zanata.seam.interceptor.MonitoringWrapper.doFilter(MonitoringWrapper.java:70) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.zanata.servlet.GWTCacheControlFilter.doFilter(GWTCacheControlFilter.java:63) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > at > org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190) > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) > at > org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92) > at > org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126) > at > org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > at > org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598) > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) > at java.lang.Thread.run(Thread.java:662) > > > </div></div>> _______________________________________________ > zanata-users mailing list > <a href="mailto:zanata-users@redhat.com">zanata-users@redhat.com</a> > <a href="https://www.redhat.com/mailman/listinfo/zanata-users" target="_blank">https://www.redhat.com/mailman/listinfo/zanata-users</a> -- Sean Flanigan Senior Software Engineer Engineering - Internationalisation Red Hat </blockquote></div> </div>