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

[DrByte]

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

Do you have PDT configured?

[sergiogold]

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

[sergiogold]

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

[DrByte]

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