CUSTOMER CONCERNS
Our customer service experts are here to listen! 

Fill out your comments below and we will be more than happy to assist you. One of our service representatives will get back to you as soon as possible.

* = Required
Name *
Email *
Phone (Optional)
Inquiry or comment *


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/footer2.cfm: line 20
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/footer2.cfm: line 20
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 ( 11357, 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.188.175.182
Referrer  
Date/Time   18-Apr-24 03:25 AM
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 cffooter22ecfm961944481.runPage(C:/home/huroniapools.com/config/footer2.cfm:20) 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 cffooter22ecfm961944481.runPage(C:/home/huroniapools.com/config/footer2.cfm:20) 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 cffooter22ecfm961944481.runPage(C:\home\huroniapools.com\config\footer2.cfm:20)
	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)