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 7023 times)

Joeri Theelen

  • I’m new here
  • *
  • Posts: 13
  • Karma: 0
  • It's nothing personal.
  • CiviCRM version: 4.4.5
  • CMS version: Drupal 7.28
  • MySQL version: 5.6.11
  • PHP version: 5.5.3
Currency Symbols messed up in CiviCRM 4.4
October 26, 2013, 06:12:47 am
Hi,
I just did a clean installation of CiviCRM 4.4 on Drupal 7.23. I noticed that special symbols such as the Euro sign, are garbled. I tried a clean installation of CiviCRM 4.3.7 and there the special symbols were fine. Same setup. I explicitly changed the collation of the MySQL database to "utf8_general_ci" before doing the installation (in both cases).

Can this be fixed?

Thanks,
Joeri
« Last Edit: October 29, 2013, 09:55:40 am by Coleman Watts »

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: Clean installation of CiviCRM 4.4 on Drupal 7.23
October 26, 2013, 02:19:05 pm

any chance you can look at the html and encoding of 4.4 vs 4.3.7 and see what the differentces are

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

Joeri Theelen

  • I’m new here
  • *
  • Posts: 13
  • Karma: 0
  • It's nothing personal.
  • CiviCRM version: 4.4.5
  • CMS version: Drupal 7.28
  • MySQL version: 5.6.11
  • PHP version: 5.5.3
Re: Clean installation of CiviCRM 4.4 on Drupal 7.23
October 26, 2013, 03:06:57 pm
Sure I can. I did a clean installation of CiviCRM 4.3.7 and 4.4 on Drupal 7.23, then went immediately to localization settings, saved the HTML-page and took a screenshot of the page-info in Firefox. See attached file (remove .txt extension !!). I looks like the encoding is the same. The saved pages are missing some styling, but the garbled characters are obviously there in the 4.4 case, not so much in the 4.3.7 case.

I did of course, look into the database script for setting up CiviCRM (e.g. file "civicrm_generated.mysql"), but could not find any differences yet.

Thanks for looking into this.

Joeri

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: Clean installation of CiviCRM 4.4 on Drupal 7.23
October 26, 2013, 04:04:06 pm
I just did a clean 4.4 install and the currency symbols all appear normal.
Not sure how to reproduce this. I wonder if it is a windows-specific issue.
Try asking your question on the new CiviCRM help site.

Joeri Theelen

  • I’m new here
  • *
  • Posts: 13
  • Karma: 0
  • It's nothing personal.
  • CiviCRM version: 4.4.5
  • CMS version: Drupal 7.28
  • MySQL version: 5.6.11
  • PHP version: 5.5.3
Re: Clean installation of CiviCRM 4.4 on Drupal 7.23
October 27, 2013, 12:40:19 am
I did a clean 4.4 install on our production environment, Ubuntu 12.04 Server, same issue. Special symbols are messed up.

I just need one clean 4.4 installation: my workaround is to do a 4.3.7 install + 4.4 upgrade. That works for me.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Clean installation of CiviCRM 4.4 on Drupal 7.23
October 29, 2013, 12:40:36 am
Coleman asked me to look at this as he thought it was a Windows issue - I'm not clear if it is since you could replicate it on Ubuntu. It is possible that you still unzipped on windows & the process of unzipping changed the file encoding?

I did do a search for messed up currencies & found a mix of 'good' & 'ungood' currency symbols for BGN (Bulgarian) -see pic

Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Joeri Theelen

  • I’m new here
  • *
  • Posts: 13
  • Karma: 0
  • It's nothing personal.
  • CiviCRM version: 4.4.5
  • CMS version: Drupal 7.28
  • MySQL version: 5.6.11
  • PHP version: 5.5.3
Re: Clean installation of CiviCRM 4.4 on Drupal 7.23
October 29, 2013, 03:47:05 am
Hi, thanks for looking into this. For me, it is not so urgent anymore: I have my 4.4 installed as described in my last message and it is working. But I'd be happy to help you with solving this issue.

I downloaded the tar.gz-archives from Sourceforge, then moved them (SCP) to my Ubuntu server home-folder before unpacking them (tar -xf). I'm not sure it is a Windows issue either. If no one else can repeat this issue, and it is only me, then I suggest you wait until another user comes around with the same issue, and continue from there.

All I can tell is that, in my environment, the 4.3.7 install is correct on Windows and Linux, and the 4.4.0 install isn't. I have done multiple installations, before doing the 4.3.7 + upgrade, which is what I am using now.

Joeri

Joeri Theelen

  • I’m new here
  • *
  • Posts: 13
  • Karma: 0
  • It's nothing personal.
  • CiviCRM version: 4.4.5
  • CMS version: Drupal 7.28
  • MySQL version: 5.6.11
  • PHP version: 5.5.3
