Invalid transaction - order status stays 'created'

cosmo
Topic Author
Offline

15 years 1 month ago #23402 by cosmo

Invalid transaction - order status stays 'created' was created by cosmo

I'm testing Paypal-plugin using Sandbox. After payment I recieve an email about an invalid transaction. Your documentation tells me to discard this information, but problem is my order status stays on 'created' where it should be changed into 'confirmed'. Is the invalid transaction causing this problem or is there something else not working correctly"?

Please Log in or Create an account to join the conversation.

nicolas
Offline

15 years 1 month ago #23434 by nicolas

Replied by nicolas on topic Re: Invalid transaction - order status stays 'created'

When HikaShop receives a payment notification, it connects to paypal's server to make sure that the notification is legit. If not, the paypal server tells hikashop that the transaction is invalid. Which is what happened if you got that error.
That should not happen when PayPal itself sends the notification.
Did you try with a second order ?
Could you try to activate the debug mode of the paypal plugin, place an order again and send the payment log file so that we can analyze it (it is located in the folder media/com_hikashop/upload/safe/log ) ?

Please Log in or Create an account to join the conversation.

cosmo
Topic Author
Offline

15 years 1 month ago #23447 by cosmo

Replied by cosmo on topic Re: Invalid transaction - order status stays 'created'

I tried several orders but the result is always the same: invalid transaction. The log shows:

Array
(
[option] => com_hikashop
[ctrl] => checkout
[task] => notify
[notif_payment] => paypal
[tmpl] => component
[lang] => nl
[Itemid] => 8
[mc_gross] => 40.00
[invoice] => 100013
[protection_eligibility] => Ineligible
[address_status] => unconfirmed
[item_number1] => Wals
[payer_id] => Q3L34RZ9HMAUL
[tax] => 0.00
[address_street] => ******
[payment_date] => 01:48:42 Aug 12, 2011 PDT
[payment_status] => Completed
[charset] => windows-1252
[address_zip] => 6789 GG
[mc_shipping] => 0.00
[mc_handling] => 0.00
[first_name] => ******
[mc_fee] => 1.71
[address_country_code] => NL
[address_name] => **********
[notify_version] => 3.2
[custom] =>
[payer_status] => verified
[business] => ***************
[address_country] => Netherlands
[num_cart_items] => 1
[mc_handling1] => 0.00
[address_city] => **********
[verify_sign] => Afi-oZM9M5WVfmmWwKAFuBmmaK5CAQho1aKtaoSzIgeJDKT37hy29POg
[payer_email] => **********
[mc_shipping1] => 0.00
[txn_id] => 2NJ475323E543090M
[payment_type] => instant
[last_name] => ******
[address_state] =>
[item_name1] => Wals
[receiver_email] => **********
[payment_fee] =>
[quantity1] => 1
[receiver_id] => 437MNY5DTL6D8
[txn_type] => cart
[mc_gross_1] => 40.00
[mc_currency] => EUR
[residence_country] => NL
[test_ipn] => 1
[transaction_subject] => Shopping Cart
[payment_gross] =>
[ipn_track_id] => uKcD5kchT6zN-79FHO5j1A
[hikashop_front_end_main] => 1
[view] => checkout
)

stdClass Object
(
[order_id] => 100013
[order_billing_address_id] => 9
[order_shipping_address_id] => 9
[order_user_id] => 17
[order_status] => created
[order_discount_code] =>
[order_created] => 1313138877
[order_ip] => **.**.***.***
[order_currency_id] => 1
[order_shipping_price] => 0.00000
[order_discount_price] => 0.00000
[order_shipping_id] =>
[order_shipping_method] =>
[order_payment_id] => 2
[order_payment_method] => paypal
[order_full_price] => 40.00000
[order_modified] => 1313138877
[order_partner_id] => 0
[order_partner_price] => 0.00000
[order_partner_paid] => 0
[order_type] => sale
[order_partner_currency_id] => 0
[order_shipping_tax] => 0.00000
[order_discount_tax] => 0.00000
[order_number] => B201108100013
)

Array
(
[scheme] => https
[host] => www.sandbox.paypal.com
[path] => /cgi-bin/webscr
[query] => _cmd=login_run&login_email=**********
[port] => 443
[host_socket] => ssl://www.sandbox.paypal.com
)

