Posted: July 10, 2018 at 11:26 pm
For reference, this is not related to reserved tickets as there are none. To be completely certain of that, I have also cleared out the reserved ticket data in the maintenance area.
I also note that for some reason, in some cases the number of registrations reported is less than the number of tickets sold…?? how can this be possible when the smallest number of registrations for 1 ticket, is 1.
Two of the tickets report fewer registrations than tickets sold.
The first of which is reporting 10 tickets sold, but there are in fact only 8 – there should be 2 tickets left for sale.
And likewise directly from the db – registrations
How is this happening and how do I fix it?
It looks to me like this value is coming from esp_ticket.TKT_sold value rather than the sum of all approved transactions or registrations. How is this value set and why would it be out of sync with actual transactions?
That’s correct, it’s in/decremented each time a registration is approved.
We’ve seen this happen with PayPal Standard and looking at your screenshots it looks like that is the payment method you have activated.
We’ve found if the PayPal IPN hits the site at exactly the same time as the user is returned to the site it can cause issues such as these and we have attempted to reduce this down to the smallest timeframe possible (we lock the transaction when either of the 2 hit the site) but apparently it can still happen.
A little while ago we replaced the PayPal Standard payment method in favour of the PayPal Express payment method to help prevent the issues with IPN’s, user’s who already use PayPal Standard can continue to do so but it does not show for new installs. I’d recommend switching the site to use that, it doesn’t use IPN’s and so doesn’t have the same problem and uses the same account type (just different credentials).
We have documentation on setting up PayPal Express here:
To fix your current tickets you can either adjust the TKT_sold value to be the correct value in the DB, or adjust the limit set on the ticket to have he correct number of spaces available.
Ok, thanks Tony.