Error on 3.3.6 with Update Participant Status action off participant results

[CiviTeacher.com]

I've got a 3.3.6 installation and when using the Update Participant Status action after using "Find Participants" I get a nonrecoverable error.

Sorry. A non-recoverable error has occurred.
ufGroupId is missing

We are not in a position to upgrade to 3.4 yet, so I would like to identify if this is a bug with a patch, and if so, backport that patch.  I looked on JIRA Issue Tracker for about 20 minutes but couldn't locate a bug that seemed similar to this one.

Any pointers to a applicable patch?  Thanks.

Code: [Select]

backTrace

/home/nonprofitoregon/public_html/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 270
/home/nonprofitoregon/public_html/sites/all/modules/civicrm/CRM/Event/Form/Task/Batch.php, fatal, 108
/home/nonprofitoregon/public_html/sites/all/modules/civicrm/CRM/Event/Form/Task/ParticipantStatus.php, buildQuickForm, 65
/home/nonprofitoregon/public_html/sites/all/modules/civicrm/CRM/Core/Form.php, buildQuickForm, 326
/home/nonprofitoregon/public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php, buildForm, 99
/home/nonprofitoregon/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/home/nonprofitoregon/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/home/nonprofitoregon/public_html/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 284
/home/nonprofitoregon/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 219
/home/nonprofitoregon/public_html/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 355
, civicrm_invoke,
/home/nonprofitoregon/public_html/includes/menu.inc, call_user_func_array, 349
/home/nonprofitoregon/public_html/index.php, menu_execute_active_handler, 17


[Kurund Jalmi]

Can you check if you are able to replicate it on http://crm33.demo.civicrm.org

Kurund

[CiviTeacher.com]

I cannot replicate it on the 3.3 demo.  Could it have something to do with a custom field set that it has been disabled?   That is the only thing we have done recently to change our installation.

Update: Nope, enabling the custom fields didn't fix anything.   Any ideas what this error means? 

I've tried disabling custom modules, and all the custom CiviCRM code on this site, with no fix either.

[Dave Greenberg]

Stuart - Looks like an upgrade issue. The error is being thrown because the expected reserved profile with 'name' = 'participant_status' is not present in that database. This reserved profile was added in 3.0 alpha1 for upgraded sites - check lines 118 - 129 in CRM/Upgrade/Incremental/sql/3.0.alpha1.mysql.tpl in 3.3 (or any version >= 3.0 alpha 1). BTW I used the backtrace (notably the 2 and 3rd lines) to jump into the code and see where things were breaking down.

I suspect that the other upgrades in that file might not have been executed either altho can't be sure. :-( I would at least scan the file and check for other changes.

The code for this specific insert is below (you'll need to remove the smarty {localize} tags to run this).

Code: [Select]

    -- add a profile for CRM-4323
    BEGIN;
        INSERT INTO civicrm_uf_group
            (name,                 group_type,    {localize field='title'}title{/localize},  is_reserved)
        VALUES
            ('participant_status', 'Participant', {localize}'Participant Status'{/localize}, 1);
        SELECT @ufgid := id FROM civicrm_uf_group WHERE name = 'participant_status';
        INSERT INTO civicrm_uf_field
            (uf_group_id, field_name,              is_required, is_reserved, {localize field='label'}label{/localize},  field_type)
        VALUES
            (@ufgid,      'participant_status_id', 1,           1,           {localize}'Participant Status'{/localize}, 'Participant');
    COMMIT;


[CiviTeacher.com]

That's interesting, cause this site has only been upgraded twice. It started at 3.2beta, then 3.2.3, then 3.3.6.   

I'll get into the database and try to find what might be missing.  Thanks.

[CiviTeacher.com]

This is the exact series of queries I ran, and it appears to fix the issue.  Thanks so much Dave.  I learned quite a few things, and I will review the upgrade file and see if anything else was missed.  I'm scratching my head as to why this query was not run if it was included in 3.0 alpha.  The site started as 3.2 beta so this should have been in the database.  I'll post an update if I find more useful info.

Code: [Select]

        INSERT INTO civicrm_uf_group
            (name,group_type,title,is_reserved)
        VALUES
            ('participant_status','Participant','Participant Status', 1);
        SELECT @ufgid := id FROM civicrm_uf_group WHERE name = 'participant_status';
        INSERT INTO civicrm_uf_field
            (uf_group_id, field_name,is_required,is_reserved,label,field_type)
        VALUES
            (@ufgid,'participant_status_id',1,1,'Participant Status','Participant');



[drifteaur]

I've had the same error, running a (hungarian) localized CiviCRM. In my case, the "name" column of the "participant status" group was localized, and this caused the error. This is what I ran that helped:

update civicrm_uf_group set name='participant_status' where id=3;

Replace '3' with the ID of your participant status group.