CiviCRM Community Forums (archive)

Hi,

For some contacts with first and last name set, the sort_name is not getting set, sort_name remains their email.  Editing the contact via Contact Record and saving seems to fix this, and then the sort_name is set after the save.

My theory is these were Contacts that were created via Profile by users during Drupal registration, but I don't have any proof of that at the moment.

Is there a script to run to update sort_name for all contacts?  Would it be /bin/UpdateAddress.php or /bin/UpdateGreeting.php perhaps?

Thx, I ran a backup don't worry. 

The script worked, although I tweaked it a little.  I also ran a SELECT statement first to get an idea of how many records would be affected by the UPDATE, and the answer was 20.  Then I did the UPDATE.

I'm going to run that SELECT again in a couple of weeks to keep an eye on the count to determine if this is an ongoing problem for the database.

We are having the same issue with a few clients.  The sort name name is sometimes replaced by their email -- this happened to 238 of 25,000 individual contacts.  The same type of issue with display name, but they tend to be missing middle name, Prefix, Suffix.

These are fixed one at a time by the editing the record or I can update the database record.

Is this something relatively new (version 3.2x)? 

Any idea what may be causing it?  Does it have anything to do with updating the contact via a profile?