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

    Developing Umbraco 7 packages

    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 10x 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
Please Sign in or register to post replies

Write your reply to:

Draft