Pay Pal IPN is not carring over my orders

[mdegeiso]

DrByte

Yes I have installed the March 21st patch, that did not seem to resolve my problem. Since I am the host, it's most likely an issue with compiling the SSL support. I've looked at some documents and think I can work through that.

Thanks
Mike

[PotzUK]

Any word on why the IPN is truncating the phone number?

[DrByte]

Any word on why the IPN is truncating the phone number?

Let's keep the discussion about passing secondary information such as account-creation phone numbers ... as a separate issue, as this particular thread is dealing with orders not being created as expected.

Your other discussion on UK PayPal IPN is a more relevant place to discuss it:
http://www.zen-cart.com/forum/showthread.php?t=60739

[PotzUK]

Why? The OP was having the same issue as well?

[golowenow]

I too seem to have just discovered this issue on my wifes cart. We are using the IPN module exclusively. She had here first customer buy today. The order was paid but when looking at the invoice and packing slip in admin the product names are not shown. The total amount is shown and the shipping cost but no items are listed thus we did not know what items were purchased. The items are one of a kind and thus they should have gone into "SOLD" mode but they were not. Am using latest Zencart with latest PayPal patch(March 21).

[DrByte]

1. I'm guessing that you should be able to salvage the order using the PayPal Stuck Order Viewer contribution available in the downloads sectin.

2. Are you running MySQL 5 by any chance? Also, what version of PHP?

3. What is your site URL ?

4. Can you put the PayPal module into debug mode and try a test transaction and see what comes up in the logs?
http://www.zen-cart.com/forum/showthread.php?t=61199

[golowenow]

Hello Dr. Byte.
Running MySQL 5
Running PHP 5.2.1
website URL is http://wildercraft.com
Leaving for long day at work. Will start debug mode and run a test hopefully tonight. Just found the problem out yesterday. I also run my stamp website and sales via PayPal express seem to work just fine except for the duplicate description email problem which I posted in a different thread which I guess you missed. We can maybe look at that later...hehe . Still at present I do not believe the IPN module has been used by customers recently so the problem MAY occur on that site as well. I will keep eye on this post daily.
Thank you.

[golowenow]

OK Dr. Byte. Ran a test on her cart and the same situation has occured. Here is the debug log for PayPal IPN. Question marks are for private information:


Apr 03 2007 17:17 -- IPN PROCESSING INITIATED.
*** Originating IP: 216.113.188.202 notify.paypal.com

Apr 03 2007 17:17 -- IPN NOTICE :: ipn_application_top -> language files okay

Apr 03 2007 17:17 -- IPN INFO - POST VARS received (sorted):
Array
(
[address_city] => ????????
[address_country] => United States
[address_country_code] => US
[address_name] => John ????
[address_state] => WA
[address_status] => unconfirmed
[address_street] => ????????????
[address_zip] => ?????
[business] => [email protected]
[charset] => windows-1252
[custom] => zenid=pl7qcknl9vli7olujagpn23lh0
[first_name] => John
[item_name] => Wildercraft Handmade Crazy Quilt Purses & Things Purchase
[item_number] => 1
[last_name] => ????
[mc_currency] => USD
[mc_fee] => 0.32
[mc_gross] => 0.60
[notify_version] => 2.1
[payer_email] => [email protected]
[payer_id] => NF2U526WE9V4Q
[payer_status] => verified
[payment_date] => 17:17:54 Apr 03, 2007 PDT
[payment_fee] => 0.32
[payment_gross] => 0.60
[payment_status] => Completed
[payment_type] => instant
[quantity] => 1
[receiver_email] => [email protected]
[receiver_id] => ANKECA9KZT4V2
[residence_country] => US
[shipping] => 0.00
[tax] => 0.00
[txn_id] => 0CE62600C1155944V
[txn_type] => web_accept
[verify_sign] => A--8MSCLabuvN8L.-MHjxC9uypBtAP6c.0a6QqgKZp-14bO9ivA.nsLZ
)


Apr 03 2007 17:17 -- 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: 937
Connection: close

