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 112
Called from /var/www/html/nfl_draft/nfl-draft-history.cfm: line 109
Called from /var/www/html/nfl_draft/nfl-draft-history.cfm: line 107
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 112
Called from /var/www/html/nfl_draft/nfl-draft-history.cfm: line 109
Called from /var/www/html/nfl_draft/nfl-draft-history.cfm: line 107
Called from /var/www/html/nfl_draft/nfl-draft-history.cfm: line 1
110 : 	<cfquery name="GetTeamPicks" datasource="fftoolbox_sql" dbtype="ODBC" cachedwithin="#CreateTimeSpan(0,1,0,0)#">
111 : 	<!--- added this loop so this won't have to be changed year to year. --->	
112 : 	<cfloop from="#year(Now())#" to="2007" step="-1" index="i">
113 : 		SELECT  '#i#' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team
114 : 		FROM #i#DraftResults

SQLSTATE   42S02
DATASOURCE   fftoolbox_sql
VENDORERRORCODE   1146
SQL    SELECT '2024' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2024DraftResults UNION SELECT '2023' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2023DraftResults UNION SELECT '2022' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2022DraftResults UNION SELECT '2021' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2021DraftResults UNION SELECT '2020' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2020DraftResults UNION SELECT '2019' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2019DraftResults UNION SELECT '2018' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2018DraftResults UNION SELECT '2017' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2017DraftResults UNION SELECT '2016' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2016DraftResults UNION SELECT '2015' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2015DraftResults UNION SELECT '2014' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2014DraftResults UNION SELECT '2013' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2013DraftResults UNION SELECT '2012' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2012DraftResults UNION SELECT '2011' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2011DraftResults UNION SELECT '2010' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2010DraftResults UNION SELECT '2009' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2009DraftResults UNION SELECT '2008' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2008DraftResults UNION SELECT '2007' AS draftYear, round_num, pick_num, player, prospect_id,nfl_team FROM 2007DraftResults ORDER BY nfl_team, draftYear DESC, round_num, pick_num
Resources:

Browser   claudebot
Remote Address   54.226.25.246
Referrer   http://fftoolbox.com/nfl_draft/nfl-draft-history.cfm?sort=te
Date/Time   19-Mar-24 12:01 AM
Stack Trace
at cfnfl2ddraft2dhistory2ecfm1958848723._factor2(/var/www/html/nfl_draft/nfl-draft-history.cfm:112) at cfnfl2ddraft2dhistory2ecfm1958848723._factor10(/var/www/html/nfl_draft/nfl-draft-history.cfm:109) at cfnfl2ddraft2dhistory2ecfm1958848723._factor11(/var/www/html/nfl_draft/nfl-draft-history.cfm:107) at cfnfl2ddraft2dhistory2ecfm1958848723.runPage(/var/www/html/nfl_draft/nfl-draft-history.cfm:1) at cfnfl2ddraft2dhistory2ecfm1958848723._factor2(/var/www/html/nfl_draft/nfl-draft-history.cfm:112) at cfnfl2ddraft2dhistory2ecfm1958848723._factor10(/var/www/html/nfl_draft/nfl-draft-history.cfm:109) at cfnfl2ddraft2dhistory2ecfm1958848723._factor11(/var/www/html/nfl_draft/nfl-draft-history.cfm:107) 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:2531)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2489)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
	at com.mysql.jdbc.StatementImpl.$fr$execute(StatementImpl.java:947)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1485)
	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._factor2(/var/www/html/nfl_draft/nfl-draft-history.cfm:112)
	at cfnfl2ddraft2dhistory2ecfm1958848723._factor10(/var/www/html/nfl_draft/nfl-draft-history.cfm:109)
	at cfnfl2ddraft2dhistory2ecfm1958848723._factor11(/var/www/html/nfl_draft/nfl-draft-history.cfm:107)
	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)