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_country.cfm: line 87
Called from D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail_country.cfm: line 1
Called from D:/vsites/GolfTripscom/root/html/golfbahamas/golfcourses/coursedetail.cfm: line 3
Called from D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail_country.cfm: line 87
Called from D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail_country.cfm: line 1
Called from D:/vsites/GolfTripscom/root/html/golfbahamas/golfcourses/coursedetail.cfm: line 3
 
85 :  	LEFT OUTER JOIN countries ON countries.Country_Id = Courses.Country
86 : LEFT OUTER JOIN Destinations PackageDestination on PackageDestination.AreaId = CS.PackageDestination 
87 : Where Courses.ID = <cfqueryparam value="#url.recordid#" cfsqltype="cf_sql_integer" />
88 : </cfquery>
89 :
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, image, Thumbsupvote, address, county, courses.slug as courseslug, tollfree, url, facebook, twitter, twitterhandle, instagram, instagramhandle, youtube, courses.tripadvisor, discount_iowagolfpass, Courses.flickr, twitterhandle, googlemapembed, googlemaplink, golfadvisor, blog, yelp, itunes, googleplay, linkedin, digitalgolfpass, vimeo, pinterest, Courses.description, rates, discounts, golfleaguesinfo, teetimelinks, teetimelinks_opentee, teetimelinks_teeoff, IFNULL(teetimelinks_golf18,'') as teetimelinks_golf18, Courses.largeimage, golfmanagement, golfgiftcards, advancedrounds, golfgiftcardsurl, advancedroundsurl, 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   18.226.87.167
Referrer  
Date/Time   02-Mar-25 05:28 PM
Stack Trace
at cfcoursedetail_country2ecfm1245840600._factor27(D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail_country.cfm:87) at cfcoursedetail_country2ecfm1245840600.runPage(D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail_country.cfm:1) at cfcoursedetail2ecfm1308649005.runPage(D:/vsites/GolfTripscom/root/html/golfbahamas/golfcourses/coursedetail.cfm:3) at cfcoursedetail_country2ecfm1245840600._factor27(D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail_country.cfm:87) at cfcoursedetail_country2ecfm1245840600.runPage(D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail_country.cfm:1) at cfcoursedetail2ecfm1308649005.runPage(D:/vsites/GolfTripscom/root/html/golfbahamas/golfcourses/coursedetail.cfm:3) 

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 cfcoursedetail_country2ecfm1245840600._factor27(D:\VSites\GolfTripscom\root\html\_templates\golfcourses\coursedetail_country.cfm:87)
	at cfcoursedetail_country2ecfm1245840600.runPage(D:\VSites\GolfTripscom\root\html\_templates\golfcourses\coursedetail_country.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 cfcoursedetail2ecfm1308649005.runPage(D:\vsites\GolfTripscom\root\html\golfbahamas\golfcourses\coursedetail.cfm:3)
	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)