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 »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Countries in Localization setting keeps reverting back to only the United States
Pages: [1] 2

Author Topic: Countries in Localization setting keeps reverting back to only the United States  (Read 2485 times)

evandonovan

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.5.3
  • CMS version: Drupal 6.33
  • MySQL version: 5.5.40
  • PHP version: 5.3.10
Countries in Localization setting keeps reverting back to only the United States
November 17, 2014, 03:12:57 pm
Does anyone know of a reason why CiviCRM would be reverting back to only the United States on the admin/setting/localization page, when I have removed all countries from the right column?

I've consulted with my colleague and he has stated that we haven't done any upgrades since the last time this reversion happened.

Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1274
  • Karma: 55
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Countries in Localization setting keeps reverting back to only the United States
November 18, 2014, 02:39:26 am
Hey there,
Quote
why CiviCRM would be reverting back to only the United States
Can you be a bit more specific about what is happening? What (field?) on what page is reverting back to the United States?
What would you expect to happen? Was something different happening previously?
Have you tried to replicate your issue on the 4.5 demo servers? Does it happen there? Knowing the answer to that will help (us and you) narrow down the problem.
Service providers: Grow your business, build your reputation and support CiviCRM. Become a partner today

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Countries in Localization setting keeps reverting back to only the United States
November 18, 2014, 04:52:18 am
This installation of CiviCRM started out at version 2.0.7 back on D5, and has been upgraded all of the way to present stats in my profile.

Years ago, perhaps CiviCRM 3.2.x and 3.3.x vintage range, CiviCRM was giving us absolute fits about automatically adjusting check boxes / radio buttons on our complex site membership join pages.

Quote
To refresh you, here is a post describing our CiviCRM configuration of this type of transaction:
http://forum.civicrm.org/index.php/topic,32168.0.html#msg137640

We would get the check boxes / radio buttons all configured the way we need them, only for them to mysteriously begin changing.

This nonsense has ceased for quite many versions of CiviCRM. Unfortunately it appears to be rearing its ugly head again.

http://forum.civicrm.org/index.php/topic,32168.msg147499.html#msg147499

So that is a bit more of the background at what Evan is only just starting to deal with.

I am thankful,
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1274
  • Karma: 55
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Countries in Localization setting keeps reverting back to only the United States
November 18, 2014, 05:06:24 am
I read it but am not sure how that background is helpful to the original question - reading those posts wasn't that useful.

Quote
We would get the check boxes / radio buttons all configured the way we need them, only for them to mysteriously begin changing.

