Login
Register
17-05-2008

Resources for the DotNetNuke Community
Join WebHost4Life.com
Support this site

  Support forums  

You need to be logged in in order to post to this forums.
SearchForum Home
  DotNetNuke Development  Templates  DotNetNuke deve...
 DotNetNuke development (Date Problem)
 
imgOfflinemjliscio
17 posts
Joined
10/1/2006

DotNetNuke development (Date Problem)
Posted: 24 Oct 06 8:14 AM

I am trying to develop a module for dnn 4.3.5

 

I am using the following tools

VS 2005

SQL Server 2003

 

I am getting the following error after i hooked it up to my stored procedures

 

DotNetNuke.Services.Exceptions.ModuleLoadException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. ---> System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value) at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime value) at System.Data.SqlTypes.SqlDateTime..ctor(DateTime value) at System.Data.SqlClient.MetaType.FromDateTime(DateTime dateTime, Byte cb) at System.Data.SqlClient.TdsParser.WriteValue(Object value, MetaType type, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj) 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 YourCompany.Modules.First.SqlDataProvider.AddFirst(Int32 portalID, Int32 moduleID, String title, String text, DateTime dateAdd, DateTime dateMod) in C:\DotNetNukeDevelop\App_Code\First\SqlDataProvider.vb:line 135 at YourCompany.Modules.First.FirstController.Add(FirstInfo objFirst) in C:\DotNetNukeDevelop\App_Code\First\FirstController.vb:line 28 at YourCompany.Modules.First.EditFirst.cmdUpdate_Click(Object sender, EventArgs e) in C:\DotNetNukeDevelop\DesktopModules\First\EditFirst.ascx.vb:line 150 --- End of inner exception stack trace ---

 

 

I know the problem is that for some odd reason it is not accepting any dates past 12/31/1999.  My question is WHY, and what can I do to fix this

imgOfflinednnjungle
141 posts
5th
Joined
3/13/2005

Re: DotNetNuke development (Date Problem)
Posted: 25 Oct 06 12:51 AM
The date limit is 12/31/9999  not the one you pointed. I think this should be related to some error on your side on how you manage this date field. Check also the null values.
Disgrafic.com
  DotNetNuke Development  Templates  DotNetNuke deve...
© Vicenç Masanas Terms Of Use Privacy Statement   
.