ContentBox3 installation error on Windows, Lucee5, MSSQL

Hi Luis, This works for Lucee 4.5 & MySql. It does not work for Lucee 4.5 and Microsoft SQL DB. There is some code in the base cborm that MSSQL Server does not like. Should probably fix because this will cause problems down the road.

mplate: D:\projects\wbg\modules\contentbox\modules\contentbox-deps\modules\cborm\models\BaseORMService.cfc
LINE: 315: options.cacheable = true;
316: }
317: return entityLoad( arguments.entityName, arguments.criteria, arguments.sortOrder, options);
318: }
319:

Here is the Stack trace.

Incorrect syntax near ‘(’.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216):216
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515):1515
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404):404
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350):350
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696):5696
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715):1715
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180):180
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155):155
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285):285
at lucee.runtime.db.driver.state.StateUtil.executeQuery(StateUtil.java:157):157
at lucee.runtime.db.driver.state.StatePreparedStatement.executeQuery(StatePreparedStatement.java:140):140
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 lucee.runtime.orm.hibernate.HibernateORMSession.load(HibernateORMSession.java:785):785
at lucee.runtime.orm.hibernate.HibernateORMSession.loadAsArray(HibernateORMSession.java:605):605
at lucee.runtime.functions.orm.EntityLoad.call(EntityLoad.java:81):81
at models.baseormservice_cfc$cf.udfCall1(/cborm/models/BaseORMService.cfc:317):317
at models.baseormservice_cfc$cf.udfCall(/cborm/models/BaseORMService.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:532):532
at lucee.runtime.SuperComponent.call(SuperComponent.java:80):80
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599):1599
at models.virtualentityservice_cfc$cf.udfCall1(/cborm/models/VirtualEntityService.cfc:109):109
at models.virtualentityservice_cfc$cf.udfCall(/cborm/models/VirtualEntityService.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:775):775
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1609):1609
at models.baseormservice_cfc$cf.udfCall1(/cborm/models/BaseORMService.cfc:294):294
at models.baseormservice_cfc$cf.udfCall(/cborm/models/BaseORMService.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:532):532
at lucee.runtime.SuperComponent.call(SuperComponent.java:80):80
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599):1599
at models.virtualentityservice_cfc$cf.udfCall1(/cborm/models/VirtualEntityService.cfc:105):105
at models.virtualentityservice_cfc$cf.udfCall(/cborm/models/VirtualEntityService.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:775):775
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1609):1609
at models.content.categoryservice_cfc$cf.udfCall(/contentbox/models/content/CategoryService.cfc:42):42
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599):1599
at modules.contentbox_installer495.models.installerservice_cfc$cf.udfCall2(/cbapp/modules/contentbox-installer/models/InstallerService.cfc:487):487
at modules.contentbox_installer495.models.installerservice_cfc$cf.udfCall(/cbapp/modules/contentbox-installer/models/InstallerService.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:766):766
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599):1599
at modules.contentbox_installer495.models.installerservice_cfc$cf.udfCall1(/cbapp/modules/contentbox-installer/models/InstallerService.cfc:54):54
at modules.contentbox_installer495.models.installerservice_cfc$cf.udfCall(/cbapp/modules/contentbox-installer/models/InstallerService.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599):1599
at modules.contentbox_installer495.handlers.home_cfc$cf.udfCall(/cbapp/modules/contentbox-installer/handlers/Home.cfc:56):56
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:775):775
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1609):1609
at system.eventhandler_cfc$cf.udfCall(/coldbox/system/EventHandler.cfc:85):85
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1778):1778
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1609):1609
at system.web.controller_cfc$cf.udfCall3(/coldbox/system/web/Controller.cfc:795):795
at system.web.controller_cfc$cf.udfCall(/coldbox/system/web/Controller.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:775):775
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1609):1609
at system.web.controller_cfc$cf.udfCall2(/coldbox/system/web/Controller.cfc:633):633
at system.web.controller_cfc$cf.udfCall(/coldbox/system/web/Controller.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:775):775
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1609):1609
at system.web.controller_cfc$cf.udfCall2(/coldbox/system/web/Controller.cfc:425):425
at system.web.controller_cfc$cf.udfCall(/coldbox/system/web/Controller.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1778):1778
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1609):1609
at coldbox.system.bootstrap_cfc$cf.udfCall1(/coldbox/system/Bootstrap.cfc:200):200
at coldbox.system.bootstrap_cfc$cf.udfCall(/coldbox/system/Bootstrap.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:766):766
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599):1599
at coldbox.system.bootstrap_cfc$cf.udfCall1(/coldbox/system/Bootstrap.cfc:360):360
at coldbox.system.bootstrap_cfc$cf.udfCall(/coldbox/system/Bootstrap.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599):1599
at application_cfc$cf.udfCall(/Application.cfc:106):106
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:414):414
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:133):133
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:37):37
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2271):2271
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2234):2234
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:456):456
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:47):47
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790):790
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85):85
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129):129
at org.cfmlprojects.regexpathinfofilter.RegexPathInfoFilter.doFilter(RegexPathInfoFilter.java:47):47
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61):61
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131):131
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84):84
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62):62
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36):36
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43):43
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43):43
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:274):274
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchToPath(ServletInitialHandler.java:209):209
at io.undertow.servlet.spec.RequestDispatcherImpl.forwardImpl(RequestDispatcherImpl.java:221):221
at io.undertow.servlet.spec.RequestDispatcherImpl.forwardImplSetup(RequestDispatcherImpl.java:147):147
at io.undertow.servlet.spec.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:111):111
at org.cfmlprojects.regexpathinfofilter.RegexPathInfoFilter.doFilter(RegexPathInfoFilter.java:45):45
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61):61
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131):131
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176):176
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:389):389
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61):61
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131):131
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84):84
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62):62
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36):36
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131):131
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57):57
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43):43
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46):46
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64):64
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60):60
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77):77
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43):43
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43):43
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43):43
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292):292
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81):81
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138):138
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135):135
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48):48
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43):43
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272):272
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81):81
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104):104
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:211):211
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:809):809
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142):1142
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617):617
at java.lang.Thread.run(Thread.java:745):745