Re: Clean installation of CiviCRM 4.4 on Drupal 7.23
October 29, 2013, 05:21:47 am
Hi Eileen, I did a pristine and clean 4.4.0 install on Ubuntu 12.04 again, and still got the issue. I have made a dump of the CiviCRM tables in MySQL (structure and data). You can find the SQL dump attached (remove .txt extension). As you can see, the wrong characters are already in the database, so I guess it is a database issue, or an issue with the filling of the database tables during installation. There really should be a difference between the 4.3.7 and 4.4.0 case with regard to installation, but looking at the installation files, I haven't found it yet.

Best,
Joeri

Michael Loughlin

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 4.4.1
  • CMS version: Drupal 7.23
  • MySQL version: 5.5.29
  • PHP version: 5.3.10
Re: Currency Symbols messed up in CiviCRM 4.4
November 11, 2013, 10:49:29 am
I had this problem on a Ubuntu server. I did a clean install on OSX Mavericks, and imported the CiviCRM database into the Ubuntu system to solve the issue. HTH

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
November 11, 2013, 11:14:05 am
So you're saying that installing the same version of Civi (4.4) on Debian and OSX have different results?
Try asking your question on the new CiviCRM help site.

Michael Loughlin

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 4.4.1
  • CMS version: Drupal 7.23
  • MySQL version: 5.5.29
  • PHP version: 5.3.10
Re: Currency Symbols messed up in CiviCRM 4.4
November 11, 2013, 01:57:56 pm
Sorry, I should have stated that. The install I did on Mavericks showed no problems with currency symbols, unlike the Ubuntu server install. Replacing the Ubuntu CiviCRM database with the one generated on the Mavericks install worked for me. No doubt there are many differences from one environment to the other, php, mysql, Apache config, etc, so I am not able to precisely pinpoint the source of the problem.

mathieu

  • Administrator
  • Ask me questions
  • *****
  • Posts: 620
  • Karma: 36
    • Work
  • CiviCRM version: 4.7
  • CMS version: Drupal
  • MySQL version: MariaDB 10
  • PHP version: 7
Re: Currency Symbols messed up in CiviCRM 4.4
November 19, 2013, 09:30:36 am
Was the installation directly into another language (en_UK or nl_NL, etc), or was it in the default US English?

The .sql files shipped with CiviCRM, which are imported by the installer, all seem OK.

I could not reproduce it on Debian, and I am wondering if it's specific to Ubuntu, which would be particularly weird.. either that, or the program that uncompresses the .tar.gz archive, although in this case, it's tar.
CiviCamp Montréal, 29 septembre 2017 | Co-founder / consultant / turn-key CiviCRM hosting for Quebec/Canada @ SymbioTIC.coop

Carlo Landmeter

  • I post occasionally
  • **
  • Posts: 31
  • Karma: 3
Re: Currency Symbols messed up in CiviCRM 4.4
November 22, 2013, 07:38:23 am
I have the same issue where it installs with the wrong encoding.
Thinks like currency and state/country all have wrong chars.

This is with latest Drupal and latest CiviCRM on Ubuntu 11.04

torrance123

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 3
  • CiviCRM version: 4.0
  • CMS version: Drupal 7
  • MySQL version: 5.0.91
  • PHP version: 5.3.3
Re: Currency Symbols messed up in CiviCRM 4.4
November 27, 2013, 07:40:01 pm
We had this issue on a new civi 4.4 install on debian 6. I had to manually copy across the badly encoded names in the civicrm_currency, civicrm_country and civicrm_state_province tables from another 4.4 version (which had only been upgraded, not wholly installed).

I had a look at the civicrm/sql/civicrm_data.mysql file and could see that all the names were correctly encoded when reading the file in a terminal (terminal locale set to UTF8). Also, the relevant tables (and default database character set) were all set to utf8. So I suspect something is up with either:

- the text encoding civicrm/php is using to read the .mysql files
- or if these are being read by mysql directly, then possibly the mysql client or connection isn't set to utf8

Though these are just guesses at the moment!

torrance123

  • I post occasionally
  • **
  • Posts: 57
  • Karma: 3
  • CiviCRM version: 4.0
  • CMS version: Drupal 7
  • MySQL version: 5.0.91
  • PHP version: 5.3.3
Re: Currency Symbols messed up in CiviCRM 4.4
November 27, 2013, 07:48:41 pm
I ran a quick test with the mysql files:

CREATE DATABASE `test` CHARACTER SET = utf8 COLLATE = utf8_general_ci;

And then:

mysql test1 < civicrm/sql/civicrm.sql
mysql test1 < civicrm/sql/civicrm_data.sql

Resulting data is just fine. So the issue lies elsewhere.
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.