Paypay Website Auto Return not working

[4thwave]

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

[DrByte]

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?

[4thwave]

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

[4thwave]

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: 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] => rhillon3######################
[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.

[4thwave]

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

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

[DrByte]

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.

[yellow1912]

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.

[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

[yellow1912]

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/zen...ngs/paypal_ipn

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