Paypay Website Auto Return not working

Hello all,

Maybe someone will have an answer to this.
I am using ZC 1.3.8a and my payment mod is Paypal Standard.

The payment goes through with Paypal and I get both the payment receipt from Paypal as well as the seller notification from Paypal but two things are not working. The auto return to the site as well as the order page within Zen cart logging the purchase.

When Paypal initiates Auto return I get the "Page Not Found" error box.
I have worked though the following:

1. Checked with GoDaddy to see if ports 80 and 443 are open.
2. Turned Curl off in Admin.
3. Ran the ipn script.
4. Rechecked in Paypal and with Paypal mod in Admin to make sure the IPN was correct. (3 times). (As well as the site url.
5. I have run debug mode and this is what I am seeing:

IPN DEBUG message (1232219363_I6rM) #8Saturday, January 17, 2009 11:09 AM
From: "[email protected]" [email protected]Add sender to Contacts To: [email protected]: 3 - Communication method verified

AND . . .

Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0

Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id = 5PY57840H1729944F

Clueless at the moment :dontgetit

Are there any more debug log segments? There should be more than 7 breakpoints mentioned, not just 4.
What version of MySQL are you using?

Thank you for the answer!

I am using MySQL 5

These are the last two that I received.

* IPN DEBUG message (1232225724_nn9B) #9Saturday, January 17, 2009 12:55 PM
IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

IPN DEBUG message (1232225724_nn9B) #10
Breakpoint: 4 - Details: txn_type=unique ordersID = 0 IPN_id=0

Relevant data from POST:
txn_type = unique
parent_txn_id = None
txn_id = 2AA59089AJ519094V*

The auto return URL I am using is:
https://www.j w b o o k s.org/index.php?main_page=checkout_process

Here are three more debug email, these all followed the most recent test transaction.

IPN DEBUG message (1232226794_xHxv) #3

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: 841
Connection: close

Array
(
[mc_gross] => 0.15
[protection_eligibility] => Ineligible
[payer_id] => 5HJ5HR9E2ARCN
[tax] => 0.00
[payment_date] => 13:13:10 Jan 17, 2009 PST
[payment_status] => Completed
[charset] => windows-1252
[first_name] => alan
[mc_fee] => 0.15
[notify_version] => 2.6
[custom] => zenid=6iqfngulfaoe5oo4c59bpg0rd1
[payer_status] => verified
[business] => [email protected]
[quantity] => 1
[verify_sign] =>
A2YnYs6LuOd-R8BHIdbWTA6xHgalA5RkBIg-TOhM05QUIVACfj8-hyE.
[payer_email] => [email protected]
[txn_id] => 4JW260084B994093J
[payment_type] => instant
[payer_business_name] => TotalSales.Com
[last_name] => harris
[receiver_email] => [email protected]
[payment_fee] => 0.15
[receiver_id] => QC3DRV67HKNSS
[txn_type] => web_accept
[item_name] => JWBOOKS.ORG Purchase
[mc_currency] => USD
[item_number] => Store Receipt
[residence_country] => US
[handling_amount] => 0.00
[transaction_subject] => zenid=6iqfngulfaoe5oo4c59bpg0rd1
[payment_gross] => 0.15
[shipping] => 0.00
[cmd] => _notify-validate
)

IPN DEBUG message (1232226794_xHxv) #6

IPN INFO :: Transaction email details.
From IPN = info@j w b o o ks.org | info@j w b o o k s.org
From CONFIG = info@j w b o o k s.org

IPN DEBUG message (1232226794_xHxv) #9

IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

DrByte,
After further testing I found that I can consistently make a purchase, once at the Paypal site, using a credit card and the "click here to return to the jwbooks site" button takes me back to the store every time. The page not found error only occurs when I use my Paypal account to pay and Pypal initiates the redirect back to the store.

What is different between the two forms of payment or even between the two return methods???

:dontgetit

Dr, Byte,
Would I be correct in thinking that the reason that auto return works on a credit card purchase is because token info is not being passed through the sql serverin the same way?

If so then this might mean that something in the .htaccess file is causing the issue?

I am using the simple seo mod, could this be part of the problem?

4thwave:

I am using the simple seo mod, could this be part of the problem?
SEO addons have a consistent track record of breaking things. You could try disabling it as a test.

4thwave:

Dr, Byte,
Would I be correct in thinking that the reason that auto return works on a credit card purchase is because token info is not being passed through the sql serverin the same way?

If so then this might mean that something in the .htaccess file is causing the issue?

I am using the simple seo mod, could this be part of the problem?
As dr byte, disable it first to see if it works. If it does, then something is wrong, make sure you have the latest version. 3.5.7 is the current version right now. Coincidentally I have just tested xpress, ipn and payment pro yesterday on this version. No problem at all.

BTW, you may want to try http://www.jwb oo ks.org/checkout_process instead.

Thank you so much for the post!!!

I disabled SSU and lo and behold Paypal return url resolves correctly.

So, something is wrong in the install. Should I uninstall the old version before installing the new one???

A

4thwave:

Thank you so much for the post!!!

I disabled SSU and lo and behold Paypal return url resolves correctly.

So, something is wrong in the install. Should I uninstall the old version before installing the new one???

A
You dont have to, just upload the new install, make sure you read the documentation come with it carefully. After upgrading (I would suggest 3.5.7 if you have php5), if you still have problem please follow this:
http://wiki.rubikintegration.com/zencart/modules/ssu/troubleshootings/paypal_ipn

PS: also try the change I suggested earlier as well.

I looked in the add on mods section and only found 3.5.1
Where can I get the latest download???

A

4thwave:

I looked in the add on mods section and only found 3.5.1
Where can I get the latest download???

A
http://public.rubikintegration.com/

Thank you!

I will install and test in the morning. (Been at this since 6:30 this morning)

Wiil let you know tomorrow how it goes, thank's

4thwave:

Thank you!

I will install and test in the morning. (Been at this since 6:30 this morning)

Wiil let you know tomorrow how it goes, thank's
Great.Feel free to pm me if you need more help!

I decided that I had to install tonight (you know, one of those got to have it things I guess)

I competed the install and tested with Paypal IPN and everything works beautifully, included the seo urls!!!

Oh, and the install only took about 15 minutes!

Thank's for all of your help!!! :clap:

Glad you got it sorted out :)

