POOL RENOVATION QUOTE REQUEST

We have dedicated pool renovation specialists here to serve all your pool renovation needs.

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 *
Mobile
Address *
City *
Postal Code *
Preferred Date of Service *
Please provide us the details of your service needs. *


Enter above value to submit form used to stop form spam

I approve Huronia LeisureScapes to send me correspondence through email regarding their promotions, products & services


 



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/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 174
Called from C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 20
Called from C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 1
Called from C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 1
Called from C:/home/huroniapools.com/config/triggers.cfm: line 838
Called from C:/home/huroniapools.com/config/triggers.cfm: line 1
Called from C:/home/huroniapools.com/config/footer1.cfm: line 22
Called from C:/home/huroniapools.com/forms/index.cfm: line 254
Called from C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 174
Called from C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 20
Called from C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 1
Called from C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 1
Called from C:/home/huroniapools.com/config/triggers.cfm: line 838
Called from C:/home/huroniapools.com/config/triggers.cfm: line 1
Called from C:/home/huroniapools.com/config/footer1.cfm: line 22
Called from C:/home/huroniapools.com/forms/index.cfm: line 254
172 : 						#forceToCWL#,
173 : 						#fake#,
174 : 						#truck#
175 : 
176 : 					)

SQLSTATE   HY000
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   Huronia
VENDORERRORCODE   102
SQL   insert into POS_TransactionItems ( transID, customerACCID, product, qty, price, fullprice, sku, revenuesource, cat, sub, taxable, void, cost, tax1, tax2, tax3, fullTaxAmount, location, inventoryCommitted, TransactionStatus, regprice, itemnote, warranty, taken, forceToCWL, fake, truck ) values ( 10741, 15053, 'Pool and Spa Maintenance + travel', 1, 135.00, 135.0000, 'poolspamaint', 'service', 'pool service', 'Pool and Spa Maintenance', 1, 0, 0, 13, 0, 0, 17.5500, 1, 1, 2, 135.0000, '', 0, 1, , 0, 0 )
Resources:

Browser   claudebot
Remote Address   18.224.32.86
Referrer   http://www.huroniapools.com/forms/index.cfm?id=6
Date/Time   16-Apr-24 03:54 PM
Stack Trace
at cfact_repeatMaintenance2ecfm2016920000._factor8(C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:174) at cfact_repeatMaintenance2ecfm2016920000._factor11(C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:20) at cfact_repeatMaintenance2ecfm2016920000._factor12(C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:1) at cfact_repeatMaintenance2ecfm2016920000.runPage(C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:1) at cftriggers2ecfm1966389557._factor40(C:/home/huroniapools.com/config/triggers.cfm:838) at cftriggers2ecfm1966389557.runPage(C:/home/huroniapools.com/config/triggers.cfm:1) at cffooter12ecfm960507936.runPage(C:/home/huroniapools.com/config/footer1.cfm:22) at cfindex2ecfm1303029829.runPage(C:/home/huroniapools.com/forms/index.cfm:254) at cfact_repeatMaintenance2ecfm2016920000._factor8(C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:174) at cfact_repeatMaintenance2ecfm2016920000._factor11(C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:20) at cfact_repeatMaintenance2ecfm2016920000._factor12(C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:1) at cfact_repeatMaintenance2ecfm2016920000.runPage(C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:1) at cftriggers2ecfm1966389557._factor40(C:/home/huroniapools.com/config/triggers.cfm:838) at cftriggers2ecfm1966389557.runPage(C:/home/huroniapools.com/config/triggers.cfm:1) at cffooter12ecfm960507936.runPage(C:/home/huroniapools.com/config/footer1.cfm:22) at cfindex2ecfm1303029829.runPage(C:/home/huroniapools.com/forms/index.cfm:254)

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 cfact_repeatMaintenance2ecfm2016920000._factor8(C:\home\huroniapools.com\secure_html\eMerchant\srvRequest\act_repeatMaintenance.cfm:174)
	at cfact_repeatMaintenance2ecfm2016920000._factor11(C:\home\huroniapools.com\secure_html\eMerchant\srvRequest\act_repeatMaintenance.cfm:20)
	at cfact_repeatMaintenance2ecfm2016920000._factor12(C:\home\huroniapools.com\secure_html\eMerchant\srvRequest\act_repeatMaintenance.cfm:1)
	at cfact_repeatMaintenance2ecfm2016920000.runPage(C:\home\huroniapools.com\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 cftriggers2ecfm1966389557._factor40(C:\home\huroniapools.com\config\triggers.cfm:838)
	at cftriggers2ecfm1966389557.runPage(C:\home\huroniapools.com\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 cffooter12ecfm960507936.runPage(C:\home\huroniapools.com\config\footer1.cfm:22)
	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 cfindex2ecfm1303029829.runPage(C:\home\huroniapools.com\forms\index.cfm:254)
	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)