Exception in onRequest

The action home:csiCategories.detail failed.

Error Executing Database Query.


Query Of Queries runtime error.
The select column reference [aliasURL] is not a column in any of the tables of the FROM table list. (Database)

Exception - struct
Cause
Exception - struct
ErrorCode 0
Message <br><b>Query Of Queries runtime error.</b><br> The select column reference [aliasURL] is not a column in any of the tables of the FROM table list.
StackTrace coldfusion.sql.imq.imqException: <br><b>Query Of Queries runtime error.</b><br> The select column reference [aliasURL] is not a column in any of the tables of the FROM table list. at coldfusion.sql.imq.rttExprColumnref.validate(rttExprColumnref.java:181) at coldfusion.sql.imq.ExprColumn.validate(ExprColumn.java:153) at coldfusion.sql.imq.SelectColumnList.validate(SelectColumnList.java:173) at coldfusion.sql.imq.rttSelectExprSpec.validate(rttSelectExprSpec.java:518) at coldfusion.sql.imq.rttSelectStmt.validate(rttSelectStmt.java:84) at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:548) at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:141) at coldfusion.sql.imq.jdbcPreparedStatement.execute(jdbcPreparedStatement.java:122) at coldfusion.sql.Executive.executeQuery(Executive.java:1467) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:411) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688) at cfcsiCategories2ecfc31501705$funcBUILDMENUITEM.runFunction(C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc:78) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2620) at cfcsiCategories2ecfc31501705$funcBUILDMENUARRAY.runFunction(C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc:57) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2428) at cfdetail2ecfm2100903676.runPage(C:\home\jccmilwaukee.org\htdocs\home\views\csiCategories\detail.cfm:62) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795) at cffw12ecfc292485017$funcINTERNALVIEW.runFunction(C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc:1542) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655) at cffw12ecfc292485017$funcONREQUEST.runFunction(C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc:549) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:300) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:426) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:763) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:351) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:214) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:800) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748)
Suppressed
Exception - array [empty]
TagContext
Exception - array
1
Exception - struct
COLUMN 0
ID CFQUERY
LINE 78
RAW_TRACE at cfcsiCategories2ecfc31501705$funcBUILDMENUITEM.runFunction(C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc:78)
TEMPLATE C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc
TYPE CFML
2
Exception - struct
COLUMN 0
ID CF_UDFMETHOD
LINE 57
RAW_TRACE at cfcsiCategories2ecfc31501705$funcBUILDMENUARRAY.runFunction(C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc:57)
TEMPLATE C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc
TYPE CFML
3
Exception - struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 62
RAW_TRACE at cfdetail2ecfm2100903676.runPage(C:\home\jccmilwaukee.org\htdocs\home\views\csiCategories\detail.cfm:62)
TEMPLATE C:\home\jccmilwaukee.org\htdocs\home\views\csiCategories\detail.cfm
TYPE CFML
4
Exception - struct
COLUMN 0
ID CFINCLUDE
LINE 1542
RAW_TRACE at cffw12ecfc292485017$funcINTERNALVIEW.runFunction(C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc:1542)
TEMPLATE C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc
TYPE CFML
5
Exception - struct
COLUMN 0
ID CF_UDFMETHOD
LINE 549
RAW_TRACE at cffw12ecfc292485017$funcONREQUEST.runFunction(C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc:549)
TEMPLATE C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc
TYPE CFML
Type coldfusion.sql.imq.imqException
Detail <br><b>Query Of Queries runtime error.</b><br> The select column reference [aliasURL] is not a column in any of the tables of the FROM table list.
ErrorCode n/a
Exceptions
Exception - array
1
Exception - struct
class coldfusion.sql.imq.imqException
message <br><b>Query Of Queries runtime error.</b><br> The select column reference [aliasURL] is not a column in any of the tables of the FROM table list.
Message Error Executing Database Query.
NativeErrorCode 0
RootCause
Exception - struct
ErrorCode 0
Message <br><b>Query Of Queries runtime error.</b><br> The select column reference [aliasURL] is not a column in any of the tables of the FROM table list.
StackTrace coldfusion.sql.imq.imqException: <br><b>Query Of Queries runtime error.</b><br> The select column reference [aliasURL] is not a column in any of the tables of the FROM table list. at coldfusion.sql.imq.rttExprColumnref.validate(rttExprColumnref.java:181) at coldfusion.sql.imq.ExprColumn.validate(ExprColumn.java:153) at coldfusion.sql.imq.SelectColumnList.validate(SelectColumnList.java:173) at coldfusion.sql.imq.rttSelectExprSpec.validate(rttSelectExprSpec.java:518) at coldfusion.sql.imq.rttSelectStmt.validate(rttSelectStmt.java:84) at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:548) at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:141) at coldfusion.sql.imq.jdbcPreparedStatement.execute(jdbcPreparedStatement.java:122) at coldfusion.sql.Executive.executeQuery(Executive.java:1467) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:411) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688) at cfcsiCategories2ecfc31501705$funcBUILDMENUITEM.runFunction(C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc:78) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2620) at cfcsiCategories2ecfc31501705$funcBUILDMENUARRAY.runFunction(C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc:57) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2428) at cfdetail2ecfm2100903676.runPage(C:\home\jccmilwaukee.org\htdocs\home\views\csiCategories\detail.cfm:62) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795) at cffw12ecfc292485017$funcINTERNALVIEW.runFunction(C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc:1542) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655) at cffw12ecfc292485017$funcONREQUEST.runFunction(C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc:549) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:300) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:426) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:763) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:351) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:214) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:800) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748)
Suppressed
Exception - array [empty]
TagContext
Exception - array
1
Exception - struct
COLUMN 0
ID CFQUERY
LINE 78
RAW_TRACE at cfcsiCategories2ecfc31501705$funcBUILDMENUITEM.runFunction(C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc:78)
TEMPLATE C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc
TYPE CFML
2
Exception - struct
COLUMN 0
ID CF_UDFMETHOD
LINE 57
RAW_TRACE at cfcsiCategories2ecfc31501705$funcBUILDMENUARRAY.runFunction(C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc:57)
TEMPLATE C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc
TYPE CFML
3
Exception - struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 62
RAW_TRACE at cfdetail2ecfm2100903676.runPage(C:\home\jccmilwaukee.org\htdocs\home\views\csiCategories\detail.cfm:62)
TEMPLATE C:\home\jccmilwaukee.org\htdocs\home\views\csiCategories\detail.cfm
TYPE CFML
4
Exception - struct
COLUMN 0
ID CFINCLUDE
LINE 1542
RAW_TRACE at cffw12ecfc292485017$funcINTERNALVIEW.runFunction(C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc:1542)
TEMPLATE C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc
TYPE CFML
5
Exception - struct
COLUMN 0
ID CF_UDFMETHOD
LINE 549
RAW_TRACE at cffw12ecfc292485017$funcONREQUEST.runFunction(C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc:549)
TEMPLATE C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc
TYPE CFML
Type coldfusion.sql.imq.imqException
SQLState n/a
Sql SELECT id,parentID,title name,orderBy,link,aliasURL url FROM arguments.query WHERE parentID= (param 1) ORDER BY orderBy
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:739) at cfcsiCategories2ecfc31501705$funcBUILDMENUITEM.runFunction(C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc:78) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2620) at cfcsiCategories2ecfc31501705$funcBUILDMENUARRAY.runFunction(C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc:57) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2428) at cfdetail2ecfm2100903676.runPage(C:\home\jccmilwaukee.org\htdocs\home\views\csiCategories\detail.cfm:62) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795) at cffw12ecfc292485017$funcINTERNALVIEW.runFunction(C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc:1542) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655) at cffw12ecfc292485017$funcONREQUEST.runFunction(C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc:549) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:300) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:426) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at sun.reflect.GeneratedMethodAccessor59.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:763) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:351) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:214) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:800) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: coldfusion.sql.imq.imqException: <br><b>Query Of Queries runtime error.</b><br> The select column reference [aliasURL] is not a column in any of the tables of the FROM table list. at coldfusion.sql.imq.rttExprColumnref.validate(rttExprColumnref.java:181) at coldfusion.sql.imq.ExprColumn.validate(ExprColumn.java:153) at coldfusion.sql.imq.SelectColumnList.validate(SelectColumnList.java:173) at coldfusion.sql.imq.rttSelectExprSpec.validate(rttSelectExprSpec.java:518) at coldfusion.sql.imq.rttSelectStmt.validate(rttSelectStmt.java:84) at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:548) at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:141) at coldfusion.sql.imq.jdbcPreparedStatement.execute(jdbcPreparedStatement.java:122) at coldfusion.sql.Executive.executeQuery(Executive.java:1467) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:411) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688) ... 99 more
Suppressed
Exception - array [empty]
TagContext
Exception - array
1
Exception - struct
COLUMN 0
ID CFQUERY
LINE 78
RAW_TRACE at cfcsiCategories2ecfc31501705$funcBUILDMENUITEM.runFunction(C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc:78)
TEMPLATE C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc
TYPE CFML
2
Exception - struct
COLUMN 0
ID CF_UDFMETHOD
LINE 57
RAW_TRACE at cfcsiCategories2ecfc31501705$funcBUILDMENUARRAY.runFunction(C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc:57)
TEMPLATE C:\home\jccmilwaukee.org\htdocs\model\csiCategories.cfc
TYPE CFML
3
Exception - struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 62
RAW_TRACE at cfdetail2ecfm2100903676.runPage(C:\home\jccmilwaukee.org\htdocs\home\views\csiCategories\detail.cfm:62)
TEMPLATE C:\home\jccmilwaukee.org\htdocs\home\views\csiCategories\detail.cfm
TYPE CFML
4
Exception - struct
COLUMN 0
ID CFINCLUDE
LINE 1542
RAW_TRACE at cffw12ecfc292485017$funcINTERNALVIEW.runFunction(C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc:1542)
TEMPLATE C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc
TYPE CFML
5
Exception - struct
COLUMN 0
ID CF_UDFMETHOD
LINE 549
RAW_TRACE at cffw12ecfc292485017$funcONREQUEST.runFunction(C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc:549)
TEMPLATE C:\home\jccmilwaukee.org\htdocs\includes\com\fw1\fw1.cfc
TYPE CFML
Type Database
queryError <br><b>Query Of Queries runtime error.</b><br> The select column reference [aliasURL] is not a column in any of the tables of the FROM table list.
where (param 1) = [type='IN', class='java.lang.Integer', value='2', sqltype='cf_sql_integer']