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) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.1 Release Testing »
  • Add "Brussel" in civicrm_state_province
Pages: [1]

Author Topic: Add "Brussel" in civicrm_state_province  (Read 2954 times)

geert.je

  • I’m new here
  • *
  • Posts: 16
  • Karma: 2
    • Flemish environment movement
  • CiviCRM version: 4.1.0
  • CMS version: Drupal 7
Add "Brussel" in civicrm_state_province
September 23, 2008, 12:06:45 pm
Is it possible to add "Brussel" to the table civicrm_state_province (county_id = 1020)
I didn't find a way to do it with administer civicrm.
When I added a new record directly in the database, I get some errors when updating 2.0.3 to 2.1 beta 3 (concerning FOREIGN KEY CONSTRAINT)
Thanks.
Geert

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Add "Brussel" in civicrm_state_province
September 24, 2008, 12:20:21 am
Quote
Is it possible to add "Brussel" to the table civicrm_state_province (county_id = 1020)
I am assuming you mean country_id = 1020

Have you added "Brussel" in your 2.0 db ?

Kurund
Found this reply helpful? Support CiviCRM

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Add "Brussel" in civicrm_state_province
September 24, 2008, 04:11:53 am
Quote from: geert.vosec on September 23, 2008, 12:06:45 pm
Is it possible to add "Brussel" to the table civicrm_state_province (county_id = 1020)
I didn't find a way to do it with administer civicrm.

It does indeed seem that Brussels was missing from the Belgian province list. I filed CRM-3609 and fixed this for both 2.1 and 2.2.

Quote from: geert.vosec on September 23, 2008, 12:06:45 pm
When I added a new record directly in the database, I get some errors when updating 2.0.3 to 2.1 beta 3 (concerning FOREIGN KEY CONSTRAINT)

You most probably added Brussels with the id that we used for some other state in 2.1. The ‘official’ id is 5217 (as per r17233). Let me know if you need help with upgrading your database to the ‘common’ numbering.
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

geert.je

  • I’m new here
  • *
  • Posts: 16
  • Karma: 2
    • Flemish environment movement
  • CiviCRM version: 4.1.0
  • CMS version: Drupal 7
Re: Add "Brussel" in civicrm_state_province
September 24, 2008, 06:43:17 am
Thank you all.
I learned:
- civicrm community is really fast!!
- there is something like ISO 3166 and you cannot ignore it

For me everything is clear now.
Geert
« Last Edit: September 24, 2008, 06:53:29 am by geert.vosec »

geert.je

  • I’m new here
  • *
  • Posts: 16
  • Karma: 2
    • Flemish environment movement
  • CiviCRM version: 4.1.0
  • CMS version: Drupal 7
Re: Add "Brussel" in civicrm_state_province
September 25, 2008, 06:02:11 am
I expected to find "Brussel" in beta 6 demo but it doesn't show up when editing a record. Belgium is selected for the regions at "administer civicrm" > "global settings" > "localization"
Geert

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Add "Brussel" in civicrm_state_province
September 26, 2008, 02:36:20 am
That’s because demo was running from an old database dump (that lacked Brussels) instead of being a fresh beta6 install. I updated it to carry Brussels (so it reflects how a fresh 2.1.beta6 install behaves in this regard).
« Last Edit: September 26, 2008, 03:23:02 am by Piotr Szotkowski »
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.1 Release Testing »
  • Add "Brussel" in civicrm_state_province

This forum was archived on 2017-11-26.