Array
(
[mc_gross] => 0.60
[address_status] => unconfirmed
[payer_id] => NF2U526WE9V4Q
[tax] => 0.00
[address_street] => ????????????
[payment_date] => 17:17:54 Apr 03, 2007 PDT
[payment_status] => Completed
[charset] => windows-1252
[address_zip] => ??????
[first_name] => John
[mc_fee] => 0.32
[address_country_code] => US
[address_name] => John ????
[notify_version] => 2.1
[custom] => zenid=pl7qcknl9vli7olujagpn23lh0
[payer_status] => verified
[business] => [email protected]
[address_country] => United States
[address_city] => ????????
[quantity] => 1
[verify_sign] => A--8MSCLabuvN8L.-MHjxC9uypBtAP6c.0a6QqgKZp-14bO9ivA.nsLZ
[payer_email] => [email protected]
[txn_id] => 0CE62600C1155944V
[payment_type] => instant
[last_name] => ????
[address_state] => WA
[receiver_email] => [email protected]
[payment_fee] => 0.32
[receiver_id] => ANKECA9KZT4V2
[txn_type] => web_accept
[item_name] => Wildercraft Handmade Crazy Quilt Purses & Things Purchase
[mc_currency] => USD
[item_number] => 1
[residence_country] => US
[payment_gross] => 0.60
[shipping] => 0.00
[cmd] => _notify-validate
)


Apr 03 2007 17:17 -- IPN INFO - Confirmation/Validation response
HTTP/1.1 200 OK
,Date: Wed, 04 Apr 2007 00:17:58 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=Sat, 01-Apr-2017 00:17:58 GMT; path=/; domain=.paypal.com
,Set-Cookie: Apache=71.227.227.54.216561175645878703; path=/; expires=Fri, 27-Mar-37 00:17:58 GMT
,Connection: close
,Transfer-Encoding: chunked
,Content-Type: text/html; charset=UTF-8
,
,8
,VERIFIED
,0
,


Apr 03 2007 17:17 -- Breakpoint: 1 - Collected data from PayPal notification

Apr 03 2007 17:17 -- IPN INFO :: Transaction email details.
From IPN = [email protected] | [email protected]
From CONFIG = [email protected]

Apr 03 2007 17:17 -- Breakpoint: 2 - Validated transaction components

Apr 03 2007 17:17 -- Breakpoint: 3 - Communication method verified

Apr 03 2007 17:17 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

Apr 03 2007 17:17 -- Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0

Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id = 0CE62600C1155944V

Apr 03 2007 17:17 -- Breakpoint: 5 - Transaction type (txn_type) = unique

Apr 03 2007 17:17 -- IPN INFO :: Currency/Amount Details:
PayPal email address = [email protected]
| mc_currency = USD
| submitted_currency = USD
| order_currency = USD
| mc_gross = 0.60
| converted_amount = 0.60
| order_amount = 0.6

Here is a copy of the info in the browser after payment was made and I was supposed to be redirected to the payment confirmed page:


1406 Data too long for column 'last_page_url' at row 1
in:
[update whos_online set customer_id = '3', full_name = '????, John', ip_address = '71.227.227.54', time_last_click = '1175645882', last_page_url = '/index.php?main_page=checkout_process&referer=paypal&tx=0CE62600C1155944V&st=Comp leted&amt=0.60&cc=USD&cm=zenid%3dpl7qcknl9vli7olujagpn23lh0&sig=TlWOCzMS7pXtxl4n QxHbNPf%2bJlZqD1b9IuMbHDt1FNxg7DsgpK8gtz1TMkTuM%2f%2bBOpB8QV9GxDjpX4256hAL5Pbiyg KHiOLTP3vxDvYeQuWOALcBVMC%2fpYQC%2bA1%2bv2rVyxvhlWFVUizGm1UxJUrmCRyxmYabPil%2bDg PBNXuznwk%3d', host_address = 'c-71-227-227-54.hsd1.or.comcast.net', user_agent = 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)' where session_id = 'pl7qcknl9vli7olujagpn23lh0' and ip_address='71.227.227.54']

Hope this helps with the IPN bug.

[DrByte]

Hmmm .... lovely MySQL 5 strict mode ...

Try editing /includes/functions/whos_online.php
line 47 says this:

  $wo_last_page_url = (zen_not_null($uri) ? $uri : 'Unknown');

try changing it to this:

  $wo_last_page_url = (zen_not_null($uri) ? substr($uri, 0, 254) : 'Unknown');

[hollygds]

I'm trying to recover an order that was an echeck done on 1.3.7 before the march 21st patch using view stuck mod in the downlaods but the 2.0 version found elsewhere. I'm running mysql5 and I get this error when I try to run the View Stuck Orders menu:

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

I haven't installed anything else that should interfere with this that I know of. Please help! Thanks!