[Anne-Marie]

Hi Cliff,

Performance problem is only in the backend. When I create an event or edit an event.

If I deactivate plugin Tickets plus there is NO performance problem
If I activate Tickets plus it takes 10 seconds or more before I can edit the event.

====

68mb isn’t large for a database but the table wp_postmeta contained 178418 records.

I deleted events, tickets and edd_log records older than nov 1, 2017 and downsized to ± 70000 records.

Performance improved slightly, but is still takes approx. 10 seconds before I can edit an event in de backend. (before deletion of the records it often timed out)

The website isn’t very big, 68 pages and 18 posts.

[Anne-Marie]

I’m sory, I don’t understand. Why should I downgrade?

My question was how can I savely delete the events and it corresponding tickets

[Anne-Marie]

There is no difference between new and old events.

The website is a few years old. It’s not an extremely large site, but the database is 68Mb. What is the best way to delete old events and their corresponding tickets?

[Anne-Marie]

This reply is private.

[Anne-Marie]

Hi,

Before I did what you suggested I looked again and saw that the button is grayed out but works.

After that I deactivated all plugins (except the events calendar + tickets), changed the theme to twenty-sixteen. The checkin button remains grayed out.

Best regards,
Anne-Marie

[Anne-Marie]

Found the issue on the EDD Github. Will proceed there.

https://github.com/easydigitaldownloads/easy-digital-downloads/issues/5304

[Anne-Marie]

Hi Barry,

We’ve switched payment gateways (from TargetPay to Mollie) and it seems as if – knock on wood – that our issue has been resolved.

Still, if I were you, I’d still want to know the different triggers. Why is stock not reduced twice but are tickets sent out twice? Wether this is something within EDD or in Event Tickets Plus is not transparent to developers.

Kind regards,
Niko (& Anne-Marie)

[Anne-Marie]

Hi Geoff,

I’ve completely recreated our original site for testing purposes at staging.amsterdammusical.nl. Our production site (amsterdammusical.nl) is in full-fledged ticket sales right now: around 30 each day of which two thirds is hitting this issue. It’s causing my customer A LOT of hassle.

Our main hypothesis is that part of the EDD-bot is being kicked into action by completed payments in Pronamic twice. See my earlier post for more detail, but this is what we see:

• when we view order details we see under Payment Notes 2x EDD Bot: Status changed from Pending to Complete
• when we check Attendees under the event, we see that ticket(s) have been issued twice
• the stock still shows the correct amount. It is not affected by the double issue

So we’re assuming the EDD-bot does issue tickets to the customer (and sends out the order confirmation to the admin therefore twice), but doesn’t influence the stock or sends out the tickets to the customer in the same way. I don’t know what exactly triggers each action? Could you enlighten us?

Besides the above the question we wonder why is there a status change from Pending to Complete twice. To verify this issue we’re switching payment provider from TargetPay to Mollie in the coming days to see if the issue will remain.

Let us know about the triggers please.

Thanks in advance,
Anne-Marie (& Niko)

• This reply was modified 7 years, 2 months ago by Anne-Marie.

[Anne-Marie]

Hi Geoff,

I installed a new WordPress site for testing with only the plugins you suggested, but I can’t reproduce the error in this site.

What we notice in the production site:

• customer orders one or more tickets and pays via iDeal
• customer gets 2 e-mails: a receipt with Print tickets – link and an email with the tickets
• administrator gets a notification

when it goes wrong:

• customers gets two e-mails, but for double the amount of tickets (customer paid only ones)
• administrator gets two notifications

In the dashboard we see:

• in the payment history under Downloads we see only one record of the payment
• when we view order details we see under Payment Notes 2x EDD Bot: Status changed from Pending to Complete
• when we check Attendees under the event, we see that ticket(s) have been issued twice
• the stock still shows the correct amount. It is not affected by the double issue

To correct this, my client has to manually delete the attendees under the event and inform the customer he has received a double amount of tickets by accident.

What we also noticed is that the ticket numbers are not unique. But this happens also when there are no problems with the tickets.

Why is there a status change form Pending to Complete twice? I don’t know what triggers that action?

I hope this information helps to find the solution

Kind regards,
Anne-Marie

[Anne-Marie]

Hi Geoff,

Thanks for your reply. It’s difficult to find a pattern, but here is the situation:

We use the following plugins:
The Events Calendar
Events Ticket
Events Ticket Plus
Easy Digital Downloads
Easy Digital Downloads Gateway Fees
Pronamic iDeal (iDeal is a common Dutch payment method) Payment provider is TargetPay

Our customers don’t have to register, they allways pay with iDeal. There are no free tickets. The problem occurs on different times, different banks, different tickets.

In the screenshot I send before I see twice a notification that payment is completed. I’m not sure what that means and which plugin is making that notification. But the bank account is showing that the payment is done only one time.

Kind regards,
Anne-Marie

[Anne-Marie]

With updating to 4.1 automatically the list of attendees was displayed on the event page. This is not something we wanted, so I’ve disabled it for now. Earlier I also wrote the following which is also true for the list of attendees now put on the outside of the website: “[..] some counting errors when comparing the amount of attendees as displayed by the system, actual number of people in the list of attendees and the displayed number of sold tickets. I must say that this is quite intransparent.” However, by displaying the list of attendees I suddenly seem to have 178 attendees for an event that still has 11 tickets available whilst the maximum amount of available spaces is 175. Not very customer-friendly as it can cause quite some confusion.

Once I’ve seen the error described above concerning double tickets again I’ll let you know. Can take a couple of days as sufficient orders need to come in.

[Anne-Marie]

This reply is private.

[Anne-Marie]

Concerning your third question: I’ve been trying to gather as many cases as possible to discover any pattern. Does it only happen with payments from a certain bank/iDeal-combination? No. At a certain point of time in the day? No. In any case it are paid events and it does not seem to happen when people order tickets for more than one event in a single payment (though this might be sheer coincidence). I can’t test it for certain browsers, mobile or with reloading of pages and such, though that does seem the most logical.

I’ll get back to you on 1 and 2 once we’ve updated and have seen wether the issue persists or not.

• This reply was modified 8 years, 1 month ago by Anne-Marie.

[Anne-Marie]

Thanks Barry, the problem is solved. Even when I re-send the payment confirmation.

Great!

Anne-Marie

[Author]

Posts