Pay Pal IPN is not carring over my orders

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

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

PotzUK:

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

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

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).

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

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:lookaroun . 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.

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:
:huh:

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: https://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:
:huh:

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=Completed&amt=0.60&cc=USD&cm=zenid%3dpl7qcknl9vli7olujagpn23lh0&sig=TlWOCzMS7pXtxl4nQxHbNPf%2bJlZqD1b9IuMbHDt1FNxg7DsgpK8gtz1TMkTuM%2f%2bBOpB8QV9GxDjpX4256hAL5PbiygKHiOLTP3vxDvYeQuWOALcBVMC%2fpYQC%2bA1%2bv2rVyxvhlWFVUizGm1UxJUrmCRyxmYabPil%2bDgPBNXuznwk%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.:smartalec:

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) ? [B]substr($uri, 0, 254)[/B] : 'Unknown');

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!

Hello again Dr. Byte.
First off thank you for reply to my duplication problem. Will research into it now that I have a clue.
Modified the whos_online.php as directed and ran another test in debug mode. This time the return page was successful and returned me to the website saying the sale was successful BUT:( the items ordered are still not showing up in the invoice for customer viewing nor for admin viewing. The products ordered is 0. It still only shows the total and the shipping and the final amount. Here is the debug log for this second round:

Apr 04 2007 19:54 -- IPN PROCESSING INITIATED.
*** Originating IP: 216.113.188.202 notify.paypal.com

Apr 04 2007 19:54 -- IPN NOTICE :: ipn_application_top -> language files okay

Apr 04 2007 19:54 -- 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=3rccj7iad2rg3v0rq0t6f89rq3
[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.55
[memo] => testing 2
[notify_version] => 2.1
[payer_email] => [email protected]
[payer_id] => NF2U526WE9V4Q
[payer_status] => verified
[payment_date] => 19:54:36 Apr 04, 2007 PDT
[payment_fee] => 0.32
[payment_gross] => 0.55
[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] => 11E56244C0474863P
[txn_type] => web_accept
[verify_sign] => A-aYL-7p-tL4-6YSI5z5o.fgjcuQAoEF9LqcvNsTnH9RJrRFwJHEAL7A
)

Apr 04 2007 19:54 -- IPN INFO - POST VARS to be sent back for validation:
To: www.paypal.com:80
POST /cgi-bin/webscr HTTP/1.1
Host: https://www.paypal.com
Content-type: application/x-www-form-urlencoded
Content-length: 952
Connection: close

Array
(
[mc_gross] => 0.55
[address_status] => unconfirmed
[payer_id] => NF2U526WE9V4Q
[tax] => 0.00
[address_street] => ???????????
[payment_date] => 19:54:36 Apr 04, 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=3rccj7iad2rg3v0rq0t6f89rq3
[payer_status] => verified
[business] => [email protected]
[address_country] => United States
[address_city] => ??????
[quantity] => 1
[verify_sign] => A-aYL-7p-tL4-6YSI5z5o.fgjcuQAoEF9LqcvNsTnH9RJrRFwJHEAL7A
[payer_email] => [email protected]
[memo] => testing 2
[txn_id] => 11E56244C0474863P
[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.55
[shipping] => 0.00
[cmd] => _notify-validate
)

Apr 04 2007 19:54 -- IPN INFO - Confirmation/Validation response
HTTP/1.1 200 OK
,Date: Thu, 05 Apr 2007 02:54:40 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=Sun, 02-Apr-2017 02:54:40 GMT; path=/; domain=.paypal.com
,Set-Cookie: Apache=71.227.227.54.316021175741680628; path=/; expires=Sat, 28-Mar-37 02:54:40 GMT
,Connection: close
,Transfer-Encoding: chunked
,Content-Type: text/html; charset=UTF-8
,
,8
,VERIFIED
,0
,

Apr 04 2007 19:54 -- Breakpoint: 1 - Collected data from PayPal notification

Apr 04 2007 19:54 -- IPN INFO :: Transaction email details.
From IPN = [email protected] | [email protected]
From CONFIG = [email protected]

Apr 04 2007 19:54 -- Breakpoint: 2 - Validated transaction components

Apr 04 2007 19:54 -- Breakpoint: 3 - Communication method verified

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

Apr 04 2007 19:54 -- Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0

Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id = 11E56244C0474863P

Apr 04 2007 19:54 -- Breakpoint: 5 - Transaction type (txn_type) = unique

Apr 04 2007 19:54 -- IPN INFO :: Currency/Amount Details:
PayPal email address = [email protected]
| mc_currency = USD
| submitted_currency = USD
| order_currency = USD
| mc_gross = 0.55
| converted_amount = 0.55
| order_amount = 0.55

? marks are private info.
Here is image of customers view of the order:

Hope this helps!:smartalec:

This might be related to your customizations in the order class:
http://www.zen-cart.com/forum/showthread.php?t=58183

It appears that the first step of establishing the new order record works fine, but it's failing when linking the products to it ... which is done by the section of code you've changed to use product descriptions instead of just names/models.

We need to know whether the various tables are getting their new data when the IPN is processing:

• paypal
• paypal_payment_status_history
• orders
• orders_status_history
• orders_products

I'm guessing that only the orders_products table is missing the needed data ... which points to something failing in the order class during the create_add_products() activity.

I see where you are coming from Dr.Byte but the modification for descriptions is for my Stamp website, not for my wifes website. They are two separate carts entirely. Her cart has no modifications except for the Image Handler 2 mod. Ummm...also am using the insurance mod. Both carts run on the same server but are are in two separate htdocs and htdocs1 folders. Both are on the same Database but have separate Databases also. Hope this clarifies things.:smartalec:

Okay.

Nothwithstanding that your order-class customizations may not apply, this issue still does apply:> DrByte:

It appears that the first step of establishing the new order record works fine, but it's failing when linking the products to it ... which is done by the section of code you've changed to use product descriptions instead of just names/models.

We need to know whether the various tables are getting their new data when the IPN is processing:

• paypal
• paypal_payment_status_history
• orders
• orders_status_history
• orders_products

I'm guessing that only the orders_products table is missing the needed data ... which points to something failing in the order class during the create_add_products() activity.

So, take a look at each of those tables. Note how many records are present, and what their ID numbers are, etc. Then do a test transaction, wait for the IPN to come in, and then review the tables again. Note the differences.

OK there are 0 records in the order products table. Ran the test several times with no luck nor change. Noticed that when sent to paypal the purchase is listed as item #1 from Wildercraft Crazy Quilt Purses and Things. No items are listed in Paypal. Only the total. As stated before it returns you correctly after payment but when going to view the order same as pictured above. Her cart has no modifications to any files other than image handler 2 and insurance mod. All PayPal patch updates are installed correctly. Could PayPal have changed something to cause this? It seems that when you confirm the order the items are lost. It shows them in the cart until you confirm. Then whamo they are gone. I am at a loss on this one.:yuck:

P.S. deleted the "period" in the description code on MY site. Will see what happens on the next order from a customer. Thank you for looking at the zip file.

Have been reading other threads and see that there seems to be a tie with this problem and the MySQL 5 database. The code change you gave me for the return URL worked perfectly. Could this be a clue as to why the database is not sending paypal the full data that is in the cart and thus the data then is not sent back to the database and saved for invoices? Totally pulling at straws Dr.Byte. Will be great to get the cart completely compatible with MySQL 5. They are working on a beta version which hopefully will make the database more compatible with things like ZC. ummm it is version 5.2.:smartalec:

golowenow:

Could this be a clue as to why the database is not sending paypal the full data that is in the cart and thus the data then is not sent back to the database and saved for invoices? Totally pulling at straws Dr.Byte.

Zen Cart stores all the information internally. It does not rely on PayPal to send all the order detail back. It waits for confirmation that payment is approved, and then transfers order data from storage into the live orders tables using the normal order-preparation code.

Have to run to work. No time ATM till this evening but the site is
http://wildercraft.com
I have not looked into setting up ftp on it in a while if you cannot access it that way then i will perhaps have to change a few firewall settings ect;. Will get back to it this evening. Thank you Dr. Byte.

Must be a mysql issue because I see nothing obviously wrong in the files.

1. What's your full MySQL version number?
2. What are its configuration parameters set to? ie: perhaps the my.cnf or my.ini file?
3. What PHP version?
4. What mode is MySQL running in ? ie: run these queries and post the results:```
   SELECT @@global.sql_mode;
   SELECT @@session.sql_mode;

[.](http://dev.mysql.com/doc/refman/5.0/en/faqs-sql-modes.html)

Hello Dr. Byte.
OK here is the requested info.
Ran the queries separately on the wildercraft database. Same results when running them on all databases.

SQL result
Host: localhost
Database: wildercraft1
Generation Time: Apr 07, 2007 at 07:17 PM
Generated by: phpMyAdmin 2.10.0.2 / MySQL 5.0.27-community-nt
SQL query: SELECT @@global.sql_mode;
Rows: 1

@@global.sql_mode
STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

SQL result
Host: localhost
Database: wildercraft1
Generation Time: Apr 07, 2007 at 07:19 PM
Generated by: phpMyAdmin 2.10.0.2 / MySQL 5.0.27-community-nt
SQL query: SELECT @@session.sql_mode;
Rows: 1

@@session.sql_mode
STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Here is a copy of the My.ini file:
Attachment #1697

As previously posted I stated that the PayPal Express module is working perfectly on my STAMP website. This leads me to believe it is something in the update patches with the IPN module. Would use the Express module on the wifes site but she is not a verified PP account holder yet. Have to open a different bank account someday for her to become verified.

I am going to run a few tests tommorrow...Sunday on the stamp website to verify both modules on the STAMP website. Perhaps the Express module is capuut too:huh: and I just don't know it yet. Last few customers have used Money order module. But the last PP Express use did not have this problem. Will post again after the tests.

We all thank you Dr. Byte. Will be posting another donation as soon as funds permit:clap: