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 »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Currency Symbols messed up in CiviCRM 4.4
Pages: 1 [2] 3

Author Topic: Currency Symbols messed up in CiviCRM 4.4  (Read 7021 times)

jaapjansma

  • I post frequently
  • ***
  • Posts: 247
  • Karma: 9
    • CiviCoop
  • CiviCRM version: 4.4.2
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5.4
Re: Currency Symbols messed up in CiviCRM 4.4
November 28, 2013, 03:07:02 am
I have the same issue on Ubuntu 12.04 did a clean install of civi 4.4.2 and a clean install of Drupal 7 yesterday.
My installation workflow was install in English. After installation I added the l10n package and set my language to Dutch and the currency symbol to Euro and now it shows some weird character instead of the euro sign.
Developer at Edeveloper / CiviCoop

jaapjansma

  • I post frequently
  • ***
  • Posts: 247
  • Karma: 9
    • CiviCoop
  • CiviCRM version: 4.4.2
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5.4
Re: Currency Symbols messed up in CiviCRM 4.4
December 10, 2013, 03:34:14 am
The problem with the messed up currency symbols is caused by the default charset of the mysql connection and client. This is set in your mysql.ini and in my case it was set to latin1.

So my connection from the civi installer to the mysql database had a character set as latin1.

There a few things to consider.
1. I have reported this as a bug in civicrm http://issues.civicrm.org/jira/browse/CRM-13946
2. Before installing civicrm set your database collation to utf8_general_ci after that the install goed correct
3. I have not found a solution to fix an already corrupted install

Jaap
Developer at Edeveloper / CiviCoop

r4zoli

  • I post occasionally
  • **
  • Posts: 88
  • Karma: 1
  • CiviCRM version: 4.7
  • CMS version: Wordpress
  • MySQL version: 5
  • PHP version: 5
Re: Currency Symbols messed up in CiviCRM 4.4
December 10, 2013, 03:58:53 am
I met same problem under xubuntu 12.04 with wordpress 3.7.1 and civi 4.4.2. The country, county and currency tables get the wrong coding, I used xubuntu with Hungarian language settings.

I installed in such way. Downloaded directly to the xubuntu download folder main and l10n package, unpacked both in download folder, copied files to the wordpress plugin folder all files.
The MySQL collation is set to utf8_general_ci before the civi installation.

I met this first when installed 4.4.alpha1 see: http://forum.civicrm.org/index.php/topic,29737.0.html

May be I wrongly assumed on that post, that the problem solved.

Something happened around this version.

« Last Edit: December 10, 2013, 04:03:46 am by r4zoli »

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: Currency Symbols messed up in CiviCRM 4.4
December 10, 2013, 06:40:59 am

r4zoli: can u test the patch submmitted by jaap

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

r4zoli

  • I post occasionally
  • **
  • Posts: 88
  • Karma: 1
  • CiviCRM version: 4.7
  • CMS version: Wordpress
  • MySQL version: 5
  • PHP version: 5
Re: Currency Symbols messed up in CiviCRM 4.4
December 10, 2013, 11:31:32 am
No help. I installed same way, the problems remains. I installed civi as Hungarian.

More problems with accented characters in main contact window email, phone, phone type, IM, dropdown selections.

jaapjansma

  • I post frequently
  • ***
  • Posts: 247
  • Karma: 9
    • CiviCoop
  • CiviCRM version: 4.4.2
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5.4
Re: Currency Symbols messed up in CiviCRM 4.4
December 10, 2013, 02:08:54 pm
rz4oli: can you check what the collation you have on your database?
Developer at Edeveloper / CiviCoop

Carlo Landmeter

  • I post occasionally
  • **
  • Posts: 31
  • Karma: 3
Re: Currency Symbols messed up in CiviCRM 4.4
December 11, 2013, 03:31:25 am
Please try this PR and see if it works:

https://github.com/civicrm/civicrm-core/pull/2195

jaapjansma

  • I post frequently
  • ***
  • Posts: 247
  • Karma: 9
    • CiviCoop
  • CiviCRM version: 4.4.2
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5.4
Re: Currency Symbols messed up in CiviCRM 4.4
December 11, 2013, 03:45:32 am
Hey Carlo,

I think you have made good solution for the installer.

Jaap
Developer at Edeveloper / CiviCoop

geoadel

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.4.3
  • CMS version: Drupal 7
  • MySQL version: 5.5.31-0
  • PHP version: 5.4.4-14
Re: Currency Symbols messed up in CiviCRM 4.4
December 11, 2013, 07:24:57 am
Thanks Carlo,

I applied the one-line change and now the installation provided correct special characters for the currencies again.

Best regards,
Georg

r4zoli

  • I post occasionally
  • **
  • Posts: 88
  • Karma: 1
  • CiviCRM version: 4.7
  • CMS version: Wordpress
  • MySQL version: 5
  • PHP version: 5
Re: Currency Symbols messed up in CiviCRM 4.4
December 11, 2013, 07:31:18 am
Carlo patch works for me, too. On all earlier problematic places correct character when I made clean install, this solved my problems, too.

Thanks, Carlo.

Zoltán

gmoe

  • I’m new here
  • *
  • Posts: 7
  • Karma: 0
  • CiviCRM version: 4.3.1
  • CMS version: Drupal 7.22
  • MySQL version: 5
  • PHP version: 5.3
Re: Currency Symbols messed up in CiviCRM 4.4
January 19, 2014, 02:11:04 pm
Hey Guys,

Any Fix for a corrupted Installation without installation.
My only Idea is to dump and coonvert the DB.

Any other Ideas?

dfunes

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.4.3
  • CMS version: Drupal
  • MySQL version: 5.6.14
  • PHP version: 5.5.6
Re: Currency Symbols messed up in CiviCRM 4.4
January 29, 2014, 11:30:42 am
Hi,

I know that it's a sloppy solution but if you only have to change 2 -3 currencies, you can execute a sql command:

Code: [Select]
UPDATE `civicrm_crm`.`civicrm_currency` SET `symbol` = '€' WHERE `civicrm_currency`.`id` =3;
This worked for me.

jaapjansma

  • I post frequently
  • ***
  • Posts: 247
  • Karma: 9
    • CiviCoop
  • CiviCRM version: 4.4.2
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5.4
Re: Currency Symbols messed up in CiviCRM 4.4
January 29, 2014, 12:09:54 pm
Thanks for the query.

Yes that would work if it is only about one or two symbols. But what you have to keep in mind is that all data which was loaded during the install is messed up. Most data is just plain ascii so you wouldn't see it because there is no difference.
So I would still recommand a re-install if you have messed up data. On the sites where I have discovered this issue, it was only on the test installs, not in productions.
Developer at Edeveloper / CiviCoop

onglipo

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
  • CiviCRM version: 4.4
  • CMS version: Drupal 7
  • MySQL version: 5.1
  • PHP version: 5.2
Re: Currency Symbols messed up in CiviCRM 4.4
February 24, 2014, 09:36:30 pm
Had the same problem for Indian Rupee symbol.
UPDATE  `civicrm`.`civicrm_currency` SET  `symbol` =  '₹' WHERE  `civicrm_currency`.`id` =6;
Seemed to fix it.

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: Currency Symbols messed up in CiviCRM 4.4
February 25, 2014, 05:09:35 am
To reiterate - fixing a single symbol in your db does not repair the entire db. Recommendation is to reinstall or at least rebuild that table.
Try asking your question on the new CiviCRM help site.
Pages: 1 [2] 3
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Currency Symbols messed up in CiviCRM 4.4

This forum was archived on 2017-11-26.