Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT c.*, cst.search_terms, c.link_category_label as category_url FROM categories c LEFT JOIN category_search_terms cst ON c.categoryid = cst.category_id WHERE c.link_category_label = 'nursing' AND cst.search_terms IS NOT NULL AND c.isActive = 1
DataSource
stringaiformedical
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringNo operations allowed after statement closed.
NativeErrorCode
number0
queryError
stringSELECT c.*, cst.search_terms, c.link_category_label as category_url FROM categories c LEFT JOIN category_search_terms cst ON c.categoryid = cst.category_id WHERE c.link_category_label = 'nursing' AND cst.search_terms IS NOT NULL AND c.isActive = 1
Sql
stringSELECT c.*, cst.search_terms, c.link_category_label as category_url FROM categories c LEFT JOIN category_search_terms cst ON c.categoryid = cst.category_id WHERE c.link_category_label = 'nursing' AND cst.search_terms IS NOT NULL AND c.isActive = 1
SQLState
stringS1009
StackTrace
stringlucee.runtime.exp.DatabaseException: No operations allowed after statement closed. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:82) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:353) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:305) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:242) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1128) at lucee.runtime.tag.Query._doEndTag(Query.java:695) at lucee.runtime.tag.Query.doEndTag(Query.java:560) at categories_cfm$cf.call(/categories.cfm:31) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1046) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:921) at application_cfc$cf.udfCall1(/Application.cfc:176) at application_cfc$cf.udfCall(/Application.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:476) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2725) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2712) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2683) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1159) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116) 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:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:668) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:770) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:829)
TagContext
Array
1
Struct
codePrintHTML
string29: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AND&nbsp;cst.search_terms&nbsp;IS&nbsp;NOT&nbsp;NULL<br> 30: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AND&nbsp;c.isActive&nbsp;=&nbsp;1<br> <b>31: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 32: &nbsp;&nbsp;&nbsp;&nbsp;&lt;cfelseif&nbsp;url.category_id&nbsp;gt&nbsp;0&gt;<br> 33: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfquery&nbsp;name=&quot;getCategory&quot;&nbsp;datasource=&quot;aiformedical&quot;&gt;<br>
codePrintPlain
string29: AND cst.search_terms IS NOT NULL 30: AND c.isActive = 1 31: </cfquery> 32: <cfelseif url.category_id gt 0> 33: <cfquery name="getCategory" datasource="aiformedical">
column
number0
id
string??
line
number31
Raw_Trace
stringcategories_cfm$cf.call(/categories.cfm:31)
template
string/web/sites/production/aimedicalcompendium/categories.cfm
type
stringcfml
2
Struct
codePrintHTML
string174: &nbsp;&nbsp;&nbsp;&nbsp;function&nbsp;onRequest(&nbsp;string&nbsp;targetPage&nbsp;)&nbsp;{<br> 175: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;try&nbsp;{<br> <b>176: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;include&nbsp;arguments.targetPage;</b><br> 177: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;catch&nbsp;(any&nbsp;e)&nbsp;{<br> 178: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;writeDump(#application#);<br>
codePrintPlain
string174: function onRequest( string targetPage ) { 175: try { 176: include arguments.targetPage; 177: } catch (any e) { 178: // writeDump(#application#);
column
number0
id
string??
line
number176
Raw_Trace
stringapplication_cfc$cf.udfCall1(/Application.cfc:176)
template
string/web/sites/production/aimedicalcompendium/Application.cfc
type
stringcfml
type
stringdatabase
where
string