I will investigate in detail but I just wanted to share initial status.
My system:
CF 9,0,1,274733 & Apache
MySQL 5.5.14
MacOSX 10.7.2
Created a virtualhost on ‘/domains/blogbox/web’ as blogbox.
Copied ColdBox 3.1 on /coldbox directory.
Copied BlogBox files on root ‘/’.
Created a MySQL DSN with and empty blogbox DB.
Updated Application.cfc for ‘dropcreate’.
Current ORM mappings is as is
// ORM Settings
this.ormEnabled = true; //this.mappings["/"] = COLDBOX_APP_ROOT_PATH;
// FILL OUT: THE DATASOURCE OF BLOGBOX
this.datasource = “blogbox”;
// FILL OUT: THE LOCATION OF THE BLOG BOX MODULE
this.mappings["/blogbox"] = COLDBOX_APP_ROOT_PATH & “modules/blogbox”;
that was actually one of the first things I noticed when I was just browsing the code. I would remove the Dialect from the original source code and let Hibernate auto detect it. If someone really needs it they should know they need to set it. Maybe even take an approach like a config file, comment it out to begin with.
Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_4) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.56 Safari/536.5
Remote Address 127.0.0.1
Referrer
Date/Time 16-Jun-12 04:38 AM
Stack Trace
<br>org.hibernate.JDBCException: Error during DDL export<br> at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:209)<br> at coldfusion.orm.hibernate.HibernateConfiguration.exportSchema(HibernateConfiguration.java:386)<br> at coldfusion.orm.hibernate.HibernateConfiguration.exportSchema(HibernateConfiguration.java:344)<br> at coldfusion.orm.hibernate.HibernateConfiguration.initHibernateConfiguration(HibernateConfiguration.java:187)<br> at coldfusion.orm.hibernate.HibernateConfiguration.<init>(HibernateConfiguration.java:152)<br> at coldfusion.orm.hibernate.ConfigurationManager.initConfiguration(ConfigurationManager.java:67)<br> at coldfusion.orm.hibernate.HibernateProvider.InitializeORMForApplication(HibernateProvider.java:176)<br> at coldfusion.orm.hibernate.HibernateProvider.beforeApplicationStart(HibernateProvider.java:79)<br> at coldfusion.filter.ApplicationFilter.fireBeforeAppStartEvent(ApplicationFilter.java:504)<br> at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:239)<br> at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)<br> at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)<br> at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)<br> at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)<br> at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)<br> at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)<br> at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)<br> at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)<br> at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)<br> at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)<br> at coldfusion.CfmServlet.service(CfmServlet.java:200)<br> at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)<br> at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)<br> at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)<br> at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)<br> at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)<br> at jrun.servlet.FilterChain.service(FilterChain.java:101)<br> at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)<br> at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)<br> at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)<br> at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)<br> at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)<br> at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)<br> at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)<br> at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)<br> at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)<br>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes<br> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)<br> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)<br> at java.lang.reflect.Constructor.newInstance(Constructor.java:513)<br> at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)<br> at com.mysql.jdbc.Util.getInstance(Util.java:381)<br> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1051)<br> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)<br> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)<br> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)<br> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)<br> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2687)<br> at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1647)<br> at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1566)<br> at coldfusion.server.j2ee.sql.JRunStatement.executeUpdate(JRunStatement.java:182)<br> at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:204)<br> ... 35 more<br>
I’m running MySQL 5.1.58 as this is the last 5.1 point release and ColdFusion tech spec says 5.1 is supported
Should I consider going up to 5.5 although it’s not on the supported list? Will that help me with this issue?
No sure, that’s the only error message I got. I tried to reverse engineer the installer but it was beyond my pay grade
I copied the contentbox database created by my new local 5.5.25 install over to my 5.1.58 production box and copied the ContentBox code over and all seem fine once you’ve got passed the issue with the installer and 5.1.58
