My PayPal IPN echeck orders not completing

[sergiogold]

dear Dr Bite and all, some help will be highly appreciated.

I'have Zen cart 1.3.7 and I've installed the last paypal IPN patch (17 june), but still ,
orders paid via Paypal Echeck do not show in the admin.

Payment are received and paypal does return the client to my zen cart, but the order doesn't show and in fact is completely gone from the customer shopping cart and database.

I've also noticed that if the order come from a recurring customer, on return from paypal ( paid via echeck) , zen cart creates a duplicate order of the last paid order of this customer in the database, even if the the prior order was of different total amount and was paid with other method like 2CO.

i've included below a paypal IPN log of a failed test ( changed Ids) and I can't see a notice at the Breakpoint: 3 that may be triggering this problem ,


please help, how to fix it ? many thanks





Aug 15 2007 7:37 -- IPN PROCESSING INITIATED.
*** Originating IP: xx.xxx.xxx.xx

notify.paypal.com

Aug 15 2007 7:37 -- IPN NOTICE :: ipn_application_top -> language

files okay

Aug 15 2007 7:37 -- IPN INFO - POST VARS received (sorted):
Array
(


[business] => [email protected]
[charset] => windows-1252
[custom]

=> zenid=d96b214xxxxxxxxxxxxxxxxxxxxxxxxx
[first_name] => John
[item_name]

=> Testshop.com - Purchase
[item_number] => Store

Receipt
[last_name] => smith
[mc_currency] => USD
[mc_gross] => 0.01


[notify_version] => 2.4
[payer_business_name] => Jamesbuy
[payer_email]

=> james########################## [payer_id] => G8Vxxxxxxxxxx
[payer_status] => verified


[payment_date] => 04:36:57 Aug 15, 2007 PDT
[payment_gross] => 0.01


[payment_status] => Pending
[payment_type] => echeck
[pending_reason] =>

echeck
[quantity] => 1
[receiver_email] => [email protected]
[receiver_id]

=> RNGxxxxxxxxxx
[residence_country] => TH
[shipping] => 0.00
[tax] =>

0.00
[txn_id] => 65Y5xxxxxxxxxxxx [txn_type] => web_accept
[verify_sign]

=> AZxbwZ9bPVPFFfxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
)


Aug 15 2007 7:37 --

IPN INFO - POST VARS to be sent back for validation:
To: www.paypal.com:80
POST

/cgi-bin/webscr HTTP/1.1
Host: www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 786
Connection: close

Array
(
[payment_date] => 04:36:57 Aug 15, 2007 PDT
[txn_type] => web_accept


[last_name] => Smith
[residence_country] => TH
[pending_reason] => echeck


[item_name] => Testshop.com - Purchase
[payment_gross] => 0.01


[mc_currency] => USD
[business] => [email protected]
[payment_type] => echeck


[verify_sign] => AZxbwZ9bPVPFFfxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


[payer_status] => verified
[tax] => 0.00
[payer_email] => james##########################


[txn_id] => 65Y5xxxxxxxxxxxx [quantity] => 1
[receiver_email] =>

[email protected]
[first_name] => James
[payer_id] => G8Vxxxxxxxxxx


[receiver_id] => RNGxxxxxxxxxx
[item_number] => Store Receipt


[payer_business_name] => Jamesbuy
[payment_status] => Pending
[shipping] =>

0.00
[mc_gross] => 0.01
[custom] => zenid=d96b214xxxxxxxxxxxxxxxxxxxxxxxxx


[charset] => windows-1252
[notify_version] => 2.4
[cmd] => _notify-validate
)


Aug 15 2007 7:37 -- IPN INFO - Confirmation/Validation response
SUCCESS

Aug 15 2007

7:37 -- Breakpoint: 1 - Collected data from PayPal notification

Aug 15 2007 7:37 --

IPN INFO :: Transaction email details.
From IPN = [email protected] |

[email protected]
From CONFIG = [email protected]

Aug 15 2007 7:37 -- Breakpoint: 2 -

Validated transaction components

Aug 15 2007 7:37 -- Breakpoint: 3 - Communication

method verified

Aug 15 2007 7:37 -- IPN NOTICE :: Could not find matched txn_id

record in DB. Therefore is new to us.

Aug 15 2007 7:37 -- Breakpoint: 4 - Details:

txn_type=unique ordersID = 0 IPN_id=0

Relevant data from POST:
txn_type =

unique
parent_txn_id = None
txn_id = 65Y5xxxxxxxxxxxx

Aug 15 2007 7:37 --

Breakpoint: 5 - Transaction type (txn_type) = pending-echeck

[DrByte]

Does the order show up properly after the echeck clears ?

[sergiogold]

dera Dr Byte, Thanks for your reply.


this is getting worse, I have detected 2 scenarios:


scenario 1-

a completely new customer register, checkout and pay via PAYPAL ECHECK, upon return to my website , the checkout_sucess page displays a " 500 INTERNAL SERVER error page".
No sign of the order in the database but I do get the echeck payment email notice from paypal.

I have created 4 new customers and tested , and each time happen the same, paypal return to a 500 internal server error page.


scenario 2-

a return customer checkout and pay via paypal echeck, upon return to my website , the checkout_sucess page displays a confirmation with the ID number of the prior existing order of this customer in the database.


I will have to wait a couple of days for the test transactions checks to clear before I will know, however, even if the orders latter show up in the admin , why is that the checkout_success page is displaying a 500 INTERNAL SERVER ERROR, rather than the order confirmation ?

I also can't see any data of those orders into my mysql database tables, so I can't understand how possible paypal IPN return could suddenly create those orders data with detail.


Again, I have problems ONLY with paypal echeck, normal paypal payments works fine.


Please help
many thanks

