CiviCRM Community Forums (archive)

This might be a really strange one and although I'm the tech for this site, the configuration was done by someone else after I set it up with Drupal 6/civiCRM 3.1. That person has since left the organization and we have updated it to civiCRM 3.4.6.

The issue is that the Main Street Address fields on a number of records in a civiCRM installation appear to be corrupted somehow. We've only discovered this when exporting the membership to print mailing labels but it is quite an odd issue. The symptoms are as follows:

1) When looking at the contact dashboard and just viewing the contact record it all looks pretty normal... In all cases the "Main Street Address" is populated and most if not all contact records have set the main location as the primary location. However when you export a mailing list and one of the fields is the primary location street address, some records are exported with an empty field for primary location street address.

2) If you then look at each record that is in question (/civicrm/contact/view?reset=1&cid=xxx), the main location looks fine (the main street address is populated) but if you edit it, you will see that it does not contain a main location street address. In most instances I've looked at the main location city, state, country, zip are populated.

3) This is where it gets weird... If you simply add a street address to the empty field and save it, it will now view (/civicrm/contact/view?reset=1&cid=xxx) with two street addresses for the main location.

4) The only way I have been able to fix this issue is by using the "delete this address" tool and replacing it with a brand new address record.

* I don't know when this occurred because the person who was managing the CRM has left the organization but some of the existing people have indicated that this has been going on for a while so I don't think it was introduced by upgrading from 3.1 to 3.4.5 and then to 3.4.6. That said, I have noticed it has been occurring with new contact records more often than not.

Drupal 6.26
civiCRM 3.4.6

Ok, I solved this. It was pretty simple but hard to find so I've put a brief description below in case it comes up again:

After lots of testing and review, I noticed that this problem only occured for applicants who signed up online via one of the membership form so I looked at the fields in the profile that was used in that form. The problem was someone had set up the Address Name field as the Address Main field.

We don't even use the Address Name field anywhere in the system so we never pulled out a report where we would have caught that but if that field has a value, it will be included when viewing the contact record which meant that if we saw a record  that had no street address and edited/added it, Then in the contact record it would appear to have the same field show up twice. Crazy 

So now I have to go in and remove Address Name fields and add Street addresses for a bunch of records.