Support

Home Forums Event Espresso Premium PayPal returns to server, the EE Send Payment Confirmation works but no [txn_id]

PayPal returns to server, the EE Send Payment Confirmation works but no [txn_id]

Posted: August 16, 2012 at 6:54 pm


mcote

August 16, 2012 at 6:54 pm

Hi,

I’ve read everything I could around this subject but haven’t found anything concerning this issue. When the return from paypal comes back it triggers the send payment confirmeation email that I’ve setup in the EE General Settings. The problem is that it doesn’t return the [txn_id] and probably other information in the wp_events_attendee table. When I look at the paypal.ipn_results.log everything passed with success.

My event payments remain pending, the [txn_id] is “NULL” in the wp_events_attendee table so something doesn’t permit the update in the table.


Josh

  • Support Staff

August 17, 2012 at 8:21 am

Can you check in the PayPal account settings and look for the option that sets “Payment review”? This setting should be disabled.


mcote

August 17, 2012 at 9:17 am

I’ve been through the whole Paypal account settings website and I found no such “Payment review” setting.

All the switches under “Website Payment Preferences” are disabled except
PayPal Account Optional –

> When this feature is turned on, your customers will go through an
> optimized checkout experience.

Nothing as such found either under My settings or My selling tools.


Josh

  • Support Staff

August 17, 2012 at 9:24 am

Is the IPN setting turned on?


mcote

August 17, 2012 at 9:34 am

Yes it is turned on, I can see all the information required to update the event for EE correctly the in the paypal.ipn_results.log

When paypal returns the customer information to our server the Event Espresso “Send Payment Notification” email is triggered but the database is not updated. Everything seems to work fine except the table update. The event remains “Pending”. Maybe I should do a fresh update of EE but I’d rather wait on version 3.1.27


mcote

August 17, 2012 at 12:38 pm

I went to the PayPal website and copied from the IPN history the Notification URL that are to be sent to the customers. I pasted the URL in the bowser, it changed the pending status to Incomplete and also changed the payment type txn_id to PayPal. It seems it triggered the events_attendee table with some missing data. Would it be possible I have an old template in my uploads folder of somehow preventing the table from being updated?

I also placed the [ESPRESSO_TXN_PAGE] between [raw] but no luck.

I’ve done some resends from paypal and they keep triggering the Event Espresso Confirmation Notification Email, so that’s ok.


Chris Reynolds

  • Support Staff

August 17, 2012 at 12:58 pm

It’s possible, although it isn’t likely to be a template file but an old version of the PayPal gateway in /wp-content/uploads/espresso/gateways. There could also be some other database issues going on, especially if you upgraded recently from an old version of Event Espresso (3.0.19 or earlier).


mcote

August 17, 2012 at 6:36 pm

Chris, Josh

I’ve decided to bypass the Default Registration Confirmation Email and since the PayPal IPN triggers my send payment notification email, it doesn’t hurt the way I’ve planned my business process. A lot of the payment information comes from the PayPal notification email and the other missing “event” information is completed by my custom email (Payment Confirmation email). Therefore I can live with this little “issue”. It also seems I’m one of the rare persons having this problem so I am concluding the problem is probably on my side with our server.

Thanks anyways for your time

The support post ‘PayPal returns to server, the EE Send Payment Confirmation works but no [txn_id]’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3 Documentation for Event Espresso 4

Status: closed

Updated by  mcote 7 years, 9 months ago ago

Topic Tags

Tagged: 

Notifications

This topic is: resolved
Do NOT follow this link or you will be banned from the site!