This is also too vague to be useful :( If you can answer the questions I asked that would help us move forward, help me to help you, etc.
Service providers: Grow your business, build your reputation and support CiviCRM. Become a partner today

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Countries in Localization setting keeps reverting back to only the United States
November 18, 2014, 03:12:12 pm
Quote from: Michael McAndrew on November 18, 2014, 05:06:24 am
This is also too vague to be useful :(

So what would be helpful?

We set the configurations to X, Y, Z, and then something comes along which we have no idea the "what" that is changing critical settings.

What types of things in current CiviCRM code update settings like we describe happening? Perhaps something will jump out at us as being in the configuration of this site.

I am thankful,
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

evandonovan

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.5.3
  • CMS version: Drupal 6.33
  • MySQL version: 5.5.40
  • PHP version: 5.3.10
Re: Countries in Localization setting keeps reverting back to only the United States
November 21, 2014, 08:11:35 am
So to give more of the specifics, this is happening on https://example.com/civicrm/admin/setting/localization?reset=1 on the Available Countries and Available States and Provinces picklists. We've been leaving those picklists empty as per the description: "To include ALL countries, leave the right-hand box empty." But after a few days, and possibly after a code upgrade (although my colleague Michael says not each time has there been a code upgrade), the right-hand box just has United States in it again.

I haven't tried replicating this on the demo server. I don't know how an unpredictable settings reversion could be replicated, but if you could give a suggestion, I could try.
« Last Edit: November 24, 2014, 08:11:17 am by evandonovan »

Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1274
  • Karma: 55
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Countries in Localization setting keeps reverting back to only the United States
November 24, 2014, 12:34:46 am
Quote
So what would be helpful?
Specific details of what field changed, the value before and the value after. The timeframe on the change (a few page refreshes, a few hours, weeks, months). Basically the more info you can give, and the more concisely you can give it, the better.

Quote
We would get the check boxes / radio buttons all configured the way we need them, only for them to mysteriously begin changing.
For example, in the sentence above, some details on what field it was is necessary.

Is it just this field, or does it affect others as well?  If it does affect others, which ones, what did they change from and to.

Quote
I don't know how an unpredictable settings reversion could be replicated

Hard to do indeed (from your original post, I thought that it was happening on page reload, which would be much easier to replicate).

Narrowing down the causes is one way to solve the mystery.

Is this an out of the box CiviCRM, or are there any extensions enabled? Have you customised it in any other way?

If it keeps on happening and you want to narrow down exactly when it is happening, you can potentially turn on logging.  You'll then be able to see exactly when the change happened, which you can then potentially correlate to other activties on the site by logging at server logs to see what was happening when it changed.
Service providers: Grow your business, build your reputation and support CiviCRM. Become a partner today

evandonovan

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.5.3
  • CMS version: Drupal 6.33
  • MySQL version: 5.5.40
  • PHP version: 5.3.10
Re: Countries in Localization setting keeps reverting back to only the United States
November 24, 2014, 08:13:39 am
Michael, the fields that change are Available Countries and Available States/Provinces. The value before was blank; the value after is "United States". It seems to happen every few days.

It's definitely not happening on page reload.

CiviCRM is out of the box.

What is the logging you suggest turning on? Would the logging track field changes?

Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1274
  • Karma: 55
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Countries in Localization setting keeps reverting back to only the United States
December 09, 2014, 03:26:23 am
http://book.civicrm.org/user/current/advanced-configuration/logging/

do you have any cron jobs that are running every few days? It might be that job that is causing the problem.
Service providers: Grow your business, build your reputation and support CiviCRM. Become a partner today

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Countries in Localization setting keeps reverting back to only the United States
December 22, 2014, 05:16:20 pm
Greetings Michael,

We have the "Membership status processor" cron job executing hourly via Drush.

On a note of "settings getting changed", I just found all the CiviCRM sites I support had "Enable Drupal Watchdog Logging" set back to the default of No. That is another setting I have to keep putting back.

The country pick lists have remained populated for the moment. However, I have not done a CiviCRM upgrade recently. This latest hole does not apply as we do not use that component of CiviCRM on any of the sites I support. Allowing peaceful year-end contributions to process.

I  am thankful,
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Countries in Localization setting keeps reverting back to only the United States
January 10, 2015, 01:36:04 pm
Greetings,

Post end of the year rush, this weekend I am getting around to applying the 4.5.5 update. Indeed, performing version upgrades wipes out / back do defaults the preferences on these two screens:

Home » CiviCRM » Administer CiviCRM
Settings - Debugging and Error Handling
/civicrm/admin/setting/debug?reset=1

Home » CiviCRM » Administer CiviCRM
Settings - Localization
/civicrm/admin/setting/localization?reset=1

Could someone please look into what causes these settings pages to revert back to default settings when performing version upgrades?

I am thankful,
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Re: Countries in Localization setting keeps reverting back to only the United States
January 10, 2015, 03:34:52 pm
Although in a way you are replying to a question within this topic, you should start a new topic with an appropriate title for you last post ( ie the resetting of preferences on upgrade.)

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Countries in Localization setting keeps reverting back to only the United States
January 11, 2015, 11:35:17 am
Quote from: joanne on January 10, 2015, 03:34:52 pm
Although in a way you are replying to a question within this topic, you should start a new topic with an appropriate title for you last post ( ie the resetting of preferences on upgrade.)

So since we discover that the issue happens when we go through a CiviCRM version upgrade we must start over on a NEW thread titled:

"Countries in Localization setting keeps reverting back to only the United States after CiviCRM upgrade"

instead of the current:

"Countries in Localization setting keeps reverting back to only the United States"

Seriously!?!?!?  ???

I am thankful,
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Re: Countries in Localization setting keeps reverting back to only the United States
January 11, 2015, 02:17:57 pm
Ah, so are you saying that the statement

Quote from: evandonovan on November 21, 2014, 08:11:35 am
although my colleague Michael says not each time has there been a code upgrade

was not correct and the original problem was only occurring on upgrade?

If so, then, yes, it should be in one topic.

I have found that it is better to list all countries in the right hand box rather than leave it blank.  I can't remember why, perhaps it was indeed to stop the list reverting to just the US on upgrade.

If others can support this observation then I will amend the relevant help text.

 


mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Countries in Localization setting keeps reverting back to only the United States
January 12, 2015, 07:08:49 am
Quote from: joanne on January 11, 2015, 02:17:57 pm
Ah, so are you saying that the statement

Quote from: evandonovan on November 21, 2014, 08:11:35 am
although my colleague Michael says not each time has there been a code upgrade

was not correct and the original problem was only occurring on upgrade?

One way to proke the problem is by doing an upgrade. I believe there have been times the settings have revertted to defaults that we have not been upgrading.

At least at this point I have added these two URL's to a list of URL's to recheck after each upgrade... and occasionally to make sure settings are not tampered with.


Quote from: joanne on January 11, 2015, 02:17:57 pm
I have found that it is better to list all countries in the right hand box rather than leave it blank.  I can't remember why, perhaps it was indeed to stop the list reverting to just the US on upgrade.


I have tried having all of the countries on both the left and right side, either way it gets set back to the CiviCRM default state.

Quote from: joanne on January 11, 2015, 02:17:57 pm
If others can support this observation then I will amend the relevant help text.

So you are suggesting that perhaps an update to the help text to state that "these settings are not preserved during CiviCRM upgrades" is the preferred way to address this behavior?

I am thankful,
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Countries in Localization setting keeps reverting back to only the United States

This forum was archived on 2017-11-26.