George that’s a sql exception not an cborm exception. It means the sql generated by the orm failed. Look in the orm logs for the offending call please. I will try to replicate.

Luis Majano
CEO
Ortus Solutions, Corp

P/F: 1-888-557-8057

Here is the offending SQL and Stack Trace.

Hibernate:
select
this_.categoryID as categoryID2_0_,
this_.createdDate as createdD2_2_0_,
this_.modifiedDate as modified3_2_0_,
this_.isDeleted as isDeleted2_0_,
this_.category as category2_0_,
this_.slug as slug2_0_,
(select
count()
from
cb_contentCategories as contentCategories,
cb_contentStore as contentStore,
cb_content as content
where
contentCategories.FK_categoryID=this_.categoryID
and contentCategories.FK_contentID = contentStore.contentID
and contentStore.contentID = content.contentID) as formula1_0_,
(select
count(
)
from
cb_contentCategories as contentCategories,
cb_contentStore as contentStore,
cb_content as content
where
contentCategories.FK_categoryID=this_.categoryID
and contentCategories.FK_contentID = contentStore.contentID
and contentStore.contentID = content.contentID
and content.isPublished = 1
and content.publishedDate <= CURRENT_TIMESTAMP()
and content.passwordProtection = ‘’
and (
content.expireDate is null
or content.expireDate >= CURRENT_TIMESTAMP()
)) as formula2_0_,
(select
count()
from
cb_contentCategories as contentCategories,
cb_entry as entry,
cb_content as content
where
contentCategories.FK_categoryID=this_.categoryID
and contentCategories.FK_contentID = entry.contentID
and entry.contentID = content.contentID) as formula3_0_,
(select
count(
)
from
cb_contentCategories as contentCategories,
cb_entry as entry,
cb_content as content
where
contentCategories.FK_categoryID=this_.categoryID
and contentCategories.FK_contentID = entry.contentID
and entry.contentID = content.contentID
and content.isPublished = 1
and content.publishedDate <= CURRENT_TIMESTAMP()
and content.passwordProtection = ‘’
and (
content.expireDate is null
or content.expireDate >= CURRENT_TIMESTAMP()
)) as formula4_0_,
(select
count()
from
cb_contentCategories as contentCategories,
cb_page as page,
cb_content as content
where
contentCategories.FK_categoryID=this_.categoryID
and contentCategories.FK_contentID = page.contentID
and page.contentID = content.contentID) as formula5_0_,
(select
count(
)
from
cb_contentCategories as contentCategories,
cb_page as page,
cb_content as content
where
contentCategories.FK_categoryID=this_.categoryID
and contentCategories.FK_contentID = page.contentID
and page.contentID = content.contentID
and content.isPublished = 1
and content.publishedDate <= CURRENT_TIMESTAMP()
and content.passwordProtection = ‘’
and (
content.expireDate is null
or content.expireDate >= CURRENT_TIMESTAMP()
)) as formula6_0_
from
cb_category this_
where
this_.slug=?
and this_.category=?
ERROR coldbox.system.Bootstrap Error: Incorrect syntax near ‘(’. ExtraInfo: {“Extended_Info”:"",“Message”:“Incorrect syntax near ‘(’.”,“Detail”:"",“SQLState”:“S0001”,“additional”:{“Cause”:“com.microsoft.sqlserver.jdbc.SQLServerException”,“hibernate exception”:“org.hibernate.exception.SQLGrammarException: could not execute query”,“sql”:“select this_.categoryID as categoryID2_0_, this_.createdDate as createdD2_2_0_, this_.modifiedDate as modified3_2_0_, this_.isDeleted as isDeleted2_0_, this_.category as category2_0_, this_.slug as slug2_0_, (select count() \n\t\t\t\t\t\tfrom cb_contentCategories as contentCategories, cb_contentStore as contentStore, cb_content as content\n\t\t\t\t\t\twhere contentCategories.FK_categoryID=this_.categoryID\n\t\t\t\t\t\t\tand contentCategories.FK_contentID = contentStore.contentID\n\t\t\t\t\t\t \tand contentStore.contentID = content.contentID) as formula1_0_, (select count() \n\t\t\t\t\t\tfrom cb_contentCategories as contentCategories, cb_contentStore as contentStore, cb_content as content\n\t\t\t\t\t\twhere contentCategories.FK_categoryID=this_.categoryID\n\t\t\t\t\t\t\tand contentCategories.FK_contentID = contentStore.contentID\n\t\t\t\t\t\t \tand contentStore.contentID = content.contentID\n\t\t\t\t\t\t \tand content.isPublished = 1\n\t\t\t\t\t\t \tand content.publishedDate <= CURRENT_TIMESTAMP()\n\t\t\t\t\t\t \tand content.passwordProtection = ‘’\n\t\t\t\t\t\t \tand ( \n\t\t\t\t\t\t\t\tcontent.expireDate is null or\n\t\t\t\t\t\t\t\tcontent.expireDate >= CURRENT_TIMESTAMP()\n\t\t\t\t\t\t \t)) as formula2_0_, (select count() \n\t\t\t\t\t\tfrom cb_contentCategories as contentCategories, cb_entry as entry, cb_content as content\n\t\t\t\t\t\twhere contentCategories.FK_categoryID=this_.categoryID\n\t\t\t\t\t\t\tand contentCategories.FK_contentID = entry.contentID\n\t\t\t\t\t\t \tand entry.contentID = content.contentID) as formula3_0_, (select count() \n\t\t\t\t\t\tfrom cb_contentCategories as contentCategories, cb_entry as entry, cb_content as content\n\t\t\t\t\t\twhere contentCategories.FK_categoryID=this_.categoryID\n\t\t\t\t\t\t\tand contentCategories.FK_contentID = entry.contentID\n\t\t\t\t\t\t \tand entry.contentID = content.contentID\n\t\t\t\t\t\t \tand content.isPublished = 1\n\t\t\t\t\t\t \tand content.publishedDate <= CURRENT_TIMESTAMP()\n\t\t\t\t\t\t \tand content.passwordProtection = ‘’\n\t\t\t\t\t\t \tand ( \n\t\t\t\t\t\t\t\tcontent.expireDate is null or\n\t\t\t\t\t\t\t\tcontent.expireDate >= CURRENT_TIMESTAMP()\n\t\t\t\t\t\t \t)) as formula4_0_, (select count() \n\t\t\t\t\t\tfrom cb_contentCategories as contentCategories, cb_page as page, cb_content as content\n\t\t\t\t\t\twhere contentCategories.FK_categoryID=this_.categoryID\n\t\t\t\t\t\t\tand contentCategories.FK_contentID = page.contentID\n\t\t\t\t\t\t\tand page.contentID = content.contentID) as formula5_0_, (select count() \n\t\t\t\t\t\tfrom cb_contentCategories as contentCategories, cb_page as page, cb_content as content\n\t\t\t\t\t\twhere contentCategories.FK_categoryID=this_.categoryID\n\t\t\t\t\t\t\tand contentCategories.FK_contentID = page.contentID\n\t\t\t\t\t\t\tand page.contentID = content.contentID\n\t\t\t\t\t\t\tand content.isPublished = 1\n\t\t\t\t\t\t \tand content.publishedDate <= CURRENT_TIMESTAMP()\n\t\t\t\t\t\t \tand content.passwordProtection = ‘’\n\t\t\t\t\t\t \tand ( \n\t\t\t\t\t\t\t\tcontent.expireDate is null or\n\t\t\t\t\t\t\t\tcontent.expireDate >= CURRENT_TIMESTAMP()\n\t\t\t\t\t\t \t)) as formula6_0_ from cb_category this_ where this_.slug=? and this_.category=?”},“TagContext”:[{“Raw_Trace”:“models.baseormservice_cfc$cf.udfCall1(/cborm/models/BaseORMService.cfc:317)”,“codePrintPlain”:“315: \t\t\toptions.cacheable = true;\n316: \t\t}\n317: \t\treturn entityLoad( arguments.entityName, arguments.criteria, arguments.sortOrder, options);\n318: \t}\n319: \n”,“column”:0,“line”:317,“template”:“D:\projects\wbg\modules\contentbox\modules\contentbox-deps\modules\cborm\models\BaseORMService.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“315: \t\t\toptions.cacheable = true;
\n316: \t\t}
\n317: \t\treturn entityLoad( arguments.entityName, arguments.criteria, arguments.sortOrder, options);
\n318: \t}
\n319:
\n”},{“Raw_Trace”:“models.baseormservice_cfc$cf.udfCall1(/cborm/models/BaseORMService.cfc:317)”,“codePrintPlain”:“315: \t\t\toptions.cacheable = true;\n316: \t\t}\n317: \t\treturn entityLoad( arguments.entityName, arguments.criteria, arguments.sortOrder, options);\n318: \t}\n319: \n”,“column”:0,“line”:317,“template”:“D:\projects\wbg\modules\contentbox\modules\contentbox-deps\modules\cborm\models\BaseORMService.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“315: \t\t\toptions.cacheable = true;
\n316: \t\t}
\n317: \t\treturn entityLoad( arguments.entityName, arguments.criteria, arguments.sortOrder, options);
\n318: \t}
\n319:
\n”},{“Raw_Trace”:“models.virtualentityservice_cfc$cf.udfCall1(/cborm/models/VirtualEntityService.cfc:109)”,“codePrintPlain”:“107: \n108: \tarray function findAllWhere(required struct criteria, string sortOrder=”"){\n109: \t\treturn super.findAllWhere(this.getEntityName(), arguments.criteria, arguments.sortOrder);\n110: \t}\n111: \n",“column”:0,“line”:109,“template”:“D:\projects\wbg\modules\contentbox\modules\contentbox-deps\modules\cborm\models\VirtualEntityService.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“107:
\n108: \tarray function findAllWhere(required struct criteria, string sortOrder=”"){
\n109: \t\treturn super.findAllWhere(this.getEntityName(), arguments.criteria, arguments.sortOrder);
\n110: \t}
\n111:
\n"},{“Raw_Trace”:“models.baseormservice_cfc$cf.udfCall1(/cborm/models/BaseORMService.cfc:294)”,“codePrintPlain”:“292: \t\tif( getUseQueryCaching() ){\n293: \t\t\t//if we are caching, we will use find all and return an array since entityLoad does not support both unique and caching\n294: \t\t\tvar arEntity = findAllWhere( argumentCollection=arguments );\n295: \t\t\t//if we found an entity, return it\n296: \t\t\tif (arrayLen(arEntity)) {\n”,“column”:0,“line”:294,“template”:“D:\projects\wbg\modules\contentbox\modules\contentbox-deps\modules\cborm\models\BaseORMService.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“292: \t\tif( getUseQueryCaching() ){
\n293: \t\t\t//if we are caching, we will use find all and return an array since entityLoad does not support both unique and caching
\n294: \t\t\tvar arEntity = findAllWhere( argumentCollection=arguments );
\n295: \t\t\t//if we found an entity, return it
\n296: \t\t\tif (arrayLen(arEntity)) {
\n”},{“Raw_Trace”:“models.virtualentityservice_cfc$cf.udfCall1(/cborm/models/VirtualEntityService.cfc:105)”,“codePrintPlain”:“103: \n104: \tany function findWhere(required struct criteria){\n105: \t\treturn super.findWhere(this.getEntityName(), arguments.criteria);\n106: \t}\n107: \n”,“column”:0,“line”:105,“template”:“D:\projects\wbg\modules\contentbox\modules\contentbox-deps\modules\cborm\models\VirtualEntityService.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“103:
\n104: \tany function findWhere(required struct criteria){
\n105: \t\treturn super.findWhere(this.getEntityName(), arguments.criteria);
\n106: \t}
\n107:
\n”},{“Raw_Trace”:“models.content.categoryservice_cfc$cf.udfCall(/contentbox/models/content/CategoryService.cfc:42)”,“codePrintPlain”:“40: \t\t\tvar properties \t= {category=thisCat, slug=htmlHelper.slugify( thisCat )};\n41: \t\t\t// check that category doesn’t exist already\n42: \t\t\tvar extantCategory = findWhere( criteria = properties );\n43: \t\t\t// if no match is found, add to array\n44: \t\t\tif( isNull( extantCategory ) ) {\n”,“column”:0,“line”:42,“template”:“D:\projects\wbg\modules\contentbox\models\content\CategoryService.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“40: \t\t\tvar properties \t= {category=thisCat, slug=htmlHelper.slugify( thisCat )};
\n41: \t\t\t// check that category doesn’t exist already
\n42: \t\t\tvar extantCategory = findWhere( criteria = properties );
\n43: \t\t\t// if no match is found, add to array
\n44: \t\t\tif( isNull( extantCategory ) ) {
\n”},{“Raw_Trace”:“modules.contentbox_installer495.models.installerservice_cfc$cf.udfCall2(/cbapp/modules/contentbox-installer/models/InstallerService.cfc:487)”,“codePrintPlain”:“485: \n486: \t\t// create a few categories\n487: \t\tcategoryService.createCategories( “News, ColdFusion, ColdBox, ContentBox” );\n488: \n489: \t\t// create some blog entries\n”,“column”:0,“line”:487,“template”:“D:\projects\wbg\modules\contentbox-installer\models\InstallerService.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“485:
\n486: \t\t// create a few categories
\n487: \t\tcategoryService.createCategories( “News, ColdFusion, ColdBox, ContentBox” );
\n488:
\n489: \t\t// create some blog entries
\n”},{“Raw_Trace”:“modules.contentbox_installer495.models.installerservice_cfc$cf.udfCall2(/cbapp/modules/contentbox-installer/models/InstallerService.cfc:487)”,“codePrintPlain”:“485: \n486: \t\t// create a few categories\n487: \t\tcategoryService.createCategories( “News, ColdFusion, ColdBox, ContentBox” );\n488: \n489: \t\t// create some blog entries\n”,“column”:0,“line”:487,“template”:“D:\projects\wbg\modules\contentbox-installer\models\InstallerService.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“485:
\n486: \t\t// create a few categories
\n487: \t\tcategoryService.createCategories( “News, ColdFusion, ColdBox, ContentBox” );
\n488:
\n489: \t\t// create some blog entries
\n”},{“Raw_Trace”:“modules.contentbox_installer495.models.installerservice_cfc$cf.udfCall1(/cbapp/modules/contentbox-installer/models/InstallerService.cfc:54)”,“codePrintPlain”:“52: \t\t\t// Do we create sample data?\n53: \t\t\tif( arguments.setup.getpopulateData() ){\n54: \t\t\t\tcreateSampleData( arguments.setup, author );\n55: \t\t\t}\n56: \t\t\t// Remove ORM update from Application.cfc\n”,“column”:0,“line”:54,“template”:“D:\projects\wbg\modules\contentbox-installer\models\InstallerService.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“52: \t\t\t// Do we create sample data?
\n53: \t\t\tif( arguments.setup.getpopulateData() ){
\n54: \t\t\t\tcreateSampleData( arguments.setup, author );
\n55: \t\t\t}
\n56: \t\t\t// Remove ORM update from Application.cfc
\n”},{“Raw_Trace”:“modules.contentbox_installer495.models.installerservice_cfc$cf.udfCall1(/cbapp/modules/contentbox-installer/models/InstallerService.cfc:54)”,“codePrintPlain”:“52: \t\t\t// Do we create sample data?\n53: \t\t\tif( arguments.setup.getpopulateData() ){\n54: \t\t\t\tcreateSampleData( arguments.setup, author );\n55: \t\t\t}\n56: \t\t\t// Remove ORM update from Application.cfc\n”,“column”:0,“line”:54,“template”:“D:\projects\wbg\modules\contentbox-installer\models\InstallerService.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“52: \t\t\t// Do we create sample data?
\n53: \t\t\tif( arguments.setup.getpopulateData() ){
\n54: \t\t\t\tcreateSampleData( arguments.setup, author );
\n55: \t\t\t}
\n56: \t\t\t// Remove ORM update from Application.cfc
\n”},{“Raw_Trace”:“modules.contentbox_installer495.handlers.home_cfc$cf.udfCall(/cbapp/modules/contentbox-installer/handlers/Home.cfc:56)”,“codePrintPlain”:“54: \t\t}\n55: \t\t// start installation\n56: \t\tinstallerService.execute( populateModel( “Setup@cbi” ) );\n57: \t\t// start up fresh in next request\n58: \t\tapplicationStop();\n”,“column”:0,“line”:56,“template”:“D:\projects\wbg\modules\contentbox-installer\handlers\Home.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“54: \t\t}
\n55: \t\t// start installation
\n56: \t\tinstallerService.execute( populateModel( “Setup@cbi” ) );
\n57: \t\t// start up fresh in next request
\n58: \t\tapplicationStop();
\n”},{“Raw_Trace”:“modules.contentbox_installer495.handlers.home_cfc$cf.udfCall(/cbapp/modules/contentbox-installer/handlers/Home.cfc:56)”,“codePrintPlain”:“54: \t\t}\n55: \t\t// start installation\n56: \t\tinstallerService.execute( populateModel( “Setup@cbi” ) );\n57: \t\t// start up fresh in next request\n58: \t\tapplicationStop();\n”,“column”:0,“line”:56,“template”:“D:\projects\wbg\modules\contentbox-installer\handlers\Home.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“54: \t\t}
\n55: \t\t// start installation
\n56: \t\tinstallerService.execute( populateModel( “Setup@cbi” ) );
\n57: \t\t// start up fresh in next request
\n58: \t\tapplicationStop();
\n”},{“Raw_Trace”:“system.eventhandler_cfc$cf.udfCall(/coldbox/system/EventHandler.cfc:85)”,“codePrintPlain”:“83: \tany function _privateInvoker( required method, required argCollection ){\n84: \t\tvar _targetAction = variables[ arguments.method ];\n85: \t\tvar _targetResults = _targetAction( argumentCollection=argCollection );\n86: \t\tif( !isNull( _targetResults ) ){ return _targetResults; }\n87: \t}\n”,“column”:0,“line”:85,“template”:“D:\projects\wbg\coldbox\system\EventHandler.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“83: \tany function _privateInvoker( required method, required argCollection ){
\n84: \t\tvar _targetAction = variables[ arguments.method ];
\n85: \t\tvar _targetResults = _targetAction( argumentCollection=argCollection );
\n86: \t\tif( !isNull( _targetResults ) ){ return _targetResults; }
\n87: \t}
\n”},{“Raw_Trace”:“system.web.controller_cfc$cf.udfCall3(/coldbox/system/web/Controller.cfc:795)”,“codePrintPlain”:“793: \t\tboolean private=false\n794: \t){\n795: \t\treturn arguments.target._privateInvoker( method=arguments.method, argCollection=arguments.argCollection );\n796: \t}\n797: \n”,“column”:0,“line”:795,“template”:“D:\projects\wbg\coldbox\system\web\Controller.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“793: \t\tboolean private=false
\n794: \t){
\n795: \t\treturn arguments.target._privateInvoker( method=arguments.method, argCollection=arguments.argCollection );
\n796: \t}
\n797:
\n”},{“Raw_Trace”:“system.web.controller_cfc$cf.udfCall2(/coldbox/system/web/Controller.cfc:633)”,“codePrintPlain”:“631: \t\t\t\telse{\n632: \t\t\t\t\t// Normal execution\n633: \t\t\t\t\tloc.results = invoker( target=oHandler, method=ehBean.getMethod(), argCollection=argsMain, private=arguments.private );\n634: \t\t\t\t}\n635: \t\t\t}\n”,“column”:0,“line”:633,“template”:“D:\projects\wbg\coldbox\system\web\Controller.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“631: \t\t\t\telse{
\n632: \t\t\t\t\t// Normal execution
\n633: \t\t\t\t\tloc.results = invoker( target=oHandler, method=ehBean.getMethod(), argCollection=argsMain, private=arguments.private );
\n634: \t\t\t\t}
\n635: \t\t\t}
\n”},{“Raw_Trace”:“system.web.controller_cfc$cf.udfCall2(/coldbox/system/web/Controller.cfc:425)”,“codePrintPlain”:“423: \t\t// relay if no event caching activated or no caching needed\n424: \t\tif( !getSetting( “eventCaching” ) OR !arguments.cache ){\n425: \t\t\treturn _runEvent( argumentCollection=arguments );\n426: \t\t}\n427: \n”,“column”:0,“line”:425,“template”:“D:\projects\wbg\coldbox\system\web\Controller.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“423: \t\t// relay if no event caching activated or no caching needed
\n424: \t\tif( !getSetting( “eventCaching” ) OR !arguments.cache ){
\n425: \t\t\treturn _runEvent( argumentCollection=arguments );
\n426: \t\t}
\n427:
\n”},{“Raw_Trace”:“coldbox.system.bootstrap_cfc$cf.udfCall1(/coldbox/system/Bootstrap.cfc:200)”,“codePrintPlain”:“198: \t\t\t\t//****** EXECUTE MAIN EVENT */\n199: \t\t\t\tif( NOT event.isNoExecution() ){\n200: \t\t\t\t\trefResults.results = cbController.runEvent( defaultEvent=true );\n201: \t\t\t\t}\n202: \t\t\t\t// RENDERING PROCEDURES */\n",“column”:0,“line”:200,“template”:“D:\projects\wbg\coldbox\system\Bootstrap.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:"198: \t\t\t\t// EXECUTE MAIN EVENT */
\n199: \t\t\t\tif( NOT event.isNoExecution() ){
\n200: \t\t\t\t\trefResults.results = cbController.runEvent( defaultEvent=true );
\n201: \t\t\t\t}
\n202: \t\t\t\t//
RENDERING PROCEDURES *******/
\n”},{“Raw_Trace”:“coldbox.system.bootstrap_cfc$cf.udfCall1(/coldbox/system/Bootstrap.cfc:360)”,“codePrintPlain”:“358: \t\t// Process A ColdBox Request Only\n359: \t\tif( findNoCase( ‘index.cfm’, listLast( arguments.targetPage, ‘/’ ) ) ){\n360: \t\t\tprocessColdBoxRequest();\n361: \t\t}\n362: \t\treturn true;\n”,“column”:0,“line”:360,“template”:“D:\projects\wbg\coldbox\system\Bootstrap.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“358: \t\t// Process A ColdBox Request Only
\n359: \t\tif( findNoCase( ‘index.cfm’, listLast( arguments.targetPage, ‘/’ ) ) ){
\n360: \t\t\tprocessColdBoxRequest();
\n361: \t\t}
\n362: \t\treturn true;
\n”},{“Raw_Trace”:“application_cfc$cf.udfCall(/Application.cfc:106)”,“codePrintPlain”:“104: \n105: \t\t// Process ColdBox Request\n106: \t\tapplication.cbBootstrap.onRequestStart( arguments.targetPage );\n107: \n108: \t\treturn true;\n”,“column”:0,“line”:106,“template”:“D:\projects\wbg\Application.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“104:
\n105: \t\t// Process ColdBox Request
\n106: \t\tapplication.cbBootstrap.onRequestStart( arguments.targetPage );
\n107:
\n108: \t\treturn true;
\n”},{“Raw_Trace”:“coldbox.system.bootstrap_cfc$cf.udfCall1(/coldbox/system/Bootstrap.cfc:360)”,“codePrintPlain”:“358: \t\t// Process A ColdBox Request Only\n359: \t\tif( findNoCase( ‘index.cfm’, listLast( arguments.targetPage, ‘/’ ) ) ){\n360: \t\t\tprocessColdBoxRequest();\n361: \t\t}\n362: \t\treturn true;\n”,“column”:0,“line”:360,“template”:“D:\projects\wbg\coldbox\system\Bootstrap.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“358: \t\t// Process A ColdBox Request Only
\n359: \t\tif( findNoCase( ‘index.cfm’, listLast( arguments.targetPage, ‘/’ ) ) ){
\n360: \t\t\tprocessColdBoxRequest();
\n361: \t\t}
\n362: \t\treturn true;
\n”},{“Raw_Trace”:“application_cfc$cf.udfCall(/Application.cfc:106)”,“codePrintPlain”:“104: \n105: \t\t// Process ColdBox Request\n106: \t\tapplication.cbBootstrap.onRequestStart( arguments.targetPage );\n107: \n108: \t\treturn true;\n”,“column”:0,“line”:106,“template”:“D:\projects\wbg\Application.cfc”,“id”:"??",“type”:“cfml”,“codePrintHTML”:“104:
\n105: \t\t// Process ColdBox Request
\n106: \t\tapplication.cbBootstrap.onRequestStart( arguments.targetPage );
\n107:
\n108: \t\treturn true;
\n”}],“ErrorCode”:102,“type”:“com.microsoft.sqlserver.jdbc.SQLServerException”,“StackTrace”:“Incorrect syntax near ‘(’.\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216):216\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515):1515\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404):404\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350):350\r\n\tat com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696):5696\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715):1715\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180):180\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155):155\r\n\tat com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285):285\r\n\tat lucee.runtime.db.driver.state.StateUtil.executeQuery(StateUtil.java:157):157\r\n\tat lucee.runtime.db.driver.state.StatePreparedStatement.executeQuery(StatePreparedStatement.java:140):140\r\n\tat org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208):208\r\n\tat org.hibernate.loader.Loader.getResultSet(Loader.java:1869):1869\r\n\tat org.hibernate.loader.Loader.doQuery(Loader.java:718):718\r\n\tat org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270):270\r\n\tat org.hibernate.loader.Loader.doList(Loader.java:2449):2449\r\n\tat org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192):2192\r\n\tat org.hibernate.loader.Loader.list(Loader.java:2187):2187\r\n\tat org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119):119\r\n\tat org.hibernate.impl.SessionImpl.list(SessionImpl.java:1706):1706\r\n\tat org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347):347\r\n\tat lucee.runtime.orm.hibernate.HibernateORMSession.load(HibernateORMSession.java:785):785\r\n\tat lucee.runtime.orm.hibernate.HibernateORMSession.loadAsArray(HibernateORMSession.java:605):605\r\n\tat lucee.runtime.functions.orm.EntityLoad.call(EntityLoad.java:81):81\r\n\tat models.baseormservice_cfc$cf.udfCall1(/cborm/models/BaseORMService.cfc:317):317\r\n\tat models.baseormservice_cfc$cf.udfCall(/cborm/models/BaseORMService.cfc):-1\r\n\tat lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111\r\n\tat lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328\r\n\tat lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229\r\n\tat lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642\r\n\tat lucee.runtime.ComponentImpl._call(ComponentImpl.java:532):532\r\n\tat lucee.runtime.SuperComponent.call(SuperComponent.java:80):80\r\n\tat lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743\r\n\tat lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599):1599\r\n\tat models.virtualentityservice_cfc$cf.udfCall1(/cborm/models/VirtualEntityService.cfc:109):109\r\n\tat models.virtualentityservice_cfc$cf.udfCall(/cborm/models/VirtualEntityService.cfc):-1\r\n\tat lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111\r\n\tat lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328\r\n\tat lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216\r\n\tat lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:775):775\r\n\tat lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774\r\n\tat lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1609):1609\r\n\tat models.baseormservice_cfc$cf.udfCall1(/cborm/models/BaseORMService.cfc:294):294\r\n\tat models.baseormservice_cfc$cf.udfCall(/cborm/models/BaseORMService.cfc):-1\r\n\tat lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111\r\n\tat lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328\r\n\tat lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229\r\n\tat lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642\r\n\tat lucee.runtime.ComponentImpl._call(ComponentImpl.java:532):532\r\n\tat lucee.runtime.SuperComponent.call(SuperComponent.java:80):80\r\n\tat lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743\r\n\tat lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599):1599\r\n\tat models.virtualentityservice_cfc$cf.udfCall1(/cborm/models/VirtualEntityService.cfc:105):105\r\n\tat models.virtualentityservice_cfc$cf.udfCall(/cborm/models/VirtualEntityService.cfc):-1\r\n\tat lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111\r\n\tat lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328\r\n\tat lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216\r\n\tat lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:775):775\r\n\tat lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774\r\n\tat lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1609):1609\r\n\tat models.content.categoryservice_cfc$cf.udfCall(/contentbox/models/content/CategoryService.cfc:42):42\r\n\tat lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111\r\n\tat lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328\r\n\tat lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229\r\n\tat lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642\r\n\tat lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524\r\n\tat lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761\r\n\tat lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743\r\n\tat lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599):1599\r\n\tat modules.contentbox_installer495.models.installerservice_cfc$cf.udfCall2(/cbapp/modules/contentbox-installer/models/InstallerService.cfc:487):487\r\n\tat modules.contentbox_installer495.models.installerservice_cfc$cf.udfCall(/cbapp/modules/contentbox-installer/models/InstallerService.cfc):-1\r\n\tat lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111\r\n\tat lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328\r\n\tat lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229\r\n\tat lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:766):766\r\n\tat lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743\r\n\tat lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599):1599\r\n\tat modules.contentbox_installer495.models.installerservice_cfc$cf.udfCall1(/cbapp/modules/contentbox-installer/models/InstallerService.cfc:54):54\r\n\tat modules.contentbox_installer495.models.installerservice_cfc$cf.udfCall(/cbapp/modules/contentbox-installer/models/InstallerService.cfc):-1\r\n\tat lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111\r\n\tat lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328\r\n\tat lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229\r\n\tat lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642\r\n\tat lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524\r\n\tat lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761\r\n\tat lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743\r\n\tat lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599):1599\r\n\tat modules.contentbox_installer495.handlers.home_cfc$cf.udfCall(/cbapp/modules/contentbox-installer/handlers/Home.cfc:56):56\r\n\tat lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111\r\n\tat lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328\r\n\tat lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216\r\n\tat lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:775):775\r\n\tat lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774\r\n\tat lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1609):1609\r\n\tat system.eventhandler_cfc$cf.udfCall(/coldbox/system/EventHandler.cfc:85):85\r\n\tat lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111\r\n\tat lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328\r\n\tat lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216\r\n\tat lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643\r\n\tat lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524\r\n\tat lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1778):1778\r\n\tat lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774\r\n\tat lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1609):1609\r\n\tat system.web.controller_cfc$cf.udfCall3(/coldbox/system/web/Controller.cfc:795):795\r\n\tat system.web.controller_cfc$cf.udfCall(/coldbox/system/web/Controller.cfc):-1\r\n\tat lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111\r\n\tat lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328\r\n\tat lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216\r\n\tat lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:775):775\r\n\tat lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774\r\n\tat lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1609):1609\r\n\tat system.web.controller_cfc$cf.udfCall2(/coldbox/system/web/Controller.cfc:633):633\r\n\tat system.web.controller_cfc$cf.udfCall(/coldbox/system/web/Controller.cfc):-1\r\n\tat lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111\r\n\tat lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328\r\n\tat lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216\r\n\tat lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:775):775\r\n\tat lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774\r\n\tat lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1609):1609\r\n\tat system.web.controller_cfc$cf.udfCall2(/coldbox/system/web/Controller.cfc:425):425\r\n\tat system.web.controller_cfc$cf.udfCall(/coldbox/system/web/Controller.cfc):-1\r\n\tat lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111\r\n\tat lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328\r\n\tat lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216\r\n\tat lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643\r\n\tat lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524\r\n\tat lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1778):1778\r\n\tat lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774\r\n\tat lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1609):1609\r\n\tat coldbox.system.bootstrap_cfc$cf.udfCall1(/coldbox/system/Bootstrap.cfc:200):200\r\n\tat coldbox.system.bootstrap_cfc$cf.udfCall(/coldbox/system/Bootstrap.cfc):-1\r\n\tat lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111\r\n\tat lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328\r\n\tat lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229\r\n\tat lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:766):766\r\n\tat lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743\r\n\tat lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599):1599\r\n\tat coldbox.system.bootstrap_cfc$cf.udfCall1(/coldbox/system/Bootstrap.cfc:360):360\r\n\tat coldbox.system.bootstrap_cfc$cf.udfCall(/coldbox/system/Bootstrap.cfc):-1\r\n\tat lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111\r\n\tat lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328\r\n\tat lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229\r\n\tat lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642\r\n\tat lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524\r\n\tat lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761\r\n\tat lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743\r\n\tat lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599):1599\r\n\tat application_cfc$cf.udfCall(/Application.cfc:106):106\r\n\tat lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111\r\n\tat lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328\r\n\tat lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229\r\n\tat lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642\r\n\tat lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524\r\n\tat lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761\r\n\tat lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:414):414\r\n\tat lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:133):133\r\n\tat lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:37):37\r\n\tat lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2271):2271\r\n\tat lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2234):2234\r\n\tat lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:456):456\r\n\tat lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:47):47\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:790):790\r\n\tat io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85):85\r\n\tat io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129):129\r\n\tat org.cfmlprojects.regexpathinfofilter.RegexPathInfoFilter.doFilter(RegexPathInfoFilter.java:47):47\r\n\tat io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61):61\r\n\tat io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131):131\r\n\tat io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84):84\r\n\tat io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62):62\r\n\tat io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36):36\r\n\tat io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43):43\r\n\tat io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43):43\r\n\tat io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:274):274\r\n\tat io.undertow.servlet.handlers.ServletInitialHandler.dispatchToPath(ServletInitialHandler.java:209):209\r\n\tat io.undertow.servlet.spec.RequestDispatcherImpl.forwardImpl(RequestDispatcherImpl.java:221):221\r\n\tat io.undertow.servlet.spec.RequestDispatcherImpl.forwardImplSetup(RequestDispatcherImpl.java:147):147\r\n\tat io.undertow.servlet.spec.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:111):111\r\n\tat org.cfmlprojects.regexpathinfofilter.RegexPathInfoFilter.doFilter(RegexPathInfoFilter.java:45):45\r\n\tat io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61):61\r\n\tat io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131):131\r\n\tat io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84):84\r\n\tat io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62):62\r\n\tat io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36):36\r\n\tat io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43):43\r\n\tat io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43):43\r\n\tat io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:274):274\r\n\tat io.undertow.servlet.handlers.ServletInitialHandler.dispatchToPath(ServletInitialHandler.java:209):209\r\n\tat io.undertow.servlet.spec.RequestDispatcherImpl.forwardImpl(RequestDispatcherImpl.java:221):221\r\n\tat io.undertow.servlet.spec.RequestDispatcherImpl.forwardImplSetup(RequestDispatcherImpl.java:147):147\r\n\tat io.undertow.servlet.spec.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:111):111\r\n\tat org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:213):213\r\n\tat org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171):171\r\n\tat org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145):145\r\n\tat org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92):92\r\n\tat org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:389):389\r\n\tat io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61):61\r\n\tat io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131):131\r\n\tat io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84):84\r\n\tat io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62):62\r\n\tat io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36):36\r\n\tat io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131):131\r\n\tat io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57):57\r\n\tat io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43):43\r\n\tat io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46):46\r\n\tat io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64):64\r\n\tat io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60):60\r\n\tat io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77):77\r\n\tat io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43):43\r\n\tat io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43):43\r\n\tat io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43):43\r\n\tat io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292):292\r\n\tat io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81):81\r\n\tat io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138):138\r\n\tat io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135):135\r\n\tat io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48):48\r\n\tat io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43):43\r\n\tat io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272):272\r\n\tat io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81):81\r\n\tat io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104):104\r\n\tat io.undertow.server.Connectors.executeRootHandler(Connectors.java:211):211\r\n\tat io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:809):809\r\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142):1142\r\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617):617\r\n\tat java.lang.Thread.run(Thread.java:745):745\r\n”,“ExtendedInfo”:""}

