Design My Spa

Welcome to our online design my spa application. You will be able to select model, shell color, cabinet color, cover color and all desired upgrade options to build your dream spa!

Select the spa model you would like to build?

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 'maintenanceContractRepeat'.

The error occurred in C:/home/designerpools.ca/secure_html/EMerchant/srvRequest/act_repeatMaintenance.cfm: line 1
Called from C:/home/designerpools.ca/config/triggers.cfm: line 805
Called from C:/home/designerpools.ca/config/triggers.cfm: line 1
Called from C:/home/designerpools.ca/config/footer1.cfm: line 41
Called from C:/home/designerpools.ca/custom/BuildMySpa/index.cfm: line 180
Called from C:/home/designerpools.ca/secure_html/EMerchant/srvRequest/act_repeatMaintenance.cfm: line 1
Called from C:/home/designerpools.ca/config/triggers.cfm: line 805
Called from C:/home/designerpools.ca/config/triggers.cfm: line 1
Called from C:/home/designerpools.ca/config/footer1.cfm: line 41
Called from C:/home/designerpools.ca/custom/BuildMySpa/index.cfm: line 180

1 : <cfquery datasource="#dbdatasource#" username="#dbusername#" password="#dbpassword#" name="Mainten">
2 : 	update POS_Transactions
3 : 		set maintenanceScheduleAll = 0

SQLSTATE	42S22
EXCEPTIONS	<small><i>not set</i></small>
DATASOURCE	designer
VENDORERRORCODE	207
SQL	update POS_Transactions set maintenanceScheduleAll = 0 where maintenanceContractRepeat IS NOT NULL AND maintenanceScheduleAll IS NULL

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	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address	18.222.121.50
Referrer	http://designerpools.ca/custom/buildmyspa
Date/Time	04-Feb-25 11:04 PM

Stack Trace

at cfact_repeatMaintenance2ecfm546233745.runPage(C:/home/designerpools.ca/secure_html/EMerchant/srvRequest/act_repeatMaintenance.cfm:1) at cftriggers2ecfm1633498371._factor42(C:/home/designerpools.ca/config/triggers.cfm:805) at cftriggers2ecfm1633498371.runPage(C:/home/designerpools.ca/config/triggers.cfm:1) at cffooter12ecfm850990701.runPage(C:/home/designerpools.ca/config/footer1.cfm:41) at cfindex2ecfm1515094989.runPage(C:/home/designerpools.ca/custom/BuildMySpa/index.cfm:180) at cfact_repeatMaintenance2ecfm546233745.runPage(C:/home/designerpools.ca/secure_html/EMerchant/srvRequest/act_repeatMaintenance.cfm:1) at cftriggers2ecfm1633498371._factor42(C:/home/designerpools.ca/config/triggers.cfm:805) at cftriggers2ecfm1633498371.runPage(C:/home/designerpools.ca/config/triggers.cfm:1) at cffooter12ecfm850990701.runPage(C:/home/designerpools.ca/config/footer1.cfm:41) at cfindex2ecfm1515094989.runPage(C:/home/designerpools.ca/custom/BuildMySpa/index.cfm:180)

java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'maintenanceContractRepeat'.
	at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1085)
	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 cfact_repeatMaintenance2ecfm546233745.runPage(C:\home\designerpools.ca\secure_html\EMerchant\srvRequest\act_repeatMaintenance.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 cftriggers2ecfm1633498371._factor42(C:\home\designerpools.ca\config\triggers.cfm:805)
	at cftriggers2ecfm1633498371.runPage(C:\home\designerpools.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 cffooter12ecfm850990701.runPage(C:\home\designerpools.ca\config\footer1.cfm:41)
	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 cfindex2ecfm1515094989.runPage(C:\home\designerpools.ca\custom\BuildMySpa\index.cfm:180)
	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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
	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)