paypal IPN woes

[wishy]

Have you tried turning on the debug for this?

Yes, I have debug on. I've looked at the resulting log files but don't really know how to diagnose the problem from that info.

[wishy]

Anyone any hints on how my PayPal log files can help identify problems? There is the following extract that looks mighty suspicious...


--------------------------
May 04 2007 8:51 -- Breakpoint: 1 - Collected data from PayPal notification

May 04 2007 8:51 -- IPN INFO :: Transaction email details.
From IPN = [email protected] | [email protected]
From CONFIG = [email protected]

May 04 2007 8:51 -- Breakpoint: 2 - Validated transaction components

May 04 2007 8:51 -- Breakpoint: 3 - Communication method verified

May 04 2007 8:51 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

May 04 2007 8:51 -- Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0

-----------------------------


tia,
wishy

[DrByte]

That debug log correctly states that:

Could not find matched txn_id record in DB. Therefore is new to us.

For a new transaction (rather than an update such as an eCheck clearance notice, etc), that is expected.

There should be several more lines in the debug output, similar to this:

May 03 2007 11:02 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

May 03 2007 11:02 -- Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0

Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id = 62V10969UC5928123

May 03 2007 11:02 -- Breakpoint: 5 - Transaction type (txn_type) = something-here

May 03 2007 11:02 -- IPN INFO :: Currency/Amount Details:
PayPal email address = mytest@my_test.com
| mc_currency = GBP
| submitted_currency = GBP
| order_currency = GBP
| mc_gross = 3.62
| converted_amount = 3.62
| order_amount = 6.84

May 03 2007 11:02 -- Breakpoint: 6 - Completed IPN order add. ordersID = 32 IPN_id=13

Was there any more info in your log? If not, then at least we know approximately "where" it's failing.


What version of PHP are you using?
What version of MySQL?

[wishy]

That debug log correctly states that:For a new transaction (rather than an update such as an eCheck clearance notice, etc), that is expected.

There should be several more lines in the debug output, similar to this:Was there any more info in your log? If not, then at least we know approximately "where" it's failing.

Yes there are more lines. Here's the full debug file with customer details and store email blanked out.

Don't know if it's relevant but set cookie gives the store server IP address

---------------------------------

May 05 2007 14:57 -- IPN PROCESSING INITIATED.
*** Originating IP: 216.113.188.202 notify.paypal.com

May 05 2007 14:57 -- IPN NOTICE :: ipn_application_top -> language files okay

May 05 2007 14:57 -- IPN INFO - POST VARS received (sorted):
Array
(
[address_city] => XXXXXXXXXXX
[address_country] => XXXXXXXXXXXXX
[address_country_code] => US
[address_name] => XXXXXXX XXXXXXXXX
[address_state] => XX
[address_status] => confirmed
[address_street] => XXXX XXXXX XXXX
[address_zip] => XXXXXX
[business] => [email protected]
[charset] => windows-1252
[custom] => zenid=4a5c61366939afd7df2cc208a2f633bb
[first_name] => XXX
[item_name] => Future Historic Purchase
[item_number] => 1
[last_name] => XXXXXX
[mc_currency] => GBP
[mc_fee] => 0.51
[mc_gross] => 7.99
[notify_version] => 2.1
[payer_email] => XXXXXXXXXXXXXXXX
[payer_id] => CWRYWEKB9BY2A
[payer_status] => verified
[payment_date] => 06:58:06 May 05, 2007 PDT
[payment_fee] =>
[payment_gross] =>
[payment_status] => Completed
[payment_type] => instant
[quantity] => 1
[receiver_email] => [email protected]
[receiver_id] => R87L7YBPSPRQS
[residence_country] => US
[shipping] => 0.00
[tax] => 0.00
[txn_id] => 8JS141025P5949601
[txn_type] => web_accept
[verify_sign] => AKwUpvimaCAfmfJ-.PhckWeGqTcrArGM-jI.FuK.RrlthLo0frKDkBOg
)


May 05 2007 14:57 -- IPN INFO - POST VARS to be sent back for validation:
To: www.paypal.com:80
POST /uk/cgi-bin/webscr HTTP/1.1
Host: www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 893
Connection: close

