Hi,
I have a website with
Joomla 3.8.10
Virtuemart 3.2.14 (latest)
OPC by rupostel 2.0.367 (latest)
The paypal was working like this before:
When user place order on website with Paypal, both user & vendor was receiving order email with 'Pending' status and just few moments later, another email with 'Confirmed' status. Also, the order status was getting changed to 'Confirmed' on successful payment.
But since 9th Sept 18 the order status for all the orders placed with Paypal are stuck with Pending status even after successful payment.
No changes are made on website. It suddenly started since 9th Sept. Anyone else with same problem?
Can you please suggest a fix?
Thanks.
check your IPN history at Paypal and see if they are being accepted with the correct response (200)
switch on the paypal logging and do a transaction .. check the logs
Jumbo from Virtueplanet has found the problem
the url for ipn posts has been changed by VM
needs in Modified file - plugins/vmpayment/paypal/paypal/helpers/paypal.php
Need to use https://ipnpb.paypal.com/cgi-bin/webscr instead of https://www.paypal.com/cgi-bin/webscr
e.g. line 274
from
$url = ($this->_method->sandbox) ? $protocol . 'www.sandbox.paypal.com' : $protocol . 'www.paypal.com';
to
$url = ($this->_method->sandbox) ? $protocol . 'ipnpb.sandbox.paypal.com' : $protocol . 'ipnpb.paypal.com';
there will be an update shortly
Thank you very much for the quick reply.
Here are some test cases,
1. I turned on sandbox environment and then tried making payment without making any changes & here is what i have in log:
(ignore *** in place of email & domain)
---------------------------------------------------------------------------
#
#<?php die("Forbidden."); ?>
2018-09-11 13:43:42 DEBUG plgVmConfirmedOrder: order number: 8NP602647
2018-09-11 13:43:42 MESSAGE plgVmConfirmedOrder: Amount/Currency stored 69.11 paymentcurrency 9 orderusercurrency9
2018-09-11 13:43:42 DEBUG PayPal request:: Array
(
[cmd] => _ext-enter
[redirect_cmd] => _xclick
[paymentaction] => sale
[upload] => 1
[business] => ***@***.com.au
[receiver_email] => ***@***.com.au
[order_number] => 8NP602647
[invoice] => 8NP602647
[custom] => eea72887edb0fee7b4981881bf2d5a79
[currency_code] => AUD
[address_override] => 0
[first_name] => James
[last_name] => Dainton
[address1] => 59 Stubbs Street
[address2] =>
[zip] => 3032
[city] => Kensington
[state] => MH
[country] => IN
[email] => ***@gmail.com
[night_phone_b] => 1300 334 741
[return] => https://www.***.com.au/index.php?option=com_virtuemart&view=vmplg&task=pluginresponsereceived&on=8NP602647&pm=4&Itemid=0&lang=en
[notify_url] => https://www.***.com.au/index.php?option=com_virtuemart&view=vmplg&task=notify&tmpl=component&lang=en
[cancel_return] => https://www.***.com.au/index.php?option=com_virtuemart&view=vmplg&task=pluginUserPaymentCancel&on=8NP602647&pm=4&Itemid=0&lang=en
[rm] => 2
[bn] => VirtueMart_Cart_PPA
[no_shipping] => 0
[no_note] => 1
[image_url] => https://www.***.com.au/images/stories/virtuemart/vendor/logo.png
[item_name] => Order Number: 8NP602647
[amount] => 69.11
)
2018-09-11 13:47:04 DEBUG plgVmOnPaymentResponseReceived: stdClass Object
(
[paypal_method] => 0
[paypal_fullresponse] => 0
[id] => 1689
[virtuemart_order_id] => 2709
[order_number] => 8NP602647
[virtuemart_paymentmethod_id] => 4
[payment_name] => <span class="vmpayment_name">Test Paypal</span> <span style="color:red;font-weight:bold">Sandbox (4)</span>
[payment_order_total] => 69.11000
[payment_currency] => 9
[email_currency] => 9
[cost_per_transaction] => 0.00
[cost_percent_total] => 0.00
[tax_id] => 0
[paypal_custom] => eea72887edb0fee7b4981881bf2d5a79
[paypal_response_mc_gross] => 0.00
[paypal_response_mc_currency] => 0
[paypal_response_invoice] => 0
[paypal_response_protection_eligibility] => 0
[paypal_response_payer_id] => 0
[paypal_response_tax] => 0.00
[paypal_response_payment_date] => 0
[paypal_response_payment_status] => 0
[paypal_response_pending_reason] => 0
[paypal_response_mc_fee] => 0.00
[paypal_response_payer_email] => 0
[paypal_response_last_name] => 0
[paypal_response_first_name] => 0
[paypal_response_business] => 0
[paypal_response_receiver_email] => 0
[paypal_response_transaction_subject] => 0
[paypal_response_residence_country] => 0
[paypal_response_txn_id] => 0
[paypal_response_txn_type] => 0
[paypal_response_parent_txn_id] => 0
[paypal_response_case_creation_date] => 0
[paypal_response_case_id] => 0
[paypal_response_case_type] => 0
[paypal_response_reason_code] => 0
[paypalresponse_raw] => 0
[created_on] => 2018-09-11 13:43:42
[created_by] => 455
[modified_on] => 2018-09-11 13:43:42
[modified_by] => 455
[locked_on] => 0000-00-00 00:00:00
[locked_by] => 0
)
---------------------------------------------------------------------------
2. I made change you suggested in plugin file & then tested with sandbox and right after i clicked on pay button on website, it took me to white page on paypal sanbox showing only this instead of login:
encrypted_cross_dispatch=dBj_5OZqrT0ylD0nfxaKBYoUgT6_o5ee6d9boXj5KLs7s2b7aVQ87DYNl9NgTwTAeK3QUMXitgFzepKANIS0vO4UQFU_27mayX1nAW
3. Then i changed to production environment keeping changes made in plugin file & it takes me to paypal login page, but i have not completed payment as i will have to get confirmation from my boss first.
Hope, there will be quick fix available for this issue.
Thanks.
Same problem here.
Have you fix it?
All my transitions are pending even if the payment is completed.