Portal Engine Questions on portal engine and web parts.
Version 5.x > Portal Engine > Server error with Search tutorial View modes: 
User avatar
Member
Member
efusien - 11/1/2010 10:32:13 AM
   
Server error with Search tutorial
Hello,

I follow the Kentico 5.x tutorial to install a search box on my website (http://www.kentico.com/docs/tutorial/search_page.htm).

Sometimes the search is correct : results appear on the result page and all links are OK.
But with some keywords (like "SharePoint") I have a server error page :

Server Error in '/' Application.
<target>.Category and <source>.Category have conflicting properties: DataType property mismatch.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.DataException: <target>.Category and <source>.Category have conflicting properties: DataType property mismatch.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[DataException: <target>.Category and <source>.Category have conflicting properties: DataType property mismatch.]
System.Data.Merger.MergeSchema(DataTable table) +1451827
System.Data.Merger.MergeTableData(DataTable src) +42
System.Data.Merger.MergeDataSet(DataSet source) +541
System.Data.DataSet.Merge(DataSet dataSet, Boolean preserveChanges, MissingSchemaAction missingSchemaAction) +148
System.Data.DataSet.Merge(DataSet dataSet) +83
CMS.SearchProviderSQL.SearchProvider.Search(String siteName, String searchNodePath, String cultureCode, String searchExpression, SearchModeEnum searchMode, Boolean searchChildNodes, String classNames, Boolean filterResultsByReadPermission, Boolean searchOnlyPublished, String whereCondition, String orderBy, Boolean combineWithDefaultCulture) +1696
CMS.TreeEngine.TreeProvider.Search(String siteName, String searchNodePath, String cultureCode, String searchExpression, SearchModeEnum searchMode, Boolean searchChildNodes, String classNames, Boolean filterResultsByReadPermission, Boolean searchOnlyPublished, String whereCondition, String orderBy, Boolean combineWithDefaultCulture) +336
CMS.Controls.CMSSearchResults.ReloadData(Boolean forceLoad) +1023
CMS.Controls.CMSSearchResults.OnLoad(EventArgs e) +35
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627


Version Information: Microsoft .NET Framework Version:2.0.50727.3607; ASP.NET Version:2.0.50727.3614



Any idea ?

User avatar
Member
Member
efusien - 11/1/2010 12:43:33 PM
   
RE:Server error with Search tutorial
Ok. "Tout est beau".

I found a workaround on this page :
http://devnet.kentico.com/Knowledge-Base/Content-Management/A-workaround-to-the--DataType-property-mismatch%E2%80%9D-e.aspx

In my solution I found 2 document types with the same field name. In my case : "Category".

So... be careful when create new document types : set different field names to avoid conflicts.