I am still getting the [cbPermission] error with the be version.

Using CommandBox - install contentbox-installer@be
Lucee 4.5, MSSQL 2014

Oopsy! Something went wrong!Event: contentbox-installer:home.install

Routed URL: cbinstaller/install/
Layout: N/A (Module: )
View: N/A
Timestamp: 07/26/2017 02:14:02 PM

Jim can you clear your commandbox artifacts cache. I cannot reproduce your issue anymore since our latest BE commits.

The error is deceiving. The real error is identifying in the orm logs. But this was resolved in the latest commits with the installer.

Can you try by clearing your artifatcts and issuing a install contentbox-installer@be

Luis Majano
CEO
Ortus Solutions, Corp

P/F: 1-888-557-8057

So I went to C:\Users\Jim.CommandBox\artifacts and I emptied the folder. Is that what you mean by clearing the CommandBox artifacts Cache?

I deleted my previous ContentBox download, I only kept my server.json. It was stopped when I downloaded ContentBox BE. When it finished downloading, I started my Lucee 4.5 server via CommandBox, filled out the installer forms and produced the error I pasted before.

My MSSQL 2014 database has db_owner and sysadmin roles assigned. The datasource connects OK in Lucee Admin. I cannot find anything not configured correctly…hit me with things to check.

For what its worth, I also tried the embedded DB and it errors out saying: Error creating DSN: Access is denied Is that a Windows permissions error on the directory? I’m not sure what CommandBox is running as. My windows account login is an Administrator account, so assuming CommandBox uses the User account that is logged in, it should have permission to access the directory.

