Solr facets returning deleted TIDs

This seems to be a common issue when deleting terms linked to indexed content via term/entity reference, but no solution has worked so far.

I am using the following:

  • Drupal 7
  • Solr 5.5.3
  • Search API 7.x-1.22
  • Field reference delete 7.x-1.0-beta1

The terms are linked via a term reference field on a node.

When the term is deleted, Field reference delete module informs Solr the referenced nodes need reindexing, which removes all articles containing the TID. This works fine. However after reindexing the term ID is still shown with (0) results on display instead of the term name.

Only deleting all indexed content and reindexing removes the facet as expected.

Before this, querying Solr for facets returns this:

{   "response": {     "numFound": 1139,     "start": 0,     "maxScore": 0.43971312,     "docs": [       {         "item_id": "124618",         "score": 0.43971312       }     ]   },   "facet_counts": {     "facet_queries": {},     "facet_fields": {       "im_field_tax_tags": {         "1107": 8,         "1108": 212,         "1109": 29,         "1110": 619,         "1111": 0,         "1112": 61,         "1114": 59,         "1115": 105,         "1117": 48,         "1118": 35,         "1119": 67,         "1121": 120,         "1124": 234,         "1125": 15,         "1127": 60,         "1129": 6,         "1133": 304,         "1134": 59,         "1214": 856,         "1215": 317,         "1216": 397,         "1217": 819,         "1219": 597,         "1220": 6       },     },     "facet_dates": {},     "facet_ranges": {},     "facet_intervals": {},     "facet_heatmaps": {}   } } 

Note 1111 has been deleted and has 0 results, yet still appears in Solr’s list of facets. I presume this is cached somehow. Searching for im_field_tax_tags:1111 also returns 0 results.

It is also worth noting that the facet display has a Minimum facet count of 0, as the way they are displayed requires empty facets to be shown. I understand changing this to 1 would solve the problem (I suspect this is a more common configuration, which may explain why others have had more success), but it is unfortunately not an option.

Any help would be appreciated.

This article was republished from its original source.
Call Us: 1(800)730-2416

Pixeldust is a 20-year-old web development agency specializing in Drupal and WordPress and working with clients all over the country. With our best in class capabilities, we work with small businesses and fortune 500 companies alike. Give us a call at 1(800)730-2416 and let’s talk about your project.

FREE Drupal SEO Audit

Test your site below to see which issues need to be fixed. We will fix them and optimize your Drupal site 100% for Google and Bing. (Allow 30-60 seconds to gather data.)

Powered by

Solr facets returning deleted TIDs

On-Site Drupal SEO Master Setup

We make sure your site is 100% optimized (and stays that way) for the best SEO results.

With Pixeldust On-site (or On-page) SEO we make changes to your site’s structure and performance to make it easier for search engines to see and understand your site’s content. Search engines use algorithms to rank sites by degrees of relevance. Our on-site optimization ensures your site is configured to provide information in a way that meets Google and Bing standards for optimal indexing.

This service includes:

  • Pathauto install and configuration for SEO-friendly URLs.
  • Meta Tags install and configuration with dynamic tokens for meta titles and descriptions for all content types.
  • Install and fix all issues on the SEO checklist module.
  • Install and configure XML sitemap module and submit sitemaps.
  • Install and configure Google Analytics Module.
  • Install and configure Yoast.
  • Install and configure the Advanced Aggregation module to improve performance by minifying and merging CSS and JS.
  • Install and configure Schema.org Metatag.
  • Configure robots.txt.
  • Google Search Console setup snd configuration.
  • Find & Fix H1 tags.
  • Find and fix duplicate/missing meta descriptions.
  • Find and fix duplicate title tags.
  • Improve title, meta tags, and site descriptions.
  • Optimize images for better search engine optimization. Automate where possible.
  • Find and fix the missing alt and title tag for all images. Automate where possible.
  • The project takes 1 week to complete.