Author Topic: Can't Remove Profile from Event Registration Form  (Read 811 times)

Offline farmrchrys

  • I post occasionally
  • **
  • Posts: 85
  • Karma: 2
    • Pine Meadow Farm Center
  • CiviCRM version: CiviCRM 4.1.0
  • CMS version: Drupal 7.15
  • MySQL version: MySQL 5.0.96-community
  • PHP version: PHP 5.2.17
Can't Remove Profile from Event Registration Form
« on: July 21, 2009, 06:43:31 am »
Hello,

Somehow I managed to accidentally include the same profile both at the top of my event registration form as well as at the bottom. When I tried to remove the bottom instance by selecting "select" from the drop-down list, the profile would remain. Looks like once you choose a profile you cannot go back to having no profile in that spot. Luckily, I decided I wanted another profile there, but there should be a way to remove any profile. Is there?

Offline grobot

  • Ask me questions
  • ****
  • Posts: 466
  • Karma: 46
  • www.giantrobot.co.nz/contact
    • Giant Robot
Re: Can't Remove Profile from Event Registration Form
« Reply #1 on: July 26, 2009, 04:00:29 pm »
See also http://forum.civicrm.org/index.php?topic=8601.0

There are duplicate entries in civicrm_uf_join which need to be removed.

Looking at one of our events (with event ID = 13), this should be:
Code: [Select]
select * from civicrm_uf_join where module = 'CiviEvent' and entity_id = 13
My testing on 2.2.7 just now shows that selecting "- Select -" as the profile does not remove a formerly added profile. The simplest workaround is to do as Pete suggests and replace it with an innocuous profile. When this is done, there will be more than two entries in civicrm_uf_join for the query above, but the weight of the third and later profiles means that they won't display.

I'll add an issue for this - although I'm pretty sure I raised this sometime in the 2.0 or 2.1 series, I can't find that ticket now. Here's the ticket: http://issues.civicrm.org/jira/browse/CRM-4790

You should be able to remove the extra entries from civicrm_uf_join via SQL.
« Last Edit: July 26, 2009, 04:07:29 pm by xurizaemon »
Giant Robot ● Drupal + CiviCRM support & consulting
@grobotwww.giantrobot.co.nz