CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Profiles (Moderator: Dave Greenberg) »
  • profile type has wrong data
Pages: [1]

Author Topic: profile type has wrong data  (Read 452 times)

Shai

  • I post frequently
  • ***
  • Posts: 202
  • Karma: 8
    • Content2zero
  • CiviCRM version: 4.3.x, 4.4.x, 4.5.x
  • CMS version: Drupal 7
  • MySQL version: 5.5.x
  • PHP version: 5.3.x, 5.4.x
profile type has wrong data
March 23, 2015, 12:51:56 pm
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
Don't miss out! Sign up now for free expert advice on CiviCRM's new StackExchange help site.

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: profile type has wrong data
March 23, 2015, 01:48:56 pm
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.
Try asking your question on the new CiviCRM help site.

Shai

  • I post frequently
  • ***
  • Posts: 202
  • Karma: 8
    • Content2zero
  • CiviCRM version: 4.3.x, 4.4.x, 4.5.x
  • CMS version: Drupal 7
  • MySQL version: 5.5.x
  • PHP version: 5.3.x, 5.4.x
Re: profile type has wrong data
March 23, 2015, 02:36:08 pm
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.
Don't miss out! Sign up now for free expert advice on CiviCRM's new StackExchange help site.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Profiles (Moderator: Dave Greenberg) »
  • profile type has wrong data

This forum was archived on 2017-11-26.