AW: [opencms-dev] Illegal mix of collations error

Sat Jul 3 23:34:01 CEST 2004

Ok,
So I made the default char set utf8 in mysql now I get the error:
Tables could not be created!
Error executing SQL statement: create table CMS_PROJECTRESOURCES (PROJECT_ID INT NOT NULL, RESOURCE_NAME VARCHAR(218) NOT NULL, primary key(PROJECT_ID, RESOURCE_NAME), index projectresource_resource_name (RESOURCE_NAME))
-------------------------------------------
java.sql.SQLException: Syntax error or access violation message from server: "Specified key was too long. Max key length is 500" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2752) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1532) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622) at com.mysql.jdbc.Connection.execSQL(Connection.java:2273) at com.mysql.jdbc.Connection.execSQL(Connection.java:2204) at com.mysql.jdbc.Statement.execute(Statement.java:868) at org.opencms.setup.CmsSetupDb.executeStatement(CmsSetupDb.java:283) at org.opencms.setup.CmsSetupDb.executeSql(CmsSetupDb.java:206) at org.opencms.setup.CmsSetupDb.createTables(CmsSetupDb.java:145) at org.apache.jsp.setup.step_005f5_005fdatabase_005fcreation_jsp._jspService(step_005f5_005fdatabase_005fcreation_jsp.java:350) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644) at java.lang.Thread.run(Thread.java:534) 

This seems to be a MySQL error, anyways it seems I need to reduce some varchar sizes. Does any one know how to fix this particular example so that the table can be built and still be useable ?

[ The example is :
create table CMS_PROJECTRESOURCES (PROJECT_ID INT NOT NULL, RESOURCE_NAME VARCHAR(218) NOT NULL, primary key(PROJECT_ID, RESOURCE_NAME), index projectresource_resource_name (RESOURCE_NAME)) ]

Leighton

 --- On Fri 07/02, leightonbrown at excite.com < leightonbrown at excite.com > wrote:
From: leightonbrown at excite.com [mailto: leightonbrown at excite.com]
To: opencms-dev at opencms.org
Date: Fri,  2 Jul 2004 12:46:15 -0400 (EDT)
Subject: RE: AW: [opencms-dev] Illegal mix of collations error

Hi, I changed the key's value to ?useUnicode\=true&characterEncoding\=ISO-8859-1 which allowed me to complete the steps to import the workspace. However my /sites/default/resource folder is now empty for both online and offline projects. I don't think this is correct. I remember seeing so error about locales. Is there an installation log ? and do we require unicode to install the resources ? Leighton --- On Thu 07/01, Thomas Weckert < t.weckert at alkacon.com > wrote: From: Thomas Weckert [mailto: t.weckert at alkacon.com] To: opencms-dev at opencms.org Date: Thu, 1 Jul 2004 12:24:12 +0200 Subject: AW: [opencms-dev] Illegal mix of collations error Hi, that param gets set by the key mysql.constr.params in webapp/setup/database/mysql/database.properties, which contains a set of predefined key/value pair settings per db server. Hth, Thomas Weckert Alkacon Software - The OpenCms Experts http://www.alkacon.com > -----Ursprüngliche Nachricht----- > Von: opencms-dev-admin at opencms.org > [mailto:opencms-dev-admin at opencms.org] Im Auftrag von > leightonbrown at excite.com > Gesendet: Mittwoch, 30. Juni 2004 23:33 > An: opencms-dev at opencms.org > Betreff: RE: [opencms-dev] Illegal mix of collations error > > > > Hi, > > does anyone know where in source code the opencms.properties > key : > db.pool.default.jdbcUrl.params=?useUnicode\=true&characterEnco > ding\=UTF-8 > gets set ? > > Leighton > > > > --- On Wed 06/30, leightonbrown at excite.com < > leightonbrown at excite.com > wrote: > From: leightonbrown at excite.com [mailt o: leightonbrown at excite.com] > To: opencms-dev at opencms.org > Date: Wed, 30 Jun 2004 08:10:37 -0400 (EDT) > Subject: [opencms-dev] Illegal mix of collations error > > Hi, I'm using opencms version: pre5.3.6dev Ix > (from CVS) tomcat : 5.0.25 mysql : 5.0.0 linux > (kernel) : 2.6.7 I'm not able to import the workspace > on initial setup. I get errors like - 103:	>>Root > cause was: java.sql.SQLException: Illegal mix of collations > (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) > for operation '=' 102:	 > >>org.opencms.main.CmsException: > [org.opencms.db.mysql.CmsWorkflowDriver] where: > org.opencms.db.generic.CmsWorkflowDriver.writeTaskType(CmsWork > flowDriver.java:823), why: java.sql.SQLException: Illegal mix > of collations (latin1_swedish_ci,IMPLICIT) and > (utf8_general_ci,COERCIBLE) for operation '=' [Code 4 - Sql > exception] I've tried the mysql connector which came > with opencms. ( mysql-connector-java-3.0.11-stable-bin.jar ), > I've also tried the > mysql-connector-java-3.0.14-production-bin.jar , > mysql-connector-java-3.1.nightly-20040630-bin.jar , and > mysql-connector-java-3.1.2-alpha-bin.jar without > success. Any ideas > ? Leighton ___________________________________ ____________> Join Excite! - http://www.excite.com The > most > personalized portal on the > Web! _______________________________________________ Thi > s mail is send to you from the opencms-dev mailing list To > change your list options, or to unsubscribe from the list, > please > visit http://mail.opencms.org/mailman/listinfo/opencms-dev > > _______________________________________________ > Join Excite! - http://www.excite.com > The most personalized portal on the Web! > _______________________________ ________________ > This mail is send to you from the opencms-dev mailing list > To change your list options, or to unsubscribe from the list, > please visit http://mail.opencms.org/mailman/listinfo/opencms-dev > > _______________________________________________ This mail is send to you from the opencms-dev mailing list To change your list options, or to unsubscribe from the list, ple
 ase visit http://mail.opencms.org/mailman/listinfo/opencms-dev _______________________________________________ Join Excite! - http://www.excite.com The most personalized portal on the Web! _______________________________________________ This mail is send to you from the opencms-dev mailing list To change your list options, or to unsubscribe from the list, please visit http://mail.opencms.org/mailman/listinfo/opencms-dev

_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!