Developer forum

Forum » Development » Trying to delete a page results in

Trying to delete a page results in


Reply

I'm having some problems on a solution where when you try and delete a page, i the error:

 

Exception Details: System.Data.SqlClient.SqlException: String or binary data would be truncated.


The statement has been terminated.
 

 

I belive the error comes when you are trying to write to a column where you exceed the length of the column. But im not sure where i should make my fields longer in the database.

 

[SqlException (0x80131904): String or binary data would be truncated.
The statement has been terminated.]
   System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) +1455816
   System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) +41
   System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) +2037
   System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping) +40
   System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable) +183
   System.Data.Common.DbDataAdapter.Update(DataSet dataSet) +12
   Dynamicweb.Information.Logger.Log(Action Action, String EntityType, String Entity, String EntityID, String LocationType, String Location, String LocationID, String DestinationType, String Destination, String DestinationID) +405
   Dynamicweb.Information.Logger.Log(Action Action, EntityType EntityType, String Entity, String EntityID, EntityType LocationType, String Location, String LocationID, EntityType DestinationType, String Destination, String DestinationID) +313
   Dynamicweb.Information.Logger.ParagraphDeleted(String ParagraphName, Int32 ID, Int32 LocationID) +111
   Dynamicweb.TrashBin.MoveParagraphToTrashBin(Int32 intParagraphId, String strData, Int32 intUnitOfWork) +155
   Dynamicweb.TrashBin.MoveAllParagraphsToTrashBin(ArrayList alChilds, String strData, Int32 intUnitOfWork) +81
   Dynamicweb.TrashBin.MovePageToTrashBin(Int32 intPageId, String strData) +940
   Dynamicweb.TrashBin.MoveAllPagesToTrashBin(ArrayList alChilds, String strData) +77
   Dynamicweb.TrashBin.MoveToById(Int32 intID, String strDescription, String strData, Type typeEnum, Int32 PageID, Int32 MasterID) +143
   Dynamicweb.TrashBin.MoveToById(Int32 intID, String strDescription, String strData, Type typeEnum, Int32 MasterID) +25
   Dynamicweb.Admin.Page_Delete.Page_Load(Object sender, EventArgs e) +195
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

 


Replies

 
Reply

I've flushed the trashbin, i've given minimum of 250 chars in nvarchar fields in the trashbin and actionlog

 

edit:

nvm after changing the actionlog fields to nvarchar(max) everything works :)

 
Reply

Thanks for your fast reply;)

 

You must be logged in to post in the forum