Body: <p>I'm running CiviCRM 5.5.3 on Drupal 7.59. I installed CiviVolunteer a long time ago, but had disabled it, because no one wanted to use it at the time. Now, there is interest in using it. So, I attempted to upgrade it to 4.7.31-2.3.1 and re-enable it and this failed. I Searched for solutions and found information here: <a href="https://civicrm.stackexchange.com/questions/12430/civivolunteer-install-fails#12570">CiviVolunteer install fails</a>. I followed the suggestions there and still had no luck getting it to install. </p>
  
  <p>One error I got was: 
  "Field: <code>name</code> must be unique. An conflicting entity already exists - id: 93" </p>
  
  <p>I removed the duplicate entry for <em>skill_level</em> in <em>civicrm_option_group</em> in the DB, followed instructions found at the link above once more and tried to install again and got new errors.</p>
  
  <p>After hours and hours of frustration, I finally decided to install CiviVolunteer into a bare bones drupal/CiviCRM setup on my computer and to go through each DB table to see what tables were created or had data added to them for CiviVolunteer. From doing this, I was finally able to clear out all the old CiviVolunteer data in the production DB and get CiviVoluteer to install. </p>
  
  <p>I decided to provide a list of what tables are affected/added by this extension, so that other sufferers can clean up old DB data/tables and get CiviVolunteer to install or update or can check if their install was complete.</p>
  
  <p><strong>Tables added:</strong> </p>
  
  <ul>
   <li>*civicrm_value_civivolunteer_1* (or some number besides 1),</li> 
  <li>*civicrm_value_volunteer_com_3* (or some number besides 3),  </li>   <li>*civicrm_value_volunteer_inf_2* (or some number besides 2),  </li>   <li>*civicrm_volunteer_need,*   </li>   
  <li>*civicrm_volunteer_project,*  </li>    <li>*civicrm_volunteer_project_contact*</li> 
  </ul>
  
  <p>Note: All these tables should have no data in them in a fresh install. </p>
  
  <p><strong>Tables altered:</strong></p>
  
  <p><em>civicrm_custom_field</em>  <br>
  adds 6 entries (<em>names</em> = Volunteer_Need_Id, Volunteer_Role_Id, Time_Scheduled_Minutes, Time_Completed_Minutes, camera_skill_level, volunteer_project_id)</p>
  
  <p><em>civicrm_custom_group</em> <br> 
  adds 3 entries (<em>names</em> = CiviVolunteer, Volunteer_Information, volunteer_commendation)</p>
  
  <p><em>civicrm_msg_template</em>  <br>
  adds 1 entry (<em>msg_title</em> = Volunteer - Registration (on-line))</p>
  
  <p><em>civicrm_navigation</em>  <br> 
  adds 1 entry (<em>label</em> = New Volunteer)</p>
  
  <p><em>civicrm_option_group</em>  <br> 
  adds 4 entries (<em>name</em> = msg_tpl_workflow_volunteer, volunteer_project_relationship, skill_level, volunteer_role) Note: "skill_level" is the entry that caused the "field must be unique" error. It is apparently not removed if you uninstall CiviVolunteer. </p>
  
  <p><em>civicrm_extension</em>  <br> 
  adds 1 entry for the CiviVolunteer extension.</p>
  
  <p><em>civicrm_uf_field</em>  <br> 
  adds 8 entries (<em>field_name</em> has 2 entries each for = phone, email, last_name, first_name) Note: <em>uf_group_id</em> of the <em>field_name</em> should match the two id's of the group entries in <em>civicrm_uf_group</em> (below)</p>
  
  <p><em>civicrm_uf_group</em>  <br>
  adds 2 entries (<em>group_type</em> = Volunteer,Contact; <em>tittle</em> = Notify Me of Volunteer Opportunities | <em>group_type</em> = Individual,Contact; <em>title</em> = Volunteer Sign Up)</p>
  
  <p><em>civicrm_uf_join</em> <br>
  adds 2 entries (<em>module</em> = CiviVolunteer, Profile) Note: "Profile" should have an id that follows that of "CiviVolunteer". So if CiviVolunteer has an id of 7, then "Profile" will have an id of 8. There are multiple "Profile" entries in this table that don't belong to CiviVolunteer.</p>
  
  <p>Hopefully, I listed everything and that this helps somebody. </p>
  
  <p>Tish</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-03-31T16:07:46.027Z
