Accept Cookies?
Provided by OpenGlobal E-commerce

X Close

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]Invalid column name 'newsDate'.

The error occurred in C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm: line 971
Called from C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm: line 967
Called from C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm: line 954
Called from C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm: line 949
Called from C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm: line 913
Called from C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm: line 1
Called from C:/home/icr-world.com/wwwroot/Website/pub/index.cfm: line 57
Called from C:/home/icr-world.com/wwwroot/Website/pub/index.cfm: line 42
Called from C:/home/icr-world.com/wwwroot/Website/pub/index.cfm: line 11
Called from C:/home/icr-world.com/wwwroot/Website/pub/index.cfm: line 1
Called from C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm: line 971
Called from C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm: line 967
Called from C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm: line 954
Called from C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm: line 949
Called from C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm: line 913
Called from C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm: line 1
Called from C:/home/icr-world.com/wwwroot/Website/pub/index.cfm: line 57
Called from C:/home/icr-world.com/wwwroot/Website/pub/index.cfm: line 42
Called from C:/home/icr-world.com/wwwroot/Website/pub/index.cfm: line 11
Called from C:/home/icr-world.com/wwwroot/Website/pub/index.cfm: line 1

969 : 															<cfif navLink EQ "news-archive">
970 : 										
971 : 																<cfquery name="getLatestNews" datasource="#application.datasource#" maxrows="1">
972 : 																	SELECT  IM_navigation.navLink
973 : 																	FROM    IM_news INNER JOIN

SQLSTATE	42S22
DATASOURCE	investAberdeen2019
VENDORERRORCODE	207
SQL	SELECT IM_navigation.navLink FROM IM_news INNER JOIN IM_navigation ON IM_news.navID = IM_navigation.ID WHERE IM_news.archived = 1 AND IM_navigation.newsStory = 1 ORDER BY IM_news.newsDate DESC

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address	35.168.111.191
Referrer
Date/Time	29-Jan-20 01:07 PM

Stack Trace

at cfheader2ecfm1882506658._factor22(C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm:971) at cfheader2ecfm1882506658._factor23(C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm:967) at cfheader2ecfm1882506658._factor24(C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm:954) at cfheader2ecfm1882506658._factor25(C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm:949) at cfheader2ecfm1882506658._factor27(C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm:913) at cfheader2ecfm1882506658.runPage(C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm:1) at cfindex2ecfm1029446262._factor0(C:/home/icr-world.com/wwwroot/Website/pub/index.cfm:57) at cfindex2ecfm1029446262._factor9(C:/home/icr-world.com/wwwroot/Website/pub/index.cfm:42) at cfindex2ecfm1029446262._factor10(C:/home/icr-world.com/wwwroot/Website/pub/index.cfm:11) at cfindex2ecfm1029446262.runPage(C:/home/icr-world.com/wwwroot/Website/pub/index.cfm:1) at cfheader2ecfm1882506658._factor22(C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm:971) at cfheader2ecfm1882506658._factor23(C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm:967) at cfheader2ecfm1882506658._factor24(C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm:954) at cfheader2ecfm1882506658._factor25(C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm:949) at cfheader2ecfm1882506658._factor27(C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm:913) at cfheader2ecfm1882506658.runPage(C:/home/icr-world.com/wwwroot/Website/priv/inc/header.cfm:1) at cfindex2ecfm1029446262._factor0(C:/home/icr-world.com/wwwroot/Website/pub/index.cfm:57) at cfindex2ecfm1029446262._factor9(C:/home/icr-world.com/wwwroot/Website/pub/index.cfm:42) at cfindex2ecfm1029446262._factor10(C:/home/icr-world.com/wwwroot/Website/pub/index.cfm:11) at cfindex2ecfm1029446262.runPage(C:/home/icr-world.com/wwwroot/Website/pub/index.cfm:1)

java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'newsDate'.
	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.ddm.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddm.x(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddm.d(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddn.a(Unknown Source)
	at macromedia.jdbc.sqlserver.dda4.h(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1567)
	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 cfheader2ecfm1882506658._factor22(C:\home\icr-world.com\wwwroot\Website\priv\inc\header.cfm:971)
	at cfheader2ecfm1882506658._factor23(C:\home\icr-world.com\wwwroot\Website\priv\inc\header.cfm:967)
	at cfheader2ecfm1882506658._factor24(C:\home\icr-world.com\wwwroot\Website\priv\inc\header.cfm:954)
	at cfheader2ecfm1882506658._factor25(C:\home\icr-world.com\wwwroot\Website\priv\inc\header.cfm:949)
	at cfheader2ecfm1882506658._factor27(C:\home\icr-world.com\wwwroot\Website\priv\inc\header.cfm:913)
	at cfheader2ecfm1882506658.runPage(C:\home\icr-world.com\wwwroot\Website\priv\inc\header.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:4286)
	at cfindex2ecfm1029446262._factor0(C:\home\icr-world.com\wwwroot\Website\pub\index.cfm:57)
	at cfindex2ecfm1029446262._factor9(C:\home\icr-world.com\wwwroot\Website\pub\index.cfm:42)
	at cfindex2ecfm1029446262._factor10(C:\home\icr-world.com\wwwroot\Website\pub\index.cfm:11)
	at cfindex2ecfm1029446262.runPage(C:\home\icr-world.com\wwwroot\Website\pub\index.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.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:557)
	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.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:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	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:193)
	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:202)
	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.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:422)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:844)