WordPress database error (Not unique table/alias)

[cacpro]

Here is our errorlog.

[07-Sep-2016 19:59:25 UTC] WordPress database error Not unique table/alias: ‘ksc801_postmeta’ for query SELECT SQL_CALC_FOUND_ROWS ksc801_posts.ID FROM ksc801_posts INNER JOIN ksc801_postmeta ON ( ksc801_posts.ID = ksc801_postmeta.post_id ) INNER JOIN ksc801_postmeta ON ksc801_posts.ID = ksc801_postmeta.post_id WHERE 1=1 AND (
( ksc801_postmeta.meta_key = ‘_tribe_wooticket_event’ AND ksc801_postmeta.meta_value = ‘9858’ )
) AND ksc801_posts.post_type = ‘tribe_wooticket’ AND (ksc801_posts.post_status = ‘publish’ OR ksc801_posts.post_status = ‘acf-disabled’) AND ( ksc801_postmeta.meta_key = ‘_king-street-church:enclosure’ ) GROUP BY ksc801_posts.ID ORDER BY ksc801_posts.ID DESC LIMIT 0, 30 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_feed, do_action(‘do_feed_king-street-church’), call_user_func_array, powerpress_do_podcast_feed, load_template, require_once(‘/plugins/powerpress/feed-podcast.php’), do_action(‘rss2_item’), call_user_func_array, powerpress_rss2_item, powerpress_get_the_exerpt, get_the_excerpt, apply_filters(‘get_the_excerpt’), call_user_func_array, wp_trim_excerpt, apply_filters(‘the_content’), call_user_func_array, Tribe__Tickets__Tickets_View->inject_link_template_the_content, Tribe__Tickets__Tickets_View->has_ticket_attendees, Tribe__Tickets__Tickets_View->get_event_attendees_by_order, Tribe__Tickets__Tickets::get_event_attendees, Tribe__Tickets_Plus__Commerce__WooCommerce__Main->get_attendees, WP_Query->__construct, WP_Query->query, WP_Query->get_posts

[Andras]

Hi cacpro,

Thanks for reaching out to us with this issue and sorry you are having this.

This has been flagged to us last week, so we are aware of the issue.

Do see or experience any of this issue on the front-end or the back-end? Or you only get this logged in the server log?

Could you possibly check what action you are doing when this warning gets logged?

If you could check and answer these, that would help us fix this issue faster.

Thanks and cheers,
Andras

[Andras]

I see you are using PowerPress. One user who reported this earlier was using that as well. Would it be possible for you to test if you are getting the warnings if you have PowerPress deactivated?

Also, it would be great if you could share a database dump. Usually the files are too big to upload here, so sharing it via a cloud service like dropbox is fine. You can paste the link in a private reply.

Thanks,
Andras

[cacpro]

This reply is private.

[Andras]

This reply is private.

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Victor]

Hi Cacpro!

Just wanted to share with you that a new release of our plugins is out. As of this version, and possibly earlier versions too, we can no longer reproduce the issue described in this ticket.

You can find out more about this release → https://theeventscalendar.com/maintenance-release-for-the-week-of-27-may-2018/

Please update the plugins and see if it works for you. Don’t hesitate to open a new topic if anything comes up.

Best,
Victor

[Author]

Posts