Order not showing up on site.

[Guest]

Hi Folks.

We had an order last night, the payment has been processed by our merchant and we have received the ticket from them. However, When we go into customer orders, it is not listed anywhere. Basically, we know the customer has bought and paid for something but we do not know what it is that they have bought. Quite a big problem.

We have put a test purchase through before and it is listed in the orders section perfectly.

 

Any ideas???

 

Thanks

randelld

[Recidivist]

Hi randelld,

 

Is your payment gateway Protx?

 

We're having the same problem. Protx say they are sure it's not their system at fault, but nothing on our server has changed in months, yet this started happening yesterday and it has already affected about 10 orders..

 

k.

[Guest]

Hi randelld,

 

Is your payment gateway Protx?

 

We're having the same problem. Protx say they are sure it's not their system at fault, but nothing on our server has changed in months, yet this started happening yesterday and it has already affected about 10 orders..

 

k.

 

Yes, it is ProtX and the order in question was placed yesterday. It is still happening today.

 

Yes, it is ProtX and the order in question was placed yesterday. It is still happening today.

 

 

Would you be so kind as to let me know if you reach a solution to this

 

I'll contact you should I find a solution.

 

Thanks

Dean

[rjavery]

We too are having the problem.

 

Protx has a support document (Article ID 42) which mentions that success/failure URLs get mangled under protocol version 2.22 if they do not get the capitalisation of 'VSPTxId' correct.

 

I am using version 1.06 of the forms module (which uses VPSTxID I believe). Mike Jackson released a new version (1.08) on 23/9/05. This version specifically mentions an update for protocol version 2.22. The release is bugfixed in version 1.09 on 20/10/05. The module is here http://www.oscommerce.com/community/contri...ll/search,protx

 

I am trying to find if there was a change that affected the protocol version on 2/11/05 (the date I started having issues) but I suspect that a change to this version may well fix it.

 

Unfortunately I am away on holiday at the moment and so will have to wait to install the patch.

 

Please let me know what version you are using and if you try a fix let me know how it goes.

 

As far as finding out what they purchased - do you have the recover carts module installed. This will tell you what was in the customer cart at the time.

 

Regards

 

Hi Folks.

We had an order last night, the payment has been processed by our merchant and we have received the ticket from them. However, When we go into customer orders, it is not listed anywhere. Basically, we know the customer has bought and paid for something but we do not know what it is that they have bought. Quite a big problem.

We have put a test purchase through before and it is listed in the orders section perfectly.

 

Any ideas???

 

Thanks

randelld

[rjavery]

Drat, figured a way to get the patch installed (v1.09).

 

I now get the emails from Protx which include the cart contents (which confirms the patch is installed) - but the order is still not created in OSCommerce.

 

Anyone else got any ideas?

 

Are all of us experiencing problems using Protx Forms?

 

Anyone using Protx forms and not having problems?

 

Just out of interest I use 1and1.co.uk for my hosting - not sure if they might have changed something to do with PHP or mySQL that impacted things.

[Recidivist]

Yes, we use 1and1 (professional) as well. I have emailed them and asked this very question. I will post their response here, when I get one.

 

k.

[HSMagic]

A quick "fix" for any problem of this nature is to install the master password contribution so that you can log on as the user and force thier cart through. It's saved me through a few paypal embarassments.

[4Ever Youthful]

I'm having this problem with paypal orders. I rcvd 3 orders today and 2 failed to post an order while one did fine. Anxiously awaiting a solution.

[Recidivist]

I've also been posting re this on this thread, as this issue is essentially the same problem.

 

The problem seems limited to OSCommerce stores hosted by 1and1 and using Protx as the payment gateway and is related to 1and1s latest php update on Thursday 3rd Nov.

 

I am still looking for a fix.

 

k.

[Recidivist]

I have just spoken with Protx and they have advised that they have provided help for a fix for this problem to one of their clients who implemented the fix and now has a working store again.

 

Essentially, the problem seems to stem from the php upgrade at 1&1 which is causing plusses (+) to be replaced with spaces in the encrypted string which gets sent to Protx. Thus, when Protx returns the encrypted string to the OSCommerce success url, and it is decryped by OSCommerce, the returned string is incorrect.

 

To fix this (it is recommended we try) replacing spaces in the encryped string with plusses to restore the original string syntax.

 

I think I understood that correctly! :)

 

Anyone know how to do this?

 

k.

[rjavery]

Do you have any further specifics on what the problem or fix was. If I could see where the string is being corrupted there is a replace function which would probably do what you describe.

 

I would like to understand more about exactly where the error occurs. The release notes for PHP do not seem to indicate anything major has changed. The biggest difference in 4.4 seems to be to do with sort orders. Have prox offered you any further information that may be useful?

[Recidivist]

Yes, I think we have just fixed it.

 

The problem was to replace spaces with plusses just BEFORE decryption of the string returned from Protx.

 

So, directly BEFORE this line:

 

$Decoded = $this->SimpleXor(base64_decode(str_replace (" ", "+", $crypt)),MODULE_PAYMENT_PROTX_FORM_PASSWORD);

 

we put this line:

 

