Hi, I have used the "country" predefined list to populate a multiple select field called "TRADE_COUNTRIES" in my community. I wanted to get rid of some of the really small island nations, and things like "Antarctica" and "Vatican City", etc. I first tried this by directly editing the predefined list in the admin panel, but I was getting database errors related to the "set statement". Then I went and just deleted the countries I didn't want from the "countries" table in phpmyadmin - but they still show up in my join and edit forms! What gives? Something here that I don't understand.
-
Rob
|
Been a few weeks so I'm bumping this. Nothing earth shaking - just a mystery. I'm trying to get rid of tiny "countries" like "Vatican City" etc. I deleted them from the "countries" table in phpmyadmin, but they are still on my join and search forms - so I guess I don't know where the predefined lists are stored. Could someone help me clear this up?
-
Thanks
-
Rob
|
Sorry about the bump but this is a mystery I never solved. I'm trying to edit the country predefined list to get rid of some of the really tiny countries. I can't do this in admin because I get an error message, and when I do it in the country table directly in phpmyadmin it seems to have no effect - i.e. the obsure countries still show up on the join and edit forms. How could this be happening? Where are the predefined list tables hiding? |
Check file inc/prof.inc.php
maybe it have to be canged in both DB and file!!
|
Thanks Ottar, but I don't see any countries in inc/prof.inc.php . There is a table called "countries" in my database and - for example, I deleted "Christmas Island" from the list- but Christmas Island is still on my join form. I've cleared my cache, so I don't think that is it, and I am still stumped.
|
Every Dol. ver. bellow have it, maybe it is changed because of your "country" predefined list!! I don't now..
inc/prof.inc.php Dol 6.1.1
inc/prof.inc.php Dol 6.1.2
inc/prof.inc.php Dol 6.1.3
inc/prof.inc.php Dol 6.1.4
$aPreValues = array(
'Country' => array
|
I must have looked at the profile.inc.php by mistake. I just opened the prof.inc.php and the countries popped up right in front of me- right on top. Thanks for finding this Ottar, it was driving me nuts.
|
OK, deleting countries from that seems to work - haven't tested much but don't think it will cause any problems. If you edit country names though it may cause some underscores in your selection list unless the language keys match up.
-
As a side issue, where on earth did Boonex get that country list from? - it is not the United Nations list. I just spent quite a bit of time of Wikipedia getting a geography lesson on some really obscure countries- like- Bouvet Island - an uninhabited sub-antarctic volcanic island in the South Atlantic Ocean- several others almost as weird on the country list. Might be more important to me than others as I am also using the countries as a selection list, but if anyone else wants to pare that list down, editing the inc/prof.inc.php file seems to be the right file.
|
You can try to edit sys_countries table too. |
