Plugins that may conflict with WooTickets 3.0.2 – No tickets on the Event Page

[George]

Thanks Barry for your support in the previous thread: https://tri.be/support/forums/topic/errors-on-all-event-pages/#post-58992.
I have at last discovered the plugin that has been giving me such a headache with my WooTickets. As Long as “NextGEN Gallery” Version 2.0.0 by Photocrati Media is running under WordPress 3.6 and The Events Calendar 3.0.3, the tickets will not show up on the Events page.
I don’t yet know whether that is only in my case, It would be interesting if someone ales could give this a test! I believe it could save others the headache.

Thanks Guys.

[Barry]

Hi George,

Thanks for posting this separately – and for breaking it down and troubleshooting it. I’ll definitely take a look at NextGEN and see if I can replicate what you are experiencing.

Stay tuned!

[Barry]

OK, there’s definitely a considerable problem there. Bear with us while we dig in a little deeper, we do appreciate NextGEN is particularly popular and will definitely see if there is anything we can do here.

[Barry]

So this comes down to a problem where NextGen (specifically, the code in its M_DataMapper class) is changing the query used to build the list of tickets, effectively breaking it from our point of view.

I’m not sure at this point why it’s hijacking our query in this way but I’ll ask one of the dev team to investigate.

[George]

Thanks Barry for checking this out. As you said NextGEN is very popular, so this may be a common issue. Good luck.

[impressit]

Hi i can also confirm that by activating NextGEN 2.0.0 the tickets disappear.
Enabling debugging produces this SQL statement.
WordPress database error: [Unknown column ‘ids’ in ‘field list’]
SELECT DISTINCT ids FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) WHERE 1=1 AND wp_posts.post_type = ‘product’ AND (wp_posts.post_status = ‘publish’) AND ( (wp_postmeta.meta_key = ‘_tribe_wooticket_for_event’ AND CAST(wp_postmeta.meta_value AS CHAR) = ‘159’) ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC

This happens on the events page both in the front and backend.
Deactivating NextGEN fixes the issue.

[Barry]

Yeah there’s definitely a problem and it seems to boil down to their code changing one of the queries issues by WooCommerce Tickets.

Our dev team is looking into it and if it’s something we can/should solve within our code we’ll certainly do so – and I’ll dfefinitely update this thread to let you know the outcome.

[moatplayers]

Hi
I have the same issue with NextGen & WooTickets.
https://tri.be/support/forums/topic/wootickets-nextgen-gallery-conflict/
Thanks
H

[Barry]

We are still digging into this, all I can really tell you at this point is that our plugin is unable to retrieve tickets when NextGen is active – as soon as there’s a more substantive update we’ll get back to you.

Thanks for your patience 🙂

[Rob]

Hey everyone. Thanks for the follow-ups and patience here. We discussed this on our meeting with the development team yesterday, and this is something we’re looking into – but unfortunately there is no easy solution or workaround we can provide at this time. We realize that NextGen is a long-lasting and widely used plugin, but there are aspects of how it’s coded that run counter to some of the WordPress best practices + coding standards we’ve used to build our plugin. It poses a unique challenge as a result.

We are absolutely keeping this on the radar and will seek to better integrate in a future release, but for the maintenance build we’re focused on at the moment (the August release), we’re realistically going to be focused exclusively on widespread bugs with our codebase. At the moment this is scheduled to be investigated further for our next / subsequent maintenance release, though I cannot guarantee anything.

My apologies to everyone for the inconvenience they’re faced with so far. Have you raised this with the developers of that plugin? We’d be happy to provide them some feedback or work with them to see if either/both sides could better optimize to ensure smoother integration. Feel free to email us directly (pro /a/ tri.be) if you see value in that approach.

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts