Hello Sean Thanks for this answer, i'll try the next release asap. Keep the good job.. Cheers Greg <div class="gmail_quote">Le 10 mai 2013 03:49, "Sean Flanigan" <<a href="mailto:sflaniga@redhat.com">sflaniga@redhat.com</a>> a écrit : <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> This seems to be <a href="https://bugzilla.redhat.com/show_bug.cgi?id=953195" target="_blank">https://bugzilla.redhat.com/show_bug.cgi?id=953195</a> On 15/04/13 21:02, Gregoire Henry wrote: > Hi Sean , thanks for answering > >>> is your database definitely using UTF-8 as its > default collation? > >>>> yes , but the default server collation is latin1 (don't think it matter but ...) > >>> Is the locale being translated definitely enabled > for the project in question? > >>>> Yes > > >>> And this happens with any search string > you try to use? > >>>> Yes > > > 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 .. > > each request to make a search raise this error , > - if you just try to use the check box (translated, need review > ,untranslated) in workspace , you get the message .. > - if you try to search from the search box , idem > - if you try a global search/remplace .. the same > > > > > > > > > > 2013/4/15 Sean Flanigan <<a href="mailto:sflaniga@redhat.com">sflaniga@redhat.com</a> <mailto:<a href="mailto:sflaniga@redhat.com">sflaniga@redhat.com</a>>> > > 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. > > 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> > <<a href="http://tf.document.id" target="_blank">http://tf.document.id</a>> > > <<a href="http://tf.document.id" target="_blank">http://tf.document.id</a>>=:docId AND ((lower(tf.content0) like > > :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> > <<a href="http://tf.document.id" target="_blank">http://tf.document.id</a>> > > <<a href="http://tf.document.id" target="_blank">http://tf.document.id</a>>=:docId AND ((lower(tf.content0) like > > :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) > > > > > > > > _______________________________________________ > > zanata-users mailing list > > <a href="mailto:zanata-users@redhat.com">zanata-users@redhat.com</a> <mailto:<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 > > -- Sean Flanigan Senior Software Engineer Engineering - Internationalisation Red Hat </blockquote></div>