|
|
 |
Joined: 1/24/2014
Posts: 12
|
|
|
I'm getting this error on checkout:
Error processing payment. Please try again. Conversion overflows.
I have Bill Me Later and a Credit Card processor set up. I'm using Bill Me Later.
Thanks,
Chris
|
|
|
|
 | |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Chris,
Which version of the Cart and DNN are you using?
Which Payment Gateway do you have configured?
|
|
|
|
| |
|
|
|
Joined: 1/24/2014
Posts: 12
|
|
|
DNN: 8.x
SmithCart: 7.22
I don't think it's the payment gateway. I've tested on Paypal, BillMeLater and PayTrace. The payment actually goes through, much to my chagrin. I have 5 charges on my cc now :)
|
|
|
|
| |
|
|
|
Joined: 1/24/2014
Posts: 12
|
|
|
More info:
The order is being created in Smith_StoreOrders but nothing is appearing in Smith_StoreOrderDetails.
|
|
|
|
| |
|
|
|
Joined: 1/24/2014
Posts: 12
|
|
|
More info again:
Smith_StoreOrders.PayHistID is not being populated. It's the only field in the table that is different than the previous orders. Smith_PayHist is also not being populated for these transactions.
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Chris,
What is the full error being logged to your DNN -> Event Viewer?
Do you have any Languages enabled on your portal?
Is this a fresh install of the Cart and DNN or have you upgraded from a previous version?
Thanks!
|
|
|
|
| |
|
|
|
Joined: 1/24/2014
Posts: 12
|
|
|
No languages.
Not a fresh install. DNN upgrade to 8 from 7, SmithCart Update from 7.0x to current.
Here is the error:
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, SqlDataReader ds) 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(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.AddStoreOrderDetails(StoreOrderDetailsInfo objStoreOrderDetails) at Smith.DNN.Modules.BuyNow.ProductsController.AddStoreOrderDetails(StoreOrderDetailsInfo objStoreOrderDetails) at Smith.DNN.Modules.BuyNow.Confirm.AddOrderDetails(StoreOrdersInfo objOrder, String giftCardType, IPayment status) at Smith.DNN.Modules.BuyNow.Confirm.AddStoreOrder(Int32 PayHistID, String orderStatus, IPayment status) at Smith.DNN.Modules.BuyNow.Confirm.ProcessStatus(IPayment status, Boolean success) at Smith.DNN.Modules.BuyNow.Confirm.Submit() at Smith.DNN.Modules.BuyNow.Confirm.btnSubmit_Click(Object sender, EventArgs e)
Thanks,
Chris
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Chris,
Did the checkout work prior to upgrading?
Please confirm that you have the following 2 sql connection strings in your web config:
<|connectionStrings|>
<|add name="SiteSqlServer" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=dnn551cart;User ID=sa;Password=xxxx"/|>
<|/connectionStrings|>
<|appSettings|>
<|add key="SiteSqlServer" value="Data Source=.\SQLEXPRESS;Initial Catalog=dnn551cart;User ID=sa;Password=xxxxxxxxx"/|>
<|/appSettings|>
|
|
|
|
| |
|
|
|
Joined: 1/24/2014
Posts: 12
|
|
|
Yes, the checkout worked fine before the upgrade.
The connection strings are fine. The site wouldn't work otherwise.
Thanks,
Chris
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Chris,
Are you using the Cart's built in Add To Cart and Checkout screens or are you using the Cart SDK to add the Products to checkout?
|
|
|
|
| |
|
|
|
Joined: 1/24/2014
Posts: 12
|
|
|
I'm using the SDK -- .AddToShoppingCart.
All the products I add are displaying correctly on checkout. The only issue I'm having there is changing the quantity. The quantity displays properly but when I refresh using the Update Quantity button, the quantity reverts.
As I stated, before upgrading, all this worked fine.
Thanks!
Chris
|
|
|
|
| |
|
|
|
Joined: 1/24/2014
Posts: 12
|
|
|
OK. I've figured some stuff out here.
As I stated before, everything was working fine until SmithCart 7.22. We were using an early version of 7 the last time things worked properly.
Some of the products in the store have been in there for a couple of years. When they were entered, the following fields were skipped on entry and set to null:
quantityonhand=-1
Weight=0
ExcludeCoupon=0
items=1
share=0
recurring=0
subscriptioninterval=0
requirelogin=0
UsePriPriceWght=0
MasterBundleID=0
BundleID=0
PriceClass=0
I set them to the values above and things started working. Obviously, one or more of those fields is now required and I don't have time to test out which one.
I don't know if I'm out of the woods yet and I would like to know which one was causing the issue.
Thanks,
Chris
|
|
|
|
| |
|
|
 |
Joined: 7/28/2009
Posts: 1452
|
|
|
Its hard to tell exactly without a line number for the error but my educated guess would be quantityonhand and Weight. Make sure that quantityonhand is > 0. If you are not managing inventory on your store then just set quantity on hand to 1000
At your service,
Dave Smith
|
|
|
|