MY ACCOUNT PAY INVOICE

Blog Menu



Archives



Categories






Postings In August 2019

Hot Tub Maintenance Schedule
August 15/2019
We know the key to enjoying your hot tub is always having clean, clear, inviting water to soak in. Caring for your hot tub only takes a few minutes each day, but if you do this properly your hot tub water will sparkle every time you soak in it. We’ve put together a simple outline to help you get the
Read full blog post
Posted in Hot Tub Talk
(0)

How to Change Your Pool Filter Sand
August 01/2019
When was the last time you changed the sand in your pool filter? Your pool filter sand is one of those things that only gets changed every so often.  Usually, every 3 or 4 years, because of this it can be easy to forget.Clean sand in your pool filter is a very important part of keeping your poo
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]Cannot create a row of size 8062 which is greater than the allowable maximum row size of 8060.
 
The error occurred in C:/home/bluehorizonpoolsandspas.com/config/triggers.cfm: line 915
Called from C:/home/bluehorizonpoolsandspas.com/config/triggers.cfm: line 1
Called from C:/home/bluehorizonpoolsandspas.com/config/footer1.cfm: line 22
Called from C:/home/bluehorizonpoolsandspas.com/blog/index.cfm: line 226
Called from C:/home/bluehorizonpoolsandspas.com/blog/index.cfm: line 1
Called from C:/home/bluehorizonpoolsandspas.com/config/triggers.cfm: line 915
Called from C:/home/bluehorizonpoolsandspas.com/config/triggers.cfm: line 1
Called from C:/home/bluehorizonpoolsandspas.com/config/footer1.cfm: line 22
Called from C:/home/bluehorizonpoolsandspas.com/blog/index.cfm: line 226
Called from C:/home/bluehorizonpoolsandspas.com/blog/index.cfm: line 1
 
913 : 	update EM_SR_Bookings
914 : 	set ccn = 'xxxx xxxx xxxx xxxx'
915 : 	where (DATEDIFF(day, bookingdate, <CFQUERYPARAM Value="#CreateODBCDateTime(now())#" cfsqltype="CF_SQL_TIMESTAMP">) > 5)
916 : </cfquery>
917 : <cfquery datasource="#dbdatasource#" username="#dbusername#" password="#dbpassword#">
SQLSTATE   HY000
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   BlueHorizonPoolsandSpas08
VENDORERRORCODE   511
SQL   update EM_SR_Bookings set ccn = 'xxxx xxxx xxxx xxxx' where (DATEDIFF(day, bookingdate, (param 1) ) > 5)
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   3.235.226.14
Referrer  
Date/Time   08-Sep-24 10:59 PM
Stack Trace
at cftriggers2ecfm1613175086._factor41(C:/home/bluehorizonpoolsandspas.com/config/triggers.cfm:915) at cftriggers2ecfm1613175086.runPage(C:/home/bluehorizonpoolsandspas.com/config/triggers.cfm:1) at cffooter12ecfm118178727.runPage(C:/home/bluehorizonpoolsandspas.com/config/footer1.cfm:22) at cfindex2ecfm1078974315._factor16(C:/home/bluehorizonpoolsandspas.com/blog/index.cfm:226) at cfindex2ecfm1078974315.runPage(C:/home/bluehorizonpoolsandspas.com/blog/index.cfm:1) at cftriggers2ecfm1613175086._factor41(C:/home/bluehorizonpoolsandspas.com/config/triggers.cfm:915) at cftriggers2ecfm1613175086.runPage(C:/home/bluehorizonpoolsandspas.com/config/triggers.cfm:1) at cffooter12ecfm118178727.runPage(C:/home/bluehorizonpoolsandspas.com/config/footer1.cfm:22) at cfindex2ecfm1078974315._factor16(C:/home/bluehorizonpoolsandspas.com/blog/index.cfm:226) at cfindex2ecfm1078974315.runPage(C:/home/bluehorizonpoolsandspas.com/blog/index.cfm:1) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot create a row of size 8062 which is greater than the allowable maximum row size of 8060.
	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.r.a(TDSRPCRequest.java:1063)
	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.fe.B(BasePreparedStatement.java:530)
	at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
	at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
	at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656)
	at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1639)
	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 cftriggers2ecfm1613175086._factor41(C:\home\bluehorizonpoolsandspas.com\config\triggers.cfm:915)
	at cftriggers2ecfm1613175086.runPage(C:\home\bluehorizonpoolsandspas.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 cffooter12ecfm118178727.runPage(C:\home\bluehorizonpoolsandspas.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 cfindex2ecfm1078974315._factor16(C:\home\bluehorizonpoolsandspas.com\blog\index.cfm:226)
	at cfindex2ecfm1078974315.runPage(C:\home\bluehorizonpoolsandspas.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)