Server OS: Windows NT ENEXSQL 5.2 build 3790
HTTP Server: Microsoft-IIS/6.0
Database: MySQL 5.0.37-community-nt
PHP Version: 5.2.8 (Zend: 2.2.0)
Zen Cart 1.3.8a
Database Patch Level: 1.3.8
mods: VAT mod 1.5.1, Admin pw mod, Orders mod (not super orders), Image Handler 2
I am all of a sudden receiving IPN errors via paypal. Just the other week paypal payments were fine and transactions were being created.
I have read the below posts and here are some findings
http://www.zen-cart.com/forum/showthread.php?t=119431
http://www.zen-cart.com/forum/showthread.php?t=128248
http://www.zen-cart.com/forum/showthread.php?t=90695
http://www.zen-cart.com/forum/showthread.php?t=73123
http://www.zen-cart.com/wiki/index.php/PayPal
i'm pretty sure it has something to do with fsocket -- but it's enabled and has been for the past few months.
1. https://www.mysite.com/ipn_main_handler.php --> Nothing to process. Please return to home page.
as expected. debug code confirms.
2. all paypal payment module settings correct
3. all paypal.com settings correct (redirect, Ipn auto redirect, etc)
4. curl proxy disabled in admin\my store
5. ssl certificate added to list of certificates on paypal site. not a self-signed certificate
6. allow_url_fopen ON
7. when running https://www.mysite.com/extras/ipncheck.php:
Code:
IPNCHECK.PHP - Version 1.0
IPN TESTING - POSTING to PayPal via: ssl://www.paypal.com:443
Warning: fsockopen() [function.fsockopen]: unable to connect to ssl://www.paypal.com:443 (Unable to find the socket transport "ssl" - did you forget to enable it when you configured PHP?) in <removed>\catalog\extras\ipncheck.php on line 81
IPN FATAL ERROR :: Could not establish fsockopen.
Host Details = ssl://www.paypal.com:443 (24) 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: FAILED
Script finished.
8. to check if function fsockopen exists i run a simple check which returns: Function exists
Code:
<?php
If(function_exists("fsockopen")){
echo 'Function Exists';
}
Else{
echo 'function does not exist';
}
?>
9. Below is my debug code (several files) for a transactions that paypal accepts but does not issue a new order for. As mentioned in post http://www.zen-cart.com/forum/showthread.php?t=119431 paypal is using the previous order number for a new order.
File1
Code:
Oct 14 2009 21:14 -- Keys for submission: Array
(
[charset] => iso-8859-2
[lc] => US
[page_style] => Primary
[custom] => zenid=5m0qt7bhiga81ou2bj6qo72fi7
[business] => <removed: private data>
[return] => https://<removed: private data>/index.php?main_page=checkout_process&referer=paypal
[cancel_return] => https://<removed: private data>/index.php?main_page=checkout_payment
[shopping_url] => https://<removed: private data>/index.php?main_page=shopping_cart
[notify_url] => https://<removed: private data>/ipn_main_handler.php
[redirect_cmd] => _xclick
[rm] => 2
[bn] => zencart
[mrb] => <removed: private data>
[pal] => <removed: private data>
[first_name] => <removed: private data>
[last_name] => <removed: private data>
[address1] => <removed: private data>
[city] => <removed: private data>
[state] => <removed: private data>
[zip] => <removed: private data>
[country] => <removed: private data>
[email] => <removed: private data>
[H_PhoneNumber] => <removed: private data>
[night_phone_a] => <removed: private data>
[night_phone_b] => <removed: private data>
[night_phone_c] => <removed: private data>
[day_phone_a] => <removed: private data>
[day_phone_b] => <removed: private data>
[day_phone_c] => <removed: private data>
[no_shipping] => 1
[upload] => 1
[currency_code] => EUR
[cmd] => _ext-enter
[item_name] => <removed: private data>
[item_number] => Store Receipt
[amount] => 0.01
[shipping] => 0.00
[tax] => 0.00
[tax_cart] => 0.00
)
File2
Code:
Oct 14 2009 21:15 -- IPN INFO - POST VARS to be sent back for validation:
To: www.paypal.com:80
POST /uk/cgi-bin/webscr HTTP/1.1
Host: www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 101
Connection: close
Array
(
[cmd] => _notify-sync
[tx] => <removed: private data>
[at] => <removed: private data>
)
Oct 14 2009 21:15 -- IPN INFO - Confirmation/Validation response
0
Oct 14 2009 21:16 -- IPN WARNING :: PDT Transaction was not marked as SUCCESS. Keep this report for potential use in fraud investigations.
IPN Info =
0
File3
Code:
Oct 14 2009 21:15 -- PDT Returned Data Array
(
)
Oct 14 2009 21:16 -- PDT WARNING :: Order not marked as "Completed". Check for Pending reasons or wait for IPN to complete.
[payment_status] =>
[pending_reason] =>
Oct 14 2009 21:16 -- PDT WARNING :: Transaction already exists. Perhaps IPN already added it. PDT processing ended.
File4
Code:
Oct 14 2009 21:15 -- IPN PROCESSING INITIATED.
*** Originating IP: 66.211.170.66 notify.paypal.com
Oct 14 2009 21:15 -- IPN INFO - POST VARS received (sorted):
Array
(
[business] => <removed: private data>
[charset] => windows-1250
[custom] => zenid=5m0qt7bhiga81ou2bj6qo72fi7
[first_name] => <removed: private data>
[handling_amount] => 0.00
[item_name] => <removed: private data>
[item_number] => Store Receipt
[last_name] => <removed: private data>
[mc_currency] => EUR
[mc_fee] => 0.01
[mc_gross] => 0.01
[notify_version] => 2.8
[payer_email] => <removed: private data>
[payer_id] => <removed: private data>
[payer_status] => unverified
[payment_date] => 12:15:37 Oct 14, 2009 PDT
[payment_fee] =>
[payment_gross] =>
[payment_status] => Completed
[payment_type] => instant
[protection_eligibility] => Ineligible
[quantity] => 1
[receipt_id] => <removed: private data>
[receiver_email] => <removed: private data>
[receiver_id] => <removed: private data>
[residence_country] => US
[shipping] => 0.00
[tax] => 0.00
[transaction_subject] => zenid=5m0qt7bhiga81ou2bj6qo72fi7
[txn_id] => <removed: private data>
[txn_type] => web_accept
[verify_sign] => <removed: private data>
)
Oct 14 2009 21:16 -- IPN INFO - POST VARS to be sent back for validation:
To: www.paypal.com:80
POST /uk/cgi-bin/webscr HTTP/1.1
Host: www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 857
Connection: close
Array
(
[mc_gross] => 0.01
[protection_eligibility] => Ineligible
[payer_id] => <removed: private data>
[tax] => 0.00
[payment_date] => 12:15:37 Oct 14, 2009 PDT
[payment_status] => Completed
[charset] => windows-1250
[first_name] => <removed: private data>
[mc_fee] => 0.01
[notify_version] => 2.8
[custom] => zenid=5m0qt7bhiga81ou2bj6qo72fi7
[payer_status] => unverified
[business] => <removed: private data>
[quantity] => 1
[verify_sign] => <removed: private data>
[payer_email] => <removed: private data>
[txn_id] => <removed: private data>
[payment_type] => instant
[last_name] => <removed: private data>
[receiver_email] => <removed: private data>
[payment_fee] =>
[receiver_id] => <removed: private data>
[txn_type] => web_accept
[item_name] => <removed: private data>
[mc_currency] => EUR
[item_number] => Store Receipt
[residence_country] => US
[receipt_id] => <removed: private data>
[handling_amount] => 0.00
[transaction_subject] => zenid=5m0qt7bhiga81ou2bj6qo72fi7
[payment_gross] =>
[shipping] => 0.00
[cmd] => _notify-validate
)
Oct 14 2009 21:16 -- IPN INFO - Confirmation/Validation response
0
Oct 14 2009 21:16 -- Breakpoint: 1 - Collected data from PayPal notification
anything i failed to check?
Bookmarks