Invalid transaction - order status stays 'created'

  • Posts: 19
  • Thank you received: 0
12 years 8 months ago #23402

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.

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
12 years 8 months ago #23434

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.

  • Posts: 19
  • Thank you received: 0
12 years 8 months ago #23447

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¬if_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¬if_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=**********¬ify_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.

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
12 years 8 months ago #23450

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.

  • Posts: 19
  • Thank you received: 0
12 years 8 months ago #23454

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: 12 years 8 months ago by cosmo. Reason: PS

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

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
12 years 8 months ago #23540

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.

  • Posts: 19
  • Thank you received: 0
12 years 8 months ago #23557

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: http://www.hikashop.com/en/support/documentation/32-hikashop-payment-paypal-form.html

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

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
12 years 8 months ago #23559

We'll do that. Thanks.

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

  • Posts: 50
  • Thank you received: 0
12 years 6 months ago #28386

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.

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
12 years 6 months ago #28420

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.

  • Posts: 50
  • Thank you received: 0
12 years 5 months ago #28928

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.

  • Posts: 19
  • Thank you received: 1
12 years 2 months ago #40392

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.

Array
(
    [option] => com_hikashop
    [ctrl] => checkout
    [task] => notify
    [notif_payment] => paypal
    [tmpl] => component
    [lang] => en
    [Itemid] => 516
    [mc_gross] => 19.95
    [invoice] => 17
    [protection_eligibility] => Ineligible
    [address_status] => unconfirmed
    [item_number1] => 
    [payer_id] => K9GRDXWBSNGTJ
    [tax] => 0.00
    [address_street] => 1 Cheeseman Ave - East
    [payment_date] => 03:13:54 Feb 21, 2012 PST
    [payment_status] => Completed
    [charset] => windows-1252
    [address_zip] => 3001
    [mc_shipping] => 0.00
    [mc_handling] => 0.00
    [first_name] => Tim
    [mc_fee] => 0.78
    [address_country_code] => AU
    [address_name] => *****
    [notify_version] => 3.4
    [custom] => 
    [payer_status] => verified
    [business] => ***@gmail.com
    [address_country] => Australia
    [num_cart_items] => 1
    [mc_handling1] => 0.00
    [address_city] => Melbourne
    [verify_sign] => AFcWxV21C7fd0v3bYYYRCpSSRl31AKQh8J6N740wjLZZCuYf.M6TDVDA
    [payer_email] => ****@gmail.com
    [mc_shipping1] => 0.00
    [txn_id] => 66585041DC7407927
    [payment_type] => instant
    [last_name] => ******
    [address_state] => Victoria
    [item_name1] => Total price
    [receiver_email] => ****@gmail.com
    [payment_fee] => 
    [quantity1] => 1
    [receiver_id] => E9CJTJLVAKR2N
    [txn_type] => cart
    [mc_gross_1] => 19.95
    [mc_currency] => AUD
    [residence_country] => AU
    [test_ipn] => 1
    [transaction_subject] => Shopping CartTotal price
    [payment_gross] => 
    [ipn_track_id] => 3c4e86057377
    [hikashop_front_end_main] => 1
    [view] => checkout
)



stdClass Object
(
    [order_id] => 17
    [order_billing_address_id] => 12
    [order_shipping_address_id] => 12
    [order_user_id] => 2
    [order_status] => created
    [order_discount_code] => 
    [order_created] => 1329822807
    [order_ip] => 203.219.235.34
    [order_currency_id] => 6
    [order_shipping_price] => 5.00000
    [order_discount_price] => 0.00000
    [order_shipping_id] => STANDARD
    [order_shipping_method] => aupost
    [order_payment_id] => 1
    [order_payment_method] => paypal
    [order_full_price] => 19.95000
    [order_modified] => 1329822807
    [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] => T17
    [order_tax_info] => Array
        (
        )

)



Array
(
    [scheme] => https
    [host] => www.sandbox.paypal.com
    [path] => /cgi-bin/websc
    [query] => 
    [port] => 443
    [host_socket] => ssl://www.sandbox.paypal.com
)



POST /cgi-bin/websc HTTP/1.0
User-Agent: PHP/5.2.17
Referer: *****.org/index.phpoption=com_hikashop&ctrl=checkout&task=notify&notif_payment=paypal&tmpl=component&lang=en&Itemid=516
Server: Apache
Host: www.sandbox.paypal.com:443
Content-Type: application/x-www-form-urlencoded
Content-Length: 1244
Accept: */*




option=com_hikashop&ctrl=checkout&task=notify&notif_payment=paypal&tmpl=component&lang=en&Itemid=516&mc_gross=19.95&invoice=17&protection_eligibility=Ineligible&address_status=unconfirmed&item_number1=&payer_id=K9GRDXWBSNGTJ&tax=0.00&address_street=1+Cheeseman+Ave+-+East&payment_date=03%3A13%3A54+Feb+21%2C+2012+PST&payment_status=Completed&charset=windows-1252&address_zip=3001&mc_shipping=0.00&mc_handling=0.00&first_name=Tim&mc_fee=0.78&address_country_code=AU&address_name=*****&notify_version=3.4&custom=&payer_status=verified&business=****%40gmail.com&address_country=Australia&num_cart_items=1&mc_handling1=0.00&address_city=Melbourne&verify_sign=AFcWxV21C7fd0v3bYYYRCpSSRl31AKQh8J6N740wjLZZCuYf.M6TDVDA&payer_email=*****%40gmail.com&mc_shipping1=0.00&txn_id=66585041DC7407927&payment_type=instant&last_name=*****&address_state=Victoria&item_name1=Total+price&receiver_email=*****%40gmail.com&payment_fee=&quantity1=1&receiver_id=E9CJTJLVAKR2N&txn_type=cart&mc_gross_1=19.95&mc_currency=AUD&residence_country=AU&test_ipn=1&transaction_subject=Shopping+CartTotal+price&payment_gross=&ipn_track_id=3c4e86057377&hikashop_front_end_main=1&view=checkout&cmd=_notify-validate


HTTP/1.1 200 OK
Date: Tue, 21 Feb 2012 11:13:59 GMT
Server: Apache
X-Frame-Options: SAMEORIGIN
Set-Cookie: c9MWDuvPtT9GIMyPc3jwol1VSlO=S70piDxDBPgVNQagQ8GshsO-t4rO_WereloVbmHPbt4y-yEVzBNi-MscRsrkucgHjTemHPSr8yT4S61bP7NierVIiexTQHtpr2pD6Bs70m-zq1-VlZdItdDg_63vu7ewhlJjcG%7cXOhCkPOGUvsKe9k4i-RHuNkxxDkY1tuhU-nTcEqHw50rQcEKJM8lSH5l_lhqnqFl5yJ--m%7cE28S-EVnDco9-VYYV_bOpT64u1rLYR6hi3ADGInjbOLaGD95x6I-7_wyyd-7UqIKcZ2AHW%7c1329822839; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: cookie_check=yes; expires=Fri, 18-Feb-2022 11:14:00 GMT; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: navcmd=_notify-validate; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: navlns=0.0; expires=Mon, 16-Feb-2032 11:14:00 GMT; domain=.paypal.com; path=/; Secure; HttpOnly
Set-Cookie: Apache=10.72.109.11.1329822839502087; path=/; expires=Thu, 13-Feb-42 11:13:59 GMT
Connection: close
Content-Type: text/html; charset=UTF-8

INVALID


invalid transaction

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

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
12 years 2 months ago #40569

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.106 seconds
Powered by Kunena Forum