CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Country :: Singapore dont have a state!
Pages: [1]

Author Topic: Country :: Singapore dont have a state!  (Read 691 times)

redking

  • I’m new here
  • *
  • Posts: 28
  • Karma: 2
  • CiviCRM version: CiviCRM 4.1.0
  • CMS version: Joomla! 2.5.4
  • MySQL version: 5.1.30
  • PHP version: 5.2.8
Country :: Singapore dont have a state!
March 10, 2010, 02:30:56 am
Hi guys,

keep up the good work!

I have discovered that Singapore don't have a state. It is a City State.

When selecting the country as Singapore. The state follows but in civicrm state is not defined as City State, hence when user selects the country as Singapore then the state select option gets STUCK!!

Did this strike anybody?  How to overcome this issue?


Thanks
redking

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Country :: Singapore dont have a state!
March 10, 2010, 06:45:08 am

There is an issue in the system to fix this bug. Bermuda is another example. check this issue:

http://issues.civicrm.org/jira/browse/CRM-5427

there is a temporary work-around in there. If you can submit a patch for this issue that would be great. We can help u get started on IRC

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

redking

  • I’m new here
  • *
  • Posts: 28
  • Karma: 2
  • CiviCRM version: CiviCRM 4.1.0
  • CMS version: Joomla! 2.5.4
  • MySQL version: 5.1.30
  • PHP version: 5.2.8
Re: Country :: Singapore dont have a state!
March 10, 2010, 08:45:05 pm
Hi Lobo,

I found a way around!

I edited the data base tables and inserted a  City-State-Singapore in the
table "civicrm_state_province" inserted a state called as City-State-Singapore

new id for state as 10020
name of the state as City State - Singapore
abbreviation as SING
country id as 1191

it works!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Country :: Singapore dont have a state!

This forum was archived on 2017-11-26.