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.

Unknown column 'C.courseid' in 'where clause'
 
The error occurred in D:/vsites/GolfTripscom/root/html/_templates/videos/coursevideos.cfm: line 15
Called from D:/vsites/GolfTripscom/root/html/golfmidwest/videos/coursevideos.cfm: line 10
Called from D:/vsites/GolfTripscom/root/html/_templates/videos/coursevideos.cfm: line 15
Called from D:/vsites/GolfTripscom/root/html/golfmidwest/videos/coursevideos.cfm: line 10
13 : 	
14 : 	<cfif AppState IS "MG">
15 : 		<cfquery name="fouronefour" datasource="#Appdatasource#">
16 : 			SELECT Videos.video, Videos.title, Videos.videocode, Videos.tags, Videos.videodesc, Videos.Revised, 
17 : 				Videos.Complete, Videos.TimesViewed, Videos.State, Videos.courseid,

SQLSTATE   42S22
DATASOURCE   GolfTrips_661
VENDORERRORCODE   1054
SQL    SELECT Videos.video, Videos.title, Videos.videocode, Videos.tags, Videos.videodesc, Videos.Revised, Videos.Complete, Videos.TimesViewed, Videos.State, Videos.courseid, Courses.Address, Courses.City, VideoImage, courselogo, Courses.name FROM Videos INNER JOIN Courses ON Courses.Id = courseid INNER JOIN States S on S.State = C.State WHERE C.courseid <> '' ORDER BY C.Title
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   54.226.102.115
Referrer  
Date/Time   18-Jun-19 05:59 AM
Stack Trace
at cfcoursevideos2ecfm1703485566.runPage(D:/vsites/GolfTripscom/root/html/_templates/videos/coursevideos.cfm:15) at cfcoursevideos2ecfm783955168.runPage(D:/vsites/GolfTripscom/root/html/golfmidwest/videos/coursevideos.cfm:10) at cfcoursevideos2ecfm1703485566.runPage(D:/vsites/GolfTripscom/root/html/_templates/videos/coursevideos.cfm:15) at cfcoursevideos2ecfm783955168.runPage(D:/vsites/GolfTripscom/root/html/golfmidwest/videos/coursevideos.cfm:10)

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'C.courseid' in 'where clause'
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3206)
	at com.mysql.jdbc.Statement.execute(Statement.java:727)
	at com.mysql.jdbc.Statement.execute(Statement.java:804)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1485)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
	at cfcoursevideos2ecfm1703485566.runPage(D:\vsites\GolfTripscom\root\html\_templates\videos\coursevideos.cfm:15)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
	at cfcoursevideos2ecfm783955168.runPage(D:\vsites\GolfTripscom\root\html\golfmidwest\videos\coursevideos.cfm:10)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
	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:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)