this was the closest category that i could find for a problem that i'm having. i have paypal ipn configured, with autoreturn, and payment data tokens, and everything works fine but i have 1 bug... if someone pays using internet explorer... and they use their credit card through paypal, auto-return doesnt work! but if they use a paypal account, it works fine, and if they use firefox, it auto returns them either way.

even though it still registers the sale, and sends out a receipt, i really need auto-return to work because it registers commissions, but the commissions don't register if they don't return to the site from paypal. and its fine if the push the button to return the site, but WHY DOESNT AUTORETURN WORK IN INTERNET EXPLORER ON PAYPAL CREDIT CARD ORDERS!

(i just posted this in another category, but found this one to be more fitting)

I have a few zencart sites, with autoreturns on, and everything works great and fine, i'm using paypal ipn, and payment data tokens, as well as autoreturn, and all using one paypal account. all the sites autoreturn to their respective sites just fine, UNLESS, they use their credit card on paypals site, with Internet Explorer. If they use their paypal account with internet explorer, it workds just fine, and if they use firefox it works fine both ways.. but autoreturn doesnt register with internet explorer credit card payments thru paypal.

even tho the sale is generated, and the receipts go where theyre supposed to go, and the order registers in zencart... i need autoreturn to come back to my site to give an affiliate credit for the sale. without autoreturn, an affiliate won't get a commission unless the customer clicks on "return to merchant" button after sale. whats wrong with inernet explorer, paypal, or zencart???

sorry, update to my last message... this is a paypal problem.. ive found others tlaking about this problem in paypal developor community.. i thought firefox went around it.. i was wrong. any ways around it anyone knows of?

sorry, update to my last message... this is a paypal problem.. ive found others tlaking about this problem in paypal developor community.. i thought firefox went around it.. i was wrong. any ways around it anyone knows of?