1

I have CiviVolunteer installed on WordPress and have been using it without any issues until this morning when each attempt to save a project led to the following error message: 'A technical problem has occurred Your submission was not saved. Resubmitting the form is unlikely to resolve this problem. Please contact a system administrator.'

  • Thanks for your post. It would be helpful if you could edit it to provide the versions of CiviCRM, CiviVolunteer and WordPress that you are using. – William Mortada Mar 12 '17 at 14:49
1

I had the same issue. After enabling debugging I saw that the civicrm_volunteer_project table was missing the title field.

There is an alter query in this file that did not run correctly for me as it failed on removing the foreign key.

extensions/org.civicrm.volunteer/sql/volunteer_upgrade_2.0.sql

Modified version (though you should run your own tests):

ALTER TABLEcivicrm_volunteer_project ADDtitleVARCHAR(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'The title of the Volunteer Project' AFTERid, ADDdescriptionTEXT COLLATE utf8_unicode_ci COMMENT 'Full description of the Volunteer Project. Text and HTML allowed. Displayed on sign-up screens.' AFTERtitle, ADDloc_block_idINT(10) unsigned DEFAULT NULL COMMENT 'FK to Location Block ID' AFTERis_active, ADD CONSTRAINTFK_civicrm_volunteer_project_loc_block_id FOREIGN KEY (loc_block_id) REFERENCEScivicrm_loc_block(id) ON DELETE SET NULL, ADDcampaign_idINT(10) unsigned DEFAULT NULL COMMENT 'The campaign associated with this Volunteer Project.' AFTERloc_block_id, ADD CONSTRAINTFK_civicrm_volunteer_project_campaign_id FOREIGN KEY (campaign_id) REFERENCEScivicrm_campaign(id) ON DELETE SET NULL, MODIFYentity_tablevarchar(64) NULL, MODIFYentity_idint(10) NULL;

  • Patch welcome matey! – JohnFF Mar 12 '17 at 6:02
  • Thank you! I was able to resolve the issue by resetting the defaults for the Configure Volunteer Settings. – Executive Director Mar 13 '17 at 15:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.