Paypal listener problems

Hello,

First of all, let me apologise for my english, it's not my native language.

I have a problem with Chronoform (obviously). This should work this way :
- An application send informations to the form (simulated by a post form for now)
- Users are redirected to Paypal (one product, no shipping, just a name and a price), done with Redirect URL & user
- After paypal, users recieve an email with an URL (given by the application at the beginning)

Here is my problem : Everything works, except for the listener. I have an email sent before (for test purposes) that i recieve... But not the ones i gave in the listener.

I tried with DB saves, but this is not working too...

Here is a screen of my configuration.


Moreover, the redirect URL is set this way :

currency_code=EUR
cmd=_xclick
business=<my_sandbox_email_test>
lc=FR
item_name=test
amount=42
quantity=1
no_note=1
no_shipping=1
notify_url=http://46.255.181.126/InsideJoomla/index.php?option=com_chronoforms&chronoform=Paypal_send&event=ipn
event=ipn



The custom code only try a manual database save in a custom table. Not working too.

i'm sure this is trivial, but i can't figure it out. I've searched on this forum.

By the way, this plugin is awesome!

Hi salakis,

What is in the Custom Code action after the test Email action? Maybe that is failing?

Bob

    $mysql_co = mysql_connect("localhost", <login>, <password>);
    mysql_select_db("virdysinside");

    $query = "INSERT INTO `virdysinside`.`a_test` (`id`, `test`) VALUES ('1', 'Success');";
    $result = mysql_query($query);

I have created this table for tests.

But it's not working without anyway :/

In addition to this, i receive every information in my email

Array ( [option] => com_chronoforms [chronoform] => Paypal_send [event] => ipn [Itemid] => [test_ipn] => 1 [payment_type] => instant [payment_date] => 00:20:03 Feb 05, 2013 PST [payment_status] => Completed [payer_status] => verified [first_name] => John [last_name] => Smith [payer_email] => buyer@paypalsandbox.com [payer_id] => TESTBUYERID01 [business] => seller@paypalsandbox.com [receiver_email] => seller@paypalsandbox.com

    [receiver_id] => TESTSELLERID1
    [residence_country] => US
    [item_name1] => something
    [item_number1] => AK-1234
    [quantity1] => 1
    [tax] => 2.02
    [mc_currency] => EUR
    [mc_fee] => 0.44
    [mc_gross] => 15.34
    [mc_gross_1] => 12.34
    [mc_handling] => 2.06
    [mc_handling1] => 1.67
    [mc_shipping] => 3.02
    [mc_shipping1] => 1.02
    [txn_type] => cart
    [txn_id] => 325820
    [notify_version] => 2.4
    [custom] => xyz123
    [invoice] => abc1234
    [charset] => windows-1252
    [verify_sign] => AKV9gzVQ2P4MFMm.U1JWRldQLlHQAzePt8eiBSwZRX4gE5wJSOFV7.yK
)

(generated by the Instant Payment Notification (IPN) simulator)

So i receive correct informations, but the listener don't let me pass...

Hi salakis,

I don't see any obvious problems but I haven't used the IPN action and don't know much about it. I suggest that you use the Contact Us link above to ask Max if he can help.

Bob

Okay

Thanks for your help.

Hi again!

I have a good news :

The listener is working...kindof.

My curl php module wasn't ON. Now, i receive a mail from the form, but an error.

I have my fsockopen enabled, and no error in my apache error log

Hi salakis,

What error do you get?

Bob

Ok i think i figured it out :
I sent informations to paypal (but no informations about the customer). And when the listener tries to get approval, paypal denies because it didn't receive any information about the payer.

I changed paypal_listener a little, to match my current test situation, but i guess i have to send as many information i can to paypal right?

Hi salakis,

I don't know enough about what you are doing (or the PayPal Listener action) to make any useful suggestions.

The PayPal listener's I have coded a) check the transaction details sent from PayPal to make sure that they are genuine and match the saved transaction; then b) send these back to PayPal as confirmation; then c) listed for the 'approved' response from PayPal.

I think this is what Max's code does except that it doesn't do the a) step.

Bob

I'm sorry, i have problems explaining this in english.

I saw that using Paypal's IPN simulator, everything just works fine. But when i am using my form (for tests), i don't get any email, and variables says "pending". Maybe it's due to incomplete informations (no payer email etc...)?

Hi salakis,

If PayPal says that it's 'Pending' then usually the transaction hasn't yet completed. It can take anything from a few seconds to a week or more (if the buyer used e-cheques) to complete. Check the IPN notifications on your PayPal account to see what PayPal thinks is happening.

Bob

In fact, i am using the sandbox mode. I didn't receive anything.

I'll wait until monday, and i'll tell you if i receive a mail.

Best regards

Ok i think i figured it out :
I sent informations to paypal (but no informations about the customer). And when the listener tries to get approval, paypal denies because it didn't receive any information about the payer.

I changed paypal_listener a little, to match my current test situation, but i guess i have to send as many information i can to paypal right?

How it is possible to sent information in paypal without info for customer? You can something wrong

In fact, i send all the informations to Paypal (for now, this is a test version).
All i send is :

currency_code=EUR
cmd=_xclick
business=***@***.com
lc=FR
item_name=***
amount={media_price}
quantity=1
no_note=1
no_shipping=1
notify_url=***
payer_email=<my email adress>
custom=<random var, for tests>

When i use the IPN simulator (with the paypal sandbox), it works fine. But when i use my custom form (in which i have : custom, payer_email and amount) i just get "pending".

I'll try with more data.

Ok, i fixed it : Payment Review was enabled... *facepalm*

Thanks for your help

Hi salakis,

Well found - those little settings can be rally hard to track down.

Bob