Hello, some hints here : http://jira.nuxeo.org/browse/NXP-3422
----- Mail Original ----- De: "Sean Radford" <[email protected]> À: [email protected] Envoyé: Mercredi 19 Août 2009 17h33:26 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm / Vienne Objet: [Ecm] syntax error in tsquery Anyone able to shed some light on this. I enter a multi-word search (i.e. more than 1 word) in the search (simple or advanced) and it fails: 2009-08-19 16:07:49,193 DEBUG [org.nuxeo.ecm.webapp.search.SearchActionsBean] Fire Event: searchPerformed 2009-08-19 16:07:49,193 DEBUG [org.nuxeo.ecm.webapp.search.SearchActionsBean] performing searchType: KEYWORDS 2009-08-19 16:07:49,194 DEBUG [org.nuxeo.ecm.webapp.pagination.ResultsProvidersCacheBean] Invalidating provider 'SIMPLE_SEARCH' 2009-08-19 16:07:49,194 DEBUG [org.nuxeo.ecm.webapp.pagination.ResultsProvidersCacheBean] (Re)building provider 'SIMPLE_SEARCH' 2009-08-19 16:07:49,195 DEBUG [org.nuxeo.ecm.webapp.querymodel.QueryModelActionsBean] (Re)building query model SIMPLE_SEARCH 2009-08-19 16:07:49,195 DEBUG [org.nuxeo.ecm.core.search.api.client.querymodel.QueryModel] execute query: SELECT * FROM Document WHERE ec m:fulltext LIKE 'one two' AND ecm:mixinType != 'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND ecm:curren tLifeCycleState != 'deleted' 2009-08-19 16:07:49,195 DEBUG [org.nuxeo.ecm.core.api.ejb.DocumentManagerBean] Initializing session for repository: default 2009-08-19 16:07:49,196 DEBUG [org.nuxeo.ecm.core.storage.sql.ra.ManagedConnectionImpl] getConnection: org.nuxeo.ecm.core.storage.sql.ra. managedconnectioni...@cad055d 2009-08-19 16:07:49,196 DEBUG [org.nuxeo.ecm.core.storage.sql.ra.ManagedConnectionImpl] addConnection: org.nuxeo.ecm.core.storage.sql.ra. connectioni...@5fb696f0 2009-08-19 16:07:49,201 ERROR [org.nuxeo.ecm.webapp.pagination.ResultsProvidersCacheBean] failed to obtain sorted resultProvider org.nuxeo.ecm.core.api.ClientException: Failed to execute query: ERROR: syntax error in tsquery: "one two" at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1403) .... at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) at java.lang.Thread.run(Thread.java:619) Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.query.QueryException. message: Invalid query: SELECT * FROM Document WHERE ecm:fulltext LIKE 'one two' AND ecm:mixinType != 'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted' at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession$SQLSessionQuery.execute(SQLSession.java:457) at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1350) ... 171 more Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.nuxeo.ecm.core.storage.StorageException. message: Invalid query: SELEC T * FROM Document WHERE ecm:fulltext LIKE 'one two' AND ecm:mixinType != 'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted' at org.nuxeo.ecm.core.storage.sql.SessionImpl.query(SessionImpl.java:590) at org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.query(ConnectionImpl.java:257) at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession$SQLSessionQuery.execute(SQLSession.java:452) ... 172 more Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception: org.postgresql.util.PSQLException. message: ERROR: syntax error in tsquery : "one two" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) at sun.reflect.GeneratedMethodAccessor149.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:471) at $Proxy373.executeQuery(Unknown Source) at org.nuxeo.ecm.core.storage.sql.Mapper.query(Mapper.java:1791) at org.nuxeo.ecm.core.storage.sql.SessionImpl.query(SessionImpl.java:588) ... 174 more The server is running Postgres 8.3 with the casts and plpgsql setup. Thanks in advance. Sean -- Dr. Sean Radford, MBBS, MSc http://www.tacola.com/ t: +44 (0) 8700 671 490 m: +44 (0) 7802 24 24 86 _______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm _______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
