Ever since a client of our updated this plugin we’re now running up against this error:<\/p>\n
[18-Dec-2013 23:54:23 UTC] WordPress database error Not unique table\/alias: ‘wp_postmeta’ for query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, IF (wp_posts.post_type = ‘tribe_events’, wp_postmeta.meta_value, wp_posts.post_date) AS post_date FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) LEFT JOIN wp_postmeta on wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = ‘_EventStartDate’ WHERE 1=1 AND wp_posts.post_type IN (‘post’, ‘page’, ‘tribe_events’) AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_author = 2 AND wp_posts.post_status = ‘private’) AND ( (wp_postmeta.meta_key = ‘_feature’ AND CAST(wp_postmeta.meta_value AS CHAR) = ‘on’) ) ORDER BY post_date DESC LIMIT 0, 10 made by require(‘wp-blog-header.php’), require_once(‘wp-includes\/template-loader.php’), include(‘\/themes\/redDoorProject\/front-page.php’), get_footer, locate_template, load_template, require_once(‘\/themes\/redDoorProject\/footer.php’), include(‘\/themes\/redDoorProject\/includes\/feature.php’), WP_Query->__construct, WP_Query->query, WP_Query->get_posts<\/p>\n
which is preventing the entire feature to fail at displaying posts.<\/p>\n
the WP_Query that is being used is:<\/p>\n
$the_query = new WP_Query(
\n\tarray(
\n\t\t‘post_type’ => array(
\n\t\t\t‘post’,
\n\t\t\t‘page’,
\n\t\t\t‘tribe_events’
\n\t\t),
\n\t\t‘meta_query’ => array(
\n\t\t\tarray(
\n\t\t\t\t‘key’ => ‘_feature’,
\n\t\t\t\t‘value’ => ‘on’
\n\t\t\t)
\n\t\t),
\n\t)
\n); <\/p>\n
Only content with the custom meta value of ‘_feature’ should be display, yet none are.<\/p>\n
If I remove the ‘tribe_events’ from the WP_Query’s ‘post_type’ array, then the feature successfully shows all posts and pages that have the ‘_featured’ custom meta checked.<\/p>\n
Please advise.
\n-M<\/p>\n","protected":false},"template":"","class_list":["post-82635","topic","type-topic","status-closed","hentry"],"yoast_head":"\n