CiviCRM Community Forums (archive)

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

Kurund

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).

    -- 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;


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.

        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');