Array
(
[mc_gross] => 7.99
[address_status] => confirmed
[payer_id] => CWRYWEKB9BY2A
[tax] => 0.00
[address_street] => XXX XXXXX XXXX
[payment_date] => 06:58:06 May 05, 2007 PDT
[payment_status] => Completed
[charset] => windows-1252
[address_zip] => XXXXX
[first_name] => XXX
[mc_fee] => 0.51
[address_country_code] => US
[address_name] => XXX XXXXXX
[notify_version] => 2.1
[custom] => zenid=4a5c61366939afd7df2cc208a2f633bb
[payer_status] => verified
[business] => [email protected]
[address_country] => XXXXXX XXXXXXX
[address_city] => XXXXXXXXXXXX
[quantity] => 1
[verify_sign] => AKwUpvimaCAfmfJ-.PhckWeGqTcrArGM-jI.FuK.RrlthLo0frKDkBOg
[payer_email] => XXXXXXXXXXXXXXX
[txn_id] => 8JS141025P5949601
[payment_type] => instant
[last_name] => XXXXXXX
[address_state] => XX
[receiver_email] => [email protected]
[payment_fee] =>
[receiver_id] => R87L7YBPSPRQS
[txn_type] => web_accept
[item_name] => Future Historic Purchase
[mc_currency] => GBP
[item_number] => 1
[residence_country] => US
[payment_gross] =>
[shipping] => 0.00
[cmd] => _notify-validate
)


May 05 2007 14:57 -- IPN INFO - Confirmation/Validation response
HTTP/1.1 200 OK
,Date: Sat, 05 May 2007 13:58:10 GMT
,Server: Apache/1.3.33 (Unix) mod_fastcgi/2.4.2 mod_gzip/1.3.26.1a mod_ssl/2.8.22 OpenSSL/0.9.7e
,Set-Cookie: cookie_check=yes; expires=Tue, 02-May-2017 13:58:10 GMT; path=/; domain=.paypal.com
,Set-Cookie: Apache=81.21.73.35.143141178373490727; path=/; expires=Mon, 27-Apr-37 13:58:10 GMT
,Connection: close
,Transfer-Encoding: chunked
,Content-Type: text/html; charset=UTF-8
,
,8
,VERIFIED
,0
,


May 05 2007 14:57 -- Breakpoint: 1 - Collected data from PayPal notification

May 05 2007 14:57 -- IPN INFO :: Transaction email details.
From IPN = [email protected] | [email protected]
From CONFIG = [email protected]

May 05 2007 14:57 -- Breakpoint: 2 - Validated transaction components

May 05 2007 14:57 -- Breakpoint: 3 - Communication method verified

May 05 2007 14:57 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

May 05 2007 14:57 -- Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0

Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id = 8JS141025P5949601

May 05 2007 14:57 -- Breakpoint: 5 - Transaction type (txn_type) = unique

May 05 2007 14:57 -- IPN INFO :: Currency/Amount Details:
PayPal email address = [email protected]
| mc_currency = GBP
| submitted_currency = GBP
| order_currency = GBP
| mc_gross = 7.99
| converted_amount = 7.99
| order_amount = 7.99

-----------------------------------

What version of PHP are you using?

PHP Ver 5.0.3

What version of MySQL?

MySQL Ver 4.1.10a


cheers,
wishy

[DrByte]

Do you have any mods/contributions/addons installed? Which ones?

Have you made any customization changes to the order.php class or the checkout_process.php module?

[wishy]

Do you have any mods/contributions/addons installed? Which ones?

I've added, Add Customers from Admin and Capitalize Sign_Up Fields. Both to try and assist with the problem which had occurred prior.

Have you made any customization changes to the order.php class or the checkout_process.php module?

No. I'm not a coder. The Paypal process initially worked during testing but never has with real remote customers.


wishy

[Merlinpa1969]

Just for gigles,
in your paypal mod in your ZC admin,

what do you have set for the currency?

[wishy]

Just for gigles,
in your paypal mod in your ZC admin,

what do you have set for the currency?

The first one, which is called Selected Currency.

wishy

[lina0962]

Hello, Wishy:

I have exactly the same problem you did right now. When customer place an order onto my side and pay with Pay IPN, I can receive the money into my paypal account, but I don't receive any email from the Admin, and there is no new order showing in the "Order" in Admin.

Right now I am following Ajeh's suggestions and reintall a brand new Zencart 3.17 onto my server and use the original Zencart database, without adding any modules. If this problem still exists, then it must be something wrong with Paypal IPN. I will let you the result after I finish the intall and test.

Lina

[lina0962]

Hello, Wishy:

I installed the original zencart 3.7 onto the server and tested the Paypal IPN, without adding any modules. The same problem still orrured. I think it is the problem of Paypal. But you can still use Pay Express Checkout, which is still working.

Lina