CiviCRM Community Forums (archive)

The {domain.address} token in our CiviMail mailings is being rendered without the 'state_province' field showing. This did not occur under 1.7 before we upgraded. It does not seem to be related to the 'Administration > Global Settings > Address Settings' either; these show the {state_province} field.

Has anyone seen this before? Any ideas on the cause?

In my troubleshooting, I could not figure out where in the database the domain address information is stored. I searched every table for the domain's street address with no meaningful results. Can anyone tell me where the data entered in the 'Administration > Domain Information' page is stored?

Thanks,

Matt

The {domain.address} token in our CiviMail mailings is being rendered without the 'state_province' field showing. This did not occur under 1.7 before we upgraded. It does not seem to be related to the 'Administration > Global Settings > Address Settings' either; these show the {state_province} field.

Has anyone seen this before? Any ideas on the cause?

In my troubleshooting, I could not figure out where in the database the domain address information is stored. I searched every table for the domain's street address with no meaningful results. Can anyone tell me where the data entered in the 'Administration > Domain Information' page is stored?

Matt - I've updated http://issues.civicrm.org/jira/browse/CRM-2565 to make sure the state_province is properly handled in 2.0 (once the fatal error you reported has been fixed :-) ).

As far as debugging 1.9, I can tell you that the domain address is stored in civicrm_address. To find it you need to first find the civicrm_location record where entity_table = 'civicrm_domain' and entity_id = 1 (or your domain_id if it's not 1). Then find the civicrm_address record with that location_id.

Assuming the data looks good, you'll probably have to add some debug statements to the token eval code (CRM/Utils/Token.php).