Knowledgebase
Home » Item #609
Checkout process hanging on mailorder.asp page
Question
I am running Microsoft SQL Server. When I go to checkout, the mailorder.asp page sits there for ages, then I get a "Page Not Found" error. What's going on?
Answer
There are a few things to check.
Firstly, make sure that the database is set up correctly in config.asp. Make sure that the strDatabaseType is set to "mssql", and that the numCursorType is set to 1 (if your CactuShop is v5.116 or earlier).
If that doesn't help, try disabling transactions (the 'ordertransactions' config settings). Transactions is a system by which a number queries can be grouped together such that they either succeed or fail as a whole. If one part fails, any changes made in prior queries within the same transaction are rolled back. However, some MS SQL Servers are set to not support transactions - in this case, you must disable it from the config settings so that CactuShop does not try to use them.