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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Problem with editing address fields
Pages: [1]

Author Topic: Problem with editing address fields  (Read 2130 times)

JLong

  • I post occasionally
  • **
  • Posts: 33
  • Karma: 0
Problem with editing address fields
June 09, 2008, 09:08:43 pm
I am having a problem with editing address information for users/contacts. When I enter field data and submit the form, the data disappear. I have checked the DB tables and the changes do not appear there either. This problem happens under different login conditions:
1) logged in as admin and editing through the Find Contacts-Edit interface.
2) logged in as user and editing through a custom profile in the drupal user account.

The following fields are affected: street address, city, postal code.
The following fields are not affected: state, phone.
In the profile these are all keyed as the Primary fields (as opposed to Main, Billing, etc.)

Two other things:
1) The entries are still present during form validation, because if I leave required fields empty, I trigger a "fill in these fields" error.
2) The contacts I'm trying to edit have valid address data in them initially. If I pull up a contact in edit mode, make no changes, and click Submit, the existing address information is deleted from the specified fields.

Any help is appreciated.

Matt2000

  • I post frequently
  • ***
  • Posts: 288
  • Karma: 27
    • http://www.ninjitsuweb.com
Re: Problem with editing address fields
June 09, 2008, 09:51:05 pm
More information needed. CiviCRM version, CMS ? Any errors in your logs? Any errors from Firebug, if you have that?
Drupal/CiviCRM micro-blogging http://twitter.com/matt2000

Ninjitsu Web Development http://www.NinjitsuWeb.com/

JLong

  • I post occasionally
  • **
  • Posts: 33
  • Karma: 0
Re: Problem with editing address fields
June 09, 2008, 09:58:39 pm
Sorry.
CiviCRM 1.9 with Drupal 5.1.
No entries in Drupal logs. Are there other logs I can consult?
Also no errors from Firebug.

Matt2000

  • I post frequently
  • ***
  • Posts: 288
  • Karma: 27
    • http://www.ninjitsuweb.com
Re: Problem with editing address fields
June 09, 2008, 10:10:48 pm
hmm. Very strange. You might want to upgrade to 2.0, though this is obviously not an inherent problem in 1.9 .

Are you possibly using an unsupported version of MySQL ?
Drupal/CiviCRM micro-blogging http://twitter.com/matt2000

Ninjitsu Web Development http://www.NinjitsuWeb.com/

JLong

  • I post occasionally
  • **
  • Posts: 33
  • Karma: 0
Re: Problem with editing address fields
June 10, 2008, 08:37:38 am
PHP Version 5.2.5

JLong

  • I post occasionally
  • **
  • Posts: 33
  • Karma: 0
Re: Problem with editing address fields
June 16, 2008, 09:20:28 pm
An update to this topic...I run into the same problem when I manually add a new contact to the CRM.
I would appreciate any thoughts on ways to uncover the source of this problem. I'm at a loss as to where to look next.

JLong

  • I post occasionally
  • **
  • Posts: 33
  • Karma: 0
Re: Problem with editing address fields
November 09, 2008, 07:06:37 pm
After a long hiatus, I have completed upgrading our site to Drupal 6.6, CiviCRM 2.1. The problem described above remains. To resummarize:

When I submit a form containing address information, data in certain fields is stripped before the database is updated. "Stripped" might be the wrong term, but the end result is that the database value for these fields is NULL. These fields include street_address, city, and postal_code (I'm using field names from the civicrm_address table). The supplemental_address_1 and supplemental_address_2 fields do not demonstrate this problem.

This occurs whether I am editing an existing contact record or submitting a new contact record. If I manually update the address table using phpmyadmin, the manually edited information will appear the next time I bring up that contact record.

I would appreciate any advice. Site specs:
Drupal 6.6
CiviCRM 2.1
MySQL 5.0.51a
PHP 5.2.5

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Problem with editing address fields
November 09, 2008, 08:22:26 pm
Do you happen to have "Address Standardization" feature enabled in this site? Check Admin CiviCRM >> Global Settings >> Address Settings (bottom of form). If so, try removing values in that fieldset and retry editing. If that's not the issue, I would also checking if you have a Mapping Provider enabled and try disabling that (altho it's less clear to me how that might trigger the behavior you're describing).
Protect your investment in CiviCRM by  becoming a Member!

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Problem with editing address fields
November 09, 2008, 08:26:22 pm
Worth just verifying what is meant by "When I submit a form " - are we talking a profile, or the contact summary page, or what? a url may also give a clue as to where you are having this problem
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

JLong

  • I post occasionally
  • **
  • Posts: 33
  • Karma: 0
Re: Problem with editing address fields
November 09, 2008, 08:33:48 pm
Quote from: Dave Greenberg on November 09, 2008, 08:22:26 pm
Do you happen to have "Address Standardization" feature enabled in this site? Check Admin CiviCRM >> Global Settings >> Address Settings (bottom of form). If so, try removing values in that fieldset and retry editing.
This solved the problem...I cleared the address standardization fields and I can now edit addresses. Thank you so much.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Problem with editing address fields

This forum was archived on 2017-11-26.