POST /cgi-bin/webscr?_cmd=login_run&login_email=********** HTTP/1.0

User-Agent: PHP/5.3.2-1ubuntu4.9

Referer: www.**********.nl/index.phpoption=com_hikashop&ctrl=checkout&task=notify&notif_payment=paypal&tmpl=component&lang=nl&Itemid=8

Server: Apache

Host: www.sandbox.paypal.com:443

Content-Type: application/x-www-form-urlencoded

Content-Length: 1274

Accept: */*

option=com_hikashop&ctrl=checkout&task=notify&notif_payment=paypal&tmpl=component&lang=nl&Itemid=8&mc_gross=40.00&invoice=100013&protection_eligibility=Ineligible&address_status=unconfirmed&item_number1=Wals&payer_id=Q3L34RZ9HMAUL&tax=0.00&address_street=**********&payment_date=01%3A48%3A42+Aug+12%2C+2011+PDT&payment_status=Completed&charset=windows-1252&address_zip=******&mc_shipping=0.00&mc_handling=0.00&first_name=******&mc_fee=1.71&address_country_code=NL&address_name=**********&notify_version=3.2&custom=&payer_status=verified&business=**********&address_country=Netherlands&num_cart_items=1&mc_handling1=0.00&address_city=********&verify_sign=Afi-oZM9M5WVfmmWwKAFuBmmaK5CAQho1aKtaoSzIgeJDKT37hy29POg&payer_email=**********&mc_shipping1=0.00&txn_id=2NJ475323E543090M&payment_type=instant&last_name=******&address_state=&item_name1=Wals&receiver_email=**********&payment_fee=&quantity1=1&receiver_id=437MNY5DTL6D8&txn_type=cart&mc_gross_1=40.00&mc_currency=EUR&residence_country=NL&test_ipn=1&transaction_subject=Shopping+Cart&payment_gross=&ipn_track_id=uKcD5kchT6zN-79FHO5j1A&hikashop_front_end_main=1&view=checkout&cmd=_notify-validate

HTTP/1.1 200 OK

Date: Fri, 12 Aug 2011 08:48:48 GMT

Server: Apache

Set-Cookie: c9MWDuvPtT9GIMyPc3jwol1VSlO=Nnwl5g-8xwU27Clua82xQqSPo6lcB_pO053s_6reT-NxzUXUXa_W0S2Q8RbBD8G5D93FVSxB7DLZ2R1G7zCN-zufUPlz6PKf7yr2NyJphJeD0Cy7MXSgUzj4Uz8Fg6jP-hR74W%7cebh2AqcVukqmuw_F4_6spGQuHn9_JiG_LpSD-2RFWfaVT70QBrEQPNJlQDl2CGrrAMAXiG%7c5onYEhYliS7U6iig711hEg6Qa0fpfEi0CsjwPRbGG77Pj9hp4n93Cl6usBuPkE6L7GbSpG%7c1313138929; domain=.paypal.com; path=/; Secure; HttpOnly

Set-Cookie: cookie_check=yes; expires=Mon, 09-Aug-2021 08:48:49 GMT; domain=.paypal.com; path=/; Secure; HttpOnly

Set-Cookie: navcmd=_notify-validate; domain=.paypal.com; path=/; Secure; HttpOnly

Set-Cookie: navlns=0.0; expires=Thu, 07-Aug-2031 08:48:49 GMT; domain=.paypal.com; path=/; Secure; HttpOnly

Set-Cookie: Apache=10.72.109.11.1313138928774145; path=/; expires=Sun, 04-Aug-41 08:48:48 GMT

Connection: close

Content-Type: text/html; charset=UTF-8

INVALID

invalid transaction

Please Log in or Create an account to join the conversation.

nicolas
Offline

15 years 1 month ago #23450 by nicolas

Replied by nicolas on topic Re: Invalid transaction - order status stays 'created'

How come your paypal URL is www.sandbox.paypal.com/cgi-bin/webscr?_c...gin_email=********** ?

It should just be www.sandbox.paypal.com/cgi-bin/webscr

Could you check that you're using the correct URL in your paypal plugin configuration's URL option ?

I also see that the charset sent by paypal is windows-1252 where normally hikashop sends the parameters in utf-8 at the end of the checkout and tells paypal that the request is in utf8. Could that come from there ? Did you change something in the paypal plugin's code or in your paypal account settings on that regard ?

Please Log in or Create an account to join the conversation.

cosmo
Topic Author
Offline

15 years 1 month ago - 15 years 1 month ago #23454 by cosmo

Replied by cosmo on topic Re: Invalid transaction - order status stays 'created'

I changed the URL to www.sandbox.paypal.com/cgi-bin/webscr , but I still get the message 'invalid transaction'. So it's not the URL.

Where do I find the charset-settings? I haven't changed anything in the code.

PS
What's the "Return method" option for in the paypal plugin?

Last edit: 15 years 1 month ago by cosmo. Reason: PS

Please Log in or Create an account to join the conversation.

nicolas
Offline

15 years 1 month ago #23540 by nicolas

Replied by nicolas on topic Re: Invalid transaction - order status stays 'created'

You can look on that page for explanations on how to set the charset in the options of your account:
www.paypalobjects.com/en_US/ebook/PP_Web...ProfileAndTools.html

The return method option defines how paypal should return the data after the payment has been made. You should have it activated in most cases.

If that doesn't solve your problem, I would recommend you to ask help to the paypal support by providing them with the log file generated by HikaShop. They will have all the information they need to understand where is the problem and why they sent back an invalid status to HikaShop when that should not have happened.

Please Log in or Create an account to join the conversation.

cosmo
Topic Author
Offline

15 years 1 month ago #23557 by cosmo

Replied by cosmo on topic Re: Invalid transaction - order status stays 'created'

Nicolas, thanks a lot for your help, switching on 'Return method' solved the problem!

Maybe you could update the documentation on the paypal-plugin because this radio-button is not mentioned: www.hikashop.com/en/support/documentatio...ent-paypal-form.html

Please Log in or Create an account to join the conversation.

nicolas
Offline

15 years 1 month ago #23559 by nicolas

Replied by nicolas on topic Re: Invalid transaction - order status stays 'created'

We'll do that. Thanks.

Please Log in or Create an account to join the conversation.

ClickWebDesign
Offline

14 years 11 months ago #28386 by ClickWebDesign

Replied by ClickWebDesign on topic Re: Invalid transaction - order status stays 'created'

Hi Nicolas,
I'm having this problem with paypal. I receive admin emails with the subject "Paypal payment notification refused: Connection to Paypal failed for the order XXXX".

I'm wondering if it's to do with the IPN settings in paypal - under profile>my selling tools>Instant payment notifications, there is the option to turn IPN on/off and set the "return url".

Could the cause be having this off or no notification url set? What should the notification url be?

Thanks
Chris

Please Log in or Create an account to join the conversation.

nicolas
Offline

14 years 11 months ago #28420 by nicolas

Replied by nicolas on topic Re: Invalid transaction - order status stays 'created'

Hi,

No, if you receive that email, it means that paypal is contacting HikaShop using the IPN but that HikaShop is not able to contact PayPal back. In that case you should look at the documentation there in the section "Connection to paypal failed":
www.hikashop.com/en/support/documentatio...rror.html#connection

Please Log in or Create an account to join the conversation.

ClickWebDesign
Offline

14 years 10 months ago #28928 by ClickWebDesign

Replied by ClickWebDesign on topic Re: Invalid transaction - order status stays 'created'

Hi Nicolas,
After speaking to my hosting they installed the OpenSSL PHP module and this sorted the issue:)

Cheers
Chris

Please Log in or Create an account to join the conversation.

timmultimedia
Offline

14 years 7 months ago #40392 by timmultimedia

Replied by timmultimedia on topic Re: Invalid transaction - order status stays 'created'

Hi Nicholas,
I'm having the exact same problem. I am receiving an "Invalid Transaction" email. I have tried turning 'Return Method' to yes and no and I still get the email in either case.

Code:

Please Log in or Create an account to join the conversation.

nicolas
Offline

14 years 7 months ago #40569 by nicolas

Replied by nicolas on topic Re: Invalid transaction - order status stays 'created'

Then you might want to contact PayPal sandbox's support and provide them with that log. They should be able to help you.

Sometimes the sandbox tests can get a bit wacky even though it works fine with normal paypal accounts...

Please Log in or Create an account to join the conversation.

Time to create page: 0.233 seconds