Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.0.0
-
Fix Version/s: 3.4.1
-
Component/s: None
-
Labels:None
Description
Missing two Spanish provinces in the table "civicrm_state_province" which prevents the import of some data. Error displayed is "Invalid value for field(s) : State / Province":
- Toledo: http://es.wikipedia.org/wiki/Provincia_de_Toledo
- Córdoba: http://es.wikipedia.org/wiki/C%C3%B3rdoba_%28Espa%C3%B1a%29
The script required to add those provinces is:
INSERT INTO civicrm_state_province (`id` ,`name` ,`abbreviation` ,`country_id`) VALUES (NULL , 'Toledo', 'TO', '1198');
INSERT INTO civicrm_state_province (`id` ,`name` ,`abbreviation` ,`country_id`) VALUES (NULL , 'Córdoba', 'CO', '1198');