Orders not showing up in Paypal or ZC admin (PayPal IPN module)

I do have precisly the same problem.

That means IPN worked when I used 1.3.6. After I upgraded to 1.3.7 everythin was fine in the beginning but than started a problem. When Ordering through IPN custumer is directed to PayPal and pay as normal, he is than redirected to the Checkout-Success page without displaying an error. No Order is recorded and the basket is empty.

Here is my IPN log of my last try:

Jan 12 2007 12:40 -- Breakpoint: 1

Jan 12 2007 12:40 -- Breakpoint: 2

Jan 12 2007 12:40 -- Breakpoint: 3

Jan 12 2007 12:40 -- IPN WARNING::Could not find matched txn_id record in DB

Jan 12 2007 12:40 -- Breakpoint: 4 txn_type=unique ordersID =  IPN_id=

Jan 12 2007 12:40 -- IPN DEBUG::uniqueness-test.  Relevant data from POST:
txn_type = unique
parent_txn_id = 
txn_id = 57J15009F9790130P

Jan 12 2007 12:40 -- IPN NOTICE::Set transaction type = pending-echeck
POST data:
mc_gross=34.95 
&address_status=unconfirmed 
&payer_id=AK2xxxxxxxxxxx
&tax=0.00 
&address_street=Donxxxxxxxxxxxxxxx
&payment_date=03:39:15 Jan 12, 2007 PST 
&payment_status=Pending 
&charset=windows-1252 
&address_zip=4710 
&first_name=Ariane 
&address_country_code=BE 
&address_name=Dieter Brandenburger 
&notify_version=2.1 
&custom=zenid=f91f80f3fa2c9748889b225824c32266 
&payer_status=unverified 
&business=admin@txxxxxxxxxxxx
&address_country=Belgium 
&address_city=Lontzen 
&quantity=1 
&verify_sign=AUaxvSoxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 
&[email protected] 
&txn_id=57J15009F9790130P 
&payment_type=echeck 
&last_name=Brxxxxxxxxxxx 
&address_state=0 
&receiver_email=admin@xxxxxxxxxxxxxxxx 
&receiver_id=QGWEEHNU35J7S 
&pending_reason=echeck 
&txn_type=web_accept 
&item_name=DREHMAHL - Shop Einkauf 
&mc_currency=EUR 
&item_number=1 
&residence_country=DE 
&payment_gross= 
&shipping=0.00 
&cmd=_notify-validate

Jan 12 2007 12:40 -- Breakpoint: 5 txn_type=pending-echeck

Jan 12 2007 12:40 -- IPN WARNING:: Could not establish txn type pending-echeck
 postdata=mc_gross=34.95 
&address_status=unconfirmed 
&payer_id=AK2CQ72SQDESS 
&tax=0.00 
&address_street=Doxxxxxxxxxxxxxxxxxxx
&payment_date=03:39:15 Jan 12, 2007 PST 
&payment_status=Pending 
&charset=windows-1252 
&address_zip=4710 
&first_name=Ariane 
&address_country_code=BE 
&address_name=Dietexxxxxxxxxxxxxx
&notify_version=2.1 
&custom=zenid=f91f80f3fa2c9748889b225824c32266 
&payer_status=unverified 
&business=admin@xxxxxxxxxxxxxxx 
&address_country=Belgium 
&address_city=Lontzen 
&quantity=1 
&verify_sign=AUaxvSojqajxsiGA9qxxxxxxxxxxxxxxxxxxxxx 
&[email protected] 
&txn_id=57J15009F9790130P 
&payment_type=echeck 
&last_name=Bxxxxxxxxxxxxxxx
&address_state=0 
&receiver_email=admin@xxxxxxxxxxxxxxxxxxx
&receiver_id=QGWEEHNU35J7S 
&pending_reason=echeck 
&txn_type=web_accept 
&item_name=DREHMAHL - Shop Einkauf 
&mc_currency=EUR 
&item_number=1 
&residence_country=DE 
&payment_gross= 
&shipping=0.00 
&cmd=_notify-validate

I only find a warning

Jan 12 2007 12:40 -- IPN WARNING:: Could not establish txn type

but do not know what to do...

Thanks for any help
Dieter

Using phpMyAdmin ... look at the paypal table and the paypal_testing

Check the field length for:
payment_type varchar(40)

If smaller, raise to 40

Hi,

