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 CiviMember (Moderator: Deepak Srivastava) »
  • Trying to edit Member info post v1.7 upgrade
Pages: [1]

Author Topic: Trying to edit Member info post v1.7 upgrade  (Read 2873 times)

mixxmedia

  • Guest
Trying to edit Member info post v1.7 upgrade
July 24, 2007, 01:14:45 pm
I set the allowable Address locations to 1 (from default of 2). Then tried to edit the Primary address info and am receiving the following error:   

 Sorry. A non-recoverable error has occurred.

    Database Error Code: Duplicate entry 'civicrm_contact-161-3' for key 2, 1062

    Return to CiviCRM menu.

Error Details:

Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -5
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => UPDATE  civicrm_location  SET entity_table = 'civicrm_contact' , entity_id = 161 , location_type_id = 3 , is_primary = 1 , name = ''   WHERE (  civicrm_location.id = 129 )   [nativecode=1062 ** Duplicate entry 'civicrm_contact-161-3' for key 2]
    [type] => db_error
    [user_info] => UPDATE  civicrm_location  SET entity_table = 'civicrm_contact' , entity_id = 161 , location_type_id = 3 , is_primary = 1 , name = ''   WHERE (  civicrm_location.id = 129 )   [nativecode=1062 ** Duplicate entry 'civicrm_contact-161-3' for key 2]
    [to_string] => [db_error: message="DB Error: already exists" code=-5 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE  civicrm_location  SET entity_table = 'civicrm_contact' , entity_id = 161 , location_type_id = 3 , is_primary = 1 , name = ''   WHERE (  civicrm_location.id = 129 )   [nativecode=1062 ** Duplicate entry 'civicrm_contact-161-3' for key 2]"]
)



Thanks for any suggestions.

mxm

Michał Mach

  • Ask me questions
  • ****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Re: Trying to edit Member info post v1.7 upgrade
July 26, 2007, 02:39:44 am
Such problems sometimes occur after upgrade because of old information stored in caches. If you didn't clear your caches post upgrade, please make a search on this forum to find information about how to do it.

If you went through cache clearing stage, please try to reproduce this problem on our demo site (http://demo.civicrm.org/). If you manage to get the same effect, please post a bug report on http://issues.civicrm.org, we'll take care of it promptly. If not, please come back to this forum with more information - which CMS, which PHP version, from which CiviCRM version you were upgrading, etc and we'll try to debug your problem further.

Thx,
m
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!

rguerra

  • Guest
Re: Trying to edit Member info post v1.7 upgrade
July 26, 2007, 05:15:23 am
Could the upgrade script include a new section, one that

- reads the drupal & civicrm settings
- flush/clear the caches as needed

It could also be a separate script. I think it would be useful :)
« Last Edit: July 26, 2007, 06:17:48 am by rguerra »

Michał Mach

  • Ask me questions
  • ****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Re: Trying to edit Member info post v1.7 upgrade
July 26, 2007, 05:27:46 am
That could be potentially dangerous, if somebody configures their custom templates or custom files directory to be somewhere nearby template cache directories.

But the idea is not bad. Can you please file an issue at http://issues.civicrm.org/

Thx,
m
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!

rguerra

  • Guest
Re: Trying to edit Member info post v1.7 upgrade
July 26, 2007, 06:22:21 am
saved as ticket CRM-2132

Michał Mach

  • Ask me questions
  • ****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Re: Trying to edit Member info post v1.7 upgrade
July 26, 2007, 06:42:42 am
Thanks Robert!
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!

mixxmedia

  • Guest
Re: Trying to edit Member info post v1.7 upgrade
July 26, 2007, 06:48:17 am
Caches were cleared and problem persists. I will try recreating the problem on the demo once the v1.8 beta upgrade has been completed on the demo site.

mxm
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Trying to edit Member info post v1.7 upgrade

This forum was archived on 2017-11-26.