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_city.cfm: line 88
Called from D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail_city.cfm: line 1
Called from D:/VSites/GolfTripscom/root/html/golfvegas/golfcourses/coursedetail.cfm: line 3
Called from D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail_city.cfm: line 88
Called from D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail_city.cfm: line 1
Called from D:/VSites/GolfTripscom/root/html/golfvegas/golfcourses/coursedetail.cfm: line 3

86 :  	LEFT OUTER JOIN countries ON countries.Country_Id = Courses.Country
87 : LEFT OUTER JOIN Destinations PackageDestination on PackageDestination.AreaId = CS.PackageDestination 
88 : Where Courses.ID = <cfqueryparam value="#url.recordid#" cfsqltype="cf_sql_integer" />
89 : 
90 : </cfquery>

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, 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:

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.135.224.116
Referrer
Date/Time	03-Mar-25 06:22 PM

Stack Trace

at cfcoursedetail_city2ecfm776075265._factor29(D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail_city.cfm:88) at cfcoursedetail_city2ecfm776075265.runPage(D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail_city.cfm:1) at cfcoursedetail2ecfm1679425489.runPage(D:/VSites/GolfTripscom/root/html/golfvegas/golfcourses/coursedetail.cfm:3) at cfcoursedetail_city2ecfm776075265._factor29(D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail_city.cfm:88) at cfcoursedetail_city2ecfm776075265.runPage(D:/VSites/GolfTripscom/root/html/_templates/golfcourses/coursedetail_city.cfm:1) at cfcoursedetail2ecfm1679425489.runPage(D:/VSites/GolfTripscom/root/html/golfvegas/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_city2ecfm776075265._factor29(D:\VSites\GolfTripscom\root\html\_templates\golfcourses\coursedetail_city.cfm:88)
	at cfcoursedetail_city2ecfm776075265.runPage(D:\VSites\GolfTripscom\root\html\_templates\golfcourses\coursedetail_city.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 cfcoursedetail2ecfm1679425489.runPage(D:\VSites\GolfTripscom\root\html\golfvegas\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)