Tutorial - remove duplicate entries Event Booking

IF you have duplicates in the registrant list to remove them perform the following sql in phpmyadmin
Then as some of the eb_registrant duplicate entries removed from the table were the published versions I had to reset the unpublished registrants to published.

Thanks for sharing the solution. The question here is what's exactly the issue you were having?

Hi for some reason eventbooking booked in some users twice into the event.
I checked the events my client had setup and noticed in the "Advanced Settings" paypal email field was filled to the same paypal email account that was in the paypal payment plugin.
Could this have caused a duplicate transaction?

I had this same issue, I think it was due to failed payments, however I was using stripe payments. I had multiples of the same person but only one would have an actual invoice, but each duplicate had a new ID.

Please note that the system stores the registration records into database before the payment is processed

So in case the payment failed (users stopped making payment when they are being redirected to payment gateway or they entered wrong credit card number), the records are still available in database (but not being shown by default - and not being counted / treated as registrants in the system)

So having duplicate records are actually not an issue.

Regards,

Tuan