profile type has wrong data

[Shai]

On a 4.5.8 Drupal 7 site I have a profile that is set to: ParticipantEventType::Meeting when it is supposed to be: ParticipantEventType::Retreat

Strangely, the profile does show up on the event. One site admin is seeing an error, "Can't use this profile on this event type" though I haven't seen that error.

It doesn't seem possible to change that setting via the UI. What happens if you change that data in the db. Where is that info kept in the db?

Thanks,

Shai

[Coleman Watts]

I wonder if "Meeting" is the machine name and "Retreat" is the display name for the event type in the DB. Can you peek into your civicrm_option_value sql table and let me know?
If so we should identify where Civi code is displaying the wrong field.

[Shai]

Coleman,

Thanks for the help.

What you suggested does not appear to be the problem.

I ran

Code: [Select]

SELECT *
FROM  civicrm_option_value
WHERE label =  "Meeting"
I also ran

Code: [Select]

SELECT *
FROM  civicrm_option_value
WHERE name =  "Meeting"
Both queries returned the same two records. One record with option_group_id "2", which is activities. And the other record with option_group_id "14" which is event types.

I also ran

Code: [Select]

SELECT *
FROM  civicrm_option_value
WHERE label =  "Retreat"
and

Code: [Select]

SELECT *
FROM  civicrm_option_value
WHERE name =  "Retreat"
Both queries returned the same one record with group_option_id is "14", event types.

Where in the db are profiles associated with types?

Any other ideas?

Thanks much.