<
From version < 7.2 >
edited by Helmut Nagy
on 2008/12/17
To version < 8.1 >
edited by steel
on 2009/03/24
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.hel
1 +XWiki.steel
Content
... ... @@ -37,8 +37,21 @@
37 37  {code}
38 38  
39 39  
40 -1.1 Fix search function
40 +1.1 Troubleshooting
41 41  
42 +1.1.1 Fix search function
43 +
42 42  If you try to do a search, via [Main.WebSearch], you will get an error. This is because the UPPER() function doesn not work on TEXT or NTEXT as used by MSSQL 2000 for blobs. The only solution I have found is to remove all the calls to upper() in [Main.WebSearch]. This is however not very practical, because it makes search case&#45;sensitive.
43 43  
44 44  Alternatively, you may want to use the [Lucene search>code:Applications.SearchApplication] instead of the default search.
47 +
48 +1.1.1 Hints for upgrading to MS SQL 2005
49 +
50 +In MS SQL 2005 the standard schema in all databases is dbo by default. However, if you upgrade your server with the standard Microsoft software, all tables in your xwiki database will be configured to use a schema whichs name is equivalent to the database name. (If your database name is "xwiki", the schema name will also be "xwiki" and the full qualified tablenames will be "xwiki.xwikidoc", and so on)
51 +
52 +Since the standard schema in is configured to be "dbo", xwiki will not find any tables (since it searches for "dbo.xwikidoc", ...). This will result in an exception when calling the xwiki webapp (in the logfiles you will see an "object not found" - exception for xwikidoc, because xwikidoc is the first table to be mapped via hibernate)\\
53 +\\
54 +There are 2 possible solutions to this problem:
55 +
56 +* Reconfigure your server to use "xwiki" as standard scheme inside the xwiki-database.
57 +* Adopt the hibernate file (xwiki.mssql.hbm.xml). Look for the table definitions, eg. ~~table="xwikidoc"~~ and set it to ~~table="xwiki.xwikidoc"~~, or to whatever your schema/database is called. Do this for all tables you can find in the file.
XWiki.XWikiComments[0]
Date
... ... @@ -1,1 +1,1 @@
1 -2008-12-17 17:58:28.343
1 +2008-12-17 17:58:28.0

Get Connected