Context
Sometimes entities created in a reference field get an incorrect ID.
Example: This term has (48) in the title:
https://contrib.drupalarchitect.info/drupal/development-48
This might be related to using View Popular Tags on Drupal.orgPopular Tags, or this View on Drupal.org #2924783patch for referencing entities with parenthesis in the title Status: Needs work.
This issue mentions the combination: View on Drupal.org #2924783confusing error & behavior when creating a new referenced entity containing parentheses Status: Needs work
The last comment has an explanation of the bug: View on Drupal.org #2924783confusing error & behavior when creating a new referenced entity containing parentheses Status: Needs work
Reproduction
With View on Drupal.org #2924783patch #46 Status: Needs work in View on Drupal.org #2924783confusing error & behavior when creating a new referenced entity containing parentheses Status: Needs work, referencing an entity with ID 48 is creating a new entity with (48) in the title.
Drupal Architect: https://www.drupalarchitect.info/tags/search-48
Contrib: https://contrib.drupalarchitect.info/drupal/development-48
Resolution
View on Drupal.org #2924783New patch should fix issues with handling ID numbers Status: Needs work.
List all taxonomy terms to find parenthesis:drush sqlq "select tid, name from taxonomy_term_field_data where name like '%(%' order by name"
List all node titles with parenthesis:drush sqlq "select nid, title from node_field_data where title like '%(%' order by title"
TODO
Point duplicate references back to original, delete duplicate.