My best guess is you manually updated the *_connections_addresses table, yes? The problem is the address data is also cached in the *_connections table. That cached data is what is used for display. This is done to ensure as few db queries as possible. The actual *_connections_addresses table is only used when editing the entry and searches. Unfortunately there is no way to bulk update this cache.
What could be done, is disable the use of the address cache but that does mean an extra db query per entry shown on the page. Depending on the host this time is actually fairly minute probably in the realm of .005 seconds.
To disable the cache, install the Code Snippets plugin.
Add a new snippet with the following code:
function cn_disable_output_cache( $cached ) {
return FALSE;
}
function cn_enable_output_cache() {
remove_filter( 'cn_address_cached', 'cn_disable_output_cache' );
//remove_filter( 'cn_phone_cached', 'cn_disable_output_cache' );
//remove_filter( 'cn_email_cached', 'cn_disable_output_cache' );
//remove_filter( 'cn_messenger_cached', 'cn_disable_output_cache' );
//remove_filter( 'cn_social_network_cached', 'cn_disable_output_cache' );
//remove_filter( 'cn_link_cached', 'cn_disable_output_cache' );
//remove_filter( 'cn_date_cached', 'cn_disable_output_cache' );
}
add_filter( 'cn_address_cached', 'cn_disable_output_cache' );
//add_filter( 'cn_phone_cached', 'cn_disable_output_cache' );
//add_filter( 'cn_email_cached', 'cn_disable_output_cache' );
//add_filter( 'cn_messenger_cached', 'cn_disable_output_cache' );
//add_filter( 'cn_social_network_cached', 'cn_disable_output_cache' );
//add_filter( 'cn_link_cached', 'cn_disable_output_cache' );
//add_filter( 'cn_date_cached', 'cn_disable_output_cache' );
add_action( 'cn_update-entry', 'cn_enable_output_cache');
add_action( 'cn_save-entry', 'cn_enable_output_cache');
Save and activate the new snippet.
If you need to to disable any other caches, just uncomment the related filters.
Hope that helps!
