On Sat, Oct 24, 2009 at 16:45, Sergiu Dumitriu <[email protected]> wrote:
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.
OK, after a long hassle with MS SQL, I managed to get XWiki working on it. The problem seems to be the UPPER function, which doesn't work on TEXT types directly. http://databases.aspfaq.com/database/why-do-i-get-argument-data-type-text-is... explains it and gives a solution, I'll try to make it work automatically.
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/