My PayPal IPN echeck orders not completing

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]

=> [email protected] [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: https://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] => [email protected]

[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

Does the order show up properly after the echeck clears ?

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

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 ?

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.

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

What happens if you go to www.your_site.com/ipn_main_handler.php with your browser?

Do you have PDT configured?

yes I have PDT configured.

I see this message at page ipn_main_handler

" Nothing to process. Please return to home page"

I have tested the connection with IPN tool and I get this:

IPNCHECK.PHP - Version 1.0

IPN TESTING - POSTING to PayPal via: ssl://www.paypal.com:443

IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = ssl://www.paypal.com:443 (136581300) Unable to find the socket transport "ssl" - did you forget to enable it when you configured PHP?

Trying again without SSL ...

IPN TESTING - Confirmation/Validation response: RESPONSE RECEIVED - Communications OKAY

Script finished.

allow_url_fopen is off by default at my unix server , but I've added an .htaccess file ( php_value allow_url_fopen 1) to open it as per my server admin instructions

the connection seems to work ok because regular paypal orders return fine , the problem is with echecks payments.

The peculiar thing is that the return process for echecks is no different from the process for non-echecks.

thanks god, my top programer just figured out the internal server error and it fixed, I was going nut.

It was something to do with a modification we did to the orders auto mailer system.

Still echeck orders do not show in the admin, so I'm waiting to see what will happen within a day or 2 once pending echeck orders clears.

I have a client who just called me with this problem also. She is using Zen Cart 1.3.7 with all patches installed.

Even after the eCheck clears the order does not show up in her admin panel. This has happened twice in the last month.

Thanks,
Denise

today checks have cleared and no sign of the orders at the admin.

I suspected that will be the case, since there is no trace of the orders at the database.

PDT is configured. paypal patch is installed, all setup as per instructions, only eChecks is problem

What can we do next ?, please dr Bite, help us !

many thanks

dr Byte , please some help on this, you are our only hope to fix this !!

Can you download your paypal debug log files, zip them, upload the file to your server, and PM me with a link to the zip? Reviewing them will help determine trends and hopefully cause.

sergiogold:

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 ?I wouldn't expect that error to show up with Zen Cart, since Zen Cart usually validates all email traffic before actually sending a message. Everthing I've seen on Google about that error message suggests that somehow you've got a script that's attempting either to send to a blank email address or the mailserver has an odd configuration that wants its email parameters sent in a different order than what is being supplied.
Zen Cart doesn't accept blank email addresses, so I'm not sure if that error is happening as a result of Zen Cart processing or some other script on your site.

Even if it was a result of bad data coming back from PayPal, Zen Cart still shouldn't attempt to send an email to a blank address ... it should just ignore the whole transaction because the data is not valid.

Again, more paypal logs will help to understand the problem more clearly.
A list of installed mods/contributions and the kinds of customizations you've done to your site would also be a help.

Dr Byte,
This is happening to me as well and has been happening for a month or 2 now. I just had one this morning. It was a paypal echeck, there is nothing listed when I look at the paypal IPN linkin admin. I am at a loss cause I see the uncleard payment in the paypal account but no sign of the order on the site. I can also tell you that in my cart it skipped the order number. I have 582, 584 and 585.. Order 583 would have been placed around the time the customer for the echeck ordered it. But it is no where to be found. I even went through the database and there is no records of it at all that I can find. PLEASE HELP

Rich Fallon
Foilman.com

Logs will be a big help ...

Dr Byte,
I thought I had my logs turned on, but apparently I did not. I just turned them on this morning and I will get you a log from testing ASAP.

Thanks,
Rich Fallon
Foilman.com

I have just been informed that we are having the same problem. I have recently update to the latest zen cart.

On our old one echecks worked fine, but since I have installed the new zen cart they dont show up in the admin at all?!?!