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.

Server connection failure during transaction. Due to underlying exception: 'com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections'. ** BEGIN NESTED EXCEPTION ** com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException MESSAGE: Too many connections STACKTRACE: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2924) at com.mysql.jdbc.Connection.<init>(Connection.java:1555) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:614) at coldfusion.server.j2ee....
 
The error occurred in D:/vsites/GolfTripscom/root/html/_templates/golfcourses/coursecoupon.cfm: line 22
Called from D:/vsites/GolfTripscom/root/html/_templates/golfcourses/coursecoupon.cfm: line 1
Called from D:/vsites/GolfTripscom/root/html/golfmichigan/golfcourses/coursecoupon.cfm: line 2
20 :     WHERE Courses.id = #recordid#
21 : 	AND Coupon.couponexp>= #CreateODBCDate(Now())#
22 : 	AND IFNULL(Coupon.couponStart, '#DateFormat(Today)#')<=#CreateODBCDate(Now())#
23 : 	ORDER BY Name asc
24 : </cfquery>

SQLSTATE   08001
DATASOURCE   GolfTrips_661
SQL    SELECT DISTINCT(ID), CID, Coupon.Coupon, Coupon.CouponExp, Coupon.CouponDesc, coupon.rate_discount, coupon.rate_regular, Courses.id, Courses.Name, Courses.City, Courses.phone, Courses.image2, Courses.state, Courses.courselogo, Courses.courselogoheight, Courses.courselogowidth, 'Course' AS CourseType, Courses.Name AS URL, Coupon_Cart_Code, Coupon_Cart_msg, Coupon_Players_Code, Coupon_Players_msg, Coupon_Holes_Code, Coupon_Holes_msg, Coupon_Age_Code, Coupon_Age_msg, Country_Name FROM Courses INNER JOIN Coupon ON WiGolfID = ID LEFT OUTER JOIN coupon_holes ON Coupon.holes_dd = Coupon_holes_ID LEFT OUTER JOIN coupon_cart ON Coupon.cart_dd = Coupon_cart_id LEFT OUTER JOIN coupon_golfers ON Coupon.golfers_dd = coupon_players_id LEFT OUTER JOIN coupon_age ON Coupon.age_dd = coupon_age_id LEFT OUTER JOIN countries ON countries.Country_Id = Courses.Country WHERE Courses.id = 8900 AND Coupon.couponexp>= {d '2019-12-13'} AND IFNULL(Coupon.couponStart, '13-Dec-19')<={d '2019-12-13'} ORDER BY Name asc
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   3.215.182.36
Referrer  
Date/Time   13-Dec-19 08:26 PM
Stack Trace
at cfcoursecoupon2ecfm1524247638._factor8(D:/vsites/GolfTripscom/root/html/_templates/golfcourses/coursecoupon.cfm:22) at cfcoursecoupon2ecfm1524247638.runPage(D:/vsites/GolfTripscom/root/html/_templates/golfcourses/coursecoupon.cfm:1) at cfcoursecoupon2ecfm564563266.runPage(D:/vsites/GolfTripscom/root/html/golfmichigan/golfcourses/coursecoupon.cfm:2)

com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections'.

** BEGIN NESTED EXCEPTION ** 

com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException
MESSAGE: Too many connections

STACKTRACE:

com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Too many connections
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:921)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2924)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
	at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:614)
	at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
	at java.lang.Thread.run(Thread.java:745)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up.
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2997)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
	at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:614)
	at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
	at java.lang.Thread.run(Thread.java:745)