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

Forums / Developing with Sitefinity / CMS Page Deletion error...

CMS Page Deletion error...

5 posts, 1 answered
  1. Gaurav Mehta
    Gaurav Mehta avatar
    43 posts
    Registered:
    09 Dec 2009
    17 Sep 2010
    Link to this post
    Hi,

    We are using Sitefinity 3.6 SP1
    We  try clean up test pages from CMS so we started to delete them.
    After deleting some pages when we try to delete a page we got following error

    Non-negative number required.
    Parameter name: count

    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.ArgumentOutOfRangeException: Non-negative number required.
    Parameter name: count

    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:

    [ArgumentOutOfRangeException: Non-negative number required.
    Parameter name: count]
       System.IO.MemoryStream.Read(Byte[] buffer, Int32 offset, Int32 count) +7681906
       MySql.Data.MySqlClient.MySqlPacket.ReadString(Int64 length) +106
       MySql.Data.Types.MySqlString.MySql.Data.Types.IMySqlValue.ReadValue(MySqlPacket packet, Int64 length, Boolean nullVal) +155
       MySql.Data.MySqlClient.NativeDriver.ReadColumnValue(Int32 index, MySqlField field, IMySqlValue valObject) +176
       MySql.Data.MySqlClient.ResultSet.ReadColumnData(Boolean outputParms) +78
       MySql.Data.MySqlClient.ResultSet.NextRow(CommandBehavior behavior) +194
       MySql.Data.MySqlClient.MySqlDataReader.Read() +79
       Nolics.ORMapper.DataProviders.SQLDataProvider.ParseResult(Int32 fromRow, Int32 maxRows, DataSet dsResult, IDataReader rd) +33
       Nolics.ORMapper.DataProviders.SQLDataProvider.ExecuteKeyQuery(DataSet queries, Boolean fPrimaryKey) +295
       Nolics.ORMapper.DataProviders.SQLDataProvider.QueryByForeignKey(DataSet keys) +6
       Nolics.ORMapper.Base.ForeignKeyQuery.LoadFKQuery() +46
       Nolics.ORMapper.Base.Relation`1.Load() +216
       Nolics.ORMapper.Base.Relation`1.Refresh() +89
       Nolics.ORMapper.Base.Relation`1.DoAutoRefresh(ObKey foreignKey) +26
       Telerik.Cms.Data.WebControlBase.get_Properties() +93
       Telerik.Cms.Data.WebControlBase.nn_DeleteObject() +26
       Telerik.Cms.Data.CmsWebControl.nn_DeleteObject() +15
       Telerik.Cms.Data.WebControlBase.Delete() +15
       Telerik.Cms.Data.StagedPage.DeleteObject() +243
       Nolics.ORMapper.Base.OdbClassHelper.DeleteClass(IOdbClass cl, OdbObjectStates& state) +80
       Telerik.Cms.Data.StagedPage.Delete() +27
       Telerik.Cms.Data.PageContentBase.DeleteObject() +520
       Nolics.ORMapper.Base.OdbClassHelper.DeleteClass(IOdbClass cl, OdbObjectStates& state) +80
       Telerik.Cms.Data.PageContentBase.Delete() +27
       Telerik.Cms.Data.PageBase.DeleteObject() +385
       Telerik.Cms.Data.CmsPage.DeleteObject() +41
       Nolics.ORMapper.Base.OdbClassHelper.DeleteClass(IOdbClass cl, OdbObjectStates& state) +80
       Telerik.Cms.Data.PageBase.Delete() +28
       Telerik.Cms.Data.DefaultProvider.DeletePage(IPage page) +302
       Telerik.Cms.Web.UI.SiteMapPanel.button_Command(Object sender, CommandEventArgs e) +2170
       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


    Can you check and let us know  how to fix it ?
    Or is there any other way to delete these pages (e.g from database directly using query) ?

    Regards,
    Gaurav
  2. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    17 Sep 2010
    Link to this post
    Hi Gaurav Mehta,

    Thank you for using our services.

    Could you please let us know how you performed the deleting of the pages? Are you deleting them through the User Interface or you are trying to delete them through code?

    Sincerely yours,
    Radoslav Georgiev
    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
  3. Gaurav Mehta
    Gaurav Mehta avatar
    43 posts
    Registered:
    09 Dec 2009
    18 Sep 2010
    Link to this post
    Hi Radoslav Georgiev ,

    Yes we are deleting it from within Sitefinity Admin area (E.g User Interface):
    Select page and than "Delete"

    No we are not deleting the page through code.

    Regards,
    Gaurav
  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    19 Sep 2010
    Link to this post
    Hello Gaurav Mehta,

    This looks like as an issue with MySQL or you have made some changes to the database. We have no encountered this issue before and no one has reported it.

    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
    Answered
  5. Gaurav Mehta
    Gaurav Mehta avatar
    43 posts
    Registered:
    09 Dec 2009
    20 Sep 2010
    Link to this post
    Hi Ivan Dimitrov,

    Thanks for your reply.

    Yes you are right. It was Mysql connector problem.
    We have some custom functionality in our site  that  uses MySql connector 6.3.0.0 and we found that Sitefinity 3.6  SP1 uses 5.0.0.7 version  so we add binding redirect to 6.3.0.0  in web.config
    Once I changed it back to 5.0.0.7 version to test this , pages were deleted successfully.

    Regards,
    Gaurav
Register for webinar
5 posts, 1 answered