$process_button_string = str_replace(" ", "+", $process_button_string);

 

and this seems to have fixed the problem. We are still conducting tests, though..

 

I'd be glad to hear that this works on your store too...

 

k.

[Recidivist]

Sorry, I made a mistake with that last post. The line to look for is

 

$Decoded = $this->SimpleXor(base64_decode($crypt),MODULE_PAYMENT_PROTX_FORM_PASSWORD);

 

Put this BEFORE it:

 

$process_button_string = str_replace(" ", "+", $process_button_string);

 

then change the first line to:

 

$Decoded = $this->SimpleXor(base64_decode(str_replace (" ", "+", $crypt)),MODULE_PAYMENT_PROTX_FORM_PASSWORD);

 

Sorry, about that, and remember to back up before making the changes.

 

There also seems to be an issue with dashes(-) in the string, but this change fixes the general problem and store orders are now being processed correctly.

 

k.

[Guest]

Sorry, I made a mistake with that last post. The line to look for is

 

$Decoded = $this->SimpleXor(base64_decode($crypt),MODULE_PAYMENT_PROTX_FORM_PASSWORD);

 

Put this BEFORE it:

 

$process_button_string = str_replace(" ", "+", $process_button_string);

 

then change the first line to:

 

$Decoded = $this->SimpleXor(base64_decode(str_replace (" ", "+", $crypt)),MODULE_PAYMENT_PROTX_FORM_PASSWORD);

 

Sorry, about that, and remember to back up before making the changes.

 

There also seems to be an issue with dashes(-) in the string, but this change fixes the general problem and store orders are now being processed correctly.

 

Hi, What file is this in??

Thanks

 

k.

[Recidivist]

This is in /includes/modules/payment/protx_form.php

 

k.

[Guest]

Hello, bare with me....i'm very new to all this stuff

 

I have noticed on my system that when I place an order myself (test the system out) it takes me to protx, finish off the payments, but when you come out of protx again, i dont get the "Thank you for shopping at xxxxxx". Also as it was myself shopping, i only get 2 emails instead of 3....one saying my order was process successfully and the other saying that the protx payment was successful. The 3rd email should have been the "Order Process" email which shows whats been order by the customer. As I dont get this email, the order is stuck in "held orders" and not in "Orders" where it should be, but within protx the payment shows up.

 

This has only happened in 2 orders since yesterday (myself and a customer, but when another customer ordered all the correct emails came through)

 

 

I have done the coding changes suggested in this topic and tested the system but I still only get 2 emails.

 

I am on the 1and1 hosting too.

[Guest]

Thanks for your help and suggestions everybody. Problem sorted. However, Our store is hosted with namesco and not 1&1

That's a coincidence isn't it?

 

Thanks

[Flyer5]

I have a client using Protx form protocol 2.22.

Its hosted with me on donhost servers in doncaster and we have never had this issue.

 

I've had it plenty with barclays ePDQ mind... :(

but thats another story....

[rgvsean]

Same problem here http://www.oscommerce.com/forums/index.php?showtopic=179369

 

I am not on 1&1 just a very good up-to-date hoster. I am using pay-pal and have the same problems.

 

Is there any code I can edit? I'll find out what my admin server guy thinks.

[rgvsean]

I have set up my pay-pal auto return and all seems fine. I set the URL to www.XXXXXXXX.com/checkout_process.php

 

:thumbsup:

[Guest]

I just tried the above code but it doesn't seem to have worked for me. How am I best to go about debugging this? I'm running php 5.0.4 and don't have any option to downgrade.

[marcr]

My host recently upgraded to php 4.4.1 and I had this problem, the fix worked perfectly for me

thank you

[Guest]

Protx got back to me with essentially the same solution as on here but still no joy. How do I test if I've got this problem? I'm running PHP 5.0.4 and everyone else seems to be talking about the latest version of PHP 4 so I don't even know if these fixes are for my problem.

 

Thanks.

[Guest]

OK I'm now doing some debugging and I'm emailing myself the contents of $crypt, $Decoded and $process_button_string before AND after the lines

 

$process_button_string = str_replace(" ", "+", $process_button_string);
$Decoded = $this->SimpleXor(base64_decode(str_replace(" ","+",$crypt)),MODULE_PAYMENT_PROTX_FORM_PASSWORD);

 

Both are completely empty. Anyone know what's going on there? I think I might have a different issue to the rest of you because I don't appear to be getting anything back from Protx, nevermind data that's invalid.

[nmlloyd]

I use oneandone hosting with Protx and around about 10% of this weeks orders have been affected so the problem was intermittent but the frequency of errors seemed to be increasing.

 

I applied the suggested code posted by Recidivist in Post #13 and it appears to work on the two test transactions that I put through, but this maybe early days yet. (.....thanks for the fix!)

 

Another side effect I noticed when testing with the original unfixed payment module was that test transactions aborted in the Protx payment screen via the CANCEL returned back to OSCOMMERCE with a corrupted error message instead of the standard "The Customer ABORTED the transaction by clicking the CANCEL button on the payment screen" message

 

After applying the fix, the correct CANCEL message is displayed.