CiviCRM Community Forums (archive)

Joomla 1.0.15 and CiviCRM 2.0.6 w/ Authorize.net proccessor

So far we have had over +70 people register w/out issue, but we received the following feedback from a user in Japan attempting to register for an event. 

The person entered in a address of with a city Nagoya, 23 4660825 JP.

Everything was fine on the registration Registration summary page until they clicked on "Continue" to finalize the transaction, they received the following msg:

Sorry. A non-recoverable error has occurred.
DB Error: unknown error
 Cannot add or update a child row: a foreign key constraint fails (`dbname/civicrm_address`, CONSTRAINT `FK_civicrm_address_state_province_id`
FOREIGN KEY (`state_province_id`) REFERENCES `civicrm_state_province` (`id`) ON DELETE SET NULL), 1452

We noticed the the Nagoya is not a default city in civicrm_state_province table.

Should it be in the table in order to complete the transaction?
Is the solution to simply do an insert and add that city with the correct FK ref to Country?

Thanks for any suggestions or feedback.

-B