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

[donnerkul]

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

[Ajeh]

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

[donnerkul]

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.

Dieter

[Ajeh]

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?

[donnerkul]

I'll check this....

tomorrow.

(Have to go now)

CU and Thanks
Dieter

[donnerkul]

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

[Ajeh]

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?

[donnerkul]

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

[Ajeh]

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

[boyemillar]

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.