Support

Home Forums Event Espresso Premium Reserved Tickets not resetting

Reserved Tickets not resetting

Posted: September 12, 2018 at 3:11 am


Jack Goo

September 12, 2018 at 3:11 am

I have Version 4.9.67.p
Some events are showing tickets as reserved – for example this event has had 8 reservations for several weeks:
https://www.bristol.gs/events/mod-1-fixed-wing-helicopter-28/

I have tried this: Event Espresso -> Maintenace -> Reset/Delete Data -> Reset Ticket and Datetime Reserved Counts
However it times out with the message:
Service Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
Apache Server at http://www.bristol.gs Port 443


Jack Goo

September 12, 2018 at 3:12 am

I have Version 4.9.67.p
Some events are showing tickets as reserved – for example this event has had 8 reservations for several weeks:
https://www.bristol.gs/events/mod-1-fixed-wing-helicopter-28/

I have tried this: Event Espresso -> Maintenace -> Reset/Delete Data -> Reset Ticket and Datetime Reserved Counts
However it times out with the message:
Service Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
Apache Server at http://www.bristol.gs Port 443


Josh

  • Support Staff

September 12, 2018 at 7:45 am

Hi Jack,

Since the server is throwing an error when you try to manually reset the reserved counts, quite likely the same thing is happening when Event Espresso makes an attempt at the automatic reset.

What you can do is use a tool like phpmyadmin (usually available from your web host’s control panel), then run the two following queries:

In the above example, the WordPress database prefix is the default wp_. Your database prefix may be different and if so you’ll make that adjustment.


Jack Goo

September 12, 2018 at 8:08 am

That query didn’t work, but I was able to go through the database and edit them individually. Not ideal, but it’s done now.
Is this something that will happen again, or should it be fixed now?


Josh

  • Support Staff

September 12, 2018 at 8:23 am

It could happen again because the underlying condition (the server throwing an error) has not be fixed. You could check your server’s PHP error logs for errors thrown at the time you tried using the Reset Reserved counts tool. For example if you see an error that says “Fatal Error Memory Exhausted” error, then the way forward will be to bump the memory limit.

The support post ‘Reserved Tickets not resetting’ 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.

Event Espresso