thanks for the reply, BUT.... not working :(

payment_type had been lower than 40, rising it to 1st 40 and 2nd to 64 did not make any change. Still the same Problem and the same error message in the IPN log.

:cry: Dieter

And you updated all of the files for:
/ipn_main_handler.php
/includes/modules/payment/paypal.php
/includes/modules/payment/paypal

in addition to the other changed files in v1.3.7 ...

You also checked the PayPal site and your settings to ensure PayPal did not reset anything?

I'll check this....

tomorrow.

(Have to go now)

CU and Thanks
Dieter :lamo:

Yes I checked the paypal.php file and the settings with paypal, but still there is no change. The file version is:

• @version $Id: paypal.php 5352 2006-12-22 21:35:58Z drbyte

One thing. When I confirm order I am redirected to paypal. Meanwhile the paypal_testing table is still empty... Maybe this helps?

Kind regards
Dieter

It is very strange the the code worked in v1.3.6 and work initially in v1.3.7 and then ... "changed its mind" ...

Code doesn't change its mind ...

Did something change on your server?

How long was it working in v1.3.7 before it "changed its mind" and stopped working?

For giggles and grins have you tried loading a clean v1.3.7 into a test directory with a test database and the demo data and just add a few cheap test products to see if that works?

Regarding the "software changing mind" thing:

Well as I just noticed, my error discription was not precise. I updated vom 1.3.6 to 1.3.7. Bevor PayPal IPN worked perfectly for all kind of transactions. Now the discribed error occures (only) on pending transactions. So if a PayPal custumer chooses "Bank Transfer" within paypal the order is not processed allthough he gets an oder success message. The cart is delete, but no order issued. On transaction that are payed directly (like Creditcard within Paypal) everything works fine.

What I did for now, I stoped accepting pending payment types within paypal.

Maybe this information helps somehow.

Thanks anyway
Dieter

Try running these in the Tools ... Install SQL Patches ...

ALTER TABLE paypal CHANGE txn_type txn_type varchar(32) NOT NULL default '';
ALTER TABLE paypal CHANGE payment_type payment_type varchar(40) NOT NULL default '';
ALTER TABLE paypal_testing CHANGE txn_type txn_type varchar(32) NOT NULL default '';
ALTER TABLE paypal_testing CHANGE payment_type payment_type varchar(40) NOT NULL default '';

Then, get the updated file on post #19:
http://www.zen-cart.com/forum/showthread.php?t=54679

See it those help you ...

Is this fix only for paypal express users...

Im in the UK and noticed a user go through all the steps using user tracking module but there was no record of the order in admin area but i did get a confirmation from paypal via email to say they had received payment via echeque which would be cleared in 3 > 4 days.

For v1.3.7 ... this is a good patch to add in to ensure all is set right ...

http://www.zen-cart.com/forum/showthread.php?t=56216

As to is there an issue on your site due to the code ... well questions are:

1 Is this a clean v1.3.7 or an upgrade ...

2 if an upgrade, from what version and how ...

3 has this ever worked right? what about in all your testing before you went live?

4 any changes on your server? such as new php version, moving hosts, etc.

Thanks for the reply Ajeh...

Its a new install of 1.3.7 and it only went live about 2 weeks ago i've had 12 other standard paypal and 6 cheque/money order transactions and they have been comming through fine but this paypal echeque didnt come through.

I logged in using the master password to the customers account and there is no sign of the order so the user thinks it has gone through fine. I have emailed the customer to find out what they ordered but have had no reply yet.

I tested the cheque/money order and the paypal payments before going live but not paypal echeque payments.

MySQL 4.1.21-standard
Linux 2.6.9-42.ELsmp
PHP 4.4.3 (Zend: 1.3.0)
Apache/1.3.37 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a PHP-CGI/0.1b

And did you add that update that I posted the link for? :smile:

We are also experienceing the same kind of issue. Ive followed the thred. From what ive seen the PP IPN is working, but not the Order number so all the orders are now # 0 - ive copied a few lines for people to see . If anyone finds a fix please email me at [email protected]
IT WAS working. Ill keep looking...
thanks
0 28 cleared-address
Adam xxx Completed
Parent Trans ID:
Trans ID:52Y15337AJ376045YUSD 25.99 0 27 cleared-address
xxx white Completed
Parent Trans ID:
Trans ID:8LV00585JN3030703USD 39.29 0 26 cleared-address
Howard xxx Completed
Parent Trans ID:
Trans ID:2JJ46916YU2895933USD 53.99 8 25 unique
leonard xxx
xxx Completed
Parent Trans ID:
Trans ID:35K975565F7182255USD 24.35 7

Thanks Ajeh...

I will FTP the patch that you posted and will also try and test it tonight just wasnt sure if the patch would do anything for non paypal express users.

Ive also noticed some strange PP behavor on their server - some Icons not showing and such last night. With the PP IPN working just last week and we have not know any changes to our systems im starting to think that they may be the issue for this bug. Ive looked at their status an altho its not reporting anything major - i suspect them at this time. A lot of people have the issue and not made a change. logic tells me that something is broken somewhere.

Ive spent about 3 weeks trying to get paypal IPN to work, it was a new install of 1.3.6, Dr Byte helped, but it worked some times and not others, checked with host all ports open etc. Driving me crazy!!

So gave up with 1.3.6

Fresh install of 1.3.7, paypal still not working, so installed the dr Byte patches and linda's sql update, and good news it is all working now

thanks for all the help given

Andy

Thanks for the update that loading the paypal patch for v1.3.7 was able to fix your issues ... :smile:

The current patch can be found at:
http://www.zen-cart.com/forum/showthread.php?t=56216

Hello,
I had the same problem with the orders not showing for the PayPal customers. I did the recommended patch (thank you).

After I did a test order, Admin does the show order, but when you look at the order, there are no line items listed. The totals show on the invoice (Sub-Total, UPS, Tax, and Total), but the products are not listed. I did not receive an e-mail with my order confirmation for my test order either. After I made my payment with PayPal, I could return to my store’s “Thank you” page.

My PayPal account did process the charge automatically.

I have version 1.3.7 for both the database and Zencart. I am not using the PayPal Express, just the PayPal IPN.

I have tried to cancel the PayPal IPN and re-install it.

Please help.

Katrina

Hello folks,

I had same problem and finally found out that this is a bug in ipn_main_handler.php: transaction type "pending-echeck" is missing in the switch statement, and therefore PayPal transactions with status "pending-echeck" cannot be processed.

Open ipn_main_handler.php file in your shop directory and look for:

/**
 * take action based on transaction type and corresponding requirements
 */
switch ($txn_type) {
  case 'pending-address':
  case 'pending-intl':
  case 'pending-multicurrency':
  case 'pending-verify':

Then insert following line after "switch (....":

    case 'pending-echeck':

Now it works!

Hope it helps,
Vygi