Dear Rafael,
Need your help badly..
Here is the environmnet I am using.
Suse Linux 10.1
Tomcat 6.0.13
MySql 5.0
Please note I have tried two versions of mysql connector as well
one that comes with JForum mysql-connector-java-5.0.3-bin.jar
and another one mysql-connector-java-5.0.5-bin
JForum 2.1.8
Bwlow is the Problem I am facing when I try to install Jforum it installs sucessfully buy when I try to access the forum I see the error below
An error has occurred.
For detailed error information, please see the HTML source code, and contact the forum Administrator.
java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_unicode_ci,IMPLICIT) for operation 'UNION'
When I see the source code below is the exception stack trace:
<!-- BEGIN ERROR STACK TRACE
<br /> net.jforum.exceptions.DatabaseException: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_unicode_ci,IMPLICIT) for operation 'UNION'
<br /> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
<br /> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
<br /> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
<br /> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
<br /> at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
<br /> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
<br /> at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1403)
<br /> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
<br /> at net.jforum.dao.generic.security.GenericGroupSecurityDAO.loadRoles(GenericGroupSecurityDAO.java:209)
<br /> at net.jforum.dao.generic.security.GenericGroupSecurityDAO.loadRolesByUserGroups(GenericGroupSecurityDAO.java:287)
<br /> at net.jforum.repository.SecurityRepository.load(SecurityRepository.java:151)
<br /> at net.jforum.repository.SecurityRepository.load(SecurityRepository.java:94)
<br /> at net.jforum.repository.SecurityRepository.load(SecurityRepository.java:112)
<br /> at net.jforum.JForum.service(JForum.java:163)
<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
<br /> at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
<br /> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
<br /> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
<br /> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
<br /> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
<br /> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
<br /> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
<br /> at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:852)
<br /> at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:584)
<br /> at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)
<br /> at java.lang.Thread.run(Thread.java:595)
<br /> Caused by: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_unicode_ci,IMPLICIT) for operation 'UNION'
<br /> ... 30 more
<br />
<br /> URL is: /fm/forums/list.page?null
<br /> END ERROR STACK TRACE-->
<html>
<head>
<title>Error</title>
</head>
<body>
An error has occurred.
For detailed error information, please see the HTML source code, and contact the forum Administrator.
<pre class="pre-error">
java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_unicode_ci,IMPLICIT) for operation 'UNION'</pre>
</body>
</html>
I have read this
thread but I am still struggling after repeated attempts.
mysql.propertied looks like below:
#Sat Mar 08 20:00:12 EST 2008
database.support.autokeys=true
database.driver.name=mysql
database.connection.pool.timeout=5000
database.connection.dbname=xxxxx
database.support.subqueries=true
dao.driver=net.jforum.dao.mysql.MysqlDataAccessDriver
mysql.unicode=
database.connection.pool.min=5
database.connection.password=xxxxx
database.connection.pool.max=10
database.connection.username=xxxxx
dbencoding=utf-8
database.connection.port=3306
dbunicode=true
database.connection.host=localhost
database.connection.driver=com.mysql.jdbc.Driver
database.connection.string=jdbc:mysql://${database.connection.host}:${database.connection.port}/${database.connection.dbname}?user=${database.connection.username}&password=${database.connection.password}&autoReconnect=true
mysql.encoding=
and jforum-custom.conf looks like below
#Installation specific configuration options
#Sat Mar 08 20:00:06 EST 2008
dao.driver=net.jforum.dao.mysql.MysqlDataAccessDriver
database.connection.dbname=xxxxx
database.connection.driver=com.mysql.jdbc.Driver
database.connection.host=localhost
database.connection.implementation=net.jforum.PooledConnection
database.connection.password=xxxxx
database.connection.pool.max=10
database.connection.pool.min=5
database.connection.pool.timeout=5000
database.connection.port=3306
database.connection.string=jdbc:mysql://${database.connection.host}:${database.connection.port}/${database.connection.dbname}?user=${database.connection.username}&password=${database.connection.password}&autoReconnect=true
database.connection.username=xxxxx
database.driver.name=mysql
database.support.autokeys=true
database.support.subqueries=true
dbencoding=utf-8
dbunicode=true
forum.link=http\://localhost\:8080/fm/
homepage.link=http\://localhost\:8080
i18n.board.default=en_US
installed=true
mysql.encoding=
mysql.unicode=
search.indexing.enabled=true
user.hash.sequence=4b7f9504ac8d40cdc7dfd8b74f901e0d
I have created a database in mysql called "xxxxx" with Character set as "utf8 -- UTF-8 Unicode" and collation "utf8_unicode_ci" please note I have tried with leaving collation blank at the time of database creation and in which case the default collation is "utf8_general_ci". The user I am using has all the rights on this database except grant permissions.
I need your help badly I have tried to install it now like 25 times at least. and have almost read every possible thread on the topic.
[originally posted on jforum.net by vicky]
ops: 
