Hi to all,
trying to play around little with contenbox (contenbox-installer). I could set everything up to work last week, but today I just wanted to try a fresh and clean setup: I am facing the following exception after submitting datasource inside the contentbox welcome page. I’ve deleted my User/.CommandBox several times, also the webroots where I was starting the server from. But now I am facing always this error during setup:
Error building: SettingService@cb -> could not execute query
Using: Windows10
CommandBox 5.0.1+00137 (Windows JRE-64)
Engine Running: Default Engine: Lucee 5.3.4.80
DB: MariaDB 10.4.10.0
How to reproduce:
- Downloaded commandBox JRE 64bit and unzip it to c:\box\ + added environment path to system
- created working-directory: d:\workspace_contentbox
- CMD => cd to d:\workspace_contentbox> box.exe
after commandbox unpacked everything into c:\user\myuser.CommandBox\ - workspace_contentbox>install contentbox-installer
- in terminal entered from the same workspace_contentbox=> server start (Default Lucee starts running)
- Went to lucees server admin, but have to create C:\Users\claud_000.CommandBox\server{hash}-server\lucee-5.3.4.80\WEB-INF\lucee-server\context\password.txt, what I sucessfully did.
- Ceated an empty database “contentbox” in mariaDB via HeidiSQL and setup a dsn “contenbox”, which is verified as “OK”
- Setup Application.cfc dialect as mentioned (uncommented presetting for mysqlinnodb)
- Loaded the website through tray icon “site home”
- At welcome site on DSN I clicked “yes” and continued
Then I am faced with the following stack trace.:
Lucee 5.3.4.80 Error (Builder.BuildCFCDependencyException)
Message Error building: SettingService@cb -> could not execute query
.
Detail DSL: , Path: contentbox.models.system.SettingService,
Error Location:
D:\workspace_contentbox\modules\contentbox\modules\contentbox-deps\modules\cborm\models\CriteriaBuilder.cfc:254
D:\workspace_contentbox\modules\contentbox\models\system\SettingService.cfc:693
D:\workspace_contentbox\modules\contentbox\models\system\SettingService.cfc:247
Stacktrace The Error Occurred in
D:\workspace_contentbox\coldbox\system\ioc\Builder.cfc: line 180
178: detail = "DSL: #thisMap.getDSL()#, Path: #thisMap.getPath()#,
179: Error Location:
180: #reducedTagContext#"
181: );
182: }
called from D:\workspace_contentbox\coldbox\system\ioc\Injector.cfc: line 402
400: switch( thisMap.getType() ){
401: case “cfc” : {
402: oModel = variables.builder.buildCFC( thisMap, arguments.initArguments );
403: break;
404: }
called from D:\workspace_contentbox\coldbox\system\ioc\scopes\Singleton.cfc: line 70
68:
69: // construct the singleton object
70: var tmpSingleton = variables.injector.buildInstance( arguments.mapping, arguments.initArguments);
71:
72: // If not in wiring thread safety, store in singleton cache to satisfy circular dependencies
called from D:\workspace_contentbox\coldbox\system\ioc\Injector.cfc: line 370
368: var target = variables
369: .scopes[ mapping.getScope() ]
370: .getFromScope( mapping, arguments.initArguments );
371:
372: // Announce creation, initialization and DI magicfinicitation!
called from D:\workspace_contentbox\coldbox\system\ioc\Builder.cfc: line 614
612: if( variables.injector.containsInstance( modelName ) ){
613: // Get Model object
614: var oModel = variables.injector.getInstance( modelName );
615: // Factories: TODO: Add arguments with ‘ref()’ parsing for argument references or ‘dsl()’
616: if( len( methodCall ) ){
called from D:\workspace_contentbox\coldbox\system\ioc\Builder.cfc: line 436
434: // WireBox Internal DSL for models and id
435: case “model” : case “id” : {
436: refLocal.dependency = getModelDSL( argumentCollection=arguments );
437: break;
438: }
called from D:\workspace_contentbox\coldbox\system\ioc\Injector.cfc: line 897
895: definition = thisDIData,
896: targetID = arguments.targetID,
897: targetObject = arguments.targetObject
898: );
899: }
called from D:\workspace_contentbox\coldbox\system\ioc\Injector.cfc: line 653
651: }
652: // DIProperty injection
653: processInjection( targetObject, thisMap.getDIProperties(), arguments.targetID );
654: // DISetter injection
655: processInjection( targetObject, thisMap.getDISetters(), arguments.targetID );
called from D:\workspace_contentbox\coldbox\system\ioc\scopes\Singleton.cfc: line 78
76:
77: // wire up dependencies on the singleton object
78: variables.injector.autowire( target=tmpSingleton, mapping=arguments.mapping );
79:
80: // If thread safe, then now store it in the singleton cache, as all dependencies are now safely wired
called from D:\workspace_contentbox\coldbox\system\ioc\Injector.cfc: line 370
368: var target = variables
369: .scopes[ mapping.getScope() ]
370: .getFromScope( mapping, arguments.initArguments );
371:
372: // Announce creation, initialization and DI magicfinicitation!
called from D:\workspace_contentbox\coldbox\system\web\services\InterceptorService.cfc: line 350
348: */
349: function getInterceptor( required interceptorName ){
350: return variables.wirebox.getInstance( “interceptor-” & arguments.interceptorName );
351: }
352:
called from D:\workspace_contentbox\coldbox\system\web\services\InterceptorService.cfc: line 341
339:
340: // retrieve, build and wire from wirebox
341: return getInterceptor( arguments.interceptorName );
342: }
343:
called from D:\workspace_contentbox\coldbox\system\web\services\InterceptorService.cfc: line 275
273: // Create the Interceptor Class
274: try{
275: oInterceptor = createInterceptor( interceptorClass, objectName, interceptorProperties );
276: } catch( Any e ){
277: variables.log.error( “Error creating interceptor: #arguments.interceptorClass#. #e.detail# #e.message# #e.stackTrace#”, e.tagContext );
called from D:\workspace_contentbox\coldbox\system\web\services\ModuleService.cfc: line 573
571: interceptorProperties = thisInterceptor.properties,
572: interceptorName = thisInterceptor.name & “@” & moduleName
573: );
574: } );
575:
called from D:\workspace_contentbox\coldbox\system\web\services\ModuleService.cfc: line 574
572: interceptorName = thisInterceptor.name & “@” & moduleName
573: );
574: } );
575:
576: // Register module routing entry point pre-pended to routes
called from D:\workspace_contentbox\coldbox\system\web\services\ModuleService.cfc: line 441
439: var sTime = getTickCount();
440:
441: this.activateModule( moduleName );
442:
443: if( variables.logger.canDebug() ){
called from D:\workspace_contentbox\coldbox\system\web\services\LoaderService.cfc: line 59
57: }
58: // Activate All Modules
59: controller.getModuleService().activateAllModules();
60: // Flag the initiation, Framework is ready to serve requests. Praise be to GOD.
61: controller.setColdboxInitiated( true );
called from D:\workspace_contentbox\coldbox\system\Bootstrap.cfc: line 98
96: application[ appKey ] = new coldbox.system.web.Controller( COLDBOX_APP_ROOT_PATH, appKey );
97: // Setup the Framework And Application
98: application[ appKey ].getLoaderService().loadApplication( COLDBOX_CONFIG_FILE, COLDBOX_APP_MAPPING );
99: // Application Start Handler
100: try {
called from D:\workspace_contentbox\Application.cfc: line 85
83: setting requestTimeout=“300”;
84: application.cbBootstrap = new coldbox.system.Bootstrap( COLDBOX_CONFIG_FILE, COLDBOX_APP_ROOT_PATH, COLDBOX_APP_KEY, COLDBOX_APP_MAPPING );
85: application.cbBootstrap.loadColdbox();
86: return true;
87: }
called from D:\workspace_contentbox\Application.cfc: line 137
135: private void function reinitApplication(){
136: //Run onAppStart
137: onApplicationStart();
138: }
139:
called from D:\workspace_contentbox\Application.cfc: line 97
95: !structKeyExists( application, “cbController” )
96: ){
97: reinitApplication();
98: }
99:
Java Stacktrace lucee.runtime.exp.CustomTypeException: Error building: SettingService@cb -> could not execute query
.
at lucee.runtime.tag.Throw._doStartTag(Throw.java:212)
at lucee.runtime.tag.Throw.doStartTag(Throw.java:201)
at throw_cfm$cf.udfCall(/throw.cfm:11)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:205)
at lucee.runtime.functions.system.CFFunction.call(CFFunction.java:109)
at system.ioc.builder_cfc$cf.udfCall1(/coldbox/system/ioc/Builder.cfc:180)
at system.ioc.builder_cfc$cf.udfCall(/coldbox/system/ioc/Builder.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:680)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at system.ioc.injector_cfc$cf.udfCall1(/coldbox/system/ioc/Injector.cfc:402)
at system.ioc.injector_cfc$cf.udfCall(/coldbox/system/ioc/Injector.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:680)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at system.ioc.scopes.singleton_cfc$cf.udfCall(/coldbox/system/ioc/scopes/Singleton.cfc:70)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:680)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at system.ioc.injector_cfc$cf.udfCall1(/coldbox/system/ioc/Injector.cfc:370)
at system.ioc.injector_cfc$cf.udfCall(/coldbox/system/ioc/Injector.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:680)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at system.ioc.builder_cfc$cf.udfCall2(/coldbox/system/ioc/Builder.cfc:614)
at system.ioc.builder_cfc$cf.udfCall(/coldbox/system/ioc/Builder.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:205)
at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:792)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1728)
at system.ioc.builder_cfc$cf.udfCall2(/coldbox/system/ioc/Builder.cfc:436)
at system.ioc.builder_cfc$cf.udfCall(/coldbox/system/ioc/Builder.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:205)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:681)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1917)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1728)
at system.ioc.injector_cfc$cf.udfCall3(/coldbox/system/ioc/Injector.cfc:897)
at system.ioc.injector_cfc$cf.udfCall(/coldbox/system/ioc/Injector.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:779)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at system.ioc.injector_cfc$cf.udfCall1(/coldbox/system/ioc/Injector.cfc:653)
at system.ioc.injector_cfc$cf.udfCall(/coldbox/system/ioc/Injector.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:205)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:681)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1917)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1728)
at system.ioc.scopes.singleton_cfc$cf.udfCall(/coldbox/system/ioc/scopes/Singleton.cfc:78)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:680)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at system.ioc.injector_cfc$cf.udfCall1(/coldbox/system/ioc/Injector.cfc:370)
at system.ioc.injector_cfc$cf.udfCall(/coldbox/system/ioc/Injector.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:680)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at system.web.services.interceptorservice_cfc$cf.udfCall2(/coldbox/system/web/services/InterceptorService.cfc:350)
at system.web.services.interceptorservice_cfc$cf.udfCall(/coldbox/system/web/services/InterceptorService.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:779)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at system.web.services.interceptorservice_cfc$cf.udfCall2(/coldbox/system/web/services/InterceptorService.cfc:341)
at system.web.services.interceptorservice_cfc$cf.udfCall(/coldbox/system/web/services/InterceptorService.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:779)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at system.web.services.interceptorservice_cfc$cf.udfCall2(/coldbox/system/web/services/InterceptorService.cfc:275)
at system.web.services.interceptorservice_cfc$cf.udfCall(/coldbox/system/web/services/InterceptorService.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:205)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:681)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1917)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1728)
at system.web.services.moduleservice_cfc$cf.udfCall2(/coldbox/system/web/services/ModuleService.cfc:573)
at system.web.services.moduleservice_cfc$cf.udfCall(/coldbox/system/web/services/ModuleService.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:210)
at lucee.runtime.type.EnvUDF.call(EnvUDF.java:109)
at lucee.runtime.functions.closure.Each._call(Each.java:214)
at lucee.runtime.functions.closure.Each.invoke(Each.java:170)
at lucee.runtime.functions.closure.Each._call(Each.java:89)
at lucee.runtime.functions.closure.Each.call(Each.java:66)
at lucee.runtime.functions.arrays.ArrayEach._call(ArrayEach.java:51)
at lucee.runtime.functions.arrays.ArrayEach.call(ArrayEach.java:38)
at lucee.runtime.functions.arrays.ArrayEach.invoke(ArrayEach.java:67)
at lucee.runtime.interpreter.ref.func.BIFCall.getValue(BIFCall.java:134)
at lucee.runtime.type.util.MemberUtil.call(MemberUtil.java:117)
at lucee.runtime.type.util.ArraySupport.call(ArraySupport.java:322)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at system.web.services.moduleservice_cfc$cf.udfCall2(/coldbox/system/web/services/ModuleService.cfc:574)
at system.web.services.moduleservice_cfc$cf.udfCall(/coldbox/system/web/services/ModuleService.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:680)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at system.web.services.moduleservice_cfc$cf.udfCall2(/coldbox/system/web/services/ModuleService.cfc:441)
at system.web.services.moduleservice_cfc$cf.udfCall(/coldbox/system/web/services/ModuleService.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:680)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at system.web.services.loaderservice_cfc$cf.udfCall(/coldbox/system/web/services/LoaderService.cfc:59)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:680)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at coldbox.system.bootstrap_cfc$cf.udfCall1(/coldbox/system/Bootstrap.cfc:98)
at coldbox.system.bootstrap_cfc$cf.udfCall(/coldbox/system/Bootstrap.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:680)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at application_cfc$cf.udfCall(/Application.cfc:85)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:779)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at application_cfc$cf.udfCall(/Application.cfc:137)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:779)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at application_cfc$cf.udfCall(/Application.cfc:97)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:680)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:436)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:132)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:42)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2415)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2405)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2380)
at lucee.runtime.engine.Request.exe(Request.java:43)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1110)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1056)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:791)
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
at org.cfmlprojects.regexpathinfofilter.RegexPathInfoFilter.doFilter(RegexPathInfoFilter.java:47)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269)
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130)
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249)
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78)
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99)
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:376)
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Timestamp 4/8/20 12:32:30 PM CEST
Tried doing the same by starting Adobe CF Engine with
server start cfengine=adobe
Received also the following error there:
# Error in executing the DDL.
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘type=InnoDB’ at line 1Other Errors :
Stacktrace:
Remote Address 127.0.0.1
Referrer
Date/Time 08-Apr-20 01:15 PM
Stack Trace
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:525)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:470)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.createTable(AbstractSchemaMigrator.java:273)
at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:71)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:203)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:110)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:87)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:58)
at coldfusion.orm.hibernate.HibernateConfiguration.exportSchema(HibernateConfiguration.java:441)
at coldfusion.orm.hibernate.HibernateConfiguration.exportSchema(HibernateConfiguration.java:399)
at coldfusion.orm.hibernate.HibernateProvider.initializeORMForApplication(HibernateProvider.java:163)
at coldfusion.orm.hibernate.HibernateProvider.beforeApplicationStart(HibernateProvider.java:72)
at coldfusion.filter.ApplicationFilter.fireBeforeAppStartEvent(ApplicationFilter.java:803)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:415)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:226)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.cfmlprojects.regexpathinfofilter.RegexPathInfoFilter.doFilter(RegexPathInfoFilter.java:47)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269)
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130)
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249)
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78)
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99)
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:376)
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘type=InnoDB’ at line 1
at jdk.internal.reflect.GeneratedConstructorAccessor105.newInstance(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265)
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
… 65 more
Looks like some old JDBC Driver? Or am I missing a setting? Googled around, but couldn’t find anything related. Hint and answers are very welcome and appreciated.