Saving layout

One Moment...

Resetting layout

One Moment...
X

Customise your homepage

default
save
Drag each panel to set your preferred order. Click the eye icon to toggle the visibility of the panel. You can reset the layout by clicking the 'Default' button above.
Slider
Statistics
Introduction
News
On This Day
Social History
Match Centre / League Table
Players / Managers / HOF
The Aberdeen Collection
Squad (Hidden)
Profile / Dark Blue Dons / Wartime Dons
Results / Pittodrie Stadium
RedTV / Milestones
AFC Heritage Trust
main.cfm

main.cfm

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.

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'ORDER'.
 
The error occurred in C:/home/afcheritage.org/wwwroot2023b/website/priv/inc/intro.cfm: line 25
Called from C:/home/afcheritage.org/wwwroot2023b/website/priv/inc/generic_content.cfm: line 54
Called from C:/home/afcheritage.org/wwwroot2023b/website/priv/views/inner.cfm: line 533
Called from C:/home/afcheritage.org/wwwroot2023b/website/priv/views/inner.cfm: line 289
Called from C:/home/afcheritage.org/wwwroot2023b/website/priv/views/inner.cfm: line 1
Called from C:/home/afcheritage.org/wwwroot2023b/website/pub/index.cfm: line 113
Called from C:/home/afcheritage.org/wwwroot2023b/website/priv/inc/intro.cfm: line 25
Called from C:/home/afcheritage.org/wwwroot2023b/website/priv/inc/generic_content.cfm: line 54
Called from C:/home/afcheritage.org/wwwroot2023b/website/priv/views/inner.cfm: line 533
Called from C:/home/afcheritage.org/wwwroot2023b/website/priv/views/inner.cfm: line 289
Called from C:/home/afcheritage.org/wwwroot2023b/website/priv/views/inner.cfm: line 1
Called from C:/home/afcheritage.org/wwwroot2023b/website/pub/index.cfm: line 113
 
23 :     WHERE   IM_navigation.navLink = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#getSafeHTML(whichPage)#">
24 : 			<cfif whichPage NEQ "privacy-and-cookies">
25 :             AND IM_navigation.topID = #getTopLevel.id#
26 : 			</cfif>
27 :     ORDER BY IM_panel_custom_new.panelOrder
SQLSTATE   HY000
DATASOURCE   AFCHT2023-Live
VENDORERRORCODE   156
SQL    SELECT IM_panel_custom_new.panelTitle, IM_panel_custom_new.layout, IM_panel_custom_new.panelContent, IM_panel_custom_new.image, IM_panel_custom_new.imageOpacity, IM_panel_custom_new.imageAlt, IM_panel_custom_new.imageBackgroundColor, IM_navigation.navLink, IM_navigation.navTitle, IM_navigation.id FROM IM_panel_custom_new INNER JOIN IM_navigation ON IM_panel_custom_new.navID = IM_navigation.ID WHERE IM_navigation.navLink = (param 1) AND IM_navigation.topID = ORDER BY IM_panel_custom_new.panelOrder
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   172.70.135.132
Referrer  
Date/Time   28-Nov-23 03:22 PM
Stack Trace
at cfintro2ecfm620134302.runPage(C:/home/afcheritage.org/wwwroot2023b/website/priv/inc/intro.cfm:25) at cfgeneric_content2ecfm2084870117.runPage(C:/home/afcheritage.org/wwwroot2023b/website/priv/inc/generic_content.cfm:54) at cfinner2ecfm551605208._factor16(C:/home/afcheritage.org/wwwroot2023b/website/priv/views/inner.cfm:533) at cfinner2ecfm551605208._factor18(C:/home/afcheritage.org/wwwroot2023b/website/priv/views/inner.cfm:289) at cfinner2ecfm551605208.runPage(C:/home/afcheritage.org/wwwroot2023b/website/priv/views/inner.cfm:1) at cfindex2ecfm1087498419.runPage(C:/home/afcheritage.org/wwwroot2023b/website/pub/index.cfm:113) at cfintro2ecfm620134302.runPage(C:/home/afcheritage.org/wwwroot2023b/website/priv/inc/intro.cfm:25) at cfgeneric_content2ecfm2084870117.runPage(C:/home/afcheritage.org/wwwroot2023b/website/priv/inc/generic_content.cfm:54) at cfinner2ecfm551605208._factor16(C:/home/afcheritage.org/wwwroot2023b/website/priv/views/inner.cfm:533) at cfinner2ecfm551605208._factor18(C:/home/afcheritage.org/wwwroot2023b/website/priv/views/inner.cfm:289) at cfinner2ecfm551605208.runPage(C:/home/afcheritage.org/wwwroot2023b/website/priv/views/inner.cfm:1) at cfindex2ecfm1087498419.runPage(C:/home/afcheritage.org/wwwroot2023b/website/pub/index.cfm:113) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'ORDER'.
	at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1583)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1317)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1247)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794)
	at cfintro2ecfm620134302.runPage(C:\home\afcheritage.org\wwwroot2023b\website\priv\inc\intro.cfm:25)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329)
	at cfgeneric_content2ecfm2084870117.runPage(C:\home\afcheritage.org\wwwroot2023b\website\priv\inc\generic_content.cfm:54)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329)
	at cfinner2ecfm551605208._factor16(C:\home\afcheritage.org\wwwroot2023b\website\priv\views\inner.cfm:533)
	at cfinner2ecfm551605208._factor18(C:\home\afcheritage.org\wwwroot2023b\website\priv\views\inner.cfm:289)
	at cfinner2ecfm551605208.runPage(C:\home\afcheritage.org\wwwroot2023b\website\priv\views\inner.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329)
	at cfindex2ecfm1087498419.runPage(C:\home\afcheritage.org\wwwroot2023b\website\pub\index.cfm:113)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:555)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	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:226)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)