|
|
|
|
Joined: 2/29/2012
Posts: 42
|
|
|
Get this error no matter what whether in test mode or live for Authorize.net payment gateway.
Error processing payment. Please try again. SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
Please advise.
Dustin
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Dustin,
Could you please provide what version of the Cart and DNN you are currently running? In addition, if you could please provide a screen shot of the error in your DNN event viewer it will help to further determine the cause of the issue.
Please let me know if you have anymore questions. Thank you!
|
|
|
|
| |
|
|
|
|
Joined: 2/29/2012
Posts: 42
|
|
|
Using lastest version of cart 5.64 and DNN 7.0.5
This is the error in the Event Viewer:
Cart Error: at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc, Boolean sync, TaskCompletionSource`1 completion, Int32 startRpc, Int32 startParam) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 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.AddCustomerAdmin(CustomerInfo info) at Smith.DNN.Modules.BuyNow.Confirm.a(PaymentStatus A_0, Boolean A_1) at Smith.DNN.Modules.BuyNow.Confirm.Submit() at Smith.DNN.Modules.BuyNow.Confirm.btnSubmit_Click(Object sender, EventArgs e)
Server Name: CT389
Screen shots of the cart error are attached.
|
|
| | Login to download attachment |
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Dustin,
I tested the issue and I was able to complete a one time transaction using Auth.net in the latest version of the cart. May I ask if you have any recurring billing settings configured? I believe the issue your experiencing exists in 5.64 and has since been resolved in 5.65. I recommend installing 5.65 and the issue should be resolved.
Please note: It is always highly recommend that you have a full backup stored before upgrading the cart
Please let me know if you have anymore questions. Thank you!
|
|
|
|
| |
|
|
|
|
Joined: 2/29/2012
Posts: 42
|
|
|
I just purchased the license this week off of the DNN store and the only version available for download is version 5.64. Please send me version 5.65 and license key if needed for that version.
dustin
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Dustin,
I have given you access to our downloads page at the link below. You will have access for three months which is the warranty included with your SmithCart purchase. We release new versions of the cart frequently with bug fixes, security patches and new features which provides a level of protection for your ecommerce site.
http://www.smith-consulting.com/Support/SmithCartDownloads.aspx
Please let me know if you have anymore questions. We appreciate your business very much. Thank you!
|
|
|
|
| |
|
|
|
Joined: 4/1/2013
Posts: 2
|
|
|
I have upgrade the cart and get the same exact error.
Dustin
|
|
|
|
| |
|
|
|
Joined: 4/1/2013
Posts: 2
|
|
|
I now believe my client has been giving me the wrong API Login and Transaction Key. Ill look into this further please don;t worry about exploring this issue further.
Dustin
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Thanks Dustin. Let us know if we can help with anything else.
|
|
|
|
| |
|
|
|
Joined: 10/18/2013
Posts: 51
|
|
|
I'm getting this same error. I'm on SC 5.64 and DNN 7.0.06.
I've gotten the API Login and Transaction Key straight from Auth.net so I'm pretty sure they are good.
I do not have recurring billing. Can you give me access to download the latest version to see if this fixes it?
Thanks,
Tom
|
|
| | Login to download attachment |
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Tom,
For access to v5.65 of the Cart you will need access to the SmithCart Downloads page. Please submit a ticket to our Licensing Dept at the following link and we will check on your upgrade eligibility - http://www.smith-consulting.com/Suppo...
Thanks!
|
|
|
|
| |
|
|
|
Joined: 10/18/2013
Posts: 51
|
|
|
Upgraded to 5.65. Still getting the same error.
What's next?
Tom
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Tom,
Are you using a live or test Auth.net account?
Is Auth.net virtaul terminal set to "Test Mode"?
Do you have "Test Mode" enabled or disabled in your Cart?
Are there any errors being logged to your DNN Event Viewer?
Thanks!
|
|
|
|
| |
|
|
|
Joined: 10/18/2013
Posts: 51
|
|
|
Kevin Carlson wrote:
Hi Tom,
Are you using a live or test Auth.net account?
Is Auth.net virtaul terminal set to "Test Mode"?
Do you have "Test Mode" enabled or disabled in your Cart?
Are there any errors being logged to your DNN Event Viewer?
Thanks!
I am using a Live account. Your question on whether Virtual Terminal is in Test Mode is somewhat confusing. Virtual Terminal seems to be a way to manually enter a CC transaction and doesn't have a Test Mode that I can see. The account itself is in Test Mode however so I assume that's what you mean.
The Cart is also in Test Mode. Should one of the two Test Modes be switched off?
Yes, I get the following in the Event log when this happens.
Cart Error: at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc, Boolean sync, TaskCompletionSource`1 completion, Int32 startRpc, Int32 startParam) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 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.AddCustomerAdmin(CustomerInfo info) at Smith.DNN.Modules.BuyNow.RegistrationController.AddCustomerAdmin(CustomerInfo info) at Smith.DNN.Modules.BuyNow.Confirm.ProcessStatus(PaymentStatus status, Boolean success) at Smith.DNN.Modules.BuyNow.Confirm.Submit() at Smith.DNN.Modules.BuyNow.Confirm.btnSubmit_Click(Object sender, EventArgs e)
Server Name: Generic171
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Tom,
Since real money gets moved when tesing with a live account, to test transactions you need to use a test account from authorize.net that you get here http://developer.authorize.net/testaccount/
Not your live account in test mode, there is a difference
The following forum post should also help: also http://www.smith-consulting.com/forums/forumid/1/postid/232/scope/posts.aspx#232
If your Auth.net live account is in "Test Mode", the Cart shoud NOT have "Test Mode" enabled.
Hope this helps!
|
|
|
|