I am working on a property editor wher I am storring a long html string. To be able on saving long string i changed cmsPropertyData > dataNvarchar to ntext. After I have done that it my media liabry is not working!!
When opening medialibary I get error:
GROUP BY cannot be used with ntext and image data.
As a extra comment I am not able in changing dataNvarchar back to nVarchar...
Can anyone explain me a workaround or help me understand database structure.
Would it be okay if I I change dataNvarchar to nText?
From log:
2014-06-06 23:21:10,785 [5] INFO Umbraco.Core.PluginManager - [Thread 23] Starting resolution types of Umbraco.Web.Trees.TreeController
2014-06-06 23:21:10,785 [5] INFO Umbraco.Core.PluginManager - [Thread 23] Completed resolution of types of Umbraco.Web.Trees.TreeController, found 4 (took 0ms)
Setting datatype for my own property editor
I am working on a property editor wher I am storring a long html string. To be able on saving long string i changed cmsPropertyData > dataNvarchar to ntext. After I have done that it my media liabry is not working!!
When opening medialibary I get error:
GROUP BY cannot be used with ntext and image data.
As a extra comment I am not able in changing dataNvarchar back to nVarchar...
Can anyone explain me a workaround or help me understand database structure.
Thanks...
Hi Anders
Not sure what is going on but what exact version of Umbraco are you using?
Have you tried checking the /app_data/logs file to see if it reveals anything useful?
/Jan
Hi Jan
I am using V. 7.1.1
Would it be okay if I I change dataNvarchar to nText?
From log:
2014-06-06 23:21:10,785 [5] INFO Umbraco.Core.PluginManager - [Thread 23] Starting resolution types of Umbraco.Web.Trees.TreeController
2014-06-06 23:21:10,785 [5] INFO Umbraco.Core.PluginManager - [Thread 23] Completed resolution of types of Umbraco.Web.Trees.TreeController, found 4 (took 0ms)
2014-06-06 23:21:11,548 [5] ERROR Umbraco.Core.UmbracoApplicationBase - [Thread 23] An unhandled exception occurred
System.FormatException: Input string was not in a correct format.
at System.Text.StringBuilder.AppendFormat(IFormatProvider provider, String format, Object[] args)
at System.String.Format(IFormatProvider provider, String format, Object[] args)
at System.String.Format(String format, Object arg0)
at Microsoft.VisualStudio.Web.PageInspector.Runtime.MappingData.MappingDataUtilities.GenerateSelectorsForElementsWithTagName(List`1 elements, String selectorFormatString, SelectorGroupFunction[] groupMethods, Int32 startIndex)
at Microsoft.VisualStudio.Web.PageInspector.Runtime.MappingData.MappingDataUtilities.GenerateSelectorsForElementsWithTagName(List`1 elements, String selectorFormatString, SelectorGroupFunction[] groupMethods, Int32 startIndex)
at Microsoft.VisualStudio.Web.PageInspector.Runtime.MappingData.MappingDataUtilities.GenerateSelectorsForElementsWithTagName(List`1 elements, String selectorFormatString, SelectorGroupFunction[] groupMethods, Int32 startIndex)
at Microsoft.VisualStudio.Web.PageInspector.Runtime.MappingData.MappingDataUtilities.GenerateSelectorsForElementsWithTagName(List`1 elements, String selectorFormatString, SelectorGroupFunction[] groupMethods, Int32 startIndex)
at Microsoft.VisualStudio.Web.PageInspector.Runtime.MappingData.MappingDataUtilities.GenerateSelectorsWorker(IEnumerable`1 elements, String selectorFormatString, SelectorGroupFunction[] groupMethods)
at Microsoft.VisualStudio.Web.PageInspector.Runtime.MappingData.MappingDataUtilities.GenerateGlobalScopeSelectors(IEnumerable`1 elements)
at Microsoft.VisualStudio.Web.PageInspector.Runtime.MappingData.MappingDataUtilities.GenerateSelectors(IEnumerable`1 elements)
at Microsoft.VisualStudio.Web.PageInspector.Runtime.MappingData.MappingDataUtilities.ProcessDataIntoJsonObjects(IEnumerable`1 renderedOutputList)
at Microsoft.VisualStudio.Web.PageInspector.Runtime.Tracing.RequestDataHttpHandler.System.Web.IHttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
is working on a reply...