Help! Orders are NOT recording

[IncrediBody.com]

I am having the exact same problem so this must be a problem with either Zen Cart or Paypal. It only happens certain times the customer pays with paypal, but not everytime. I've had it happen twice so far. Any ideas?

[IncrediBody.com]

I think my problem may have been that our web hosting company changed the location of our secure server which we forgot to update with Paypal, although a paypal payment did show up in our Zencart orders since that time, so I'm not exactly sure how that happened. I just tried a test order and everything was okay, but the problem happened rarely, so I can't be 100% confident this is solved.

[DrByte]

For the orders that "didn't" show up, did the customer pay without having a PayPal account? If so, then maybe they failed to click "no" on the button PayPal presented asking them whether they wanted to create a PayPal account. If they don't respond to that question, then the IPN notice from PayPal never gets sent ... and thus your store will never hear about the order.
That's a design flaw on PayPal's end.

[thebeveragegourmet]

I'm having the same problem as well. If I do a test order, it comes through just fine. I have had paypal orders show up in the admin and 3 or 4 that have not. 2 from the same person. It's frustrating

[pricediscrimination]

DrByte, can you or anyone else please help me.

I have read every post I could find, including the wiki page.

I am using PayPal IPN. The orders are coming through PayPal but no order details are available in my cart (I can't even find the details in my database or by using the "view PayPal stuck orders" mod).

I checked the /ipn_main_handler.php page and there was a an error coming across as:

Warning: strstr(): Empty delimiter. in /home/content/site/includes/functions/functions_email.php on line 103

So I went to line 103 and it was for the email spam disclaimer. I went to the languages file and saw that I removed all the text in the quotes for email spam disclaimer, so I put some text in and rechecked the /ipn_main_handler.php and am now getting:

Nothing to process. Please return to home page.

I turned the debugging mode on in the IPN module and here are some of the emails I am getting:

IPN FATAL ERROR :: No POST data available -- Most likely initiated by
browser and not PayPal.

IPN INFO - POST VARS received (sorted):
Array
(
)

IPN PROCESSING INITIATED.
*** Originating IP: 66.211.170.66 notify.paypal.com

IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = http://proxy.shr.secureserver.net:80 (0) Success

http://www.paypal.com/cgi-bin/webscr
Trying again without specified protocol ...

IPN FATAL ERROR :: Could not find stored session in DB, cannot re-create
session as PayPal IPN transaction.

Any ideas? I have double checked to make sure everything is set up ok in the module and at paypal. I do not have any SEO add ons, although I did make an adjustment to the .htaccess file for one of the links on the site. But that should have nothing to do with this because it's just a category page.

[pricediscrimination]

BTW, the ipncheck.php comes back as

IPNCHECK.PHP - Version 1.0
IPN TESTING - POSTING to PayPal via: ssl://www.paypal.com:443
IPN TESTING - Confirmation/Validation response: RESPONSE RECEIVED - Communications OKAY
Script finished.

Just as well, I shut off all tax options on the site in both admin and shipping modules.

[DrByte]

After fixing your email disclaimer problem, I would suggest you delete the existing debug logs, and then do another transaction. Then report what appears in the log files.
Note: the debug emails can be hard to follow. Use the files instead.

[pricediscrimination]

I have done what you said. I deleted the previous logs, turned the debugging mode back on, and completed a new transaction. This time, when I was redirected to this page with a long string:

http://website.com/index.php?main_pa...C5IWVo2eI9M%3d

I got this message:

2013 Lost connection to MySQL server during query
in:
[select customers_email_format from zen_customers where customers_email_address= '[email protected]']

I think it's because I had the Payment data Transfer option turned on (sometime between trying to figure this problem out) because once I turned it off I was redirected to the correct "/index.php?main_page=checkout_success" page. BTW, is it supposed to take so long to redirect? It really takes more than 10 seconds!


Anyways, back to the point... it still only sends paypal confirmations and no order confirmations.

Some logs:

Oct 05 2008 23:49 -- IPN PROCESSING INITIATED.
*** Originating IP: 33.333.170.66 notify.paypal.com

Oct 05 2008 23:49 -- IPN INFO - POST VARS received (sorted):
Array
(
[business] => email######################
[charset] => windows-1252
[custom] => zenid=f42bb0192d1265132bb212bdaa663eb3
[first_name] => name
[item_name] => StorePurchase
[item_number] => Store Receipt
[last_name] => name
[mc_currency] => USD
[mc_gross] => 0.10
[notify_version] => 2.5
[payer_email] => email######################
[payer_id] => qqqqqqqqqqqqqq
[payer_status] => verified
[payment_date] => 23:49:33 Oct 05, 2008 PDT
[payment_gross] => 0.10
[payment_status] => Pending
[payment_type] => instant
[pending_reason] => address
[protection_eligibility] => None
[quantity] => 1
[receiver_email] => email######################
[receiver_id] => qqqqqqqqqqqqqq
[residence_country] => US
[shipping] => 0.00
[tax] => 0.00
[txn_id] => qqqqqqqqqqqqqq
[txn_type] => web_accept
[verify_sign] => An5ns1Kso7MWUdW4ErQKJJJ4qi4-Ay3o1o-uStCiX-3fRarLv5ifh0K6
)


Oct 05 2008 23:49 -- IPN INFO - POST VARS to be sent back for validation:
To: http://proxy.shr.secureserver.net:3128
POST http://www.paypal.com/cgi-bin/webscr HTTP/1.1
Host: proxy.shr.secureserver.net
Content-type: application/x-www-form-urlencoded
Content-length: 732
Connection: close

Array
(
[txn_type] => web_accept
[payment_date] => 23:49:33 Oct 05, 2008 PDT
[last_name] => name
[residence_country] => US
[pending_reason] => address
[item_name] => Store Purchase
[payment_gross] => 0.10
[mc_currency] => USD
[business] => email######################
[payment_type] => instant
[protection_eligibility] => None
[verify_sign] => An5ns1Kso7MWUdW4ErQKJJJ5645645o--
[payer_status] => verified
[tax] => 0.00
[payer_email] => email######################
[txn_id] => qqqqqqqqqqqqqq
[quantity] => 1
[receiver_email] => email######################
[first_name] => name
[payer_id] => qqqqqqqqqqqqqq
[receiver_id] => qqqqqqqqqqqqqq
[item_number] => Store Receipt
[payment_status] => Pending
[shipping] => 0.00
[mc_gross] => 0.10
[custom] => zenid=f42bb0192d1265132bb212bdaa663eb3
[charset] => windows-1252
[notify_version] => 2.5
[cmd] => _notify-validate
)


Oct 05 2008 23:49 -- IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = http://proxy.shr.secureserver.net:3128 (0) Success

http://www.paypal.com/cgi-bin/webscr
Trying again without SSL ...

Oct 05 2008 23:49 -- IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = http://proxy.shr.secureserver.net:80 (0) Success

http://www.paypal.com/cgi-bin/webscr
Trying again without specified protocol ...

Oct 05 2008 23:49 -- IPN INFO - POST VARS to be sent back for validation:
To: http://proxy.shr.secureserver.net:3128
POST http://www.paypal.com/cgi-bin/webscr HTTP/1.1
Host: proxy.shr.secureserver.net
Content-type: application/x-www-form-urlencoded
Content-length: 101
Connection: close

Array
(
[cmd] => _notify-sync
[tx] => 06N77316CT864515B
[at] => bttvB**********vatXy
)


Oct 05 2008 23:49 -- IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = http://proxy.shr.secureserver.net:3128 (0) Success

http://www.paypal.com/cgi-bin/webscr
Trying again without SSL ...

Oct 05 2008 23:49 -- IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = http://proxy.shr.secureserver.net:80 (0) Success

[pricediscrimination]

Ok, I've been working on this all day. And after more digging I found this thread about IPN not working with GoDaddy as a host.

I shut off the cURL in Admin>My Store>cURL Proxy Status
Now it seems to be working!

Strange though, the emails are coming across as "SEND_EXTRA_NEW_ORDERS_EMAILS_TO_SUBJECT Order Confirmation No: 45" ???

I knew I wasn't crazy, IPN was working just fine, and it seems that this issue was discovered around September 2008.

DrByte, the question is, should I keep cURL off? Or should I follow your fix in this thread?

Two more side questions if I may: should I leave off the Payment Data Transfer? And is it supposed to take so long for the redirect to occur from PayPal to the checkout_success?

[pricediscrimination]

One more very important note that I just found out... When I go to PayPal and accept one of the test payments, it sends me the confirmation email that should have been sent before. What's this all about?