Re: SQLException: Illegal mix of collations

I have solved my problem. It was a problem with the database. The 
restoration of the database has solved the error.

Thank you

Ronan

Michel Romy a écrit :

> Hi Ronan,
>
> is it a problem that happened after you change something either in the 
> configuration of Mysql or the database settings of Jahia ? Is it on a 
> fresh Jahia install ?
>
> It seems the default charset of the database and the charset of some 
> tables is not the same.
>
> Michel
>
>> Hi,
>>
>> I use jahia 4.1.0_01 build6070 with MySQL 4.1.14. The sever runs 
>> under linux.
>>
>> When jahia starts, it generates a SQLException :
>>
>>     5 [main] ERROR 
>> org.jahia.services.usermanager.JahiaUserManagerDBProvider.lookupUserInDB:818 
>> - SQL Exception occured : Co
>> uld not read the user [root:0]
>> java.sql.SQLException: Illegal mix of collations 
>> (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for 
>> operation '
>> ='
>>        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
>>        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
>>        at 
>> com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1347) 
>>
>>        at 
>> com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:958) 
>>
>>        at 
>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705) 
>>
>>        at 
>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) 
>>
>>        at 
>> org.jahia.services.database.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:77) 
>>
>>        at 
>> org.jahia.services.usermanager.JahiaUserManagerDBProvider.lookupUserInDB(JahiaUserManagerDBProvider.java:794) 
>>
>>        at 
>> org.jahia.services.usermanager.JahiaUserManagerDBProvider.lookupUser(JahiaUserManagerDBProvider.java:295) 
>>
>>        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>
>>
>> This exception appears just after the jahia 's logo in the 
>> catalina.out file.
>>
>> I have tried to modify the default-character-set and the 
>> default-collation properties in the configuration file of MySQL 
>> (my.cnf) but I always have the same error.
>>
>> Can someone help me ? I search a solution for 2 days and I have found 
>> nothing about this error.
>>
>> Thank you.
>>
>>
>> -- 
>> MARQUET Ronan - Collaborateur SILICOMP - AQL
>> Rue de la Châtaigneraie
>> CS 51766
>> 35517 CESSON SEVIGNE
>> Tel : 02 99 12 50 00
>> Fax : 02 99 63 70 40
>
>

-- 
MARQUET Ronan - Collaborateur SILICOMP - AQL
Rue de la Châtaigneraie
CS 51766
35517 CESSON SEVIGNE
Tel : 02 99 12 50 00
Fax : 02 99 63 70 40