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 »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Can't change e-mail on a contact
Pages: [1]

Author Topic: Can't change e-mail on a contact  (Read 1101 times)

adshill

  • I post occasionally
  • **
  • Posts: 96
  • Karma: 8
Can't change e-mail on a contact
January 12, 2012, 11:24:03 pm
We have imported contacts, then imported memberships. For the individual members who have an inherited membership from their employer, we can't update the e-mail addresses. When trying to alter e-mail we get the following error:

Code: [Select]
Sorry. A non-recoverable error has occurred.
DB Error: constraint violation
The backtrace shows:

Code: [Select]
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 159
, handle,
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 968
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2424
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1054
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/CRM/Core/DAO.php, insert, 288
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/CRM/Member/BAO/Membership.php, save, 95
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/CRM/Member/BAO/Membership.php, add, 256
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/CRM/Contact/BAO/Relationship.php, create, 1206
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/CRM/Contact/BAO/Contact/Utils.php, relatedMemberships, 366
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/CRM/Contact/BAO/Contact/Utils.php, currentEmployerRelatedMembership, 328
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php, createCurrentEmployerRelationship, 211
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php, add, 273
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/CRM/Contact/Form/Contact.php, create, 918
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 250
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php, mainProcess, 153
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php, realPerform, 130
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 284
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/CRM/Utils/Wrapper.php, run, 115
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 196
/var/www/vhosts/mysite.com/httpdocs/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 451
, civicrm_invoke,
/var/www/vhosts/mysite.com/httpdocs/includes/menu.inc, call_user_func_array, 503
/var/www/vhosts/mysite.com/httpdocs/index.php, menu_execute_active_handler, 21
Any ideas what might be going on here? Its not a complex setup but as you can imagine, changing e-mail address is vital!

For info - these contacts do have a user linked to them but the error was happening prior to the user (drupal) being imported.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Can't change e-mail on a contact
January 13, 2012, 09:45:14 am
Adam - What version of Civi is this? Can you see if this error pops up on the 4.1 public sandbox?
http://sandbox.drupal.civicrm.org/
Protect your investment in CiviCRM by  becoming a Member!

adshill

  • I post occasionally
  • **
  • Posts: 96
  • Karma: 8
Re: Can't change e-mail on a contact
January 13, 2012, 03:40:56 pm
Hi Dave,

Doesn't look like it no. I tried creating a similar scenario and the e-mail changed fine :(

I probably need to dig deeper on this one so any pointers even on the debugging side greatly appreciated! Its strange. There are only 17 corporate members out of a database of 1000 so its a minority but not being able to change the e-mail address is a show-stopper!!

For info, the version I'm running is 4.08 - recently upgraded from 4.06

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Can't change e-mail on a contact
January 16, 2012, 11:11:42 am
Adam - there were a few bugs in 4.0.x related to the implementation of membership price sets (membership ID's in several classes can be an array with multiple items rather than an integer). I think we caught all of these during the 4.1 alpha / beta cycle which may be why it doesn't happen on the 4.1 sandbox. Might be worth doing a test upgrade of that DB to 4.1 beta2 and seeing if that fixes the issue.
Protect your investment in CiviCRM by  becoming a Member!

adshill

  • I post occasionally
  • **
  • Posts: 96
  • Karma: 8
Re: Can't change e-mail on a contact
February 07, 2012, 04:11:28 am
Thanks Dave.

Unfortunately I've run this by the client (I'm actually sub-contracting on this so its another agency) and they're not happy about moving to a Beta. I see Beta 3 has been released, I'm wondering how long it'll be before a stable release? At this stage we're considering removing the membership links between the corporate memberships (they are only 18) but of course would love it if we could implement by just doing an upgrade!

Any guesstimates for release at this stage?

Thanks a lot for your help,

Adam

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Can't change e-mail on a contact
February 07, 2012, 09:13:03 am

4.1 final is planned for release sometime mid next week

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

adshill

  • I post occasionally
  • **
  • Posts: 96
  • Karma: 8
Re: Can't change e-mail on a contact
February 07, 2012, 02:10:48 pm
Great news. We'll hold out till then.

Thanks.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Can't change e-mail on a contact

This forum was archived on 2017-11-26.