♥FWR Media Posted August 2, 2007 Posted August 2, 2007 I've only had one issue this morning which is Transaction reached initial registration stage but has proceeded no further. I wonder if I'm not getting timeouts because I'm using the new URLs? Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work.
pitstop Posted August 2, 2007 Posted August 2, 2007 2013 - Lost connection to MySQL server during query is the error I am now getting. I have turned off the send basket. Any ideas how I can sort this? As many others are we are losing customers! Thanks Darren Quote
kunal247 Posted August 2, 2007 Posted August 2, 2007 Now had two orders where payment has been taken but the order hasn't been confirmed in oscommerce so there is no order. As I've had to turn "send basket contents" off, this is a real problem! Any idea? Thanks John I am having the same issue on my site. Transaction going thru but order not being completed on our site. Also some cases we are getting " 3021 : The Basket format is invalid." What is the best temp. fix for this till the matter can be resolved at protx. Kunal Quote
Guest Posted August 2, 2007 Posted August 2, 2007 @kunal247 - Firstly in your admin area (modules->payment->protx direct) change send cart to false as a temporary fix. Then to help with the timeout issues (causing payments but no order registered) open protx_process.php - you will find 2 sections that contain lines with curl_setopt - immediately after each one add the line curl_setopt($ch, CURLOPT_TIMEOUT, 90); This will give a 90second timeout for a response from the protx server - you cuold increase this further Following the Protx support forums they have admitted that there has been a problem this morning with timeouts but they beleive it is fixed now - so fingers crossed! @pitstop - please check your includes/configure.php to make sure you are not using persistent connections for your database. Tom Quote
future1 Posted August 2, 2007 Posted August 2, 2007 Hello all, we are seeing a number of transactions today that are not appearing on OSC, but showing on Protx. We have made the timeout change that Tom refered to above...will report back later. We are also seeing "Malformed - 3096 : The VPSProtocol value is required." appearing in the protx_direct table. This seems to happen when users fail 3D and are diverted back to checkout_payment.php Quote
kunal247 Posted August 2, 2007 Posted August 2, 2007 @kunal247 - Firstly in your admin area (modules->payment->protx direct) change send cart to false as a temporary fix. Then to help with the timeout issues (causing payments but no order registered) open protx_process.php - you will find 2 sections that contain lines with curl_setopt - immediately after each one add the line curl_setopt($ch, CURLOPT_TIMEOUT, 90); This will give a 90second timeout for a response from the protx server - you cuold increase this further Following the Protx support forums they have admitted that there has been a problem this morning with timeouts but they beleive it is fixed now - so fingers crossed! @pitstop - please check your includes/configure.php to make sure you are not using persistent connections for your database. Tom Hi Tom, Thanks for the quick response. Can you please tell me where to add the Timeout code ? protx_process.php lines 38 - 54 $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_POST, $data); curl_setopt($ch, CURLOPT_POSTFIELDS, $data); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); // Uncomment these lines if having problems connecting to Protx server // // curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); // curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); // // End $response = curl_exec($ch); curl_close ($ch); Quote
Guest Posted August 2, 2007 Posted August 2, 2007 add directly after this line curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); You will need to add it twice - you should find a similar section lower in the code Tom Quote
cottonmiller Posted August 2, 2007 Posted August 2, 2007 Hi, hope you can help ??? Following the changes yesterday I upgraded to v4.3 and enabled 3d secure in VSP Admin. Since then i have had various issues and currently get no responses from protx servers (or so it appears) when I switch to debug mode; I can see that all my values are being correcly sent but the response page below is a 404 - page not found? Is this because I need to tell Protx that I have upgraded and enabled 3d secure? And do they have to register my account before I can make use of 3d? Before getting the 404 page I was seeing the response below but not now - any ideas why? curl_error= SSL certificate problem, verify that the CA cert is OK error:1409086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certifictae verify failed We have currently taken no orders since the Protx upgrade and I am getting no help from Protx at he mo - all lines are jammed. Thanks in advance James http://www.linenslimited.co.uk - Bedding Quote
kunal247 Posted August 2, 2007 Posted August 2, 2007 add directly after this line curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); You will need to add it twice - you should find a similar section lower in the code Tom Thanks again Tom!! I have made the changes and updated. is this a temp add on or best to leave it there permanently. Kunal Quote
Guest Posted August 2, 2007 Posted August 2, 2007 @cottonmiller - Protx are still having some issues but for the error you are seeing you need to edit your protx_prcoess.php file. At the top of the file find the following $disable_curl_ssl_check = false; // Set to true (no quotes) // if you are having problems connecting to the protx servers and change the false to true That should help, Tom @kunal247 - there's no harm in leaving it Quote
cottonmiller Posted August 2, 2007 Posted August 2, 2007 Tom Thanks for the reply, I had already tried this and it is currently set to true - I'm getting this error either way ... (test data here of course) Request URL=https://ukvps.protx.com/vpsgateway/service/vspdirect-register.vsp Data string sent=VPSProtocol=2.22&TxType=PAYMENT&Vendor=Linens&VendorTxCode=4666-37859562676181278916619132408689&Amount=13.89&Currency=GBP&Description=Order+Number%3A+4666&CardHolder=James+Wilkinson&CardNumber=4929000000006&StartDate=0103&ExpiryDate=0509&IssueNumber=&CV2=123&CardType=VISA&BillingAddress=55+the+street%2C%0D%0A%2C%0D%0Aslough%2C%0D%0Aberks%2C%0D%0AUnited+Kingdom&BillingPostCode=sl1+1al&DeliveryAddress=55+the+street%2C%0D%0A%2C%0D%0Aslough%2C%0D%0Aberks%2C%0D%0AUnited+Kingdom&DeliveryPostCode=sl1+1al&CustomerName=James+Wilkinson&ContactNumber=12345&CustomerEMail=admin%40linenslimited.co.uk&ClientIPAddress=82.69.52.149&Basket=2%3AFaux+Suede+Swirl+Cushion+Cover+%28Chocolate%29%2C+18%22+x+18%22%3A1%3A5.91%3A1.03%3A6.94%3A6.94%3AShipping%3A1%3A6.95%3A----%3A6.95%3A6.95&AccountType=E&Apply3DSecure=0 Protx response= The page cannot be foundThe page you are looking for might have been removed, had its name changed, or is temporarily unavailable. --------------------------------------------------------------------------------Please try the following:Make sure that the Web site address displayed in the address bar of your browser is spelled and formatted correctly. If you reached this page by clicking a link, contact the Web site administrator to alert them that the link is incorrectly formatted. Click the Back button to try another link. HTTP Error 404 - File or directory not found.Internet Information Services (IIS)--------------------------------------------------------------------------------Technical Information (for support personnel)Go to Microsoft Product Support Services and perform a title search for the words HTTP and 404. Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled Web Site Setup, Common Administrative Tasks, and About Custom Error Messages. Response array=Array ( [] => [ "Content-Type" Content=text/html; charset=Windows-1252"> [ Is this a firewall issue do you think? Why the 404 response??? James (if you need any linen let me know) http://www.linenslimited.co.uk Quote
Guest Posted August 2, 2007 Posted August 2, 2007 Protx have changed their URLs - they have insisted that the old urls will continue to work and be redirected to the new ones but presumably by the 404 message that isn't happening. Try editing protx_process.php, near the top find if (MODULE_PAYMENT_PROTX_DIRECT_TRANSACTION_MODE == 'Test') { $url = 'https://ukvpstest.protx.com/vpsDirectAuth/Callback3D.asp'; } elseif (MODULE_PAYMENT_PROTX_DIRECT_TRANSACTION_MODE == 'Server IP Test') { $url = 'https://ukvpstest.protx.com/showpost/showpost.asp'; } elseif (MODULE_PAYMENT_PROTX_DIRECT_TRANSACTION_MODE == 'Simulator') { $url = 'https://ukvpstest.protx.com/VSPSimulator/VSPDirectCallback.asp'; } else { $url = 'https://ukvps.protx.com/vpsDirectAuth/Callback3D.asp'; } and replace with if (MODULE_PAYMENT_PROTX_DIRECT_TRANSACTION_MODE == 'Test') { $url = 'https://ukvpstest.protx.com/vspgateway/service/direct3dcallback.vsp'; } elseif (MODULE_PAYMENT_PROTX_DIRECT_TRANSACTION_MODE == 'Server IP Test') { $url = 'https://ukvpstest.protx.com/showpost/showpost.asp'; } elseif (MODULE_PAYMENT_PROTX_DIRECT_TRANSACTION_MODE == 'Simulator') { $url = 'https://ukvpstest.protx.com/VSPSimulator/VSPDirectCallback.asp'; } else { $url = 'https://ukvps.protx.com/vspgateway/service/direct3dcallback.vsp'; } further down find: if (MODULE_PAYMENT_PROTX_DIRECT_TRANSACTION_MODE == 'Test') { $url = 'https://ukvpstest.protx.com/vpsDirectAuth/PaymentGateway3D.asp'; } elseif (MODULE_PAYMENT_PROTX_DIRECT_TRANSACTION_MODE == 'Server IP Test') { $url = 'https://ukvpstest.protx.com/showpost/showpost.asp'; } elseif (MODULE_PAYMENT_PROTX_DIRECT_TRANSACTION_MODE == 'Simulator') { $url = 'https://ukvpstest.protx.com/VSPSimulator/VSPDirectGateway.asp'; } else { $url = 'https://ukvps.protx.com/vpsDirectAuth/PaymentGateway3D.asp'; } and replace with if (MODULE_PAYMENT_PROTX_DIRECT_TRANSACTION_MODE == 'Test') { $url = 'https://ukvpstest.protx.com/vspgateway/service/vspdirect-register.vsp'; } elseif (MODULE_PAYMENT_PROTX_DIRECT_TRANSACTION_MODE == 'Server IP Test') { $url = 'https://ukvpstest.protx.com/showpost/showpost.asp'; } elseif (MODULE_PAYMENT_PROTX_DIRECT_TRANSACTION_MODE == 'Simulator') { $url = 'https://ukvpstest.protx.com/VSPSimulator/VSPDirectGateway.asp'; } else { $url = 'https://ukvps.protx.com/vspgateway/service/vspdirect-register.vsp'; } Let me know if that helps Tom Quote
♥FWR Media Posted August 2, 2007 Posted August 2, 2007 The one cottonmiller stated in the post Request URL=https://ukvps.protx.com/vpsgateway/service/vspdirect-register.vsp is already one of the new URLs, or am I missing something? Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work.
Guest Posted August 2, 2007 Posted August 2, 2007 sorry yes you are correct - that'll teach me to skim read things!! - Hoever cottommiller has made actually made a small spelling mistake hence the 404. the correct (new) url is https://ukvps.protx.com/vspgateway/service/vspdirect-register.vsp It's important to note the difference between the VSP and VPS - confusing I know!! Tom Quote
♥FWR Media Posted August 2, 2007 Posted August 2, 2007 or am I missing something? The answer was YES you are missing something! The spelling mistake that was actually causing the error!! :D Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work.
♥Vger Posted August 2, 2007 Posted August 2, 2007 The major problem still being suffered by people seems to revolve around the redirects from the old URL's not working. I would advise anyone to use the new URL's to get around the bottle neck caused by the failing redirects. Vger Quote
cottonmiller Posted August 2, 2007 Posted August 2, 2007 (edited) @Babygurgles - you are correct but I am not .. Tom Many thanks, replacing the code (with correct bloody spellings) has made me fully functional (although very unsightly to the user at the mo) once more!!! Hooray ... Seriuosly, if you need any linen, mail me what you like on the site and I'll look after you in a trade kinda way :rolleyes: James http://www.linenslimited.co.uk - Bedding, Linen & Towels One thing though .... the module still refers to Switch - that's not allowed is it ??? Edited August 2, 2007 by cottonmiller Quote
♥Vger Posted August 2, 2007 Posted August 2, 2007 You have a VERY VERY nce website - and I don't often say that! Vger @Babygurgles - you are correct but I am not .. Tom Many thanks, replacing the code (with correct bloody spellings) has made me fully functional (although very unsightly to the user at the mo) once more!!! Hooray ... Seriuosly, if you need any linen, mail me what you like on the site and I'll look after you in a trade kinda way :rolleyes: James http://www.linenslimited.co.uk - Bedding, Linen & Towels Quote
Guest Posted August 2, 2007 Posted August 2, 2007 In what way unsightly? Officially we are not supposed to use switch but I know many customers still recognise switch more than maestro so have dual names for now seems sensible. Tom Quote
cottonmiller Posted August 2, 2007 Posted August 2, 2007 I re wrote the whole package in <div> and css and the iframe layout is not fitting correctly; not an issue I'll sort that today now that functionality is restored. Thanks again - I take your point about Switch :-" Quote
cottonmiller Posted August 2, 2007 Posted August 2, 2007 (edited) You have a VERY VERY nce website - and I don't often say that! Vger Thank you, I also design for many Os users since putting mine live so third party comments are always appreciated :blush: One in progress www.kover-it.co.uk (new oscommerce version in develeopment @ www.allweathercovers.co.uk - should be live in around 4 weeks) Edited August 2, 2007 by cottonmiller Quote
♥Vger Posted August 2, 2007 Posted August 2, 2007 Off-topic, but on the same website theme - here's one we did about a year ago: http://www.cswshopping.co.uk/ Vger Quote
cottonmiller Posted August 2, 2007 Posted August 2, 2007 Off-topic, but on the same website theme - here's one we did about a year ago: http://www.cswshopping.co.uk/ Vger Very nice scheme ... are you TerraNetwork then ? James Quote
jammy69 Posted August 2, 2007 Posted August 2, 2007 Hello I am a newbie and there are two problems i m facing.i have a website which is using both the download mode and the delivery mode.The delivery mode seems to go through but when i order to download i m facing this error "INVALID - 3021 : The Basket format is invalid. The value was 2:Highrise:1:" .Pls suggest how to correct this. The second problem that i m facing is that the for the orders that go through but when i go and see in the admin section it doesnot list in the orders section of admin but when i put the order number in the box then i m able to see the order details. Pls suggest how to correct these two as soon as possible Thnx in advance Quote
Guest Posted August 2, 2007 Posted August 2, 2007 Hi, The basket error is a known fault when there is no shipping cost - as per the previous posts the temporary fix is to set "send shopping cart" to false - the permanent fix is in the new version that i'll upload soon. I'm not quite sure what's happening with the invisible orders - this module doesn't alter the checkout processing so should be the cause of that - is this a new problem? What happens if you do test orders with another payment method? Tom Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.