1-888-365-2779
+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / Please help, our sitefinity built website is completely down!!

Please help, our sitefinity built website is completely down!!

3 posts, 0 answered
  1. Eric
    Eric avatar
    7 posts
    Registered:
    23 Mar 2012
    16 Jun 2012
    Link to this post
    I added a custom field for images called Order as a number which created SQLType
    decimal(20,0).

    I recently went into documents and added a custom field called Order but this time I wanted it to be SQLType nvarchar(255).

    I now get the following error in Sitefinity when I try to edit Content > Images, Videos or Documents.

    The column 'Order' is mapped to two (or more) different properties and has conflicting changes to the 'SqlType' property.

    I did not know that images, documents and videos are all stored in the same table.  I understand why it happened but how do I fix it?

    Our website will now not load because the Images that load fail with the above issue.

    I went into the Sitefinity SQL Database for our site but I am not sure where to edit or what to do to fix the issue.

    Please help....
    here is entire error:

    Server Error in '/' Application.

    The column 'Order' is mapped to two (or more) different properties and has conflicting changes to the 'SqlType' property.

    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.InvalidOperationException: The column 'Order' is mapped to two (or more) different properties and has conflicting changes to the 'SqlType' property.

    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:

    [InvalidOperationException: The column 'Order' is mapped to two (or more) different properties and has conflicting changes to the 'SqlType' property.]
       DynamicModule.ns.Wrapped_OpenAccessLibrariesProvider_bacfd98f3522425bbbaec441120c53a0.Initialize(String providerName, NameValueCollection config, Type managerType) +405
       Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager) +1972
       Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, ExceptionPolicyName policy, ManagerBase`1 manager) +74
       Telerik.Sitefinity.Data.ManagerBase`1.SetProvider(String providerName, String transactionName) +526
       BuildUp_Telerik.Sitefinity.Modules.Libraries.LibrariesManager(IBuilderContext ) +306
       Telerik.Microsoft.Practices.ObjectBuilder2.BuildPlanStrategy.PreBuildUp(IBuilderContext context) +304
       Telerik.Microsoft.Practices.ObjectBuilder2.StrategyChain.ExecuteBuildUp(IBuilderContext context) +434
       Telerik.Microsoft.Practices.Unity.UnityContainer.DoBuildUp(Type t, Object existing, String name, IEnumerable`1 resolverOverrides) +440
    
    [ResolutionFailedException: Resolution of the dependency failed, type = "Telerik.Sitefinity.Modules.Libraries.LibrariesManager", name = "OPENACCESSDATAPROVIDER".
    Exception occurred while: Calling constructor Telerik.Sitefinity.Modules.Libraries.LibrariesManager(System.String providerName).
    Exception is: InvalidOperationException - The column 'Order' is mapped to two (or more) different properties and has conflicting changes to the 'SqlType' property.
    -----------------------------------------------
    At the time of the exception, the container was:
    
      Resolving Telerik.Sitefinity.Modules.Libraries.LibrariesManager,OPENACCESSDATAPROVIDER
      Calling constructor Telerik.Sitefinity.Modules.Libraries.LibrariesManager(System.String providerName)
    ]
       Telerik.Sitefinity.Data.ManagerBase.GetManager(Type managerType, String providerName) +276
       Telerik.Sitefinity.Modules.Libraries.LibrariesNodeFilter.IsNodeAccessPrevented(PageSiteNode pageNode) +363
       Telerik.Sitefinity.Web.SiteMapBase.IsAccessibleToUserInternal(SiteMapNode node, ClaimsIdentityProxy user) +543
       Telerik.Sitefinity.Web.NodeFiltersCache.IsAccessible(SiteMapBase sitemap, SiteMapNode node, ClaimsIdentityProxy user) +409
       Telerik.Sitefinity.Web.SiteMapBase.IsAccessibleToUser(HttpContext context, SiteMapNode node) +200
       Telerik.Sitefinity.Web.SitefinitySiteMap.IsAccessibleToUser(HttpContext context, SiteMapNode node) +24
       Telerik.Sitefinity.Web.SitefinityRoute.CheckSecurity(HttpContextBase httpContext, PageSiteNode node) +50
       Telerik.Sitefinity.Web.SitefinityRoute.GetRouteData(HttpContextBase httpContext) +567
       System.Web.Routing.RouteCollection.GetRouteData(HttpContextBase httpContext) +355
       System.Web.Routing.UrlRoutingModule.PostResolveRequestCache(HttpContextBase context) +75
       System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80
       System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270
    

  2. Eric
    Eric avatar
    7 posts
    Registered:
    23 Mar 2012
    16 Jun 2012
    Link to this post
    I figured this out...

    Not sure if this is a bug in sitefinity or what but I went into the back end sql into the sf_mt_fields_sf_meta_attribute table and noticed two entries for the same field with different sqltypes etc....
    I delete the one that caused the issue and it is back to normal.

    There should be some sort of explanation that you cannot have the same custom field name with different data types for images, documents and videos as they all share the same table 
  3. Steve
    Steve avatar
    3037 posts
    Registered:
    03 Dec 2008
    18 Jun 2012
    Link to this post
    Since there's no response from the big T, you should submit this as a bug ticket so it can be logged and fixed...I'd say anything you can do in the backend UI that causes a YSOD...is a bug :)
3 posts, 0 answered