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
