Received Paypal confirmation, but no order...

Hi,

PayPal IPN is working again... Lucky me...:smartalec:

I saw an entry in 2 of my PayPal logs :-

Apr ** 2007 :* -- IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = ssl://www.paypal.com:443 (110) Connection timed out
Trying again without SSL ...

Should I worry about this...? Is there a fix or timeout parameter to change?

Order IDs and payment details are all OK.

Thanks.

What appeared on the next few lines after those messages?

DrByte:

What appeared on the next few lines after those messages?
Hi DrByte,
Thanks.
Here the rest of the log, some details are masked by 'x'

Apr 28 2007 2:50 -- IPN INFO - Confirmation/Validation response
HTTP/1.0 200 OK
,Date: Sat, 28 Apr 2007 09:50:32 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, 25-Apr-2017 09:50:32 GMT; path=/; domain=.paypal.com
,Set-Cookie: Apache=xx.xxx.xxx.xxx.1xx07xx7775xx322xx; path=/; expires=Mon, 20-Apr-37 09:50:32 GMT
,Content-Type: text/html; charset=UTF-8
,X-Cache: MISS from wc03.xxx.xxx.myhostServer.net
,Connection: close
,
,VERIFIED
Apr 28 2007 2:50 -- Breakpoint: 1 - Collected data from PayPal notification
Apr 28 2007 2:50 -- IPN INFO :: Transaction email details.
From IPN = [email protected] | [email protected]
From CONFIG = [email protected]
Apr 28 2007 2:50 -- Breakpoint: 2 - Validated transaction components
Apr 28 2007 2:50 -- Breakpoint: 3 - Communication method verified
Apr 28 2007 2:50 -- IPN NOTICE :: This transaction HAS a parent record. Thus this is an update of some sort.
Apr 28 2007 2:50 -- Breakpoint: 4 - Details: txn_type=parent ordersID = xx IPN_id=x

Relevant data from POST:
txn_type = parent
parent_txn_id = xxxxxxxxxxxxxxxxx
txn_id = xxxxxxxxxxxxxxxxx

Apr 28 2007 2:50 -- Breakpoint: 5 - Transaction type (txn_type) = parent
Apr 28 2007 2:50 -- IPN NOTICE :: Updating PP table record status for order #xx txn_id: xxxxxxxxxxxxxxxxxx PP IPN ID: x
Apr 28 2007 2:50 -- IPN NOTICE :: Set new status 1 for order ID = xx
Apr 28 2007 2:50 -- IPN NOTICE :: Updating order #xx to status: 1 (txn_type: parent)
Apr 28 2007 2:50 -- IPN NOTICE :: Update complete.

Okay - excellent. That shows a proper completion of communication, and proper order update. Thus, the second attempt it made appears to have gotten around the communication problem it had in SSL mode.

DrByte:

What appeared on the next few lines after those messages?

Thanks DrByte for your super prompt advice.
Zen Cart is really great. I have learnt a lot in the last month alone.:yes:

Do I check to make sure the correct ports are open?

Thanks for responding.

Scott

Here is the log file from my last transaction using a credit card with Paypal IPN. Any Help would be appreciated.

Thanks,

Scott

Apr 30 2007 8:29 -- IPN FATAL ERROR::No POST data available
Apr 30 2007 8:29 -- IPN FATAL ERROR::Could not find stored session in DB, cannot re-create session as PayPal IPN transaction.
Apr 30 2007 8:29 -- IPN FATAL ERROR::No saved session data available
Apr 30 2007 8:29 -- IPN NOTICE::ipn_application_top -> language files okay
Apr 30 2007 8:29 -- IPN INFO - POST VARS received:
cmd=_notify-validate
Apr 30 2007 8:29 -- IPN INFO - POST VARS sent back:
POST /cgi-bin/webscr HTTP/1.1
Host: www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 20
Connection: close
cmd=_notify-validate

Apr 30 2007 8:29 -- IPN INFO - CURL INFO confirmation report
HTTP/1.1 200 OK
,Date: Mon, 30 Apr 2007 14:29:25 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=Thu, 27-Apr-2017 14:29:25 GMT; path=/; domain=.paypal.com
,Set-Cookie: Apache=69.89.27.220.143441177943365184; path=/; expires=Wed, 22-Apr-37 14:29:25 GMT
,Connection: close
,Transfer-Encoding: chunked
,Content-Type: text/html; charset=UTF-8
,
,7
,INVALID
,0
,

Apr 30 2007 8:29 -- Breakpoint: 1 - Collected data from PayPal notification
Apr 30 2007 8:29 -- IPN WARNING::Transaction was not marked as VERIFIED. Keep this report for potential use in fraud investigations.
IPN Info =
HTTP/1.1 200 OK
,Date: Mon, 30 Apr 2007 14:29:25 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=Thu, 27-Apr-2017 14:29:25 GMT; path=/; domain=.paypal.com
,Set-Cookie: Apache=69.89.27.220.143441177943365184; path=/; expires=Wed, 22-Apr-37 14:29:25 GMT
,Connection: close
,Transfer-Encoding: chunked
,Content-Type: text/html; charset=UTF-8
,
,7
,INVALID
,0
,

