|
|
|
Couch Potato
Group: Forum Members
Last Login: 2/27/2008 11:00:29 AM
Posts: 4,
Visits: 0
|
|
Okay, I am a person who is very serious about fitness and I have been keeping logs of everything I do. I stumbled upon this website today, which seems to be perfect for what I am into so I signed up. The first thing I did was try to enter in my nutrition, cardio, and strength training logs for days in the past and when switch days on the calendar I would frequently get the below error with a ridiculously long stack trace.
OS: Ubuntu 2.6.22-14
Browser: FF 2.0.0.12
Error:
Server Error in '/' Application.
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
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.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
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.
I would post the stack trace but its insanely long and it gives lots of fun information about your database and paths on the server, etc... I suggest you turn off stack traces to the user and debug these problems in a development environment ASAP!
|
|
|
|
|
Online Fitness Log Founder
Group: Administrators
Last Login: 4/26/2008 1:45:40 PM
Posts: 93,
Visits: 10
|
|
| Hi, Thanks for the info. I've been seeing this calendar issue for some time now, just haven't been able to reproduce myself. Seems that the most common way it happened was for the member to click on a date that was already selected, which the control handles as deselecting the date. Hence, no date is selected and an error is thrown. I've added some javascript to disallow deselecting the date so hopefully that will remedy the situation. Regarding the error messages, I've added a custom error page to hide the message from the user. Thanks,
Trevor Stith
Online Fitness Log
|
|
|
|
|
Couch Potato
Group: Forum Members
Last Login: 2/27/2008 11:00:29 AM
Posts: 4,
Visits: 0
|
|
| Thanks! I'll give it another shot and let you know what I find.
|
|
|
|
|
Couch Potato
Group: Forum Members
Last Login: 2/27/2008 11:00:29 AM
Posts: 4,
Visits: 0
|
|
Trevor,
Thanks for hiding the ugly errors from the user, but I can't make it through a single day of my log without hitting your error page multiple times. It happens most frequently when saving new nutrition entries. It looks like it saves the information and goes to the nutrition listing and the the loading gif comes up again and it takes me to the error page.
Thanks,
Pete
|
|
|
|
|
Online Fitness Log Founder
Group: Administrators
Last Login: 4/26/2008 1:45:40 PM
Posts: 93,
Visits: 10
|
|
I need to add exception reporting for server errors generated by AJAX postbacks. Then I'll look a little more carefully at these problems.
Trevor Stith
Online Fitness Log
|
|
|
|