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 »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • [solved] Upgrading from 4.3.8 to 4.4.1 failed: "Møre og Rom..."
Pages: [1]

Author Topic: [solved] Upgrading from 4.3.8 to 4.4.1 failed: "Møre og Rom..."  (Read 1230 times)

kaless

  • I’m new here
  • *
  • Posts: 25
  • Karma: 0
[solved] Upgrading from 4.3.8 to 4.4.1 failed: "Møre og Rom..."
November 12, 2013, 11:24:45 am
Hi,

I try to upgrade from 4.3.8 to 4.4.1 and the following error occurs:


[Error: Upgrade DB to 4.4.0]
PDOException: "SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF8re og...' for column 'message' at row 1"

Is this the error?:


.../sites/all/modules/civicrm/CRM/Core/Error.php(527): watchdog("civicrm", "\n$Query = string(89) \"UPDATE civicrm_state_province SET name = 'Møre og Rom...", NULL, 7)



Greetings

Bene
« Last Edit: November 18, 2013, 01:04:52 pm by kaless »

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Upgrading from 4.3.8 to 4.4.1 failed: "Møre og Rom..."
November 12, 2013, 12:43:36 pm
The character ø maps to xF8 and this is causing an error. I would ask your host if they can help, as this appears to be a MySQL collation issue.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

kaless

  • I’m new here
  • *
  • Posts: 25
  • Karma: 0
Re: Upgrading from 4.3.8 to 4.4.1 failed: "Møre og Rom..."
November 15, 2013, 06:32:21 am
Hmm, it's our own server. I tried to change the collation to utf8_general_ci but I have still the same error.

How can I convert all the tables?

Greetings Bene

kaless

  • I’m new here
  • *
  • Posts: 25
  • Karma: 0
Re: Upgrading from 4.3.8 to 4.4.1 failed: "Møre og Rom..."
November 15, 2013, 07:37:39 am
I tried the script from here:

http://www.holisticsystems.co.uk/blog/changing-collation-all-tables-mysql-database

but I still have the error ;(

Greetings
Bene

kaless

  • I’m new here
  • *
  • Posts: 25
  • Karma: 0
Re: Upgrading from 4.3.8 to 4.4.1 failed: "Møre og Rom..."
November 18, 2013, 06:51:27 am
Hello again,

I just updated the database on a new server on VirtualBox without a problem.

And I mentioned the following: I can modify an entry in the database with phpmyadmin but not with civicrm.

Do I have a problem with character encoding on php?

Greetings

Bene

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Upgrading from 4.3.8 to 4.4.1 failed: "Møre og Rom..."
November 18, 2013, 09:44:35 am
Quote from: kaless on November 18, 2013, 06:51:27 am
Do I have a problem with character encoding on php?

Yes, that's possible.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

kaless

  • I’m new here
  • *
  • Posts: 25
  • Karma: 0
<solved> Re: Upgrading from 4.3.8 to 4.4.1 failed: "Møre og Rom..."
November 18, 2013, 01:04:33 pm
Yes indeed:

setting /etc/php5/conf.d/charset.ini

[PHP]
default_charset = "utf-8"
[mbstring]
mbstring.language = utf-8
mbstring.internal_encoding = utf-8
mbstring.http_input = utf-8
mbstring.http_output = utf-8


solved the problem. Now 4.4.1 is running ;)

Chris Burgess

  • Ask me questions
  • ****
  • Posts: 675
  • Karma: 59
Re: [solved] Upgrading from 4.3.8 to 4.4.1 failed: "Møre og Rom..."
June 03, 2014, 05:11:37 pm
A question - if you're still around Kaless?

Was this upgrade happening on a different (test) server from the one the data had been collected on? i.e. you'd copied data from a server with php / mysql / db settings in one state, and then found that upgrading on another server triggered these errors?
@xurizaemon ● www.fuzion.co.nz
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • [solved] Upgrading from 4.3.8 to 4.4.1 failed: "Møre og Rom..."

This forum was archived on 2017-11-26.