CiviCRM Community Forums (archive)

Howdy,

Something odd started a while ago: When we save new records and/or modify existing records, street_address, city, and postal_code information in the civicrm_address table for that record saves as NULL instead.  If I manually change the database record for any of these fields and view the contact in CiviCRM, the data remains intact and displays correctly.  If I open up the CiviCRM page to edit a contact I manually entered data for, that information displays correctly on the editing page.  If I save that contact (without changing anything), the aforementioned fields become NULL again.

It appears that the code that's populating the database UPDATE query has some variable mismatch issues, which is why NULL values are getting overwritten in the database for record writes. I've looked at the schema in the live database, and I can't see anything miskeyed or out of place.  I'm considering turning on debugging tools but I'm (a) not sure that they'll report useful info and (b) there are bold warnings to not use them on live production sites, which this is.

My goal is to get CiviCRM to start saving data to these fields again.  I'm currently looking at records from the last times CiviCRM saved records properly and am cross-referencing that with any Drupal modules I may have installed/activated at that time (I don't expect that Drupal modules would cause this to occur, but...).  I'd appreciate any observations, thoughts, tips, or recommendations for doing so (Other than "Revert back to saved copy of last known 'good' version.") and/or isolating the cause.

Thank you,

Jonathan L.

Howdy,

There's a screenshot of the PHPMyAdmin screen of my two most recent test entries at:

http://texvet.org/civicrm_null_tables.png

That street_address is null, as well as quite a few other fields...

(I'll come back and provide more info, but I'm about to attempt to upgrade Civi and my team's waiting on that, so I gotta go for now...)

Jonathan L.

Howdy,

FYI: FWIW, I had address parsing turned off.  I enabled that and now it's saving the parsed parts, but it's NULLing out my street_addres, city, and postal_code.

I just upgraded to CiviCRM 4.4.3 this morning, but that's not the cause.  This situation was occurring before I upgraded from 4.2.something.

Jonathan L.

Thanks for sharing!