Apr 30 2007 8:29 -- Breakpoint: 2 - Validated transaction components
Apr 30 2007 8:29 -- Breakpoint: 3 - Communication method verified
Apr 30 2007 8:29 -- IPN WARNING::Could not find matched txn_id record in DB
Apr 30 2007 8:29 -- Breakpoint: 4 - Details: txn_type=unique ordersID = IPN_id=
Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id =
Apr 30 2007 8:29 -- Breakpoint: 5 - Transaction type (txn_type) = unique
Apr 30 2007 8:29 -- IPN WARNING::Currency/Amount Mismatch. Details:
PayPal email address =
| mc_currency =
| submitted_currency = USD
| order_currency =
| mc_gross =
| converted_amount = 0.00
| order_amount = USD

Did I get the correct information to troubleshoot my Paypal IPN?

Scott

Fixed my problem.

I've been using filezilla to upload my files and I've been having problems with the files not updating on the server. I had issues with the USPS Click n Ship and also the Paypal Patch. For some reason when I would drag the whole file structure over some of these files weren't being moved. I got both contributions to work yesterday by moving the individual files over. It might just be me, but check the dates of your files on your server to make sure they have changed when you uploaded your files.

Scott

Thanks very much for the update and the method you had to use to get a good, valid load of the new files via filezilla to update your files ...

This will definitely be a help to others with a similar issue ... :smile:

Sbross:

Nothing shows up in admin orders. Emails are sent, but I have no idea what was ordered. Have been through the forums and applied the latest patch. Order does not show up in customers account either. ...Scott

Scott, I am having the same problem - paypal sent an email with an e-check notification and then an e-check clearing. Never did I get an order in the cart. My cart shows that the customer never placed an order.

All of my paypal instant payments seem to be working fine. Is this what you were able to fix by dragging over new files? Can I ask what files were involved?

Lori

Lori,

1. What version of Zen Cart?
2. Was this an upgrade or a fresh install? If upgrade, from which version?
3. What addons/contributions do you have installed?
4. If you're using Zen Cart v1.3.7, have you installed the latest PayPal patch?
   http://www.zen-cart.com/forum/showthread.php?t=56216
5. Have you enabled debug-logging? If not, please do. If yes, please post log files for review:
   http://www.zen-cart.com/forum/showthread.php?t=61199
6. Check the PayPal troubleshooting documentation:
   http://www.zen-cart.com/wiki/index.php/PayPal

DrByte:

1. What version of Zen Cart?
2. Was this an upgrade or a fresh install? If upgrade, from which version?
3. What addons/contributions do you have installed?
4. If you're using Zen Cart v1.3.7, have you installed the latest PayPal patch?
   http://www.zen-cart.com/forum/showthread.php?t=56216
5. Have you enabled debug-logging? If not, please do. If yes, please post log files for review:
   http://www.zen-cart.com/forum/showthread.php?t=61199
6. Check the PayPal troubleshooting documentation:
   http://www.zen-cart.com/wiki/index.php/PayPal

1)1.3.7
2)fresh install with an old/upgraded database
3)superorders 2.0, hide categories, master password, scott's cutom mod exclude group categories
4) The fresh install was a day of two before the patch, so I missed that but I am installing it now, was reading to see if that fixed this problem as it seemed a bit different than anything posted so far.
5) yes, I have had it turned on, will look into logs to see if this issue was logged.
6) I checked the documentation, could have been cross-eyed by the time I got there and missed something. Am still reading... LOL

Thank you for your patience and ideas, will post what I figure out.

Ok, I reviewed my logs, and though debug mode was on I had no info in the logs concerning the e-check error I posted about earlier in this thread. :blink:

FYI - I was/am not using paypal express, and this was the first e-check which had come through since the cart update. All other paypal payments had done exactly as they should have - no dropped ones - YIPEE!

I DID get the patches installed and configured, and I sent a test echeck payment. It DID generate an order this time, so that is good news. :clap:

I had debug and email on, and got all of the appropriate emails... the log says all is well though it does show I have an order even though the echeck has not yet cleared. I will update you when the echeck clears as I am curious as to what will happen.

Thanks everyone!!! the moral of the story, as you already know... patch first, ask questions later :laugh:

Thanks for the update so far ... let us know how it all pans out ... Patches are a wonderful thing ... :cool:

I am using v1.3.7 and tried to use the paypal session viewer both version 1 and 2 but keep getting this error.

Catchable fatal error: Object of class shoppingCart could not be converted to string in /home/miccysof/public_html/styalways/shop/admin/view_stuck_paypal_orders.php on line 88

any ideas?

Ok, new problem - I suspect it is a side effect of the ppal patch... I cannot get my master password to work now, it worked yesterday morning :oops:
I went back to my site admin and turned it off, then back on, thinking to reset it, changed it tested it - still not working.

I replaced the patch header file with the old one, and the login works.

I am guessing I need to go merge my yesterday morning files with my last night files. :smile: No big deal, but.....
thinking a little further ahead now...

Is there come reason I cannot use the master password with the paypal patch - for example does it give me access to their paypal account, etc... ??? :huh:

If that is the case and I decide I would rather have master password than paypal express (which I am not using anyway) what files do I edit to keep the echeck working and the master password? :blink:

Or am I on the wrong track??

"Master password" and "paypal" have no interdependencies or relationships.
Whatever busted it is unrelated to the PayPal patch files, assuming they were properly installed.