VirtueMart Forum

VirtueMart 2 + 3 + 4 => Plugins: Payment, Shipment and others => Topic started by: guardiano78 on July 13, 2018, 18:29:08 PM

Title: paypal Error email message from my website [SOLVED]
Post by: guardiano78 on July 13, 2018, 18:29:08 PM
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



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
Title: Re: paypal Error email message from my website
Post by: GJC Web Design on July 13, 2018, 19:44:52 PM
how is your [payment_order_total] => 21.86000 and your  [mc_gross] => 0.50  ?

the comparison is   Total-mc-gross
Title: Re: paypal Error email message from my website
Post by: guardiano78 on July 14, 2018, 10:37:07 AM
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.