Answers.Body: <p>This is going to sound weird, but what you need to do is add the extension files back into the extensions directory. Then refresh the extensions page so that it doesn't show that it is missing. </p>
  
  <p>If you don't want to keep it or get an error still, after that, then next enable it again and let us know if you get an error message and what it is. From there, you can disable and uninstall it again and remove the extension files. </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-09T14:52:54.043Z
Answers.Text: No luck. Even after removing CiviVolunteer values from the database, I get this error message: "'339' is not a valid option for field option_group_id". Looks like installation is getting hung up on one option group...
Answers.UserDisplayName: Adam
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-09T22:33:53.273Z
Answers.Text: It's tough to say. If you've already begun doing work on the database on the MySQL side, things could be a bit complicated, with missing parts. It might be beyond the scope of this. (edited old comment)
Answers.UserDisplayName: Christia
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-03T03:38:20.203Z
Answers.LastActivityDate: 2018-05-07T22:57:53.270Z
Answers.LastEditDate: 2018-05-07T22:57:53.270Z
Answers.UserDisplayName: Christia
Answers.Body: <p>You could try having a look at the volunteer_uninstall.sql file? </p>
  
  <p><a href="https://github.com/civicrm/org.civicrm.volunteer/blob/master/sql/volunteer_uninstall.sql" rel="nofollow noreferrer">https://github.com/civicrm/org.civicrm.volunteer/blob/master/sql/volunteer_uninstall.sql</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-03T01:12:25.747Z
Answers.LastActivityDate: 2018-05-03T01:12:25.747Z
Answers.UserDisplayName: Luke Stewart
Answers.Body: <p>OK. Had to manually delete all CiviVolunteer tables, values, etc. from the database, clear caches, completely remove the extension, and then download and install through the admin. Decidedly unsexy, but worked.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-09T19:50:40.073Z
Answers.Text: You should be able to 'accept' your own Question, if not immediately, in a while.
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-05-09T18:18:58.387Z
Answers.LastActivityDate: 2018-05-09T18:18:58.387Z
Answers.UserDisplayName: Adam
Body: <p>I'm trying to install the CiviVolunteer extension (Drupal 7, Civi 5), but am getting this error message in response:</p>
  
  <p>Field: <code>name</code> must be unique. An conflicting entity already exists - id: 186</p>
  
  <p>It looks like the developer had previously installed and enabled the extension, but then manually deleted it, without also removing the CiviVolunteer data from the database.</p>
  
  <p>Any suggestions for how to clean up the leftover CiviVolunteer data, or another way that I can reinstall the extension?</p>
  
  <ul>
  <li>UPDATE -</li>
  </ul>
  
  <p>No luck with executing the mysql commands (cannot find tables), and unable to reinstall the CiviVolunteer extension (which is ultimately what I'm after). Receiving the same error message as above, and this screen when I return to the extensions page:</p>
  
  <p><a href="https://i.sstatic.net/GdSF2.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/GdSF2.png" alt="enter image description here"></a></p>
  
Tags: <database><mysql><civivolunteer>
Title: How can I completely remove previous improperly uninstalled CiviVolunteer?
ThreadText: # How can I completely remove previous improperly uninstalled CiviVolunteer?
  
  (Asked by: username_0 on 2018-05-02)
  
  I'm trying to install the CiviVolunteer extension (Drupal 7, Civi 5), but am getting this error message in response:
  
  Field: `name` must be unique. An conflicting entity already exists - id: 186
  
  It looks like the developer had previously installed and enabled the extension, but then manually deleted it, without also removing the CiviVolunteer data from the database.
  
  Any suggestions for how to clean up the leftover CiviVolunteer data, or another way that I can reinstall the extension?
  
  * UPDATE -
  
  No luck with executing the mysql commands (cannot find tables), and unable to reinstall the CiviVolunteer extension (which is ultimately what I'm after). Receiving the same error message as above, and this screen when I return to the extensions page:
  
  [![enter image description here](https://i.sstatic.net/GdSF2.png)](https://i.sstatic.net/GdSF2.png)
  
  **Tags:** database, mysql, civivolunteer
  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_1 on 2018-05-03. Score: 2 | Accepted answer
  
  This is going to sound weird, but what you need to do is add the extension files back into the extensions directory. Then refresh the extensions page so that it doesn't show that it is missing.
  
  If you don't want to keep it or get an error still, after that, then next enable it again and let us know if you get an error message and what it is. From there, you can disable and uninstall it again and remove the extension files.
  
  > **Comments:**
  > **username_0**: No luck. Even after removing CiviVolunteer values from the database, I get this error message: "'339' is not a valid option for field option_group_id". Looks like installation is getting hung up on one option group...  
  > **username_1**: It's tough to say. If you've already begun doing work on the database on the MySQL side, things could be a bit complicated, with missing parts. It might be beyond the scope of this. (edited old comment)  
  
  ---
  
  ### Answer by username_2 on 2018-05-03. Score: 3
  
  You could try having a look at the volunteer\_uninstall.sql file?
  
  <https://github.com/civicrm/org.civicrm.volunteer/blob/master/sql/volunteer_uninstall.sql>
  
  
  ---
  
  ### Answer by username_0 on 2018-05-09. Score: 3
  
  OK. Had to manually delete all CiviVolunteer tables, values, etc. from the database, clear caches, completely remove the extension, and then download and install through the admin. Decidedly unsexy, but worked.
  
  > **Comments:**
  > **username_3**: You should be able to 'accept' your own Question, if not immediately, in a while.  
  
  ---
  
  