Thank you,
Your payment is being processed and a confirmation has been emailed to you.
Close
20/20 Project Management
×

Courses

APM
ECITB
CMI
PeopleCert & APMG
Project Controls
Online Bitesize Modules
All Courses

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 'AND'.
 
The error occurred in C:/home/2020projectmanagement.com/wwwroot/Website/pub/includes/getCourses.cfm: line 37
Called from C:/home/2020projectmanagement.com/wwwroot/Website/priv/inc/courses.cfm: line 71
Called from C:/home/2020projectmanagement.com/wwwroot/Website/priv/views/course-cats.cfm: line 60
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 241
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 168
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 75
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 15
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 1
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/includes/getCourses.cfm: line 37
Called from C:/home/2020projectmanagement.com/wwwroot/Website/priv/inc/courses.cfm: line 71
Called from C:/home/2020projectmanagement.com/wwwroot/Website/priv/views/course-cats.cfm: line 60
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 241
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 168
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 75
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 15
Called from C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm: line 1
 
35 : 						IM_navigation.courseTemplate = 1
36 : 					</cfif>
37 : 				<cfelse>
38 : 					IM_navigation.featured = 1
39 : 				</cfif>
SQLSTATE   HY000
DATASOURCE   2020project
VENDORERRORCODE   156
SQL    SELECT IM_navigation.ID, IM_navigation.navTitle, IM_navigation.navLink, IM_pageContent.image, IM_pageContent.imageFocus, IM_navigation.topID FROM IM_navigation INNER JOIN IM_pageContent ON IM_navigation.ID = IM_pageContent.navID WHERE IM_navigation.topID = AND IM_navigation.active = 1 ORDER BY IM_navigation.navOrder ASC
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   54.198.139.112
Referrer  
Date/Time   08-Dec-21 07:59 PM
Stack Trace
at cfgetCourses2ecfm676455621.runPage(C:/home/2020projectmanagement.com/wwwroot/Website/pub/includes/getCourses.cfm:37) at cfcourses2ecfm876836416.runPage(C:/home/2020projectmanagement.com/wwwroot/Website/priv/inc/courses.cfm:71) at cfcourse2dcats2ecfm1783789508.runPage(C:/home/2020projectmanagement.com/wwwroot/Website/priv/views/course-cats.cfm:60) at cfindex2ecfm17226811._factor2(C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm:241) at cfindex2ecfm17226811._factor3(C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm:168) at cfindex2ecfm17226811._factor10(C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm:75) at cfindex2ecfm17226811._factor11(C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm:15) at cfindex2ecfm17226811.runPage(C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm:1) at cfgetCourses2ecfm676455621.runPage(C:/home/2020projectmanagement.com/wwwroot/Website/pub/includes/getCourses.cfm:37) at cfcourses2ecfm876836416.runPage(C:/home/2020projectmanagement.com/wwwroot/Website/priv/inc/courses.cfm:71) at cfcourse2dcats2ecfm1783789508.runPage(C:/home/2020projectmanagement.com/wwwroot/Website/priv/views/course-cats.cfm:60) at cfindex2ecfm17226811._factor2(C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm:241) at cfindex2ecfm17226811._factor3(C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm:168) at cfindex2ecfm17226811._factor10(C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm:75) at cfindex2ecfm17226811._factor11(C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm:15) at cfindex2ecfm17226811.runPage(C:/home/2020projectmanagement.com/wwwroot/Website/pub/index.cfm:1) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'AND'.
	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.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.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 cfgetCourses2ecfm676455621.runPage(C:\home\2020projectmanagement.com\wwwroot\Website\pub\includes\getCourses.cfm:37)
	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 cfcourses2ecfm876836416.runPage(C:\home\2020projectmanagement.com\wwwroot\Website\priv\inc\courses.cfm:71)
	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 cfcourse2dcats2ecfm1783789508.runPage(C:\home\2020projectmanagement.com\wwwroot\Website\priv\views\course-cats.cfm:60)
	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 cfindex2ecfm17226811._factor2(C:\home\2020projectmanagement.com\wwwroot\Website\pub\index.cfm:241)
	at cfindex2ecfm17226811._factor3(C:\home\2020projectmanagement.com\wwwroot\Website\pub\index.cfm:168)
	at cfindex2ecfm17226811._factor10(C:\home\2020projectmanagement.com\wwwroot\Website\pub\index.cfm:75)
	at cfindex2ecfm17226811._factor11(C:\home\2020projectmanagement.com\wwwroot\Website\pub\index.cfm:15)
	at cfindex2ecfm17226811.runPage(C:\home\2020projectmanagement.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.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: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:451)
	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:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)