function forum_update_10101

Repopulate the forum index table.

File

core/modules/forum/forum.install, line 213

Code

function forum_update_10101(&$sandbox = NULL) : PluralTranslatableMarkup {
  $query = \Drupal::database()->select('forum_index', 'fi')
    ->fields('fi', [
    'nid',
    'tid',
  ])
    ->groupBy('nid')
    ->groupBy('tid');
  $query->addExpression('count(*)', 'count');
  $query->having('count(*) > 1');
  $results = $query->execute();
  $nids_to_rebuild = [];
  foreach ($results as $row) {
    \Drupal::database()->delete('forum_index')
      ->condition('tid', $row->tid)
      ->condition('nid', $row->nid)
      ->execute();
    $nids_to_rebuild[] = $row->nid;
  }
  \Drupal::state()->set('forum_update_10101_nids', $nids_to_rebuild);
  return new PluralTranslatableMarkup(count($nids_to_rebuild), 'Removed 1 duplicate entry from forum_index', 'Removed @count duplicate entries from forum_index');
}