Pay Pal IPN is not carring over my orders

[golowenow]

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

[DrByte]

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.

[golowenow]

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.

[DrByte]

Okay.

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

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.

[golowenow]

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.

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.

[golowenow]

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.

[DrByte]

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.

[golowenow]

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.

[DrByte]

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;

.

[golowenow]

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:
my ini file.txt

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