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]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
 
The error occurred in C:/HostingSpaces/admin/preachit.org/wwwroot/newsletters/index.cfm: line 138
Called from C:/HostingSpaces/admin/preachit.org/wwwroot/newsletters/index.cfm: line 64
Called from C:/HostingSpaces/admin/preachit.org/wwwroot/newsletters/index.cfm: line 1
Called from Server returned: line -1
Called from Server returned: line -1
Called from C:/HostingSpaces/admin/preachit.org/wwwroot/newsletters/index.cfm: line 138
Called from C:/HostingSpaces/admin/preachit.org/wwwroot/newsletters/index.cfm: line 64
Called from C:/HostingSpaces/admin/preachit.org/wwwroot/newsletters/index.cfm: line 1
136 : 		  AND article_topic.name = <cfqueryparam value="#search_type_id#" cfsqltype="cf_sql_varchar">
137 : 		<cfelseif search_type EQ 'keyword'>
138 : 			AND newsletter_articles.heading LIKE <cfqueryparam value="%#search_type_id#%" cfsqltype="cf_sql_varchar">
139 : 	  </cfif>	
140 : 		GROUP BY newsletter_articles.id

SQLSTATE   08S01
DATASOURCE   preachit-main
SQL    SELECT COUNT(*) AS total_rows FROM ( SELECT newsletter_articles.id FROM newsletter_articles LEFT JOIN article_topic_map ON newsletter_articles.id = article_topic_map.newsletter_article_id LEFT JOIN article_topic ON article_topic_map.article_topic_id = article_topic.article_topic_id WHERE status > 0 AND on_homepage = 1 AND author = (param 1) GROUP BY newsletter_articles.id ) AS article_ids
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   54.145.83.79
Referrer  
Date/Time   21-Oct-18 04:00 AM
Stack Trace
at cfindex2ecfm1238412950$funcGET_ARTICLES.runFunction(C:/HostingSpaces/admin/preachit.org/wwwroot/newsletters/index.cfm:138) at cfindex2ecfm1238412950._factor1(C:/HostingSpaces/admin/preachit.org/wwwroot/newsletters/index.cfm:64) at cfindex2ecfm1238412950.runPage(C:/HostingSpaces/admin/preachit.org/wwwroot/newsletters/index.cfm:1) Caused by: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server. java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server. at cfindex2ecfm1238412950$funcGET_ARTICLES.runFunction(C:/HostingSpaces/admin/preachit.org/wwwroot/newsletters/index.cfm:138) at cfindex2ecfm1238412950._factor1(C:/HostingSpaces/admin/preachit.org/wwwroot/newsletters/index.cfm:64) at cfindex2ecfm1238412950.runPage(C:/HostingSpaces/admin/preachit.org/wwwroot/newsletters/index.cfm:1)

java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
	at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddg.a(Unknown Source)
	at macromedia.jdbc.sqlserver.dda3.h(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1467)
	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 cfindex2ecfm1238412950$funcGET_ARTICLES.runFunction(C:\HostingSpaces\admin\preachit.org\wwwroot\newsletters\index.cfm:138)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
	at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
	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 cfindex2ecfm1238412950._factor1(C:\HostingSpaces\admin\preachit.org\wwwroot\newsletters\index.cfm:64)
	at cfindex2ecfm1238412950.runPage(C:\HostingSpaces\admin\preachit.org\wwwroot\newsletters\index.cfm:1)
	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.IpFilter.invoke(IpFilter.java:64)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451)
	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 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:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:450)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)