Fiji is separated into 5 divisions, however civicrm only includes 4 in the dropdown "State" list. Here are what the "State" options should be..

  • Northern
  • Western
  • Central (MISSING)
  • Eastern
  • Rotuma

I am assuming that it would be ok to do MySQL> insert into civicrm_state_province(name, abbreviation, country_id) values('Central', 'C', 1074);

Is it OK to do this, and if I do this, what will happen if and when Civicrm updates/upgrades ?

Thanks for your help...


In theory you could update this by yourself via SQL. There are two arguments against this thought:

  • The ID won't match anyone else's Civi, which could lead to problems with third-party extensions.
  • This is a change that the rest of the community can benefit from.

I would file a ticket at issues.civicrm.org. If you have the chops to create a Github pull request, great! If not, no worries. Please be sure to include a reference to sources showing the missing "State", such as https://en.wikipedia.org/wiki/Local_government_in_Fiji.

  • Thank you for taking the time to answer my question. Good advice that i'll follow.. However issues.mayfirst.org doesn't resolve anywhere – AaronS NZ Aug 11 '15 at 4:42
  • I think he meant issues.civicrm.org. – Andrew Hunt Aug 11 '15 at 5:13
  • For assistance getting this fix into CiviCRM, there's a chat channel at chat.civicrm.org/civicrm/channels/dev-newcomers - you should find someone happy to help you through the process. Hi from Dunedin! – Chris Burgess Jan 17 '17 at 22:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.