Author Topic: Error: "Profile already exists in Database" on update  (Read 955 times)

Offline annaleevk

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 4
  • Carpe Noctem!
    • Women in Development, New York
  • CiviCRM version: 3.4.5
  • CMS version: Drupal 6.22
  • MySQL version: 5.1.48
  • PHP version: 5.2.14
Error: "Profile already exists in Database" on update
« on: August 07, 2011, 07:43:51 am »
Have seen this error in 3.4.2 thru 3.4.5.  I get "Profile already exists in Database" error when I try to change something on an existing profile.

When I browse the UF_Group table I see that there are 3 rows that contain the same name.  I think this is happening when I copy an existing profile.  Instead of assigning the profile the new name, it's using the name of the copied profile for the name value.

To fix it for now, I had to manually edit the name in the uf_group table.
Annalee Van Kleeck
Lyric Systems, LLC
201 951.8711
annalee@lyricsystems.com

Offline Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 14722
  • Karma: 440
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Error: "Profile already exists in Database" on update
« Reply #1 on: August 07, 2011, 10:53:40 am »

can u please file an issue and link to this forum topic. We'll fix it in a future release. If you can work on a patch for this that would be great (and help get it into an earlier release)

lobo
Found this reply helpful? Contribute NOW and help improve CiviCRM with the Make it Happen! initiative.

Offline Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 3992
  • Karma: 120
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Error: "Profile already exists in Database" on update
« Reply #2 on: August 08, 2011, 05:51:30 am »
Can you also copy + paste the error message during the upgrade process.

Kurund
Found this reply helpful? Support CiviCRM

Offline corster

  • I post occasionally
  • **
  • Posts: 72
  • Karma: 0
  • CiviCRM version: CiviCRM 4.0.x
  • CMS version: Joomla 1.7.x
Re: Error: "Profile already exists in Database" on update
« Reply #3 on: August 08, 2011, 10:58:05 am »
FYI, this happens in 4.0.5 also.  We just upgraded from 4.0.4.
Curtis

Offline annaleevk

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 4
  • Carpe Noctem!
    • Women in Development, New York
  • CiviCRM version: 3.4.5
  • CMS version: Drupal 6.22
  • MySQL version: 5.1.48
  • PHP version: 5.2.14
Re: Error: "Profile already exists in Database" on update
« Reply #4 on: August 13, 2011, 09:25:35 am »
Lobo,

I've never filed an issue before but if you tell me how to do it, I will, however, I am not a programmer so I cannot help you patch this.

- Annalee
Annalee Van Kleeck
Lyric Systems, LLC
201 951.8711
annalee@lyricsystems.com

Offline Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 3992
  • Karma: 120
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Error: "Profile already exists in Database" on update
« Reply #5 on: August 13, 2011, 11:49:31 am »
Found this reply helpful? Support CiviCRM

Offline annaleevk

  • I post occasionally
  • **
  • Posts: 87
  • Karma: 4
  • Carpe Noctem!
    • Women in Development, New York
  • CiviCRM version: 3.4.5
  • CMS version: Drupal 6.22
  • MySQL version: 5.1.48
  • PHP version: 5.2.14
Re: Error: "Profile already exists in Database" on update
« Reply #6 on: August 14, 2011, 12:05:26 pm »
Thanks, Kurund!  Issue has been filed.
Annalee Van Kleeck
Lyric Systems, LLC
201 951.8711
annalee@lyricsystems.com