Comments.Text: I'm working through something similar under WP; this list was helpful. I was able to remove almost everything in this list. However, I could not remove the two entries in _civicrm_uf_group_ and in _civicrm_uf_join_ I did not find a following profile. The two entries in _civicrm_uf_group_ returned a warning and would not remove. For now, I've left both _civicrm_uf_group_ and in _civicrm_uf_join_ alone.
Comments.UserDisplayName: ncraig
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-03-31T21:15:54.967Z
Comments.Text: Using the list provided in this post, I was able to remove a sufficient number of the elements that I could reinstall CiviVolunteer. It appears to be running now. My problem at the outset was installing it prior to Angular profiles. With the non-functioning install cleared out I was able to reinstall with the proper order starting first with angular profiles and then CiviVolunteer.
Comments.UserDisplayName: ncraig
Tags: <drupal><mysql><civivolunteer>
Title: Civivolunteer - Can't upgrade or install
ThreadText: # Civivolunteer - Can't upgrade or install
  
  (Asked by: username_0 on 2018-09-27)
  
  I'm running CiviCRM 5.5.3 on Drupal 7.59. I installed CiviVolunteer a long time ago, but had disabled it, because no one wanted to use it at the time. Now, there is interest in using it. So, I attempted to upgrade it to 4.7.31-2.3.1 and re-enable it and this failed. I Searched for solutions and found information here: [CiviVolunteer install fails](https://civicrm.stackexchange.com/questions/12430/civivolunteer-install-fails#12570). I followed the suggestions there and still had no luck getting it to install.
  
  One error I got was:
  "Field: `name` must be unique. An conflicting entity already exists - id: 93"
  
  I removed the duplicate entry for *skill\_level* in *civicrm\_option\_group* in the DB, followed instructions found at the link above once more and tried to install again and got new errors.
  
  After hours and hours of frustration, I finally decided to install CiviVolunteer into a bare bones drupal/CiviCRM setup on my computer and to go through each DB table to see what tables were created or had data added to them for CiviVolunteer. From doing this, I was finally able to clear out all the old CiviVolunteer data in the production DB and get CiviVoluteer to install.
  
  I decided to provide a list of what tables are affected/added by this extension, so that other sufferers can clean up old DB data/tables and get CiviVolunteer to install or update or can check if their install was complete.
  
  **Tables added:**
  
  * \*civicrm\_value\_civivolunteer\_1\* (or some number besides 1),
  * \*civicrm\_value\_volunteer\_com\_3\* (or some number besides 3),
  * \*civicrm\_value\_volunteer\_inf\_2\* (or some number besides 2),
  * \*civicrm\_volunteer\_need,\*
  * \*civicrm\_volunteer\_project,\*
  * \*civicrm\_volunteer\_project\_contact\*
  
  Note: All these tables should have no data in them in a fresh install.
  
  **Tables altered:**
  
  *civicrm\_custom\_field*   
  adds 6 entries (*names* = Volunteer\_Need\_Id, Volunteer\_Role\_Id, Time\_Scheduled\_Minutes, Time\_Completed\_Minutes, camera\_skill\_level, volunteer\_project\_id)
  
  *civicrm\_custom\_group*   
  adds 3 entries (*names* = CiviVolunteer, Volunteer\_Information, volunteer\_commendation)
  
  *civicrm\_msg\_template*   
  adds 1 entry (*msg\_title* = Volunteer - Registration (on-line))
  
  *civicrm\_navigation*   
  adds 1 entry (*label* = New Volunteer)
  
  *civicrm\_option\_group*   
  adds 4 entries (*name* = msg\_tpl\_workflow\_volunteer, volunteer\_project\_relationship, skill\_level, volunteer\_role) Note: "skill\_level" is the entry that caused the "field must be unique" error. It is apparently not removed if you uninstall CiviVolunteer.
  
  *civicrm\_extension*   
  adds 1 entry for the CiviVolunteer extension.
  
  *civicrm\_uf\_field*   
  adds 8 entries (*field\_name* has 2 entries each for = phone, email, last\_name, first\_name) Note: *uf\_group\_id* of the *field\_name* should match the two id's of the group entries in *civicrm\_uf\_group* (below)
  
  *civicrm\_uf\_group*   
  adds 2 entries (*group\_type* = Volunteer,Contact; *tittle* = Notify Me of Volunteer Opportunities | *group\_type* = Individual,Contact; *title* = Volunteer Sign Up)
  
  *civicrm\_uf\_join*   
  adds 2 entries (*module* = CiviVolunteer, Profile) Note: "Profile" should have an id that follows that of "CiviVolunteer". So if CiviVolunteer has an id of 7, then "Profile" will have an id of 8. There are multiple "Profile" entries in this table that don't belong to CiviVolunteer.
  
  Hopefully, I listed everything and that this helps somebody.
  
  username_0
  
  **Tags:** drupal, mysql, civivolunteer
  
  > **Comments:**
  > **username_1**: I'm working through something similar under WP; this list was helpful. I was able to remove almost everything in this list. However, I could not remove the two entries in _civicrm_uf_group_ and in _civicrm_uf_join_ I did not find a following profile. The two entries in _civicrm_uf_group_ returned a warning and would not remove. For now, I've left both _civicrm_uf_group_ and in _civicrm_uf_join_ alone.  
  > **username_1**: Using the list provided in this post, I was able to remove a sufficient number of the elements that I could reinstall CiviVolunteer. It appears to be running now. My problem at the outset was installing it prior to Angular profiles. With the non-functioning install cleared out I was able to reinstall with the proper order starting first with angular profiles and then CiviVolunteer.  
  
  ---
  
  ## 0 answers
  
  