+Sinbad7Seas Posted February 17, 2006 Share Posted February 17, 2006 Why is the site often inaccessible lately due to an error on the site as follows: Server Error in '/' Application. -------------------------------------------------------------------------------- Cannot create a row of size 8061 which is greater than the allowable maximum of 8060. 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: Cannot create a row of size 8061 which is greater than the allowable maximum of 8060. 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: Cannot create a row of size 8061 which is greater than the allowable maximum of 8060. The statement has been terminated.] System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +180 Groundspeak.Web.SqlData.SqlConnectionManager.ExecuteNonQuery(String sql, Database database) +148 Groundspeak.Web.SqlData.SqlUserController.UpdateIPAddress(Int64 UserID, String IPAddress) +68 Groundspeak.Web.User.UpdateIPAddress(String IPAddress) +33 Geocaching.UI.WebformBase.LoginUser(User user, Boolean saveToken) +545 Geocaching.UI.WebformBase.IsLoggedIn() +865 Geocaching.UI._default.Page_Load(Object sender, EventArgs e) +122 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +772 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032 very frustrating Link to comment
+Shifty Posted February 17, 2006 Share Posted February 17, 2006 I normally get that error if the website is really busy at the time I am trying to load it. That's what I thought it was anyway. S Link to comment
Jeremy Posted February 17, 2006 Share Posted February 17, 2006 The database is choking because your profile information is so large that it can't save all that data in the database. If you reduce your profile information slightly you won't have this issue. We need to move that extra text out of the account system and into its own table which will resolve the problem. Unfortunately it is a pretty invasive procedure. So this would be a quick fix for you. It doesn't have anything to do with server load. It has to do with how much information the system is trying to send to the database at one time. Link to comment
+Sinbad7Seas Posted February 17, 2006 Author Share Posted February 17, 2006 (edited) Wait, how do I modify my profile if I can't get to the page to modify it. Please help or maybe you could just get rid of one character. Thanks. Edited February 17, 2006 by Sinbad7Seas Link to comment
+The Leprechauns Posted February 17, 2006 Share Posted February 17, 2006 I had no problem peeking at it just now, so keep trying. Or, follow the link directly to the edit page: http://www.geocaching.com/my/details.aspx And consider linking to a blog or a personal webpage or a bookmark list, to move some of the content off your profile. Putting my favorite caches onto a bookmark list is what solved the same problem for me awhile back. Link to comment
Jeremy Posted February 17, 2006 Share Posted February 17, 2006 Sure. I just removed some spaces in your profile. You can log in now. Link to comment
+Sinbad7Seas Posted February 17, 2006 Author Share Posted February 17, 2006 Sure. I just removed some spaces in your profile. You can log in now. thanks!!! Link to comment
Jeremy Posted February 17, 2006 Share Posted February 17, 2006 No problem. I thought you had an infrequent problem, not that you couldn't get into the site at all. Sorry about the confusion. Link to comment
Recommended Posts