HomeHome Product Discus... Product Discus...SmithCartSmithCartSqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
Previous
 
Next
New Post
9/12/2010 9:36 AM
 

I am using 2.97 and getting the following error when the order is submitted. What am I doing wrong?

AssemblyVersion: 5.5.0
PortalID: 11
PortalName: VBI Off-Campus
UserID: 291
UserName: test2
ActiveTabID: 688
ActiveTabName: DVD
RawURL: /Courses/DVD/tabid/688/ctl/Confirm/mid/1920/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: https://www.vbioc.com/Courses/DVD/tabid/688/ctl/Confirm/mid/1920/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US) AppleWebKit/534.3 (KHTML, like Gecko) Chrome/6.0.472.55 Safari/534.3
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 4fee3a5e-cea7-4de0-929a-9edb862f303a
InnerException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlTypes.SqlDateTime.FromTimeSpan
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: 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.SqlClient.MetaType.FromDateTime(DateTime dateTime, Byte cb) at System.Data.SqlClient.TdsParser.WriteValue(Object value, MetaType type, Byte scale, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc) 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 Smith.DNN.Modules.BuyNow.SqlDataProvider.AddCustomer(String firstName, String lastName, String address1, String address2, String city, String country, String state, String zip, String workPhone, String homePhone, String email, String login, Boolean contact, String ipAddress, String udf, String udtb1, String udtb2, String companyname, Int32 portalId, DateTime udDate) at Smith.DNN.Modules.BuyNow.RegistrationController.AddCustomer(String firstName, String lastName, String address1, String address2, String city, String country, String state, String zip, String workPhone, String homePhone, String email, String login, Boolean contact, String ipAddress, String udf, String udtb1, String udtb2, String companyname, Int32 portalId, DateTime udDate) at Smith.DNN.Modules.BuyNow.Confirm.ProcessStatus(PaymentStatusInfo status) at Smith.DNN.Modules.BuyNow.Confirm.Submit() at Smith.DNN.Modules.BuyNow.Confirm.btnSubmit_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) at System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

 
New Post
9/12/2010 9:43 AM
 

Can you upgrade to the latest version of the cart and test again.


At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
9/12/2010 9:48 AM
 

How much do I have to pay to upgrade to the latest version?

 
New Post
9/12/2010 9:59 AM
 

All software licenses include 90 days of free upgrades from date of purchase. After 90 days we offer a Maintenance Plan for $20/month to keep your software up to date.

https://www.smith-consulting.com/forums/licensingandupgrades.aspx


At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
9/12/2010 12:16 PM
 

That fixed the problem. Thanks!

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartSqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.