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) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • English -> German -> English: German strings left in civicrm_navigation table
Pages: [1]

Author Topic: English -> German -> English: German strings left in civicrm_navigation table  (Read 2237 times)

jgehrcke

  • Guest
English -> German -> English: German strings left in civicrm_navigation table
October 26, 2010, 11:35:20 am
Hey guys!

I'm a new operator/user of CiviCRM and one of the very first things I did after installing Drupal/CiviCRM was setting up the German language by loading civicrm-3.2.3-l10n.tar.gz and choosing German as "Default language used for this installation". After a few minutes I changed back to English (USA), but wondered about the following: most parts of the navigation bar were still in German (not all!). I tried to go to the bottom of the problem and looked through the CiviCRM MySQL database. Within the table "civicrm_navigation", I found that most of the entries in the column "label" are still in German. Switching back and forth between German and English (USA) doesn't change the behavior. How could that have happened?

Now, I would like to get a clean English version again. How do I do it without re-installing? I think drupal/sites/all/modules/civicrm/sql/civicrm_data.mysql would help but before screwing anything I ask for the cleanest solution here.

Thanks for help!

Jan-Philip

« Last Edit: October 26, 2010, 11:38:18 am by jgehrcke »

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: English -> German -> English: German strings left in civicrm_navigation table
October 26, 2010, 04:17:06 pm

can u run:

q=civicrm/menu/rebuild&reset=1

thanx

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

jgehrcke

  • Guest
Re: English -> German -> English: German strings left in civicrm_navigation table
October 27, 2010, 05:50:57 am
Hey Donald,

Would I have been able to trigger this function somewhere through the GUI?

Anyways, I did it your way. Got the "Menu has been rebuilt" notification. But nothing changed, the menu is still mostly in German (I cleared cache and reloaded page).
« Last Edit: October 27, 2010, 05:53:23 am by jgehrcke »

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: English -> German -> English: German strings left in civicrm_navigation table
October 27, 2010, 08:54:19 am
Argh, after thorough testing I remembered that navigation localisation assumes/requires that civicrm_navigation.labels are in English (and localises the menu on-the-fly on menu rebuilds); unfortunately, this does not work if the database is seeded with non-en_US locale.

I filed CRM-6998 to fix this.
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.

jgehrcke

  • Guest
Re: English -> German -> English: German strings left in civicrm_navigation table
October 27, 2010, 09:50:42 am
Perfectly :-)

There are some questions left to me:

1) If that's the problem as you described; then everybody should experience this problem after changing back to en_US. Why aren't more people complaining about this?

2) What should I do now to solve the problem for me? Would en_GB somehow help?

3) I started typing this... but I think I will better ask this in the bug tracker comments :-)

Thanks for your help!

Jan-Philip

kasiawaka

  • I post occasionally
  • **
  • Posts: 42
  • Karma: 4
    • Kasuwade Solutions Inc.
Re: English -> German -> English: German strings left in civicrm_navigation table
November 25, 2010, 01:05:31 pm
I have similar problem but probably caused by something else. The default language on the site was always English (US) but as soon as I turned on new available languages (English (USA) and français (Canada)), most of the profile field labels are now in French.

I have checked "Inherit CMS Language" and the Drupal language is EN but the profile fields are still in French.
I tried to disable and enable again those settings, no change.
I tried disabling all languages - no change.
I tried resetting the menu using the link provided, no change.

Any ideas would be helpful
Kasia Wakarecy
http://kasuwade.ca
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • English -> German -> English: German strings left in civicrm_navigation table

This forum was archived on 2017-11-26.