Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

Table 'fftoolbox_sql.2024DraftResults' doesn't exist
 
The error occurred in /var/www/html/nfl_draft/nfl-draft-history.cfm: line 21
Called from /var/www/html/nfl_draft/nfl-draft-history.cfm: line 1
Called from /var/www/html/nfl_draft/nfl-draft-history.cfm: line 1
Called from /var/www/html/nfl_draft/nfl-draft-history.cfm: line 21
Called from /var/www/html/nfl_draft/nfl-draft-history.cfm: line 1
Called from /var/www/html/nfl_draft/nfl-draft-history.cfm: line 1
19 : 	<cfquery name="GetTeamPicks" datasource="fftoolbox_sql" dbtype="ODBC" cachedwithin="#CreateTimeSpan(0,1,0,0)#">
20 : 	<!--- added this loop so this won't have to be changed year to year. --->	
21 : 	<cfloop from="#year(Now())#" to="2007" step="-1" index="i">
22 : 		SELECT  '#i#' AS draftYear, round_num, pick_num, player, prospect_id
23 : 		FROM #i#DraftResults

SQLSTATE   42S02
DATASOURCE   fftoolbox_sql
VENDORERRORCODE   1146
SQL    SELECT '2024' AS draftYear, round_num, pick_num, player, prospect_id FROM 2024DraftResults WHERE nfl_team = (param 1) and player like '%, TE,%' UNION SELECT '2023' AS draftYear, round_num, pick_num, player, prospect_id FROM 2023DraftResults WHERE nfl_team = (param 2) and player like '%, TE,%' UNION SELECT '2022' AS draftYear, round_num, pick_num, player, prospect_id FROM 2022DraftResults WHERE nfl_team = (param 3) and player like '%, TE,%' UNION SELECT '2021' AS draftYear, round_num, pick_num, player, prospect_id FROM 2021DraftResults WHERE nfl_team = (param 4) and player like '%, TE,%' UNION SELECT '2020' AS draftYear, round_num, pick_num, player, prospect_id FROM 2020DraftResults WHERE nfl_team = (param 5) and player like '%, TE,%' UNION SELECT '2019' AS draftYear, round_num, pick_num, player, prospect_id FROM 2019DraftResults WHERE nfl_team = (param 6) and player like '%, TE,%' UNION SELECT '2018' AS draftYear, round_num, pick_num, player, prospect_id FROM 2018DraftResults WHERE nfl_team = (param 7) and player like '%, TE,%' UNION SELECT '2017' AS draftYear, round_num, pick_num, player, prospect_id FROM 2017DraftResults WHERE nfl_team = (param 8) and player like '%, TE,%' UNION SELECT '2016' AS draftYear, round_num, pick_num, player, prospect_id FROM 2016DraftResults WHERE nfl_team = (param 9) and player like '%, TE,%' UNION SELECT '2015' AS draftYear, round_num, pick_num, player, prospect_id FROM 2015DraftResults WHERE nfl_team = (param 10) and player like '%, TE,%' UNION SELECT '2014' AS draftYear, round_num, pick_num, player, prospect_id FROM 2014DraftResults WHERE nfl_team = (param 11) and player like '%, TE,%' UNION SELECT '2013' AS draftYear, round_num, pick_num, player, prospect_id FROM 2013DraftResults WHERE nfl_team = (param 12) and player like '%, TE,%' UNION SELECT '2012' AS draftYear, round_num, pick_num, player, prospect_id FROM 2012DraftResults WHERE nfl_team = (param 13) and player like '%, TE,%' UNION SELECT '2011' AS draftYear, round_num, pick_num, player, prospect_id FROM 2011DraftResults WHERE nfl_team = (param 14) and player like '%, TE,%' UNION SELECT '2010' AS draftYear, round_num, pick_num, player, prospect_id FROM 2010DraftResults WHERE nfl_team = (param 15) and player like '%, TE,%' UNION SELECT '2009' AS draftYear, round_num, pick_num, player, prospect_id FROM 2009DraftResults WHERE nfl_team = (param 16) and player like '%, TE,%' UNION SELECT '2008' AS draftYear, round_num, pick_num, player, prospect_id FROM 2008DraftResults WHERE nfl_team = (param 17) and player like '%, TE,%' UNION SELECT '2007' AS draftYear, round_num, pick_num, player, prospect_id FROM 2007DraftResults WHERE nfl_team = (param 18) and player like '%, TE,%' ORDER BY draftYear DESC, round_num, pick_num
Resources:

Browser   claudebot
Remote Address   34.237.245.80
Referrer   http://fftoolbox.com/nfl_draft/nfl-draft-history.cfm?team=JAX&pos=TE
Date/Time   18-Mar-24 10:12 PM
Stack Trace
at cfnfl2ddraft2dhistory2ecfm1958848723._factor1(/var/www/html/nfl_draft/nfl-draft-history.cfm:21) at cfnfl2ddraft2dhistory2ecfm1958848723._factor11(/var/www/html/nfl_draft/nfl-draft-history.cfm:1) at cfnfl2ddraft2dhistory2ecfm1958848723.runPage(/var/www/html/nfl_draft/nfl-draft-history.cfm:1) at cfnfl2ddraft2dhistory2ecfm1958848723._factor1(/var/www/html/nfl_draft/nfl-draft-history.cfm:21) at cfnfl2ddraft2dhistory2ecfm1958848723._factor11(/var/www/html/nfl_draft/nfl-draft-history.cfm:1) at cfnfl2ddraft2dhistory2ecfm1958848723.runPage(/var/www/html/nfl_draft/nfl-draft-history.cfm:1)

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'fftoolbox_sql.2024DraftResults' doesn't exist
	at sun.reflect.GeneratedConstructorAccessor162.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
	at com.mysql.jdbc.Util.getInstance(Util.java:372)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2535)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1911)
	at com.mysql.jdbc.PreparedStatement.$fr$execute(PreparedStatement.java:1203)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1501)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
	at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1121)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:808)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
	at cfnfl2ddraft2dhistory2ecfm1958848723._factor1(/var/www/html/nfl_draft/nfl-draft-history.cfm:21)
	at cfnfl2ddraft2dhistory2ecfm1958848723._factor11(/var/www/html/nfl_draft/nfl-draft-history.cfm:1)
	at cfnfl2ddraft2dhistory2ecfm1958848723.runPage(/var/www/html/nfl_draft/nfl-draft-history.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
	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 sun.reflect.GeneratedMethodAccessor46.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:483)
	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.handle(FusionReactorRequestHandler.java:792)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
	at sun.reflect.GeneratedMethodAccessor50.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:483)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
	at sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:483)
	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.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:745)