Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Anders Schmidt 76 posts 207 karma points
    Jun 07, 2014 @ 16:43
    Anders Schmidt
    0

    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...

    Copy Link
  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Jun 07, 2014 @ 19:31
    Jan Skovgaard
    0

    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

    Copy Link
  • Anders Schmidt 76 posts 207 karma points
    Jun 07, 2014 @ 21:59
    Anders Schmidt
    0

    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)

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies