Hi there,
I have been able to get a local instance of ContentBox running on Cloudbees and Railo, but when I deployed to the Cloudbees hosted system I received the following error upon startup. Note, The MySQL database exists and has been registered in the Railo admin. Also note, that my original local install was done on ACF and not Railo.
Thoughts?
Railo 3.3.1.000 Error (org.hibernate.exception.SQLGrammarException)
Message could not execute query
Error Code 1146
Cause org.hibernate.exception.SQLGrammarException
Stacktrace The Error Occurred in
/mnt/var/staxapps/8400/staxcat/install/webapp.war/coldbox/system/orm/hibernate/BaseORMService.cfc: line 275
273: }
274: } else {
275: return entityLoad( arguments.entityName, arguments.criteria, true );
276: }
277: }
called from/mnt/var/staxapps/8400/staxcat/install/webapp.war/coldbox/system/orm/hibernate/VirtualEntityService.cfc: line 104
called from/mnt/var/staxapps/8400/staxcat/install/webapp.war/modules/contentbox/model/ui/LayoutService.cfc: line 43
called from/mnt/var/staxapps/8400/staxcat/install/webapp.war/modules/contentbox-ui/ModuleConfig.cfc: line 113
called from/mnt/var/staxapps/8400/staxcat/install/webapp.war/coldbox/system/web/services/ModuleService.cfc: line 324
called from/mnt/var/staxapps/8400/staxcat/install/webapp.war/coldbox/system/web/services/ModuleService.cfc: line 256
called from/mnt/var/staxapps/8400/staxcat/install/webapp.war/coldbox/system/web/services/LoaderService.cfc: line 84
called from/mnt/var/staxapps/8400/staxcat/install/webapp.war/coldbox/system/Coldbox.cfc: line 71
called from/mnt/var/staxapps/8400/staxcat/install/webapp.war/Application.cfc: line 76
Java Stacktrace could not execute query
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936):936
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934):2934
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616):1616
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708):1708
at com.mysql.jdbc.Connection.execSQL(Connection.java:3255):3255
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1293):1293
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1428):1428
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208):208
at org.hibernate.loader.Loader.getResultSet(Loader.java:1869):1869
at org.hibernate.loader.Loader.doQuery(Loader.java:718):718
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270):270
at org.hibernate.loader.Loader.doList(Loader.java:2449):2449
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192):2192
at org.hibernate.loader.Loader.list(Loader.java:2187):2187
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119):119
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1706):1706
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347):347
at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:369):369
at railo.runtime.orm.hibernate.HibernateORMSession.load(HibernateORMSession.java:678):678
at railo.runtime.orm.hibernate.HibernateORMSession.load(HibernateORMSession.java:449):449
at railo.runtime.functions.orm.EntityLoad.call(EntityLoad.java:50):50
at system.orm.hibernate.baseormservice_cfc$cf.udfCall1(/mnt/var/staxapps/8400/staxcat/install/webapp.war/coldbox/system/orm/hibernate/BaseORMService.cfc:275):275
at system.orm.hibernate.baseormservice_cfc$cf.udfCall(/mnt/var/staxapps/8400/staxcat/install/webapp.war/coldbox/system/orm/hibernate/BaseORMService.cfc):-1
at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214
at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418
at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383
at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609
at railo.runtime.ComponentImpl._call(ComponentImpl.java:504):504
at railo.runtime.SuperComponent.call(SuperComponent.java:67):67
at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733
at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444
at system.orm.hibernate.virtualentityservice_cfc$cf.udfCall1(/mnt/var/staxapps/8400/staxcat/install/webapp.war/coldbox/system/orm/hibernate/VirtualEntityService.cfc:104):104
at system.orm.hibernate.virtualentityservice_cfc$cf.udfCall(/mnt/var/staxapps/8400/staxcat/install/webapp.war/coldbox/system/orm/hibernate/VirtualEntityService.cfc):-1
at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214
at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418
at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383
at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609
at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496
at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794
at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733
at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444
at model.ui.layoutservice_cfc$cf.udfCall1(/mnt/var/staxapps/8400/staxcat/install/webapp.war/modules/contentbox/model/ui/LayoutService.cfc:43):43
at model.ui.layoutservice_cfc$cf.udfCall(/mnt/var/staxapps/8400/staxcat/install/webapp.war/modules/contentbox/model/ui/LayoutService.cfc):-1
at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214
at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418
at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383
at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609
at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496
at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794
at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733
at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444
at modules.contentbox_ui495.moduleconfig_cfc$cf.udfCall(/mnt/var/staxapps/8400/staxcat/install/webapp.war/modules/contentbox-ui/ModuleConfig.cfc:113):113
at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214
at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418
at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383
at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609
at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496
at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794
at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733
at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444
at system.web.services.moduleservice_cfc$cf.udfCall2(/mnt/var/staxapps/8400/staxcat/install/webapp.war/coldbox/system/web/services/ModuleService.cfc:324):324
at system.web.services.moduleservice_cfc$cf.udfCall(/mnt/var/staxapps/8400/staxcat/install/webapp.war/coldbox/system/web/services/ModuleService.cfc):-1
at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214
at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418
at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383
at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738
at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444
at system.web.services.moduleservice_cfc$cf.udfCall1(/mnt/var/staxapps/8400/staxcat/install/webapp.war/coldbox/system/web/services/ModuleService.cfc:256):256
at system.web.services.moduleservice_cfc$cf.udfCall(/mnt/var/staxapps/8400/staxcat/install/webapp.war/coldbox/system/web/services/ModuleService.cfc):-1
at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214
at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418
at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383
at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609
at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496
at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794
at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733
at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444
at system.web.services.loaderservice_cfc$cf.udfCall(/mnt/var/staxapps/8400/staxcat/install/webapp.war/coldbox/system/web/services/LoaderService.cfc:84):84
at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214
at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418
at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383
at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609
at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496
at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794
at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733
at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444
at coldbox.system.coldbox_cfc$cf.udfCall1(/mnt/var/staxapps/8400/staxcat/install/webapp.war/coldbox/system/Coldbox.cfc:71):71
at coldbox.system.coldbox_cfc$cf.udfCall(/mnt/var/staxapps/8400/staxcat/install/webapp.war/coldbox/system/Coldbox.cfc):-1
at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214
at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418
at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383
at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609
at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496
at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794
at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733
at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444
at application_cfc$cf.udfCall(/mnt/var/staxapps/8400/staxcat/install/webapp.war/Application.cfc:76):76
at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214
at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418
at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383
at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609
at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496
at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794
at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:347):347
at railo.runtime.listener.ModernAppListener.onApplicationStart(ModernAppListener.java:216):216
at railo.runtime.PageContextImpl.initApplicationContext(PageContextImpl.java:2566):2566
at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:101):101
at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:23):23
at railo.runtime.PageContextImpl.execute(PageContextImpl.java:1991):1991
at railo.runtime.PageContextImpl.execute(PageContextImpl.java:1958):1958
at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:297):297
at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32):32
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717):717
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290):290
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646):646
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436):436
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374):374
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302):302
at org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:213):213
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171):171
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145):145
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92):92
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381):381
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235):235
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233):233
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191):191
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127):127
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102):102
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109):109
at net.stax.appserver.webapp.RequestMonitorValve.invoke(RequestMonitorValve.java:35):35
at net.stax.appserver.admin.StaxApplicationQueryValve.invoke(StaxApplicationQueryValve.java:49):49
at net.stax.appserver.webapp.RequestSetupValve.invoke(RequestSetupValve.java:31):31
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:647):647
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298):298
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859):859
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588):588
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489):489
at java.lang.Thread.run(Thread.java:662):662
