Can't save City or Postal code for new records or edits

[ericross]

I've just realized that City and Postal code field values are not being saved on new record entries or edits. This also means that editing a record erases the existing City and Postal Code.

The log at /files/civicrm/ConfigAndLog/ has this entry many times and may point to the problem. We do have a customization to include County in a Contacts Address but County values are not affected.

Any idea how to sort this?

Mar 27 23:50:26  $Fatal Error Details = Array

    Could not find the required contact id parameter (id=) for viewing a contact record with a Profile.

Code: [Select]

Mar 27 23:50:26  [info] $backTrace = #0 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(322): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Profile/Page/View.php(71): CRM_Core_Error::fatal("Could not find the required contact id parameter (id=) for viewing a contact ...")
#2 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Profile/Page/View.php(173): CRM_Profile_Page_View->preProcess()
#3 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(323): CRM_Profile_Page_View->run((Array:3), NULL)
#4 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:13))
#5 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#6 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm.php(466): CRM_Core_Invoke::invoke((Array:3))
#7 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm.php(738): CiviCRM_For_WordPress->invoke()
#8 /home/ndpnyorg/public_html/wp-content/plugins/civicrm/civicrm.php(1140): CiviCRM_For_WordPress->wp_frontend(TRUE)
#9 [internal function](): CiviCRM_For_WordPress->shortcode_handler((Array:3), "", "civicrm")
#10 /home/ndpnyorg/public_html/wp-includes/shortcodes.php(273): call_user_func((Array:2), (Array:3), "", "civicrm")
#11 [internal function](): do_shortcode_tag((Array:7))
#12 /home/ndpnyorg/public_html/wp-includes/shortcodes.php(188): preg_replace_callback("/\[(\[?)(embed|wp_caption|caption|gallery|audio|video|Archives|archives|civic...", "do_shortcode_tag", "[civicrm component=\"profile\" gid=\"11\" mode=\"view\"]\n")
#13 [internal function](): do_shortcode("[civicrm component=\"profile\" gid=\"11\" mode=\"view\"]\n")
#14 /home/ndpnyorg/public_html/wp-includes/plugin.php(199): call_user_func_array("do_shortcode", (Array:1))
#15 /home/ndpnyorg/public_html/wp-includes/post-template.php(166): apply_filters("the_content", "[civicrm component=\"profile\" gid=\"11\" mode=\"view\"]")
#16 /home/ndpnyorg/public_html/wp-content/themes/twentyfourteen/content.php(54): the_content("Continue reading <span class=\"meta-nav\">&rarr;</span>")
#17 /home/ndpnyorg/public_html/wp-includes/template.php(443): require("/home/ndpnyorg/public_html/wp-content/themes/twentyfourteen/content.php")
#18 /home/ndpnyorg/public_html/wp-includes/template.php(417): load_template("/home/ndpnyorg/public_html/wp-content/themes/twentyfourteen/content.php", FALSE)
#19 /home/ndpnyorg/public_html/wp-includes/general-template.php(132): locate_template((Array:1), TRUE, FALSE)
#20 /home/ndpnyorg/public_html/wp-content/themes/twentyfourteen/index.php(41): get_template_part("content", FALSE)
#21 /home/ndpnyorg/public_html/wp-includes/template-loader.php(74): include("/home/ndpnyorg/public_html/wp-content/themes/twentyfourteen/index.php")
#22 /home/ndpnyorg/public_html/wp-blog-header.php(16): require_once("/home/ndpnyorg/public_html/wp-includes/template-loader.php")
#23 /home/ndpnyorg/public_html/index.php(17): require("/home/ndpnyorg/public_html/wp-blog-header.php")
#24 {main}



[ericross]

This also affects the Default Organization Address. [/size]We are not able to save the organization Address, City or Postal Code which means we cannot send bulk mail because the information is not available for the [/color][/size]{domain.address} token.[/color]

[joanne]

Has this always been the case for this site?  If not what has changed? (new plugin, update of something in your hosting environment etc)

[Eileen]

I don't think the backtrace you have posted relates to the problem - I think that is due to people/ bots hitting invalid profile urls. You might have one with an sql error in it in there somewhere?

If you have logging on try turning it off & back on (check while it's off as well as after it is back on). Is your site multilingual?

[ericross]

I still have this problem with logging off.
[/size]
[/size]This site is not multilingual.
[/size]
[/size]See the attached log file showing errors when opening the CiviCRM dashboard and adding a new record.

[joanne]

You should upgrade to 4.4.5 as there have been two updates with bug fixes since 4.4.3 which could have solved your problem.

[ericross]

Upgraded to 4.4.5 and still lose City and Postal Code when saving a record.

Edit and Add new records come back with blank City and Postal Code.


Logging is on again.


When I load the contact record, Smarty debug shows that City and Postal Code fields for {$address} are not included. What would cause this?

1 => Array (19)
  id => "3249"
  contact_id => "3941"
  location_type_id => "3"
  is_primary => "1"
  is_billing => "0"
  street_number => "267"
  street_name => "Bay Ridge Avenue"
  county_id => "2002"
  state_province_id => "1031"
  country_id => "1228"
  geo_code_1 => "37.09024"
  geo_code_2 => "-95.712891"
  manual_geo_code => "0"
  name => "Gateway City Church Location"
  address_name => "Gateway City Church Location"
  display => "<div class="location vcard"><span cla..."
  display_text => "Gateway City Church Location NY Unite..."
  location_type => "Main"
 

When I go to edit mode, {$addressSequence} does include city_postal_code so I can enter the values on the screen.

Array (7)
0 => "address_name"
1 => "street_address"
2 => "supplemental_address_1"
3 => "supplemental_address_2"
4 => "city_postal_code"
5 => "country_state_province"
13 => "county"