{"id":2382402,"date":"2011-11-04T12:11:08","date_gmt":"2011-11-04T12:11:08","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/plugin-page-tagger\/"},"modified":"2016-08-20T03:16:34","modified_gmt":"2016-08-20T03:16:34","slug":"plugin-page-tagger","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/plugin-page-tagger\/","title":{"rendered":"[Plugin: Page Tagger] Bug with custom post types which have tag support"},"content":{"rendered":"

This plugin works fine – if you only use posts and pages.<\/p>\n

If you also use a custom post type with tag-support (taxonomy: post_tag<\/code>), the plugin breaks the process of updating the correct count of tags in database so other functionalities, e.g. Tag Clouds, get unexpected and wrong results.<\/p>\n

The plugin overrides the default tag count update callback _update_post_term_count<\/code> of taxonomy post_tag<\/code> with a hardcoded sql-statement with only post types post<\/code> and page<\/code> so any other post type will not be updated.<\/p>\n

Fix for Page Tagger 0.3.6, at end of file page-tagger-class.php<\/em><\/p>\n

Old, only 2 hardcoded post_types:<\/p>\n

function _update_post_term_count( $terms )\n\t{\n\t\tglobal $wpdb;\n\t\tforeach ( (array) $terms as $term ) {\n\t\t\t$count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM $wpdb->term_relationships, $wpdb->posts WHERE $wpdb->posts.ID = $wpdb->term_relationships.object_id AND (post_type = 'post' OR post_type = 'page') AND term_taxonomy_id = %d", $term ) );\n\t\t\t$wpdb->update( $wpdb->term_taxonomy, compact( 'count' ), array( 'term_taxonomy_id' => $term ) );\n\t\t}\n\t}<\/code><\/pre>\n
New, add also custom post types to SELECT statement:<\/p>\n
function _update_post_term_count( $terms )\n\t{\n\t\tglobal $wpdb;\n\t\tforeach ( (array) $terms as $term ) {\n\t\t\t$count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM $wpdb->term_relationships, $wpdb->posts WHERE $wpdb->posts.ID = $wpdb->term_relationships.object_id AND (post_type = 'post' OR post_type = 'page'" . $this->_get_custom_post_types_sql() . ") AND term_taxonomy_id = %d", $term ) );\n\t\t\t$wpdb->update( $wpdb->term_taxonomy, compact( 'count' ), array( 'term_taxonomy_id' => $term ) );\n\t\t}\n\t}\n\/* Hack for custom post types support *\/\nfunction _get_custom_post_types_sql() {\n\t\t$sql = '';\n\t\t$cpt_arr = array();\n\t\t$args = array(\n\t\t\t'public'   => true,\n\t\t\t'_builtin' => false,\n\t\t\t'taxonomies' => array('post_tag') \/\/ taxonomies actually not used, bug wp 3.2.1\n\t\t);\n\t\t$post_types = get_post_types($args, 'names');\n\t\tforeach ($post_types as $post_type ) {\n\t\t\t$cpt_arr[] = "post_type = '$post_type'";\n\t\t}\n\t\tif ($cpt_arr) {\n\t\t\t$sql = ' OR ' . implode(' OR ', $cpt_arr);\n\t\t}\n\t\treturn $sql;\n\t}<\/code><\/pre>\n
https:\/\/wordpress.org\/extend\/plugins\/page-tagger\/<\/p>\n","protected":false},"template":"","class_list":["post-2382402","topic","type-topic","status-closed","hentry","topic-tag-custom-post-type"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/2382402","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/2382402\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=2382402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}