Hi,

Can some one help me this is a serious issue.

I'm using smith cart 5.0 and DNN 6.0. My site is a live site recently released and it worked fine. But today we got a new issue i.e., when the user(guest checkout) clicks "submit order (final order page), it is not navigating to custom payment gateway. When the registered users clicks submit order, it is navigating to payment gateway. We are using custom payment gateway (PayU). Previously guest checkout worked fine but today check guest cannot navigate to payment gateway.

I'm using "Show Sign In" page settings in smith cart settings page.

Thanks,
Swetha.

If this was once working and then it suddenly stopped working, can you provide more info about what changed in your environment that caused it to stop working.

thanks,

---

Scott Kelly
Project Manager

Hi,

We have gone live with site long back and currently we are in maintenance phase so we didn't do any development to our site. All we did was added new products in the site as per requiremnts. Please note NO OTHER changes made to the site.

Here is more info....

1) In Cart setting, Sign In/Registration Page Setup --> We have checked "Show Sign In page".
2) So while checking out a product once I select the product and click on "Proceed to check out" button
3) Navigated to Sign Page where user can go to guest login
4) Once I select continue button navigated to Sign Page (Step 1 Page) entered all the fields like first name last name etc... and click on "Next" button
5) Now I am navigated to Confirm page.
This page has the billing information and product details two buttons (Back & Submit Order" buttons). All the details are displayed correctly..

In order to proceed I clicked on "Submit Order" button. Here the ISSUE is page just gets refreshed or reloaded and does NOTHING. It is not redirected to my custom payment page. Please suggest. We are receiving lot of complaints from our customers. Please help us.

OR

Can we a create a new button in Confirm.ascx and redirect to "my custom payment page" but how about posting the parameters to my page? I want to have same functionality since "Submit Order button is not functional correctly. i.e Just like if page allows me to click on "Submit Order" button and navigating the user to custom payment page url with all necessary parameters posted to custom payment gateway page. Please suggest me..

Please take a look at our site for more details. you can reproduce the above mentioned issue in the below link: Please select any product and add it to bag and try to check out.

http://aaliyawoman.com/Shop.aspx


Ton of Thanks in Advance!

Swetha.

We too are recently facing difficulties with the checkout procedure.

The submit button doesn't seem to work anymore on the confirm.ascx page. We have a live running webshop which used to work fine until we received complaints about the unfinishing checkout.

We are using version 5.0.0 with DNN 6.2.1
The permissions have been checked and haven't changed.

Is there a hotfix available?

Martin.

Hello Kevin,

We are still looking at logs and other possible interruptions at the moment that perhaps can be pointed as the cause of the troubles.

To answer your questions:
the DNN was a clean installation and set up a couple of months ago for the new webshop. The SmithCart is also a clean installation. So, no upgrades troubles for both software.

Payment Gateway: manual
Payment Type: tried two types, "check" and "cod", but both types give the same checkout problem.

Since the release of the webshop, people has only been editing existing products and inserting new products
Will look further into all kind of logs today...

Martin.

Hello Kevin,

Looking at the log, I was able to fetch two log-entries:

Latest log-entry:
----------------------
Stacktrace: : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) 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)


First log-entry:
-------------------
Error: : Cannot insert the value NULL into column 'CustomerID', table 'db_kussenboetiek.dbo.dnn_Smith_Customer'; column does not allow nulls. INSERT fails.The statement has been terminated.


Additional explanation: we are making use of an anonymous check-out procedure.

Thanks,
Martin.

Hi Kevin,

The error is mentioning about not able to insert value NULL into field "CustomerID" of table "dnn_Smith_Customer", because the specific field is not accepting NULL values.

Has this to do with our problem?

For the rest... the requested screenshots can be downloaded from:
http://www.4success.nl/download/cart_setup.zip

Additional info: we have tried to use the standard-out-of-the-package BuyNow files, superseding the currently used and slightly changed BuyNow files. Result: same last confirmation page checkout blockage.

Thanks,
Martin.