Old Forums
Search:
Portal Engine Questions on portal engine and web parts.
Version 6.x > Portal Engine > How to Fix SqlDateTime overflow View modes: 
User avatar
Member
Member
oohoangthienoo-gmail - 10/17/2012 10:39:39 PM
   
How to Fix SqlDateTime overflow
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.
User avatar
Kentico Customer Success
Kentico Customer Success
kentico_martind2 - 10/18/2012 1:24:37 AM
   
RE:How to Fix SqlDateTime overflow
Hi,

Could you please be more specific? When this error occurs? You are supposed to use only dates between the range of SQL DateTime format.

Best regards,
Martin Danko

User avatar
Member
Member
Dlglsh - 1/9/2013 10:24:40 AM
   
RE:How to Fix SqlDateTime overflow
Following on from the original poster's message, I am also receiving this error whether or not the user selects a Time zone, they are given the following error on screen:
"An error occurred when saving data: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM."

This is using the web part here: CMSWebParts\Membership\Profile\MyProfile.ascx

The code has not been changed from the original Kentico code.

Do you know what could be causing this issue?

Thanks,
Matt

User avatar
Kentico Customer Success
Kentico Customer Success
kentico_martind2 - 1/21/2013 9:53:57 AM
   
RE:How to Fix SqlDateTime overflow
Hi Matt,

Have you modified in any way CMS_User or CMS_UserSettings system tables?

I have one more question - is anything logged in Site Manager -> Administration -> Event log? If yes, could you please send me the full exception?

Best regards,
Martin Danko

Top