CiviVolunteer install fails

Question

Failure installing CiviVolunteer ver 4.6-2.1.1 on CiviCRM ver 4.7.6.

I'd previously had CiviVolunteer1.4, (pretty much just playing with it) then attempted 2.0 install several weeks ago. Nothing happened, and then learned that it was incompatible with 4.7. Newest release was supposed to fix, but, on attempting install -> I'm getting: message:

Sorry but we are not able to provide this at the moment. Field: name must be unique. An conflicting entity already exists - id: 104

Return to home page.

On return to Civi dashboard, lots of msgs get displayed for just a few sec re: found title, found field name... Also including image of extensions screen, if that's interesting...

Thanks!

Answer 1

I was also dealing with the same problem and after many debugging, the following uninstall script finally helped me to install CiviVolunteer succesfully. Warning: you will lose the data stored in CiviVolunteer tables. Use at own risk.

/* drop custom tables */
DROP TABLE IF EXISTS `civicrm_volunteer_need`;
DROP TABLE IF EXISTS `civicrm_volunteer_project_contact`;
DROP TABLE IF EXISTS `civicrm_volunteer_project`;

/* drop report-related records */
DELETE FROM `civicrm_report_instance` WHERE report_id = 'volunteer';

/* drop custom option group for roles (FK takes care of option values) */
DELETE FROM `civicrm_option_group` WHERE NAME = 'volunteer_role';
DELETE FROM `civicrm_option_group` WHERE NAME = 'skill_level';

/* drop custom field group from Activities (FK takes care of fields) */
DELETE FROM `civicrm_custom_group` WHERE `name` = 'CiviVolunteer';
DELETE FROM `civicrm_custom_group` WHERE `name` = 'Volunteer_Information';
DELETE FROM `civicrm_custom_group` WHERE `name` = 'volunteer_commendation';

DELETE FROM civicrm_option_group WHERE `name` = 'msg_tpl_workflow_volunteer';
DELETE FROM civicrm_option_group WHERE `name` = 'volunteer_project_relationship';
DELETE FROM civicrm_contact_type WHERE `name` = 'Volunteer';
DELETE FROM civicrm_custom_group WHERE civicrm_custom_group.name = 'CiviVolunteer'; 
DELETE FROM civicrm_custom_field WHERE civicrm_custom_field.name = 'Volunteer_Need_Id';
DELETE FROM civicrm_custom_field WHERE civicrm_custom_field.name = 'Volunteer_Role_Id';
DELETE FROM civicrm_custom_field WHERE civicrm_custom_field.name = 'Time_Scheduled_Minutes';
DELETE FROM civicrm_custom_field WHERE civicrm_custom_field.name = 'Time_Completed_Minutes';
DELETE FROM civicrm_custom_field WHERE civicrm_custom_field.name = 'volunteer_project_id';
DELETE FROM civicrm_custom_field WHERE civicrm_custom_field.name = 'camera_skill_level';
DELETE FROM civicrm_msg_template WHERE msg_title = 'Volunteer - Registration (on-line)';
DELETE FROM civicrm_navigation WHERE `name` = 'New Volunteer';
DELETE FROM civicrm_option_value WHERE `label` = 'Volunteer';
DELETE FROM civicrm_option_value WHERE `label` = 'Volunteer Commendation';
DELETE civicrm_uf_join FROM civicrm_uf_group JOIN civicrm_uf_join ON civicrm_uf_join.uf_group_id = civicrm_uf_group.id  WHERE `group_type` = 'Volunteer,Contact';
DELETE FROM civicrm_uf_group WHERE `group_type` = 'Volunteer,Contact';

/* relationship_type, */


/* drop volunteer sign-up profile (FK takes care of profile fields) */
DELETE FROM `civicrm_uf_join` WHERE `module` = 'CiviVolunteer';
DELETE FROM `civicrm_uf_group` WHERE `name` = 'volunteer_sign_up';

Answer 2

The multiple installs (and I'm guessing not always clean uninstall) of the CiviVolunteer module have most certainly corrupted your database and left some files behind that produce these messages (these look like debug messages left by the developer in a not-yet-final version).

Since you have no data in CiviVolunteer I would:

• disable, then uninstall the CiviVolunteer extension from the GUI,
• if this produces errors, or just for safety, go in the database and execute the following file: https://github.com/civicrm/org.civicrm.volunteer/blob/master/sql/volunteer_uninstall.sql, then execute: DELETE FROM civicrm_extension WHERE full_name = 'org.civicrm.volunteer';
• clear all caches in CiviCRM (Administer >> System Settings >> Cleanup Caches and Update Path)
• delete the org.civicrm.volunteer folder in your extensions directory
• download the latest released version of the extension that supports your version of CiviCRM, and go through the install process again

Answer 3

I had the same trouble. That was a nightmare.

Finally I got through with this command :

https://domainURL/civicrm/admin/extensions?action=disable&id=org.civicrm.volunteer&key=org.civicrm.volunteer

But still there is several tables that need to be remove manually in the SQL database : civicrm_value_civivolunteer_2 civicrm_value_volunteer_com_4 civicrm_value_volunteer_inf_3 civicrm_volunteer_need civicrm_volunteer_project civicrm_volunteer_project_contact

but after reinstall there is an error :

CiviCRM_API3_Exception: "Field:namemust be unique. An conflicting entity already exists - id: 108"

So I remove manually from civicrm_custom_group and civicrm_custom_field for everything with volunteer :

DELETE FROM civicrm_custom_group WHERE civicrm_custom_group.id = 2; DELETE FROM civicrm_custom_field WHERE civicrm_custom_field.id = 2;

But still when reinstall the extension I still have an error.

CiviCRM_API3_Exception: "Field: name must be unique. An conflicting entity already exists - id: 108"

Then I found this https://github.com/civicrm/org.civicrm.volunteer/blob/master/sql/volunteer_uninstall.sql

But no luck still. Error.

So I give up. I will not use this extension that leave too much legacy. I remove it from the ext folder to avoid installing again.

////// EDIT //////

Finally, as there there were no way to avoid countless errors indicating Volunteer. I decided to try reinstall it rather than suppress it. That wasn't possible. So I compare a fresh install of CiviCRM with Volunteer. First I copy these tables (all are empty) via phpmyadmin, or in one case I changed the name to match :

Then I enter the SQL line :

INSERT INTO civicrm_extension ( type, full_name, name, label, file, schema_version, is_active) VALUES ( 'module', 'org.civicrm.volunteer', 'CiviVolunteer', 'CiviVolunteer', 'volunteer', NULL , 1);

Then Volunteer worked. Happy !

Answer 4

Is missing in volunteer_uninstall.sql:

DELETE FROM civicrm_option_group WHERE name = 'skill_level';