On 10/24/2009 03:43 PM, Mike Ruocco wrote:
Hello
We are using SQL 2005 SP3.
Yes, there's a known problem with MS SQL and searches, reported by several users. I'll try to debug it.
On 10/24/09 8:42 AM, "Sergiu Dumitriu-2 [via XWiki]"<[email protected]> wrote:
On 10/23/2009 04:23 PM, Mike Ruocco wrote:
When we try to search this is what we get. What am I missing?
Thanks for any help!
Caused by: com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with SQL [select distinct doc.space, doc.name, doc.date from XWikiDocument as doc where (doc.hidden<> true or doc.hidden is null) and upper(doc.content) like upper('%search...%') order by doc.date desc]
What database are you using?
-- Sergiu Dumitriu http://purl.org/net/sergiu/