{"id":1154780,"date":"2016-08-23T07:38:05","date_gmt":"2016-08-23T14:38:05","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/wordpress-database-error-not-unique-tablealias-3\/"},"modified":"2016-09-29T13:22:11","modified_gmt":"2016-09-29T20:22:11","slug":"wordpress-database-error-not-unique-tablealias-3","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/wordpress-database-error-not-unique-tablealias-3\/","title":{"rendered":"WordPress database error (Not unique table\/alias)"},"content":{"rendered":"<p>Hello, I am getting a database error that looks to be caused by a conflict between the Event Tickets and the Powerpress plugins. It began showing up in the error log on June 24, 2016, but there are no noticeable problems on the front end. I just noticed today that my error log is 210 mb and found the error.<\/p>\n<p>I found some posts about a similar error that was resolved in an earlier version of the Events Calendar plugin. Do you know how to fix this one? We sell tickets and publish podcasts for our shows, and these are two of our most-used plugins.<\/p>\n<p>Thanks for help!<\/p>\n<p>~~~~~~~<\/p>\n<p>This is the full error:<\/p>\n<p>[23-Aug-2016 14:17:53 UTC] WordPress database error Not unique table\/alias: &#8216;wp_postmeta&#8217; for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id WHERE 1=1 AND (<br \/>\n( wp_postmeta.meta_key = &#8216;_tribe_wooticket_event&#8217; AND wp_postmeta.meta_value = &#8216;8369&#8217; )<br \/>\n) AND wp_posts.post_type = &#8216;tribe_wooticket&#8217; AND (wp_posts.post_status = &#8216;publish&#8217;) AND ( wp_postmeta.meta_key = &#8216;enclosure&#8217; ) GROUP BY wp_posts.ID ORDER BY wp_posts.ID DESC LIMIT 0, 20 made by require(&#8216;wp-blog-header.php&#8217;), require_once(&#8216;wp-includes\/template-loader.php&#8217;), do_feed, do_action(&#8216;do_feed_podcast&#8217;), call_user_func_array, powerpress_do_podcast_feed, load_template, require_once(&#8216;\/plugins\/powerpress\/feed-podcast.php&#8217;), do_action(&#8216;rss2_item&#8217;), call_user_func_array, powerpress_rss2_item, powerpress_get_the_exerpt, get_the_excerpt, apply_filters(&#8216;get_the_excerpt&#8217;), call_user_func_array, wp_trim_excerpt, apply_filters(&#8216;the_content&#8217;), call_user_func_array, Tribe__Tickets__Tickets_View-&gt;inject_link_template_the_content, Tribe__Tickets__Tickets_View-&gt;has_ticket_attendees, Tribe__Tickets__Tickets_View-&gt;get_event_attendees_by_order, Tribe__Tickets__Tickets::get_event_attendees, Tribe__Tickets_Plus__Commerce__WooCommerce__Main-&gt;get_attendees, WP_Query-&gt;__construct, WP_Query-&gt;query, WP_Query-&gt;get_posts<\/p>\n","protected":false},"template":"","class_list":["post-1154780","topic","type-topic","status-closed","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>WordPress database error (Not unique table\/alias) -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/wordpress-database-error-not-unique-tablealias-3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"WordPress database error (Not unique table\/alias) -\" \/>\n<meta property=\"og:description\" content=\"Hello, I am getting a database error that looks to be caused by a conflict between the Event Tickets and the Powerpress plugins. It began showing up in the error log on June 24, 2016, but there are no noticeable problems on the front end. I just noticed today that my error log is 210 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/wordpress-database-error-not-unique-tablealias-3\/\" \/>\n<meta property=\"article:modified_time\" content=\"2016-09-29T20:22:11+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/wordpress-database-error-not-unique-tablealias-3\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/wordpress-database-error-not-unique-tablealias-3\/\",\"name\":\"WordPress database error (Not unique table\/alias) -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2016-08-23T14:38:05+00:00\",\"dateModified\":\"2016-09-29T20:22:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/wordpress-database-error-not-unique-tablealias-3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/wordpress-database-error-not-unique-tablealias-3\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/wordpress-database-error-not-unique-tablealias-3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/theeventscalendar.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"https:\/\/theeventscalendar.com\/support\/topics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Ticket Products\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/event-tickets\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Event Tickets Plus\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/event-tickets\/event-tickets-plus\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"WordPress database error (Not unique table\/alias)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\",\"url\":\"https:\/\/theeventscalendar.com\/support\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"WordPress database error (Not unique table\/alias) -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/wordpress-database-error-not-unique-tablealias-3\/","og_locale":"en_US","og_type":"article","og_title":"WordPress database error (Not unique table\/alias) -","og_description":"Hello, I am getting a database error that looks to be caused by a conflict between the Event Tickets and the Powerpress plugins. It began showing up in the error log on June 24, 2016, but there are no noticeable problems on the front end. I just noticed today that my error log is 210 [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/wordpress-database-error-not-unique-tablealias-3\/","article_modified_time":"2016-09-29T20:22:11+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/wordpress-database-error-not-unique-tablealias-3\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/wordpress-database-error-not-unique-tablealias-3\/","name":"WordPress database error (Not unique table\/alias) -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2016-08-23T14:38:05+00:00","dateModified":"2016-09-29T20:22:11+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/wordpress-database-error-not-unique-tablealias-3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/wordpress-database-error-not-unique-tablealias-3\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/wordpress-database-error-not-unique-tablealias-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/theeventscalendar.com\/support\/"},{"@type":"ListItem","position":2,"name":"Topics","item":"https:\/\/theeventscalendar.com\/support\/topics\/"},{"@type":"ListItem","position":3,"name":"Ticket Products","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/event-tickets\/"},{"@type":"ListItem","position":4,"name":"Event Tickets Plus","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/event-tickets\/event-tickets-plus\/"},{"@type":"ListItem","position":5,"name":"WordPress database error (Not unique table\/alias)"}]},{"@type":"WebSite","@id":"https:\/\/theeventscalendar.com\/support\/#website","url":"https:\/\/theeventscalendar.com\/support\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1154780","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":2,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1154780\/revisions"}],"predecessor-version":[{"id":1543432,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1154780\/revisions\/1543432"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1154780"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}