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.

Communications link failure The last packet successfully received from the server was 100,767 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.
 
The error occurred in C:/WWW/pickardchina.com/cw3/cwtags/cwincdiscountfunctions.cfm: line 95
Called from C:/WWW/pickardchina.com/cw3/cwtags/cwincdiscountfunctions.cfm: line 82
Called from C:/WWW/pickardchina.com/cw3/cwtags/cwtagglobalsettings.cfm: line 341
Called from C:/WWW/pickardchina.com/cw3/cwtags/cwtagglobalsettings.cfm: line 1
Called from C:/WWW/pickardchina.com/application.cfm: line 68
Called from C:/WWW/pickardchina.com/cw3/cwtags/cwincdiscountfunctions.cfm: line 95
Called from C:/WWW/pickardchina.com/cw3/cwtags/cwincdiscountfunctions.cfm: line 82
Called from C:/WWW/pickardchina.com/cw3/cwtags/cwtagglobalsettings.cfm: line 341
Called from C:/WWW/pickardchina.com/cw3/cwtags/cwtagglobalsettings.cfm: line 1
Called from C:/WWW/pickardchina.com/application.cfm: line 68
93 : 		AND d.discount_archive = 0	
94 : 		AND (d.discount_promotionalCode = '' 
95 : 			OR d.discount_promotionalCode = '#session.promotionalcode#')
96 : 		</cfquery>
97 : 		<cfset availableDiscounts = ValueList(rsGetDiscounts.discount_id)>

SQLSTATE   08S01
DATASOURCE   solarek
SQL    SELECT discount_id, discount_promotionalCode FROM tbl_discounts d WHERE sitecode = 5 AND ({d '2015-07-31'} >= d.discount_startDate AND {d '2015-07-31'} <= d.discount_endDate) AND d.discount_archive = 0 AND (d.discount_promotionalCode = '' OR d.discount_promotionalCode = '')
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.144.81.235
Referrer  
Date/Time   31-Jul-15 04:29 PM
Stack Trace
at cfcwincdiscountfunctions2ecfm1875899925$funcCWGETDISCOUNTS._factor0(C:/WWW/pickardchina.com/cw3/cwtags/cwincdiscountfunctions.cfm:95) at cfcwincdiscountfunctions2ecfm1875899925$funcCWGETDISCOUNTS.runFunction(C:/WWW/pickardchina.com/cw3/cwtags/cwincdiscountfunctions.cfm:82) at cfcwtagglobalsettings2ecfm1458461022._factor4(C:/WWW/pickardchina.com/cw3/cwtags/cwtagglobalsettings.cfm:341) at cfcwtagglobalsettings2ecfm1458461022.runPage(C:/WWW/pickardchina.com/cw3/cwtags/cwtagglobalsettings.cfm:1) at cfapplication2ecfm2072087900.runPage(C:/WWW/pickardchina.com/application.cfm:68) at cfcwincdiscountfunctions2ecfm1875899925$funcCWGETDISCOUNTS._factor0(C:/WWW/pickardchina.com/cw3/cwtags/cwincdiscountfunctions.cfm:95) at cfcwincdiscountfunctions2ecfm1875899925$funcCWGETDISCOUNTS.runFunction(C:/WWW/pickardchina.com/cw3/cwtags/cwincdiscountfunctions.cfm:82) at cfcwtagglobalsettings2ecfm1458461022._factor4(C:/WWW/pickardchina.com/cw3/cwtags/cwtagglobalsettings.cfm:341) at cfcwtagglobalsettings2ecfm1458461022.runPage(C:/WWW/pickardchina.com/cw3/cwtags/cwtagglobalsettings.cfm:1) at cfapplication2ecfm2072087900.runPage(C:/WWW/pickardchina.com/application.cfm:68)

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 100,767 milliseconds ago.  The last packet sent successfully to the server was 1 milliseconds ago.
	at sun.reflect.GeneratedConstructorAccessor893.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:395)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1105)
	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3670)
	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3559)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4110)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2793)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2742)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:878)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:986)
	at com.intergral.fusionreactor.jdbc.StatementSurrogate.execute(StatementSurrogate.java:63)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1451)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1201)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1131)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688)
	at cfcwincdiscountfunctions2ecfm1875899925$funcCWGETDISCOUNTS._factor0(C:\WWW\pickardchina.com\cw3\cwtags\cwincdiscountfunctions.cfm:95)
	at cfcwincdiscountfunctions2ecfm1875899925$funcCWGETDISCOUNTS.runFunction(C:\WWW\pickardchina.com\cw3\cwtags\cwincdiscountfunctions.cfm:82)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
	at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655)
	at cfcwtagglobalsettings2ecfm1458461022._factor4(C:\WWW\pickardchina.com\cw3\cwtags\cwtagglobalsettings.cfm:341)
	at cfcwtagglobalsettings2ecfm1458461022.runPage(C:\WWW\pickardchina.com\cw3\cwtags\cwtagglobalsettings.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
	at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:296)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
	at cfapplication2ecfm2072087900.runPage(C:\WWW\pickardchina.com\application.cfm:68)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:352)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
	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:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:97)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:472)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:312)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:192)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:507)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
	at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:79)
	at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:53)
	at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:199)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
	at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3119)
	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3570)
	... 88 more