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.

Data source rejected establishment of connection, message from server: "Too many connections"

The error occurred in C:\inetpub\wwwroot\realestateonline\Includes\STATLISTINGS.cfm: line 7
Called from C:\inetpub\wwwroot\AmericanAssociates\results.cfm: line 73
Called from C:\inetpub\wwwroot\AmericanAssociates\results.cfm: line 1

5 : <CFQUERY NAME="StatListing" DATASOURCE="RealEstateStats">
6 : UPDATE stats_listing SET <cfif GetHomes.Broker_Order lte 2><cfif SiteType is "Agent">SummaryViewsA = SummaryViewsA+1,<cfelse>SummaryViewsB = SummaryViewsB+1,</cfif><cfelse>SummaryViewsO = SummaryViewsO+1,</cfif>
7 : TodaySums = TodaySums+1 WHERE listingid IN (#REReplace(gethomeslist,",$","")#)
8 : </CFQUERY>
9 : </cfif>

SQL	UPDATE stats_listing SET SummaryViewsO = SummaryViewsO+1, TodaySums = TodaySums+1 WHERE listingid IN ("1503RYAN48532")
DATASOURCE	RealEstateStats
VENDORERRORCODE	1040
SQLSTATE	08004

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address	3.149.29.71
Referrer
Date/Time	27-Sep-24 05:28 PM

Stack Trace

at cfSTATLISTINGS2ecfm1372315581.runPage(C:\inetpub\wwwroot\realestateonline\Includes\STATLISTINGS.cfm:7) at cfresults2ecfm1305424200._factor18(C:\inetpub\wwwroot\AmericanAssociates\results.cfm:73) at cfresults2ecfm1305424200.runPage(C:\inetpub\wwwroot\AmericanAssociates\results.cfm:1)

java.sql.SQLException: Data source rejected establishment of connection,  message from server: "Too many connections"
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1018)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2568)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
	at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:562)
	at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
	at java.lang.Thread.run(Thread.java:534)