POOL SERVICE INQUIRIES
Need service for your pool?

Please fill out our service form below and we will contact you as soon as possible to set-up and confirm a scheduled appointment for you!

* = Required
Name *
Email *
Phone Number *
Address *
City *
Postal Code *
Preferred Date of Service *
Type of Service? *
Please provide us the details of your service needs. *


Enter above value to submit form
used to stop form spam

I approve Halton Pools N Spas to send me correspondence through email regarding their promotions, products & services


 



More online client services than any other Pool/Spa Dealer

Discover Now
x

Join our VIP Insider Program

As a member of our VIP insider program you will receive monthly savings coupons, vouchers and exclusive insider promotions.
We'll also keep you up to date on exclusive rebate offers!

No thanks, I'm not interested in saving money on my chemicals and select accessories.

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 'smtp'.
 
The error occurred in C:/home/haltonpoolsnspas.com/config/triggers.cfm: line 434
Called from C:/home/haltonpoolsnspas.com/config/triggers.cfm: line 1
Called from C:/home/haltonpoolsnspas.com/config/footer1.cfm: line 103
Called from C:/home/haltonpoolsnspas.com/forms/index.cfm: line 252
Called from C:/home/haltonpoolsnspas.com/config/triggers.cfm: line 434
Called from C:/home/haltonpoolsnspas.com/config/triggers.cfm: line 1
Called from C:/home/haltonpoolsnspas.com/config/footer1.cfm: line 103
Called from C:/home/haltonpoolsnspas.com/forms/index.cfm: line 252
 
432 : 	where desktopmail IS NULL
433 : </cfquery>								
434 : <cfquery datasource="#dbdatasource#" username="#dbusername#" password="#dbpassword#" name="getSystemEmail">
435 : 	select coremail, desktopmail, smtp, smtpusername, smtppassword, smtpport, smtpssl, smtptsl, signature
436 : 	from ARM_settings
SQLSTATE   42S22
DATASOURCE   halton
VENDORERRORCODE   207
SQL    select coremail, desktopmail, smtp, smtpusername, smtppassword, smtpport, smtpssl, smtptsl, signature from ARM_settings
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   3.236.8.46
Referrer  
Date/Time   09-Jul-20 06:58 PM
Stack Trace
at cftriggers2ecfm1941773943._factor26(C:/home/haltonpoolsnspas.com/config/triggers.cfm:434) at cftriggers2ecfm1941773943.runPage(C:/home/haltonpoolsnspas.com/config/triggers.cfm:1) at cffooter12ecfm282398221.runPage(C:/home/haltonpoolsnspas.com/config/footer1.cfm:103) at cfindex2ecfm882863527.runPage(C:/home/haltonpoolsnspas.com/forms/index.cfm:252) at cftriggers2ecfm1941773943._factor26(C:/home/haltonpoolsnspas.com/config/triggers.cfm:434) at cftriggers2ecfm1941773943.runPage(C:/home/haltonpoolsnspas.com/config/triggers.cfm:1) at cffooter12ecfm282398221.runPage(C:/home/haltonpoolsnspas.com/config/footer1.cfm:103) at cfindex2ecfm882863527.runPage(C:/home/haltonpoolsnspas.com/forms/index.cfm:252) 

java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'smtp'.
	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:1537)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
	at cftriggers2ecfm1941773943._factor26(C:\home\haltonpoolsnspas.com\config\triggers.cfm:434)
	at cftriggers2ecfm1941773943.runPage(C:\home\haltonpoolsnspas.com\config\triggers.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
	at cffooter12ecfm282398221.runPage(C:\home\haltonpoolsnspas.com\config\footer1.cfm:103)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
	at cfindex2ecfm882863527.runPage(C:\home\haltonpoolsnspas.com\forms\index.cfm:252)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	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:223)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	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:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	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:52)
	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:200)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:356)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:544)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)