Home Search Tags Members

Home » Kartris ASP.NET Ecommerce Software » Kartris technical issues » Checkout Errors

Checkout Errors

Posted By shulemj Tue 5 Jul 2016
Add to Favorites1

Checkout Errors

Topic View Topic View Topic Options Topic Options
Author Message
shulemj
Posted Tue 5 Jul 2016
Supreme Being

Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)

Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115, Visits: 565
I am not sure of these two errors are related, but they might be, so I post them together.

P.S. I'm setup with automatic UPS prices.

Error 1: Shipping gets 100% discount
Regardless of the shipping method I choose, the price comes up right, but gets discounted by 100%.
Shipping


$ 91.01-100%1$ 0.00

Error 2: Checkout "Proceed" Button Loops back to same page
(Choosing PO/Offline method)
As I click the 'Proceed' button after choosing addresses, shipping method, agreeing to terms, I get another frame of the Checkout.aspx which seems like confirmation page, with another 'Proceed' button. Only, this time, no matter how many time I click the button, I come back to that confirmation screen.
Tags
Edited Tue 5 Jul 2016 by shulemj
Post Information
Paul
Posted Tue 5 Jul 2016
große Käse

große Käse - (449,910 reputation)große Käse - (449,910 reputation)große Käse - (449,910 reputation)große Käse - (449,910 reputation)große Käse - (449,910 reputation)große Käse - (449,910 reputation)große Käse - (449,910 reputation)große Käse - (449,910 reputation)große Käse - (449,910 reputation)

Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806, Visits: 2,737
Does anything show in the error logs?

--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.

If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
Post Information
shulemj
Posted Tue 5 Jul 2016
Supreme Being

Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)

Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115, Visits: 565
Nothing in the error log
Post Information
shulemj
Posted Thu 4 Aug 2016
Supreme Being

Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)

Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115, Visits: 565
On error 2 (Checkout "Proceed" Button Loops back to same page), I got the following error in the log:

-----------------------------------------------------------------------------
>> OrdersBLL.Add
-----------------------------------------------------------------------------
>> System.Data.SqlClient.SqlException
>> 8/3/2016 6:21:51 PM
>> Version:2.9005
>> URL:http://www.malchutjudaica.com/Checkout.aspx
>> 00.00.000.000 (masked by me here)
>> CUSTOM MESSAGE:
Database Error: A general error has occurred.
>> NUMBER:1088
>> MESSAGE:
Cannot find the object "trigKartrisInvoiceRows_DML" because it does not exist or you do not have permissions.
>> STACK:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
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 OrdersBLL.Add(Int32 C_ID, String strUserEmailAddress, String strUserPassword, Address BillingAddress, Address ShippingAddress, Boolean blnSameShippingAsBilling, Basket BasketObject, List`1 BasketArray, String strOrderDetails, String strGatewayName, Int32 intLanguageID, Int32 intCurrencyID, Int32 intGatewayCurrencyID, Boolean blnOrderEmails, String strShippingMethod, Double numGatewayTotalPrice, String strEUVATNumber, String strPromotionDescription, String strPurchaseOrderNo, String strComments)
==================================================
Post Information
Tiggywiggler
Posted Thu 11 Aug 2016
Supreme Being

Supreme Being - (105,290 reputation)Supreme Being - (105,290 reputation)Supreme Being - (105,290 reputation)Supreme Being - (105,290 reputation)Supreme Being - (105,290 reputation)Supreme Being - (105,290 reputation)Supreme Being - (105,290 reputation)Supreme Being - (105,290 reputation)Supreme Being - (105,290 reputation)

Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235, Visits: 750
That trigger was removed in version 2.0000, are you running a very old database or application behind the scenes? Have you upgraded from one version to another without running the upgrade scripts?

We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
Post Information
shulemj
Posted Sun 14 Aug 2016
Supreme Being

Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)

Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115, Visits: 565
I actually installed a new Kartris from file kartris2_9005b1_WPI.
Post Information
Paul
Posted Mon 15 Aug 2016
große Käse

große Käse - (449,910 reputation)große Käse - (449,910 reputation)große Käse - (449,910 reputation)große Käse - (449,910 reputation)große Käse - (449,910 reputation)große Käse - (449,910 reputation)große Käse - (449,910 reputation)große Käse - (449,910 reputation)große Käse - (449,910 reputation)

Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806, Visits: 2,737
I searched the source in visual studio of the latest version for

trigKartrisInvoiceRows_DML

and it only finds it in old upgrade SQL scripts.

The last reference is the 1.4->2.0 upgrade script, which drops (deletes) the trigger. A clean install won't use these update scripts, it would run the MainData script, and that does not have that trigger in it. So I don't see where that trigger came from unless you have an older db. If that was upgraded using the update scripts, it shouldn't have that trigger (because the 1.4->2.0 drops it)

--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.

If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
Edited Mon 15 Aug 2016 by Paul
Post Information
shulemj
Posted Mon 15 Aug 2016
Supreme Being

Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)

Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115, Visits: 565
So it appears that our database needs some updating. What is the recommended method to do that while preserving the existing data?
Post Information
Tiggywiggler
Posted Mon 15 Aug 2016
Supreme Being

Supreme Being - (105,290 reputation)Supreme Being - (105,290 reputation)Supreme Being - (105,290 reputation)Supreme Being - (105,290 reputation)Supreme Being - (105,290 reputation)Supreme Being - (105,290 reputation)Supreme Being - (105,290 reputation)Supreme Being - (105,290 reputation)Supreme Being - (105,290 reputation)

Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235, Visits: 750
What version is the DB?

what version of application did you upgrade from? That would be a good thing to know.

We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
Post Information
shulemj
Posted Mon 15 Aug 2016
Supreme Being

Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)Supreme Being - (51,473 reputation)

Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115, Visits: 565
This is not an upgrade, but an original download from Kartris' website. Does kartris2_9005b1_WPI tell you which version? I think it's v2.9005.

I do remember that during the setup I was instructed to run several SQL scripts from \Uploads\Resources (via the DataTool) and may have received an error on two upgrades.


Does this answer anything?
Post Information

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top

Powered By InstantForum.NET 2012-1 © 2024
Execution: 0.094. 18 queries. Compression Enabled.