Collactions clash with slide 2.1b and MySql 4.1

[Michele Costabile <mi...@gmail.com>]

I have an error when I install slide and reboot the system. It is
repeatable: I canrun slide once, but the second time I have this error
and I cannot browse /files or /history.
Collaction sweish is the default: I did not set it up myself.

12 Aug 2004 11:23:45 -
org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter - ERROR - SQL
error 1267 on /: General error,  message from server: "Illegal mix of
collations (utf8_general_ci,IMPLICIT) and
(latin1_swedish_ci,COERCIBLE) for operation 'substr_index'"
org.apache.slide.common.ServiceAccessException: Service
org.apache.slide.store.impl.rdbms.JDBCStore@1d9e282 access error :
General error,  message from server: "Illegal mix of collations
(utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for
operation 'substr_index'"
	at org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter.createException(MySqlRDBMSAdapter.java:66)
	at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.retrieveRevisionDescriptors(StandardRDBMSAdapter.java:942)
	at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.retrieveRevisionDescriptors(AbstractRDBMSStore.java:654)
	at org.apache.slide.store.AbstractStore.retrieveRevisionDescriptors(AbstractStore.java:996)
	at org.apache.slide.store.ExtendedStore.retrieveRevisionDescriptors(ExtendedStore.java:816)
	at org.apache.slide.content.ContentImpl.retrieve(ContentImpl.java:168)
	at org.apache.slide.common.XMLUnmarshaller.loadObjectRevision(XMLUnmarshaller.java:346)
	at org.apache.slide.common.XMLUnmarshaller.loadDefaultObjectRevision(XMLUnmarshaller.java:313)
	at org.apache.slide.common.XMLUnmarshaller.loadObjectNode(XMLUnmarshaller.java:243)
	at org.apache.slide.common.XMLUnmarshaller.unmarshal(XMLUnmarshaller.java:90)
	at org.apache.slide.common.NamespaceAccessTokenImpl.importData(NamespaceAccessTokenImpl.java:272)
	at org.apache.slide.common.Namespace.loadBaseData(Namespace.java:804)
	at org.apache.slide.common.Domain.initNamespace(Domain.java:845)
	at org.apache.slide.common.Domain.init(Domain.java:432)
	at org.apache.slide.common.Domain.init(Domain.java:366)
	at org.apache.slide.common.Domain.init(Domain.java:329)
	at org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.java:263)
	at javax.servlet.GenericServlet.init(GenericServlet.java:256)
	at org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.java:205)
	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1019)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:862)
	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3991)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4335)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)
	at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDeployer.java:277)
	at org.apache.catalina.core.StandardHost.install(StandardHost.java:832)
	at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:613)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:431)
	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:964)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:349)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478)
	at org.apache.catalina.core.StandardService.start(StandardService.java:476)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:2298)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:284)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:422)

-- 
Michele Costabile
http://proxybar.net

---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org