[Sam Barnes]

Due to the size of the table and number of orders on this site it looks like the main issue is queries to the wp_woocommerce_order_itemmeta in order to determine how many of each ticket has been sold.

Could this not be done using:

$count = get_post_meta($product_id,’total_sales’, true);

?

Thanks.

[Sam Barnes]

Hi Andra,

Thanks for getting back to me.

The first one only seams to run on the main wp-admin dashboard for every page load and does not go when you disable event tickets plus.

I have also noticed that when events ticket plus is activated I can’t even view the events admin page: https://plesk.spoiltrottenbeads.co.uk/wp-admin/edit.php?post_type=tribe_events

It just times out.

As far as I can tell the second one is running on the list and month views but these pages are just timing out so I cant know for sure.

And the part is the same for each product apart from the meta_value which is equal to each product id.

Would it help to provide you with admin access so you can see the issues?

I have query monitor installed so you can view the slow queries.

[Sam Barnes]

The second query is run by Tribe__Tickets_Plus__Commerce__WooCommerce__Main->get_orders_by_status

[Sam Barnes]

Weirdly, I just disabled and then re-enabled the themes and plugins and its working now.

[Sam Barnes]

This reply is private.

[Sam Barnes]

This reply is private.

[Sam Barnes]

Hi Nico,

Unfortunately, we don’t have a development area so switching themes and deactivating plugins is not going to be easy.

Looking at the browser console we get a javascript uncaught exception: query function not defined for Select2 undefined

However, its letting me switch between rsvp and woocommerce ticket types fine without errors.

Also, looking at the code, its actually loading the html for the attendee information however its got display:none on both table rows.

Tickets are only loaded onto events.

[Sam Barnes]

Hi Nico,

Thanks for getting in touch. The issue seams to be that the attendee information checkbox is not showing, see the attached image.

Thanks in advance.

[Author]

Posts