paypal Error email message from my website [SOLVED]

[guardiano78]

Hello,
after updated joomla and virtuemart to latest versions, i have problem for PayPal payment.

For example, the customer purchase from my website an item for €. 0,50 (22% vat included).
He completed the order and did the payment correctly; in fact PayPal notify to the email of seller (me), the payment received.
But now we have problems:
1. Order status remain to Pending and customer do not get order email
2. The seller do not get email order but receive an email from website with an error message stored in  file language: COM_VIRTUEMART_ERROR_SUBJECT

in italian language "Errore con il pagamento %s nel tuo negozio %s" and tell to check in the log file paypal.4.log.php

this is what i have in paypal.4.log.php

Code Select Expand



2018-07-13 15:40:39 ERROR IPN notification with invalid amount or currency or email: Array
(
    [paypal_data] => Array
        (
            [mc_gross] => 0.50
            [invoice] => 55
            [protection_eligibility] => Eligible
            [address_status] => confirmed
            [payer_id] => Z7Q7E9VRQVHAL
            [address_street] => fifth street
            [payment_date] => 08:40:33 Jul 13, 2018 PDT
            [payment_status] => Completed
            [charset] => windows-1252
            [address_zip] => 70054
            [first_name] => Ignazio
            [mc_fee] => 0.37
            [address_country_code] => IT
            [address_name] => ignazio
            [notify_version] => 3.9
            [custom] => f7148c90edc919a9978b81da715de1b0
            [payer_status] => verified
            [business] => emailpaypal@libero.it
            [address_country] => Italy
            [address_city] => Bari
            [quantity] => 1
            [verify_sign] => AHN347pvyl7zuFLkOBxIkNF3K5F6ASe9lLlJlCWwgPkwVw1Fi-m.5Vdn
            [payer_email] => customer_email@gmail.com
            [txn_id] => 28J10020TK9090029
            [payment_type] => instant
            [last_name] => Rossi
            [address_state] => BA
            [receiver_email] => emailpaypal@libero.it
            [payment_fee] =>
            [shipping_discount] => 0.00
            [insurance_amount] => 0.00
            [receiver_id] => XES6PPU8SGETC
            [txn_type] => web_accept
            [item_name] => Ordine Numero: 55
            [discount] => 0.00
            [mc_currency] => EUR
            [item_number] =>
            [residence_country] => IT
            [shipping_method] => Default
            [transaction_subject] =>
            [payment_gross] =>
            [ipn_track_id] => e7425c5cf690
        )

    [payment_order_total] => 21.86000
    [currency_code_3] => EUR
    [testing Total-mc-gross] => 21.36
    [testing Compare] => 0.0005
    [testing Result] => 0
)


I tried to make an order with PayPal option "Check IPN provider IP" disabled ... but i get the same result.

I must tell that i have this problem with paypal standard in "production".
If i make an order in paypal standard "sandbox", i have not those problems.

Can anyone help me?
Thanks.



Joomla 3.8.10 + Virtuemart 3.2.14

[GJC Web Design]

how is your [payment_order_total] => 21.86000 and your  [mc_gross] => 0.50  ?

the comparison is   Total-mc-gross

[guardiano78]

Hello GJC Web Design,

I found where the problem is!

In the table #__virtuemart_payment_plg_paypal there were more than one line with the same "order number".
Surely I had forgotten to empty it before putting the site online.
Thanks for your help.