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

Forums / Bugs & Issues / Error when posting blogs

Error when posting blogs

4 posts, 1 answered
  1. MNP
    MNP avatar
    79 posts
    Registered:
    23 Apr 2008
    25 Sep 2009
    Link to this post

    Procedure or function 'sf_VrsTxtData_ins' expects parameter '@P_HasDynamicLinks', which was not supplied


    Every once in a while I get the message above when I create a blog post. The last time it happen it seemed to disappear after a while

    [SqlException (0x80131904): Procedure or function 'sf_VrsTxtData_ins' expects parameter '@P_HasDynamicLinks', which was not supplied.] 
       Nolics.ORMapper.DataProviders.SQLBlockBuilder.EndStatement(SQLCommandEventArgs args, DataRow row) +503 
       Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecCommandProcedure(StmtContext context, DataRow data) +712 
       Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecuteCommand(StmtContext context, DataRow data) +76 
       Nolics.ORMapper.DataProviders.SQLDataProvider.Update(DataSet updateData) +466 
       Nolics.ORMapper.Base.Transaction.Commit(Boolean fCleanIfSuccess) +909 
       Nolics.ORMapper.Base.Transaction.Commit() +10 
       Telerik.Versioning.Data.DefaultProvider.CreateItem(Guid id, CultureInfo culture, IVersionData[] data, Boolean save) +264 
       Telerik.Versioning.VersionManager.CreateItem(Guid id, CultureInfo culture, IVersionData[] data, Boolean save) +47 
       Telerik.Cms.Engine.ContentManager.CreateVersion(IContent cntItem, CultureInfo cult) +490 
       Telerik.Cms.Engine.ContentManager.CreateContent(String mimeType, Guid id) +206 
       Telerik.Cms.Engine.ContentManager.CreateContent(String mimeType) +38 
       Telerik.Cms.Engine.WebControls.Admin.ContentItemEdit`1.SaveContent() +214 
       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 
     
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    26 Sep 2009
    Link to this post
    Hi Matt,

    It seems that you have changed something in the database manually. @P_HasDynamicLinks is a parameter of sf_VrsTxtData_ins store procedure. Also sf_VersTxtData is table that stores information about the content item versions. HasDynamicLinks is a column there which accepts - true or false (1 and 0). If there is a dinamic link in the content of a post the value is set to 1.
    The error could be result of attaching another project with different version to the same database.

    Greetings,
    Ivan Dimitrov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
    Answered
  3. MNP
    MNP avatar
    79 posts
    Registered:
    23 Apr 2008
    28 Sep 2009
    Link to this post
    The error could be result of attaching another project with different version to the same database.

    This is what the problem was. I accidentally while testing with my dev version, set the connection string to the live database. Hopefully a restore from before I changed it will fix it.

    -Matt
  4. Georgi
    Georgi avatar
    3583 posts
    Registered:
    28 Oct 2016
    28 Sep 2009
    Link to this post
    Hello Matt,

    Yes, this could happen.  This will not be the case if the two projects are built with the same version of the CMS though. Perhaps this will be helpful in future :).

    Best wishes,
    Georgi
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Register for webinar
4 posts, 1 answered