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.

Column 'casino' in field list is ambiguous
 
The error occurred in D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail.cfm: line 100
Called from D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail.cfm: line 1
Called from D:/vsites/GolfTripscom/root/html/golfcourses/coursedetail.cfm: line 1
Called from D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail.cfm: line 100
Called from D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail.cfm: line 1
Called from D:/vsites/GolfTripscom/root/html/golfcourses/coursedetail.cfm: line 1
98 : 	<cfif application.State IS NOT "USA">
99 : 		AND ((IFNULL(Courses.State, '') = <cfqueryparam value="#application.State#" cfsqltype="cf_sql_varchar" /> )
100 : 		OR (IFNULL(PackageDestination.State, '') = <cfqueryparam value="#application.State#" cfsqltype="cf_sql_varchar" />))
101 : 	</cfif>
102 : 

SQLSTATE   23000
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   GolfTrips_661
VENDORERRORCODE   1052
SQL   SELECT Category.CategoryName, name, Courses.ID, city, Courses.state, Courses.zip, courses.phone, Latitude, Longitude, courses.slug as courseslug, Thumbsupvote, address, county, tollfree, url, facebook, twitter, twitterhandle, instagram, instagramhandle, youtube, courses.tripadvisor, Courses.flickr, twitterhandle, googlemapembed, googlemaplink, blog, yelp, itunes, googleplay, linkedin, digitalgolfpass, vimeo, pinterest, Courses.description, rates, discounts, golfleaguesinfo, teetimelinks, teetimelinks_teeoff, Courses.largeimage, golfmanagement, golfgiftcards, advancedrounds, golfgiftcardsurl, advancedroundsurl, discount_iowagolfpass, Courses.largeimage2, Courses.largeimage3, Courses.largeimage4, Courses.largeimage5, directions, courses.bannerbox, outing, Holes, par3, casino, name2, lessons, laserlink, courses.Email, EmailManager, Manager, wedding, courses.Marketing, courses.MarketingEmail, Category, Architect, YearBuilt, GolfPro, EmailGolfPro, Reservations, Season, Discounts, golftrail, golftrail2, Promotions, Courses.TeeTimes, Carts, Range2, RentalClubs, ProOnsite, CreditCards, BanquetFacility, Bar, PuttingGreen, CourseLodging, photocredit, photocrediturl, LockerRoom, PrivateOutings, golfleagues, par3, weddingimage, realestate, Courses.TimesViewed, Courses.Revised, cg_facilityid, yardagemarkers, caddies, golfcommunity, greengrasstype, fairwaysgrasstype, golfleaguesinfo, courses.lodging, membership, courselogo, gps, Courses.area, Courses.video, rates, spadetails, image2, image3, image4, image5, image6, scorecard, homesoncourse, walking, waterhazards, sandbunkers, dining, rating1, yards, tees, slope, MAX(CS.CouponExp) as StayPlayExpire, MIN(IFNULL(CS.couponStart, NOW())) as StayPlayStart, BackPar, Courses.Area, LargeLodgingPhoto, LargeRestaurantPhoto, IFNULL(outing,'') as golfouting, MIN(CS.couponStart) as StayPlayStartnotNull, Status, MAX(Coupon.CouponExp) as CouponExp, MIN(Coupon.couponStart) as CouponStart, GolfSimulator, GolfSimulatorPhoto, GolfSimulatorLink , countries.Country_Name, discount_bigsummer, discount_green, tiktok, LargeLodgingPhotoTwo, PuttingGreenDesc, PuttingGreenName, PuttingGreenPhoto,PuttingGreenLink FROM Courses LEFT JOIN Category ON Courses.Category = Category.ID LEFT OUTER JOIN Coupon_Stayplay CS ON CS.WiGolfid = Courses.ID LEFT OUTER JOIN coupon ON coupon.WiGolfid = Courses.ID LEFT OUTER JOIN countries ON countries.Country_Id = Courses.Country LEFT OUTER JOIN Destinations PackageDestination on PackageDestination.AreaId = CS.PackageDestination Where Courses.ID = (param 1)
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   3.19.74.75
Referrer  
Date/Time   27-Feb-25 10:59 PM
Stack Trace
at cfcoursedetail2ecfm121832988._factor29(D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail.cfm:100) at cfcoursedetail2ecfm121832988.runPage(D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail.cfm:1) at cfcoursedetail2ecfm1560258914.runPage(D:/vsites/GolfTripscom/root/html/golfcourses/coursedetail.cfm:1) at cfcoursedetail2ecfm121832988._factor29(D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail.cfm:100) at cfcoursedetail2ecfm121832988.runPage(D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail.cfm:1) at cfcoursedetail2ecfm1560258914.runPage(D:/vsites/GolfTripscom/root/html/golfcourses/coursedetail.cfm:1)

java.sql.SQLIntegrityConstraintViolationException: Column 'casino' in field list is ambiguous
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:370)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1629)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1355)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1285)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821)
	at cfcoursedetail2ecfm121832988._factor29(D:\VSites\GolfTripscom\root\html\_templates\golfcourses\coursedetail.cfm:100)
	at cfcoursedetail2ecfm121832988.runPage(D:\VSites\GolfTripscom\root\html\_templates\golfcourses\coursedetail.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.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274)
	at cfcoursedetail2ecfm1560258914.runPage(D:\vsites\GolfTripscom\root\html\golfcourses\coursedetail.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:199)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	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:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
	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:357)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
	at java.base/java.lang.Thread.run(Thread.java:834)