MY ACCOUNT PAY INVOICE

Blog Menu



Archives



Categories






Postings In March 2019

Plan the Perfect Backyard Pool Renovation
March 15/2019
Planning your swimming pool renovation can be a daunting task.  How to do it, who to choose and what exactly to renovate and of course when to do it are all important considerations in planning the perfect swimming po
Read full blog post
Posted in Pool Talk
(0)

Pool Fun for Land Lovers
March 01/2019
Just because there’s a pool does not mean that everyone can or enjoys swimming in it. Not everyone swims, but everyone does love to cool off and play. Fortunately, not every fun pool activity has to involve swimming! We have some great ideas on how
Read full blog post
Posted in Pool Talk
(0)

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/blog/index.cfm: line 226
Called from C:/home/huroniapools.com/blog/index.cfm: line 1
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/blog/index.cfm: line 226
Called from C:/home/huroniapools.com/blog/index.cfm: line 1
 
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 ( 11338, 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   3.133.147.252
Referrer   http://huroniapools.com/blog/index.cfm?themonth=March/2019&querytype=1&id=2
Date/Time   18-Apr-24 01:43 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 cffooter12ecfm960507936.runPage(C:/home/huroniapools.com/config/footer1.cfm:22) at cfindex2ecfm1268093540._factor16(C:/home/huroniapools.com/blog/index.cfm:226) at cfindex2ecfm1268093540.runPage(C:/home/huroniapools.com/blog/index.cfm:1) 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 cfindex2ecfm1268093540._factor16(C:/home/huroniapools.com/blog/index.cfm:226) at cfindex2ecfm1268093540.runPage(C:/home/huroniapools.com/blog/index.cfm:1) 

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 cfindex2ecfm1268093540._factor16(C:\home\huroniapools.com\blog\index.cfm:226)
	at cfindex2ecfm1268093540.runPage(C:\home\huroniapools.com\blog\index.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.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)