Jump to content


Photo

Database collation issue

installation mysql collation

  • Please log in to reply
4 replies to this topic

#1 martinst

martinst

    Member

  • Members
  • PipPip
  • 12 posts

Posted 24 June 2013 - 04:57 PM

When I try to install Zurmo I get the following error message:

 

"Database default collation is: utf8_general_ci . Database default collation should not be in: utf8_general_ci"

 

I have changed my.cnf:

init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci

 

skip-character-set-client-handshake
 
to remedy this, but this is what MySql reports for the query 'SHOW VARIABLES LIKE  "%collation%"':

collation_connection utf8_general_ci

collation_database utf8_unicode_ci

collation_server utf8_unicode_ci

 

The problem is that whatever I set collation_connection to it gets overwritten and reverts back to utf_general_ci. I have found someone with a similar issure here: http://forums.webyog...?showtopic=7007

 

I don't know how to get around this. Any suggestions would be much appreciated. At this point I am unable to install Zurm at all.

 

  • AazikZET and Neterliz like this

#2 raysto

raysto

    Zurmo Team

  • Administrators
  • 1,973 posts

Posted 24 June 2013 - 06:27 PM

Have you looked at these posts:
http://zurmo.org/for...allation-fails/
http://zurmo.org/for...533-helpplease/


Ray Stoeckicht
Zurmo Team
Try Zurmo Pro


#3 martinst

martinst

    Member

  • Members
  • PipPip
  • 12 posts

Posted 24 June 2013 - 08:22 PM

Thanks Ray!

 

I had tried the suggestions in the first link without success. However following the instructions in the second link and remove the db check in CheckServicesUtil did the trick. Hopefully all tests will pass succesfully after the installation in completed also... :-)



#4 martinst

martinst

    Member

  • Members
  • PipPip
  • 12 posts

Posted 24 June 2013 - 10:14 PM

Actually that didn't solve the problem, rather the installation crashed a little later with the following error:

 

An error has occurred. Please click here to continue to the home page. If the error persists please contact your administrator.

SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
The reference id for this error is 920947c862b94326a3757ad1362ebfdb.


#5 raysto

raysto

    Zurmo Team

  • Administrators
  • 1,973 posts

Posted 24 June 2013 - 10:32 PM

Might be an issue similar to this: http://zurmo.org/for...is-not-defined/.
We have Developer Sessions every Tuesday at 10:00AM Chicago Time (http://zurmo.org/for...arning-session/). You can always join an upcoming session and ask any questions to our technical team.


Ray Stoeckicht
Zurmo Team
Try Zurmo Pro






Also tagged with one or more of these keywords: installation, mysql, collation

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users