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-invalid-for-argument.html 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/ > -- http://purl.org/net/sergiu _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