[DrByte]

What contributions/addons do you have installed?
What is your server's errorlog saying when you get the 500 errors?
What currencies are enabled in your store?
What currencies is your ZC PayPal module setup to accept?
How much of the log files get written when you get the 500 errors ?

[sergiogold]

I lost count how many modules we have installed and how many more we did. but we have heavy customized.

However, we have no other errors and any conflicts we may get, we can usually resolve as they come.
But we are completely newbies dealing with paypal api, so, we are really stuck with this one

what modules could be causing this ?

I have enabled currency: USD, CAN, GBP, AUD, JPY, EUR, SEK, CHF, FRF

ZC paypal module set to : " Selected Currency"

about the error logs, it's strange but I could not see a single mention of 500 internal server error pages in the logs.

I could see some error logs with the godaddy seal contribution , so to be sure I have deleted all the files on that contribution, but seems to be no related.

I don't know what else to do.

[sergiogold]

I've done many many tests and still I get the 500 internal server error page , every time a new customer return to ZC from a paypal echeck payment

NOTE: that I do get the order confirmation mail ( as a store owner) but empty , without data, neither Order ID
The buyer doesn't get the order confirmation, but yes get the paypal receipt

Please note:

I do not have SEO URLs installed.

I have the original html_output file

I have installed the latest paypal patch ( 17 june)

I've removed completely .htaccess file

there are several errors in my server log file, but they seems to be relate to some missing older files of my prior website at this domain.

However, there is 1 line originated at my IP, that may be significant, which I think match the time of a test transaction, please see below:


[Thu Aug 16 14:06:06 2007] [error] [client xxx.xxx.xxx.xxx] malformed header from script. Bad header=No recipient addresses found i: /hsphere/local/home/silversi/xxxxx.com/index.php


is this error mean something to you ?


This 2 errors below , also originate at my IP and keeps repeating a lot


[Thu Aug 16 13:55:41 2007] [error] [client xxx.xxx.xxx.xxx] File does not exist: /hsphere/local/home/silversi/xxxxxx.com/favicon.ico

[Thu Aug 16 14:06:11 2007] [error] [client xxx.xxx.xxx.xxx] File does not exist: /hsphere/local/home/silversi/xxxxxxx.com/index.php_files/jscript_imagehover.js



please help me out, lost 2 days on this, I'm completely frustrated

many thanks

[lucky__starre]

I'm using zencart 1.3.7 with the latest paypal patch.

I received an echeck payment today that didn't give me any store notification, all I got was a confirmation from Paypal, this is the first echeck I've recieved so far.
I didn't have the bug files turned on but I have since turned them on & attempted to test another order but Paypal seems to be failing, I wasn't even redirected.

Here's a copy of the error log:

[bn] => zencart
[cmd] => _ext-enter
[rm] => 2
[mrb] => R-6C7952342H795591R
[pal] => 9E82WJBKKGPLQ
[page_style] => Primary
[lc] => AU
[custom] => zenid=8c6f2da11b0a5f544edcbdc3b8bef130
[charset] => iso-8859-1
[return] =>
https://web29.secure-secure.co.uk/live2knit.com.au/store/index.php?main_page=checkout_process&referer=paypal&zenid=8c6f2da11b0a5f544edcbd c3b8bef130
[cancel_return] =>
https://web29.secure-secure.co.uk/live2knit.com.au/store/index.php?main_page=checkout_payment&zenid=8c6f2da11b0a5f544edcbdc3b8bef130
[shopping_url] =>
https://web29.secure-secure.co.uk/live2knit.com.au/store/index.php?main_page=shopping_cart&zenid=8c6f2da11b0a5f544edcbdc3b8bef130
[notify_url] =>
https://web29.secure-secure.co.uk/live2knit.com.au/store/ipn_main_handler.php
[redirect_cmd] => _xclick
[business] => live2knit AT live2knit DOT com DOT au
[first_name] => xxx
[last_name] => xxxx
[address1] => xxxx
[city] => xxxx
[state] => xxxx
[zip] => xxxx
[country] => AU
[email] => xxxx
[H_PhoneNumber] => xxxx
[night_phone_b] => xxxx
[day_phone_b] => xxx
[no_shipping] => 1
[currency_code] => AUD
[paypal_order_id] =>
[item_name] => Live 2 Knit Purchase
[item_number] => Store Receipt
[upload] => 2
[amount] => 60.90
[shipping] => 0.00
[tax] => 0.00
[tax_cart] => 0.00

Please help as Paypal, has been working fine up till now.

Katie
www.live2knit.com.au

[mydanilo]

OK, I just got another echeck paypal payment. No order in my cart. I see the payment in my paypal account. I have the debug files.

Dr Byte, you can download the log files as you requested. I will PM you with the location.

BTW I noticed that I had the Instant Payment Notification Preferences ON. I use this PayPal account with two different websites and I realized that the return path was set to the other site! I guess this does not help ether.... I turned it off for now.

[mydanilo]

Now I'm confused, will the PayPal IPN still work if I set this in the pref in paypal profile.

Instant Payment Notification (IPN) Off
Instant Payment Notification (IPN) URL: (blank)

Will I still receive payments in paypal but no notice gets sent to my cart about the status? I guess this would be ok if I at least would see the order in my zen cart!

[DrByte]

Now I'm confused, will the PayPal IPN still work if I set this in the pref in paypal profile.

Instant Payment Notification (IPN) Off
Instant Payment Notification (IPN) URL: (blank)

Will I still receive payments in paypal but no notice gets sent to my cart about the status? I guess this would be ok if I at least would see the order in my zen cart!

No .. if you are using the IPN module in Zen Cart, then you need the IPN service turned on in your PayPal profile.
Otherwise you'll never get anything back in Zen Cart.