Library Events

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 '2017'.
 
The error occurred in C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/xp_GetEvents.cfm: line 405
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/inc_ek_vars.cfm: line 134
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/b/baldwin/ek.cfm: line 698
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/xp_GetEvents.cfm: line 405
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/inc_ek_vars.cfm: line 134
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/b/baldwin/ek.cfm: line 698
403 : 	
404 : 	<!--- add sort by EvtName for SanDiego 4.2.3 --->
405 : 	ORDER BY EvtDateTimeBegin<CFIF curOrder EQ 'desc'> DESC</CFIF>, EvtDateTimeEnd, EvtName
406 :     
407 : </cfquery>     

SQLSTATE   HY000
DATASOURCE   dsn_EK_1395
VENDORERRORCODE   102
SQL    SELECT EvtID, EvtIconName, EvtName, EvtNameForCal, EvtDateTimeBegin, EvtDateTimeEnd, EvtTimeBeginExists, EvtTimeEndExists, EvtPostStatus, EvtKeyword1, EvtDescription, EvtEditorNotes, EvtOrg, EvtContactName, EvtContactPhone, EvtContactEmail, EvtLocationText, EvtUrlText,EvtUrl,EvtNameColor, EvtDynaFormID, EvtListDisplay FROM events WITH (NOLOCK) WHERE 24=24 AND EvtOrg = 'BALDWIN' AND ((evtKeyword1 is null) OR (evtKeyword1 NOT LIKE '~%')) AND ((evtKeyword2 is null) OR (evtKeyword2 NOT LIKE '~%')) AND (EvtDateTimeEnd >= '{ts '2017-05-11 00:00:00'}') AND ( DatePart(mm,EvtDateTimeBegin) = '1,5' OR DatePart(mm,EvtDateTimeEnd) = '1,5' OR ( DatePart(mm,EvtDateTimeBegin) <1,5 AND DatePart(mm,EvtDateTimeEnd) > 1,5 ) ) AND DatePart(yy,EvtDateTimeBegin) = '2017,2017' AND ((EvtPostStatus = 'SHOW') OR (EvtPostStatus = 'PUBLIC')) and 125=125 AND ((EvtListDisplay IS NULL) OR ((EvtListDisplay <> 'HIDE') AND (EvtListDisplay <> 'BUSY'))) ORDER BY EvtDateTimeBegin, EvtDateTimeEnd, EvtName
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.81.230.32
Referrer  
Date/Time   24-Apr-17 06:45 PM
Stack Trace
at cfxp_GetEvents2ecfm1469197816.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/xp_GetEvents.cfm:405) at cfinc_ek_vars2ecfm1486535562.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/inc_ek_vars.cfm:134) at cfek2ecfm1511310447.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/b/baldwin/ek.cfm:698) at cfxp_GetEvents2ecfm1469197816.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/xp_GetEvents.cfm:405) at cfinc_ek_vars2ecfm1486535562.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/inc_ek_vars.cfm:134) at cfek2ecfm1511310447.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/b/baldwin/ek.cfm:698)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '2017'.
	at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda3.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.a(Unknown Source)
	at macromedia.jdbc.sqlserver.ddj.l(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source)
	at com.intergral.fusionreactor.jdbc.StatementSurrogate.execute(StatementSurrogate.java:63)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1420)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1183)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1114)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
	at cfxp_GetEvents2ecfm1469197816.runPage(C:\inetpub\wwwroot\clients\plymouthrocket.net\www\mars\incs\xp_GetEvents.cfm:405)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
	at cfinc_ek_vars2ecfm1486535562.runPage(C:\inetpub\wwwroot\clients\plymouthrocket.net\www\mars\incs\inc_ek_vars.cfm:134)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
	at cfek2ecfm1511310447.runPage(C:\inetpub\wwwroot\clients\plymouthrocket.net\www\mars\xpages\b\baldwin\ek.cfm:698)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	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:200)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at sun.reflect.GeneratedMethodAccessor33.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:97)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:472)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:499)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
	at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:79)
	at sun.reflect.GeneratedMethodAccessor31.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:53)
	at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)