Need a quote or have an inquiry regarding an In-Ground pool?
Tell us a little bit about what you are looking for so we can better assist you!
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 'lockCustomTax'.
The error occurred in C:/web/prestigepools.ca/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 22 Called from C:/web/prestigepools.ca/config/triggers.cfm: line 819 Called from C:/web/prestigepools.ca/config/triggers.cfm: line 1 Called from C:/web/prestigepools.ca/config/footer1.cfm: line 41 Called from C:/web/prestigepools.ca/forms/index.cfm: line 273 Called from C:/web/prestigepools.ca/forms/index.cfm: line 269 Called from |SQLServer|6.0.0.1282|: line 1085 Called from |SQLServer|6.0.0.1282|: line 980 Called from |SQLServer|6.0.0.1282|: line 1124 Called from |SQLServer|6.0.0.1282|: line 193 Called from |SQLServer|6.0.0.1282|: line 1153 Called from |SQLServer|6.0.0.1282|: line 4126 Called from |SQLServer|6.0.0.1282|: line 4275 Called from |SQLServer|6.0.0.1282|: line 2032 Called from |SQLServer|6.0.0.1282|: line 632 Called from |SQLServer|6.0.0.1282|: line 2699 Called from |SQLServer|6.0.0.1282|: line 2508 Called from |SQLServer|6.0.0.1282|: line 1358 Called from |SQLServer|6.0.0.1282|: line 4478 Called from |SQLServer|6.0.0.1282|: line 1085 Called from |SQLServer|6.0.0.1282|: line 980 Called from |SQLServer|6.0.0.1282|: line 1124 Called from |SQLServer|6.0.0.1282|: line 193 Called from |SQLServer|6.0.0.1282|: line 1153 Called from |SQLServer|6.0.0.1282|: line 4126 Called from |SQLServer|6.0.0.1282|: line 4275 Called from |SQLServer|6.0.0.1282|: line 2032 Called from |SQLServer|6.0.0.1282|: line 632 Called from |SQLServer|6.0.0.1282|: line 2699 Called from |SQLServer|6.0.0.1282|: line 2508 Called from |SQLServer|6.0.0.1282|: line 1358 Called from |SQLServer|6.0.0.1282|: line 4478 Called from C:/web/prestigepools.ca/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 22 Called from C:/web/prestigepools.ca/config/triggers.cfm: line 819 Called from C:/web/prestigepools.ca/config/triggers.cfm: line 1 Called from C:/web/prestigepools.ca/config/footer1.cfm: line 41 Called from C:/web/prestigepools.ca/forms/index.cfm: line 273 Called from C:/web/prestigepools.ca/forms/index.cfm: line 269
20 : where taxlock3 IS NULL
21 : </cfquery>
22 : <cfquery datasource="#dbdatasource#" username="#dbusername#" password="#dbpassword#">
23 : update POS_Transactions
24 : set lockCustomTax = 0
SQLSTATE
42S22
EXCEPTIONS
<small><i>not set</i></small>
DATASOURCE
prestigepoolsca14
VENDORERRORCODE
207
SQL
update POS_Transactions
set lockCustomTax = 0
where lockCustomTax IS NULL
Search the Knowledge Base to find a solution to your problem.
Browser
CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address
18.97.9.169
Referrer
Date/Time
04-Dec-25 06:56 PM
Stack Trace
at cfact_repeatMaintenance2ecfm575727203.runPage(C:/web/prestigepools.ca/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:22) at cftriggers2ecfm1468319563._factor47(C:/web/prestigepools.ca/config/triggers.cfm:819) at cftriggers2ecfm1468319563.runPage(C:/web/prestigepools.ca/config/triggers.cfm:1) at cffooter12ecfm2057436030.runPage(C:/web/prestigepools.ca/config/footer1.cfm:41) at cfindex2ecfm1041806148._factor8(C:/web/prestigepools.ca/forms/index.cfm:273) at cfindex2ecfm1041806148.runPage(C:/web/prestigepools.ca/forms/index.cfm:269) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1085) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2032) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1085) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2032) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at cfact_repeatMaintenance2ecfm575727203.runPage(C:/web/prestigepools.ca/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:22) at cftriggers2ecfm1468319563._factor47(C:/web/prestigepools.ca/config/triggers.cfm:819) at cftriggers2ecfm1468319563.runPage(C:/web/prestigepools.ca/config/triggers.cfm:1) at cffooter12ecfm2057436030.runPage(C:/web/prestigepools.ca/config/footer1.cfm:41) at cfindex2ecfm1041806148._factor8(C:/web/prestigepools.ca/forms/index.cfm:273) at cfindex2ecfm1041806148.runPage(C:/web/prestigepools.ca/forms/index.cfm:269)
java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'lockCustomTax'.
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1085)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2032)
at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1649)
at coldfusion.sql.Executive.executeQuery(Executive.java:1391)
at coldfusion.sql.Executive.executeQuery(Executive.java:1321)
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_repeatMaintenance2ecfm575727203.runPage(C:\web\prestigepools.ca\secure_html\eMerchant\srvRequest\act_repeatMaintenance.cfm:22)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cftriggers2ecfm1468319563._factor47(C:\web\prestigepools.ca\config\triggers.cfm:819)
at cftriggers2ecfm1468319563.runPage(C:\web\prestigepools.ca\config\triggers.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cffooter12ecfm2057436030.runPage(C:\web\prestigepools.ca\config\footer1.cfm:41)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:5083)
at cfindex2ecfm1041806148._factor8(C:\web\prestigepools.ca\forms\index.cfm:273)
at cfindex2ecfm1041806148.runPage(C:\web\prestigepools.ca\forms\index.cfm:269)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
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:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
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:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
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:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Thread.java:833)