My Account Login

Login to your account below to view your purchase history, online service bookings or to download your quotes.
Email

Password

Create Account          Forgot Password         




More online client services than any other Pool/Spa Dealer

Discover Now

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 error occurred in C:/home/clearwaterpools.ca/secure_html/etrack/VE/VEEND.cfm: line 141
Called from C:/home/clearwaterpools.ca/secure_html/etrack/VE/act_runVETask.cfm: line 43
Called from C:/home/clearwaterpools.ca/config/triggers.cfm: line 815
Called from C:/home/clearwaterpools.ca/config/triggers.cfm: line 814
Called from C:/home/clearwaterpools.ca/config/triggers.cfm: line 1
Called from C:/home/clearwaterpools.ca/config/footer2.cfm: line 101
Called from C:/home/clearwaterpools.ca/myaccountlogin.cfm: line 95
Called from C:/home/clearwaterpools.ca/secure_html/etrack/VE/VEEND.cfm: line 141
Called from C:/home/clearwaterpools.ca/secure_html/etrack/VE/act_runVETask.cfm: line 43
Called from C:/home/clearwaterpools.ca/config/triggers.cfm: line 815
Called from C:/home/clearwaterpools.ca/config/triggers.cfm: line 814
Called from C:/home/clearwaterpools.ca/config/triggers.cfm: line 1
Called from C:/home/clearwaterpools.ca/config/footer2.cfm: line 101
Called from C:/home/clearwaterpools.ca/myaccountlogin.cfm: line 95
139 : 					expiry = '3000-01-01',
140 : 					active = 0
141 : 			where id = #VEtasks.couponID#
142 : 		</cfquery>
143 : 	</cfif>

SQLSTATE   HY000
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   clearwater
VENDORERRORCODE   102
SQL   update CM_coupons set publishfrom = '3000-01-01', publishto = '3000-01-01', expiry = '3000-01-01', active = 0 where id =
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   3.226.72.194
Referrer  
Date/Time   24-Jul-24 04:28 PM
Stack Trace
at cfVEEND2ecfm1862785394.runPage(C:/home/clearwaterpools.ca/secure_html/etrack/VE/VEEND.cfm:141) at cfact_runVETask2ecfm69135559.runPage(C:/home/clearwaterpools.ca/secure_html/etrack/VE/act_runVETask.cfm:43) at cftriggers2ecfm179046781._factor36(C:/home/clearwaterpools.ca/config/triggers.cfm:815) at cftriggers2ecfm179046781._factor40(C:/home/clearwaterpools.ca/config/triggers.cfm:814) at cftriggers2ecfm179046781.runPage(C:/home/clearwaterpools.ca/config/triggers.cfm:1) at cffooter22ecfm356460431.runPage(C:/home/clearwaterpools.ca/config/footer2.cfm:101) at cfmyaccountlogin2ecfm1458921432.runPage(C:/home/clearwaterpools.ca/myaccountlogin.cfm:95) at cfVEEND2ecfm1862785394.runPage(C:/home/clearwaterpools.ca/secure_html/etrack/VE/VEEND.cfm:141) at cfact_runVETask2ecfm69135559.runPage(C:/home/clearwaterpools.ca/secure_html/etrack/VE/act_runVETask.cfm:43) at cftriggers2ecfm179046781._factor36(C:/home/clearwaterpools.ca/config/triggers.cfm:815) at cftriggers2ecfm179046781._factor40(C:/home/clearwaterpools.ca/config/triggers.cfm:814) at cftriggers2ecfm179046781.runPage(C:/home/clearwaterpools.ca/config/triggers.cfm:1) at cffooter22ecfm356460431.runPage(C:/home/clearwaterpools.ca/config/footer2.cfm:101) at cfmyaccountlogin2ecfm1458921432.runPage(C:/home/clearwaterpools.ca/myaccountlogin.cfm:95)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '='.
	at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
	at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
	at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124)
	at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273)
	at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1892)
	at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
	at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
	at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
	at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
	at macromedia.jdbc.sqlserverbase.go.execute(BaseStatement.java:4425)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1623)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1365)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1295)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
	at cfVEEND2ecfm1862785394.runPage(C:\home\clearwaterpools.ca\secure_html\etrack\VE\VEEND.cfm:141)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cfact_runVETask2ecfm69135559.runPage(C:\home\clearwaterpools.ca\secure_html\etrack\VE\act_runVETask.cfm:43)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cftriggers2ecfm179046781._factor36(C:\home\clearwaterpools.ca\config\triggers.cfm:815)
	at cftriggers2ecfm179046781._factor40(C:\home\clearwaterpools.ca\config\triggers.cfm:814)
	at cftriggers2ecfm179046781.runPage(C:\home\clearwaterpools.ca\config\triggers.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cffooter22ecfm356460431.runPage(C:\home\clearwaterpools.ca\config\footer2.cfm:101)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cfmyaccountlogin2ecfm1458921432.runPage(C:\home\clearwaterpools.ca\myaccountlogin.cfm:95)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613)
	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:97)
	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:231)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	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:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:373)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:459)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	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:833)