1.6.5 breaks query on custom taxonomy page of custom post type
-
I use the Types plugin together with WPML. After updating Types to 1.6.5 the query of the custom taxonomy page on the custom post type breaks. I do not get any result.
After doing some research I found out that there is something missing/wrong in query. This is the query I get:
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) JOIN wp_icl_translations t ON wp_posts.ID = t.element_id AND t.element_type IN ('post_post') JOIN wp_icl_languages l ON t.language_code=l.code AND l.active=1 WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (57) ) AND wp_posts.post_type IN ('product', 'post') AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 1 AND wp_posts.post_status = 'private') AND t.language_code='en' GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC LIMIT 0, 30This is the query I should get:
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) JOIN wp_icl_translations t ON wp_posts.ID = t.element_id AND t.element_type IN ('post_product') JOIN wp_icl_languages l ON t.language_code=l.code AND l.active=1 WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (57) ) AND wp_posts.post_type IN ('product', 'post') AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 1 AND wp_posts.post_status = 'private') AND t.language_code='en' GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC LIMIT 0, 30It’s only one change: post_post > post_product
Does anyone know what’s causing this? Is it a bug of Types 1.6.5? Is it a bug of WPML of is it a bug on my end.
Can anyone help me? Thanks!
- The topic ‘1.6.5 breaks query on custom taxonomy page of custom post type’ is closed to new replies.
