String or Binary Data Would Be Truncated
Last Post 03-26-2007 09:53 AM by Shane Powser. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Shane PowserUser is Offline
new to the springs
new to the springs
Posts:2
Avatar

--
03-23-2007 01:41 PM

    Hello,

     

    Getting the following error when I try to edit the contents.  It seems to only happen when I try to edit certain parts of the content.  The error is shown below.

     

     

     

     

    AssemblyVersion: 04.04.01
    PortalID: 0
    PortalName: Front Porch, Inc.
    UserID: 1
    UserName: host
    ActiveTabID: 36
    ActiveTabName: Home
    RawURL: /fpnuke/Home/tabid/36/ctl/Add/mid/405/Default.aspx
    AbsoluteURL: /FPNuke/Default.aspx
    AbsoluteURLReferrer: http://outstandingisp.com/fpnuke/Ho...fault.aspx
    UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)
    DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
    ExceptionGUID: 25b6f138-90bf-461f-91ce-8a0951fa3139
    InnerException: String or binary data would be truncated. The statement has been terminated.
    FileName:
    FileLineNumber: 0
    FileColumnNumber: 0
    Method: System.Data.SqlClient.SqlConnection.OnError
    StackTrace:
    Message: DotNetNuke.Services.Exceptions.PageLoadException: String or binary data would be truncated. The statement has been terminated. ---> System.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DataSprings.Modules.NewsTicker.SqlDataProvider.UpdateNewsItem(Guid NewsItemID, Int32 ModuleID, String NewsItem, String NewsItemText, DateTime ExpireDate, Int32 SortOrder, Int32 Inactive) at DataSprings.Modules.NewsTicker.NewsTickerController.UpdateNewsItem(NewstickerInfo NewsInfo) at DataSprings.Modules.NewsTicker.AddNewsTicker.btnUpdate_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
    Source:

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    03-26-2007 09:50 AM
    HI. This can happen if you are posting an item within the news ticker that is larger then the field is setup within the database to handle. I just checked and the maximum field size is currently set to nvarchar 2000 which should be enough but not sure what you are trying to insert as a ticker item? Also, the title of the news item is only set to 255 so if you have a larger title than that you would get an error.

    Shane PowserUser is Offline
    new to the springs
    new to the springs
    Posts:2
    Avatar

    --
    03-26-2007 09:53 AM

    Chad,

     

    It is a table with 2 columns, 5 rows.  Each cell has a city name.  All entries are centered as well as the table.

     

    Shane



    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi