exception
Catch
Entries: 16
additional
Struct (ordered)
SQL
stringSELECT count(memberID) AS total FROM this_profileStruct_qHotList WHERE dateAdded >= {d '2026-05-22'}
Cause
Catch
additional
Struct (ordered)
Detail
stringJava type of the object is java.lang.String
ErrNumber
number0
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringCan't cast String [] to a value of type [query]
StackTrace
stringlucee.runtime.exp.CasterException: Can't cast String [] to a value of type [query] at lucee.runtime.op.Caster.toQuery(Caster.java:3297) at lucee.runtime.db.HSQLDBHandler.createTable(HSQLDBHandler.java:112) at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:590) at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544) at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532) at lucee.runtime.tag.Query.executeQoQ(Query.java:1101) at lucee.runtime.tag.Query._doEndTag(Query.java:673) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at components.ajaxproxy.profile_main_cfm$cf.udfCall(/components/ajaxproxy/profile_main.cfm:20) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:732) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:604) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2129) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2113) at showprofile_cfm$cf.call_000009(/showprofile.cfm:324) at showprofile_cfm$cf.call(/showprofile.cfm:324) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1118) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:215) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2816) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2803) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2774) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1113) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1070) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:42) at javax.servlet.http.HttpServlet.service(HttpServlet.java:590) 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:54) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67) 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 runwar.undertow.SSLCertHeaderHandler.handleRequest(SSLCertHeaderHandler.java:161) at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68) 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.dispatchRequest(ServletInitialHandler.java:252) at io.undertow.servlet.handlers.ServletInitialHandler.dispatchToPath(ServletInitialHandler.java:177) at io.undertow.servlet.spec.RequestDispatcherImpl.forwardImpl(RequestDispatcherImpl.java:186) at io.undertow.servlet.spec.RequestDispatcherImpl.forwardImplSetup(RequestDispatcherImpl.java:134) at io.undertow.servlet.spec.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:97) at org.cfmlprojects.regexpathinfofilter.RegexPathInfoFilter.doFilter(RegexPathInfoFilter.java:52) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67) 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 runwar.undertow.SSLCertHeaderHandler.handleRequest(SSLCertHeaderHandler.java:161) at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68) at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117) 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:75) at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:270) at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78) at io.undertow.servlet.handlers.ServletInitialHandler$1.call(ServletInitialHandler.java:129) at io.undertow.servlet.handlers.ServletInitialHandler$1.call(ServletInitialHandler.java:126) 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:250) at io.undertow.servlet.handlers.ServletInitialHandler.handleRequest(ServletInitialHandler.java:170) at io.undertow.server.handlers.HttpContinueReadHandler.handleRequest(HttpContinueReadHandler.java:69) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at runwar.undertow.WelcomeFileHandler.handleRequest(WelcomeFileHandler.java:49) at io.undertow.server.handlers.PathHandler.handleRequest(PathHandler.java:104) at runwar.undertow.SiteDeployment$1.handleRequest(SiteDeployment.java:169) at io.undertow.predicate.PredicatesHandler.handleRequest(PredicatesHandler.java:141) at io.undertow.predicate.PredicatesHandler.handleRequest(PredicatesHandler.java:141) at io.undertow.predicate.PredicatesHandler.handleRequest(PredicatesHandler.java:113) at io.undertow.server.handlers.encoding.EncodingHandler.handleRequest(EncodingHandler.java:72) at io.undertow.server.handlers.ProxyPeerAddressHandler.handleRequest(ProxyPeerAddressHandler.java:129) at runwar.undertow.LifecyleHandler.handleRequest(LifecyleHandler.java:145) at runwar.undertow.SiteDeployment$4.handleRequest(SiteDeployment.java:360) at io.undertow.server.Connectors.executeRootHandler(Connectors.java:395) at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:893) at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18) at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513) at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538) at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
1
Struct
codePrintHTML
string18: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;this.profileStruct.qHotList<br> 19: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;dateAdded&nbsp;&gt;=&nbsp;&lt;CFQUERYPARAM&nbsp;VALUE=&quot;#dateAdd('d',&nbsp;-30,&nbsp;now())#&quot;&nbsp;CFSQLTYPE=&quot;CF_SQL_DATE&quot;&gt;<br> <b>20: &nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 21: <br> 22: &nbsp;&nbsp;&nbsp;&lt;cfquery&nbsp;name=&quot;local.qResponses&quot;&nbsp;dbtype=&quot;query&quot;&gt;<br>
codePrintPlain
string18: FROM this.profileStruct.qHotList 19: WHERE dateAdded >= <CFQUERYPARAM VALUE="#dateAdd('d', -30, now())#" CFSQLTYPE="CF_SQL_DATE"> 20: </cfquery> 21: 22: <cfquery name="local.qResponses" dbtype="query">
column
number0
id
string??
line
number20
Raw_Trace
stringcomponents.ajaxproxy.profile_main_cfm$cf.udfCall(/components/ajaxproxy/profile_main.cfm:20)
template
string/app/app/wwwroot/components/ajaxproxy/profile_main.cfm
type
stringcfml
2
Struct
codePrintHTML
string322: <br> 323: &lt;!---&nbsp;Because&nbsp;we&nbsp;need&nbsp;this&nbsp;content&nbsp;in&nbsp;the&nbsp;header&nbsp;this&nbsp;is&nbsp;executed&nbsp;ahead&nbsp;of&nbsp;time,&nbsp;then&nbsp;output&nbsp;in&nbsp;the&nbsp;body&nbsp;of&nbsp;CFGAPAGENEW&nbsp;---&gt;<br> <b>324: &lt;cfsavecontent&nbsp;variable=&quot;variables.theBodyContent&quot;&gt;&lt;cfoutput&gt;#ajaxProfile.getMain(locatorNumber=URL.locatorID)#&lt;/cfoutput&gt;&lt;/cfsavecontent&gt;</b><br> 325: &lt;!---&nbsp;the&nbsp;above&nbsp;line&nbsp;renders&nbsp;everything&nbsp;in&nbsp;the&nbsp;body&nbsp;of&nbsp;the&nbsp;profile&nbsp;page&nbsp;---&gt;<br> 326: <br>
codePrintPlain
string322: 323: <!--- Because we need this content in the header this is executed ahead of time, then output in the body of CFGAPAGENEW ---> 324: <cfsavecontent variable="variables.theBodyContent"><cfoutput>#ajaxProfile.getMain(locatorNumber=URL.locatorID)#</cfoutput></cfsavecontent> 325: <!--- the above line renders everything in the body of the profile page ---> 326:
column
number0
id
string??
line
number324
Raw_Trace
stringshowprofile_cfm$cf.call_000009(/showprofile.cfm:324)
template
string/app/app/wwwroot/showprofile.cfm
type
stringcfml
3
Struct
codePrintHTML
string322: <br> 323: &lt;!---&nbsp;Because&nbsp;we&nbsp;need&nbsp;this&nbsp;content&nbsp;in&nbsp;the&nbsp;header&nbsp;this&nbsp;is&nbsp;executed&nbsp;ahead&nbsp;of&nbsp;time,&nbsp;then&nbsp;output&nbsp;in&nbsp;the&nbsp;body&nbsp;of&nbsp;CFGAPAGENEW&nbsp;---&gt;<br> <b>324: &lt;cfsavecontent&nbsp;variable=&quot;variables.theBodyContent&quot;&gt;&lt;cfoutput&gt;#ajaxProfile.getMain(locatorNumber=URL.locatorID)#&lt;/cfoutput&gt;&lt;/cfsavecontent&gt;</b><br> 325: &lt;!---&nbsp;the&nbsp;above&nbsp;line&nbsp;renders&nbsp;everything&nbsp;in&nbsp;the&nbsp;body&nbsp;of&nbsp;the&nbsp;profile&nbsp;page&nbsp;---&gt;<br> 326: <br>
codePrintPlain
string322: 323: <!--- Because we need this content in the header this is executed ahead of time, then output in the body of CFGAPAGENEW ---> 324: <cfsavecontent variable="variables.theBodyContent"><cfoutput>#ajaxProfile.getMain(locatorNumber=URL.locatorID)#</cfoutput></cfsavecontent> 325: <!--- the above line renders everything in the body of the profile page ---> 326:
column
number0
id
string??
line
number324
Raw_Trace
stringshowprofile_cfm$cf.call(/showprofile.cfm:324)
template
string/app/app/wwwroot/showprofile.cfm
type
stringcfml
type
stringexpression
DataSource
string
Detail
stringCan't cast String [] to a value of type [query]
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringQoQ HSQLDB: error executing sql statement on query.
NativeErrorCode
number-1
queryError
stringSELECT count(memberID) AS total FROM this_profileStruct_qHotList WHERE dateAdded >= {d '2026-05-22'}
Sql
stringSELECT count(memberID) AS total FROM this_profileStruct_qHotList WHERE dateAdded >= {d '2026-05-22'}
SQLState
string
StackTrace
stringlucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query. at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:642) at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544) at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532) at lucee.runtime.tag.Query.executeQoQ(Query.java:1101) at lucee.runtime.tag.Query._doEndTag(Query.java:673) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at components.ajaxproxy.profile_main_cfm$cf.udfCall(/components/ajaxproxy/profile_main.cfm:20) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:732) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:604) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2129) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2113) at showprofile_cfm$cf.call_000009(/showprofile.cfm:324) at showprofile_cfm$cf.call(/showprofile.cfm:324) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1118) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:215) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2816) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2803) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2774) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1113) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1070) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:42) at javax.servlet.http.HttpServlet.service(HttpServlet.java:590) 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:54) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67) 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 runwar.undertow.SSLCertHeaderHandler.handleRequest(SSLCertHeaderHandler.java:161) at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68) 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.dispatchRequest(ServletInitialHandler.java:252) at io.undertow.servlet.handlers.ServletInitialHandler.dispatchToPath(ServletInitialHandler.java:177) at io.undertow.servlet.spec.RequestDispatcherImpl.forwardImpl(RequestDispatcherImpl.java:186) at io.undertow.servlet.spec.RequestDispatcherImpl.forwardImplSetup(RequestDispatcherImpl.java:134) at io.undertow.servlet.spec.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:97) at org.cfmlprojects.regexpathinfofilter.RegexPathInfoFilter.doFilter(RegexPathInfoFilter.java:52) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67) 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 runwar.undertow.SSLCertHeaderHandler.handleRequest(SSLCertHeaderHandler.java:161) at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68) at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117) 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:75) at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:270) at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78) at io.undertow.servlet.handlers.ServletInitialHandler$1.call(ServletInitialHandler.java:129) at io.undertow.servlet.handlers.ServletInitialHandler$1.call(ServletInitialHandler.java:126) 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:250) at io.undertow.servlet.handlers.ServletInitialHandler.handleRequest(ServletInitialHandler.java:170) at io.undertow.server.handlers.HttpContinueReadHandler.handleRequest(HttpContinueReadHandler.java:69) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at runwar.undertow.WelcomeFileHandler.handleRequest(WelcomeFileHandler.java:49) at io.undertow.server.handlers.PathHandler.handleRequest(PathHandler.java:104) at runwar.undertow.SiteDeployment$1.handleRequest(SiteDeployment.java:169) at io.undertow.predicate.PredicatesHandler.handleRequest(PredicatesHandler.java:141) at io.undertow.predicate.PredicatesHandler.handleRequest(PredicatesHandler.java:141) at io.undertow.predicate.PredicatesHandler.handleRequest(PredicatesHandler.java:113) at io.undertow.server.handlers.encoding.EncodingHandler.handleRequest(EncodingHandler.java:72) at io.undertow.server.handlers.ProxyPeerAddressHandler.handleRequest(ProxyPeerAddressHandler.java:129) at runwar.undertow.LifecyleHandler.handleRequest(LifecyleHandler.java:145) at runwar.undertow.SiteDeployment$4.handleRequest(SiteDeployment.java:360) at io.undertow.server.Connectors.executeRootHandler(Connectors.java:395) at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:893) at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18) at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513) at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538) at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282) at java.base/java.lang.Thread.run(Unknown Source) Caused by: lucee.runtime.exp.CasterException: Can't cast String [] to a value of type [query] at lucee.runtime.op.Caster.toQuery(Caster.java:3297) at lucee.runtime.db.HSQLDBHandler.createTable(HSQLDBHandler.java:112) at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:590) ... 94 more
TagContext
Array
1
Struct
codePrintHTML
string18: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;this.profileStruct.qHotList<br> 19: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;dateAdded&nbsp;&gt;=&nbsp;&lt;CFQUERYPARAM&nbsp;VALUE=&quot;#dateAdd('d',&nbsp;-30,&nbsp;now())#&quot;&nbsp;CFSQLTYPE=&quot;CF_SQL_DATE&quot;&gt;<br> <b>20: &nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 21: <br> 22: &nbsp;&nbsp;&nbsp;&lt;cfquery&nbsp;name=&quot;local.qResponses&quot;&nbsp;dbtype=&quot;query&quot;&gt;<br>
codePrintPlain
string18: FROM this.profileStruct.qHotList 19: WHERE dateAdded >= <CFQUERYPARAM VALUE="#dateAdd('d', -30, now())#" CFSQLTYPE="CF_SQL_DATE"> 20: </cfquery> 21: 22: <cfquery name="local.qResponses" dbtype="query">
column
number0
id
string??
line
number20
Raw_Trace
stringcomponents.ajaxproxy.profile_main_cfm$cf.udfCall(/components/ajaxproxy/profile_main.cfm:20)
template
string/app/app/wwwroot/components/ajaxproxy/profile_main.cfm
type
stringcfml
2
Struct
codePrintHTML
string322: <br> 323: &lt;!---&nbsp;Because&nbsp;we&nbsp;need&nbsp;this&nbsp;content&nbsp;in&nbsp;the&nbsp;header&nbsp;this&nbsp;is&nbsp;executed&nbsp;ahead&nbsp;of&nbsp;time,&nbsp;then&nbsp;output&nbsp;in&nbsp;the&nbsp;body&nbsp;of&nbsp;CFGAPAGENEW&nbsp;---&gt;<br> <b>324: &lt;cfsavecontent&nbsp;variable=&quot;variables.theBodyContent&quot;&gt;&lt;cfoutput&gt;#ajaxProfile.getMain(locatorNumber=URL.locatorID)#&lt;/cfoutput&gt;&lt;/cfsavecontent&gt;</b><br> 325: &lt;!---&nbsp;the&nbsp;above&nbsp;line&nbsp;renders&nbsp;everything&nbsp;in&nbsp;the&nbsp;body&nbsp;of&nbsp;the&nbsp;profile&nbsp;page&nbsp;---&gt;<br> 326: <br>
codePrintPlain
string322: 323: <!--- Because we need this content in the header this is executed ahead of time, then output in the body of CFGAPAGENEW ---> 324: <cfsavecontent variable="variables.theBodyContent"><cfoutput>#ajaxProfile.getMain(locatorNumber=URL.locatorID)#</cfoutput></cfsavecontent> 325: <!--- the above line renders everything in the body of the profile page ---> 326:
column
number0
id
string??
line
number324
Raw_Trace
stringshowprofile_cfm$cf.call_000009(/showprofile.cfm:324)
template
string/app/app/wwwroot/showprofile.cfm
type
stringcfml
3
Struct
codePrintHTML
string322: <br> 323: &lt;!---&nbsp;Because&nbsp;we&nbsp;need&nbsp;this&nbsp;content&nbsp;in&nbsp;the&nbsp;header&nbsp;this&nbsp;is&nbsp;executed&nbsp;ahead&nbsp;of&nbsp;time,&nbsp;then&nbsp;output&nbsp;in&nbsp;the&nbsp;body&nbsp;of&nbsp;CFGAPAGENEW&nbsp;---&gt;<br> <b>324: &lt;cfsavecontent&nbsp;variable=&quot;variables.theBodyContent&quot;&gt;&lt;cfoutput&gt;#ajaxProfile.getMain(locatorNumber=URL.locatorID)#&lt;/cfoutput&gt;&lt;/cfsavecontent&gt;</b><br> 325: &lt;!---&nbsp;the&nbsp;above&nbsp;line&nbsp;renders&nbsp;everything&nbsp;in&nbsp;the&nbsp;body&nbsp;of&nbsp;the&nbsp;profile&nbsp;page&nbsp;---&gt;<br> 326: <br>
codePrintPlain
string322: 323: <!--- Because we need this content in the header this is executed ahead of time, then output in the body of CFGAPAGENEW ---> 324: <cfsavecontent variable="variables.theBodyContent"><cfoutput>#ajaxProfile.getMain(locatorNumber=URL.locatorID)#</cfoutput></cfsavecontent> 325: <!--- the above line renders everything in the body of the profile page ---> 326:
column
number0
id
string??
line
number324
Raw_Trace
stringshowprofile_cfm$cf.call(/showprofile.cfm:324)
template
string/app/app/wwwroot/showprofile.cfm
type
stringcfml
type
stringdatabase
where
string
eventname
string
CGI
CGI Scope
Entries: 47
auth_password
string
auth_type
string
auth_user
string
cert_cookie
string
cert_flags
string
cert_issuer
string
cert_keysize
string
cert_secretkeysize
string
cert_serialnumber
string
cert_server_issuer
string
cert_server_subject
string
cert_subject
string
cf_template_path
string/app/app/wwwroot/showprofile.cfm
content_length
string
content_type
string
context_path
string
gateway_interface
string
http_accept
string*/*
http_accept_encoding
stringgzip, br
http_accept_language
string
http_connection
stringupgrade
http_cookie
string
http_host
stringstg.greataupair.com
http_referer
string
http_user_agent
stringMozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
https
stringon
https_keysize
string
https_secretkeysize
string
https_server_issuer
string
https_server_subject
string
local_addr
string172.18.0.3
local_host
string43623b848512
path_info
string/locatorID/3744487/type/nanny
path_translated
string/app/app/wwwroot/showprofile.cfm
query_string
string
remote_addr
string216.73.216.158
remote_host
string216.73.216.158
remote_user
string
request_method
stringGET
request_url
stringhttps://stg.greataupair.com/showprofile.cfm
script_name
string/showprofile.cfm
server_name
stringstg.greataupair.com
server_port
string443
server_port_secure
string1
server_protocol
stringHTTP/1.1
server_software
string
web_server_api
string