CiviCRM Forums
News: You can learn more about CiviCRM from our new free book: Understanding CiviCRM. Also Check the CiviCRM Blog for updated information on CiviCRM
 
Home Help Search Login Register
*
Welcome, Guest. Please login or register.
Did you miss your activation email? 		September 02, 2010, 08:49:26 am


Login with username, password and session length


CiviCRM Forums > Support > Using CiviCRM > Using CiviEvent (Moderator: Michał Mach) > Country :: Singapore dont have a state!
Pages: [1]
« previous next »
  Print  
Author Topic: Country :: Singapore dont have a state!  (Read 142 times)
redking
I’m new here
*

Karma: 2
Offline Offline

Posts: 21


View Profile
« on: 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
Logged
Donald Lobo
Administrator
I’m (like) Lobo ;)
*****

Karma: 330
Offline Offline

CiviCRM: 3.2
CMS: Drupal 6.x, Joomla 1.5.x
MySQL: MySQL 5.1.x
PHP: PHP 5.3.x

Posts: 9357



View Profile WWW
« Reply #1 on: 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
Logged
Use CiviCRM? Like CiviCRM? Then show your appreciation and make a donation.
redking
I’m new here
*

Karma: 2
Offline Offline

Posts: 21


View Profile
« Reply #2 on: 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!
Logged
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC

Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM