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]Cannot create a row of size 8063 which is greater than the allowable maximum row size of 8060.
 
The error occurred in C:/home/eastcoastleisure.com/config/triggers.cfm: line 914
Called from C:/home/eastcoastleisure.com/config/footer1.cfm: line 28
Called from C:/home/eastcoastleisure.com/blog/index.cfm: line 226
Called from C:/home/eastcoastleisure.com/blog/index.cfm: line 1
Called from C:/home/eastcoastleisure.com/config/triggers.cfm: line 914
Called from C:/home/eastcoastleisure.com/config/footer1.cfm: line 28
Called from C:/home/eastcoastleisure.com/blog/index.cfm: line 226
Called from C:/home/eastcoastleisure.com/blog/index.cfm: line 1
 
912 : 	update EM_SR_Bookings
913 : 	set ccn = 'xxxx xxxx xxxx xxxx'
914 : 	where (DATEDIFF(day, bookingdate, <CFQUERYPARAM Value="#CreateODBCDateTime(now())#" cfsqltype="CF_SQL_TIMESTAMP">) > 5)
915 : </cfquery>
916 : <cfquery datasource="#dbdatasource#" username="#dbusername#" password="#dbpassword#">
SQLSTATE   HY000
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   eastcoastleisurecom08
VENDORERRORCODE   511
SQL   update EM_SR_Bookings set ccn = 'xxxx xxxx xxxx xxxx' where (DATEDIFF(day, bookingdate, (param 1) ) > 5)
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   3.145.186.173
Referrer   http://www.eastcoastleisure.com/blog/index.cfm?themonth=March/2019&querytype=1&id=2
Date/Time   19-Apr-24 12:29 PM
Stack Trace
at cftriggers2ecfm1113460125.runPage(C:/home/eastcoastleisure.com/config/triggers.cfm:914) at cffooter12ecfm1001967891.runPage(C:/home/eastcoastleisure.com/config/footer1.cfm:28) at cfindex2ecfm596288215._factor16(C:/home/eastcoastleisure.com/blog/index.cfm:226) at cfindex2ecfm596288215.runPage(C:/home/eastcoastleisure.com/blog/index.cfm:1) at cftriggers2ecfm1113460125.runPage(C:/home/eastcoastleisure.com/config/triggers.cfm:914) at cffooter12ecfm1001967891.runPage(C:/home/eastcoastleisure.com/config/footer1.cfm:28) at cfindex2ecfm596288215._factor16(C:/home/eastcoastleisure.com/blog/index.cfm:226) at cfindex2ecfm596288215.runPage(C:/home/eastcoastleisure.com/blog/index.cfm:1) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot create a row of size 8063 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 cftriggers2ecfm1113460125.runPage(C:\home\eastcoastleisure.com\config\triggers.cfm:914)
	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 cffooter12ecfm1001967891.runPage(C:\home\eastcoastleisure.com\config\footer1.cfm:28)
	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 cfindex2ecfm596288215._factor16(C:\home\eastcoastleisure.com\blog\index.cfm:226)
	at cfindex2ecfm596288215.runPage(C:\home\eastcoastleisure.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)