How to remove a taxonomy vocabulary via database query

Question

To manually remove a taxonomy vocabulary in the database, what tables/columns etcetera do I need to delete or modify?

I have a "ghost" taxonomy - it shows up in the list, but doesn't exist anywhere else. I cannot edit it through the website admin - it says page doesn't exist. I can't delete it by using drush entup

But I must remove this somehow, as it's disrupting the website with errors...

LogicException: Missing bundle entity, entity type taxonomy_vocabulary, entity id Regions

As a hook_update_n solution didn't work, and installing a module to do 'drush entup' didn't work... where can I remove this from the database? I had the team in charge of the database itself do a search and pull this result:

I'm assuming that first result is for the block structure, and unrelated to my taxonomy. But maybe someone sees an issue with the results below it, or if we can safely delete those to get rid of this 'ghost' taxonomy?

Answer 1

From the world of weird solutions that work...

• I tried using a module and 'drush entup' ... didn't work
• I tried creating a module to use 'hook_update_N' to delete it ... didn't work
• I tried using hook_update_N to Create it, so I could then delete it ... didn't work.

On a whim, I went to the admin page, listing taxonomies. I dragged the 'ghost' taxonomy to rearrange the list. Then I saved. Suddenly, all the options to edit it had returned. I was finally able to delete the taxonomy using the usual dropdown field.

Answer 2

Take any existing custom module or create one and install it. Then let this module have an .install file and in there implement hook_update_N with the following code to delete the vocabulary when you run database updates the next time, for example via $ drush updb.

<?php

use Drupal\taxonomy\Entity\Vocabulary;

/**
 * Delete vocabulary MY_VOCABULARY.
 */
function MYMODULE_update_8101(&$sandbox) {
  $vid = 'MY_VOCABULARY_MACHINE_NAME';
  $vocabulary = Vocabulary::load($vid);
  if ($vocabulary) {
    $vocabulary->delete();
  }
}