Was the be structure created? Did it have data in it?

This is the dump of the arguments sent to the createRoles method in the InstallerService.cfc - it is passing in setup - and it appears to NOT have any data in it. I filled out the installer forms entirely. I don’t know if this helps. I don’t know what the “be” structure is.

Scope Arguments
setup 1
Component (modules.contentbox-installer.models.Setup)
Only the functions and data members that are accessible from your location are displayed

Properties
firstName
Empty:null

lastName
Empty:null

email
Empty:null

username
Empty:null

password
Empty:null

populateData
boolean true

siteName
Empty:null

siteEmail
Empty:null

siteOutgoingEmail
Empty:null

siteTagLine
Empty:null

siteDescription
string

siteKeywords
string

fullrewrite
boolean true

rewrite_engine
string mod_rewrite

cb_site_mail_server
string

cb_site_mail_username
string

cb_site_mail_password
string

cb_site_mail_smtp
string 25

cb_site_mail_tls
string false

cb_site_mail_ssl
string false

I also dumped right before the error occurs, in BaseORMService.cfc, the saveAll function, line 759:

Scope Arguments
entities 1
Array
Rows: 43

forceInsert 2
boolean false

flush 3
boolean false

transactional 4
boolean false

Jim, I think Luis meant to say “DB” as in “database”. He’s asking of the database tables (structure) was created and whether data was inserted into those tables. That tells us if ORM fired up correctly.

Thanks!

~Brad

ColdBox/CommandBox Developer Advocate
Ortus Solutions, Corp

E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com

Wow, there ARE tables with data in them. I will get rid of them, and try the install again. There hadn’t been anything in there before, so something worked better than before.