Support

Home Forums Event Espresso Premium Paypal Express Registration Integrity

Paypal Express Registration Integrity

Posted: June 26, 2018 at 10:21 am


Gonçalo Pereira

June 26, 2018 at 10:21 am

Hi!
Occasionally, a strange thing happens with some of the registrations are paid using Paypal Express.
The attendee enrolled in the event and his status changes to “Completed” and the details shows this information:

“Registration ID XXXXX-XXX-X-XXXX
Most Recent Payment Method PayPal Express
Payment method response Success
Registration Session somestuff
Registration placed from IP XXX.XXX.XXX.XXX
Registrant User Agent Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36“
If we choose to see the related transaction, the detail pages reports that its overpaid and that no attendee is associated with it!
“Registration Session somestuff
Transaction placed from IP XXX.XXX.XXX.XXX
Registrant User Agent Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36
Inscription Progress
Attendee Information : Complete
Finalize Registration : Complete”
Message:
“For some reason, there are no attendees registered for this transaction. Likely the registration was abandoned in process.”
How can I debug this to see what might be causing this behavior?
Thanks


Josh

  • Support Staff

June 26, 2018 at 11:24 am

Hi there,

Usually this is caused by caching. May I ask are there any caching plugins on the site or is there server side caching?


Gonçalo Pereira

June 26, 2018 at 12:39 pm

Hi Josh,

Thanks for your reply.

There are is no chaching that I’m aware of.

In addition I noticed that in payment method log all looks normal and that some of the related messages were not created nor sent.


Josh

  • Support Staff

June 26, 2018 at 1:06 pm

I checked your site and it does have ngnix microcaching activated, so you could check with your host about that.

The other possibility is the Attendee record (stored in the wp_posts) table was overwritten or removed. This can happen if the wp_posts table was merged from a staging/dev site or restored from a backup.


Gonçalo Pereira

June 27, 2018 at 10:43 am

Hi Josh,

Thank you very much for the nginx tip. I will talk with my host about it.
We don’t implement merge processes in this server so, the first option should solve this.

Thank you very much for your help,


Josh

  • Support Staff

June 27, 2018 at 10:45 am

You should probably check the wp_posts table in case the Attendee record is indeed missing, and then if you have backups of that table you could compare to see if the missing data is in the backup.


Gonçalo Pereira

June 28, 2018 at 3:30 am

Hi Josh!

The attendee record is in the WP_posts table. How is this records related with the transaction?


Tony

  • Support Staff

June 28, 2018 at 4:12 am

The attendee is linked with the registration assigned to that transaction, the transaction is not directly linked to the attendee.

The registrations are assigned to the attendee using the ATT_ID within the {prefix}_esp_registration table.

The same for the transaction, the registrations are assigned to a transaction using the TXN_ID field in the same table.

Note the ID of the transaction that shows no contact, then search in the esp_registration table for that transaction ID, does it list any registrations?


Gonçalo Pereira

June 28, 2018 at 9:11 am

Hi Tony,

After this last upgrade the problem disappeared…

Either way, I’ve run the queries that you suggested and found a record with both the attendee_id and TXN_id in the same record.

Could this be caused by a database anomaly?

Thanks


Gonçalo Pereira

June 28, 2018 at 10:38 am

Hi!
I apologize but my last post was incorrect (I was looking at another registration).
Although everything seems to fine in the tables, for some reason the front end doesn’t build the relation between the registration and the associated payment transaction.
I’m going to compare this case with another that displays the information as supposed and I’ll get back to you.

Thanks


Gonçalo Pereira

June 29, 2018 at 9:04 am

Hi!

The problem doesn’t come from the tables mentioned before. For some unspecified reason the table {prefix]_esp_line_item doesn’t have records of the transactions with the described problem.

I hope this helps!

Thanks


Josh

  • Support Staff

June 29, 2018 at 2:59 pm

I’ve seen similar things happen when the user stays on the payment page at PayPal.com for a while and the registration session expires.

There are two approaches that can both be used to help avoid this:
1) Use an quicker payment method like Stripe or even the new PayPal Express with Smart buttons add-on
2) Extend the length of the registration session. So for example instead of 1 hour, you can set the time limit to 2 hours by adding the following code to your custom functions plugin:

add_filter( 
'FHEE__EE_Session__construct___lifespan', 
'ee_change_reg_time_limit' 
);
function ee_change_reg_time_limit() {
 return 120 * MINUTE_IN_SECONDS;
}


Gonçalo Pereira

June 30, 2018 at 4:15 pm

Hi!

Thank you very much for your suggestions. I increased the session timeout and will evaluate the next registrations.
If the problem remains after this I will evaluate the addon.

Thank you very much.


Gonçalo Pereira

July 5, 2018 at 4:28 pm

Hi!

The session timeout solved the issue.
Thank you very much for your help.

You must be logged in to reply to this support post. Sign In or Register for an Account

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: publish

Updated by  Gonçalo Pereira 2 weeks, 1 day ago ago

Topic Tags

Tagged: 

Notifications

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