+travelfreak Posted August 29, 2003 Share Posted August 29, 2003 Please help: I cannot report a cache at the page: http://www.geocaching.com/hide/report.aspx . The browsers Javascript is activ. If I hit the button 'Report New Listing' I get the following server error messages: Server Error in '/' Application. -------------------------------------------------------------------------------- String or binary data would be truncated. The statement has been terminated. 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.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated. 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: [sqlException: String or binary data would be truncated. The statement has been terminated.] System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +180 Groundspeak.Web.SqlData.SqlConnectionManager.ExecuteNonQuery(String sql) +127 Groundspeak.Web.SqlData.SqlGeocacheController.Create(Guid CacheGUID, String Nickname, Int64 OwnerID, String OwnerEmail, Double LatDegrees, Double LatMinSec, Double LonDegrees, Double LonMinSec, String ContactName, DateTime DatePlaced, Uri URL, Double TerrainLevel, Double DifficultyLevel, Int64 CountryID, Int64 StateID, Boolean IsHtml, Int64 SiteTypeID, String ShortDescription, String LongDescription, String EncodedHints, Int64 ContainerID, Boolean IsSubscriberOnly, Boolean IsAvailable) +1264 Groundspeak.Web.CustomWpt.Geocache.CreateCache(Guid CacheGUID, String Nickname, User Owner, Double Latitude, Double Longitude, String ContactName, DateTime DatePlaced, Uri URL, Double TerrainLevel, Double DifficultyLevel, Int32 CountryID, Int32 StateID, Boolean IsHtml, Int32 SiteTypeID, String ShortDescription, String LongDescription, String EncodedHints, Int32 ContainerID, Boolean IsSubscriberOnly, Boolean IsAvailable) +308 Geocaching.UI.hide_report.btnSubmit_Click(Object sender, EventArgs e) +1162 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBa ckEvent(String eventArgument) +58 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1266 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573 So what is wrong... ? Link to comment
+travelfreak Posted August 30, 2003 Author Share Posted August 30, 2003 After many tries I finally found out that the system did not like more than 500 characters in the 'short description' - the server didn't tell me its problem at the beginning - it just always ended up in the above server errors. Only if the cache already was saved to the system and you changed back to more than 500 characters in the short description on the new page 'report/edit a cache' it told you the following: There are errors on this page. Scroll down to see the errors. Error Occured Your cache has been edited. view listing The short description can only be 500 characters. ---------------- So may be it is a little bug... Link to comment
Recommended Posts