More in this section
Forums / Deployment / News Module - Errror adding news - data is null

News Module - Errror adding news - data is null

The forums are in read-only mode. In case that you want to directly contact the Progress Sitefinity team use the support center. In our Google Plus group you can find more than one thousand Sitefinity developers discussing different topics. For the Stack Overflow threads don’t forget to use the “Sitefinity” tag.
2 posts, 0 answered
  1. Jason Hedges
    Jason Hedges avatar
    22 posts
    16 Jul 2009
    23 Aug 2010
    Link to this post
    I'm getting the following error tying to add a news item in the News module. I've not modified or extended the News module so I don't understand where this error is coming from. Any help is appreciated. Here's the error I get when I click "Create this news item".

    Data is Null. This method or property cannot be called on Null values.

    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.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.

    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:

    [SqlNullValueException: Data is Null. This method or property cannot be called on Null values.]
       System.Data.SqlClient.SqlBuffer.get_String() +4841165
       System.Data.SqlClient.SqlDataReader.GetString(Int32 i) +96
       Nolics.ORMapper.DataProviders.SqlServer2005StmtBuilder.HasProcedure(ObjectName procName) +205
       Nolics.ORMapper.DataProviders.SQLBlockBuilder.DefineCommandProcedure(OdbClassInfo dbclassInfo, SQLCrudOperations operation) +559
       Nolics.ORMapper.DataProviders.SQLBlockBuilder.DefineClass(OdbClassInfo dbClassInfo, EmitPhases phase) +197
       Nolics.ORMapper.DataProviders.SQLDataProvider.GetSchemaChanges(Boolean fRename) +770
       Nolics.ORMapper.Base.OdbDataProvider.Upgrade() +59
       Telerik.Versioning.Data.DefaultProvider.Initialize(String name, NameValueCollection config) +397
       Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings, Type providerType) +673
       Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings) +91
       Telerik.ManagerBase`1.SetProvider(String providerName) +199
       Telerik.ManagerBase`1..ctor(String providerName) +89
       Telerik.Versioning.VersionManager..ctor(String providerName) +4
       Telerik.Cms.Engine.ContentProviderBase.get_Version() +47
       Telerik.Cms.Engine.ContentManager.CreateVersion(IContent cntItem, CultureInfo cult) +432
       Telerik.Cms.Engine.ContentManager.CreateContent(String mimeType, Guid id) +170
       Telerik.Cms.Engine.ContentManager.CreateContent(String mimeType) +26
       Telerik.Cms.Engine.WebControls.Admin.ContentItemEdit`1.SaveContent() +177
       Telerik.Cms.Engine.WebControls.Admin.ContentItemEdit`1.Button_Command(Object sender, CommandEventArgs e) +62
       System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +108
       System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +135
       System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
       System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
       System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

    Version Information: Microsoft .NET Framework Version:2.0.50727.4952; ASP.NET Version:2.0.50727.4927
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    12 Sep 2017
    23 Aug 2010
    Link to this post
    Hello Jason Hedges,

    It looks like you have two or more websites that have different versions connection to the same database or you have made some changes - upgrade or database modifications and the data provider is trying to update database schema version. As you can see OdbDataProvider.Upgrade() method is called.

    Please remove all different instances of Sitefinity connected to this database. Then request the project and check some of the version tables like sf_CmsVariables and its SchemaVersion value which should be the same as your project version

    Sincerely yours,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
2 posts, 0 answered