Catch Entries: 15 |
additional | Struct (ordered) | SQL | string | SELECT ed.eventDetailID, ed.recurrenceID, ed.contactName, ed.contactPhone, ed.contactEmail, ed.allDay, ed.title, ed.typeID, ed.subtypeID, ed.sponsorID, ed.categoryID,
ed.subSponsorID, ed.recurrenceType, ed.locationID, ed.address, ed.room, ed.description, ed.url, ed.admissionInfo, ev.startDateTime, ev.endDateTime, ed.categoryID, et.typeTitle, est.subtypeTitle, el.locationName, el.markerID, es.sponsorName, ess.subSponsorName, ec.eventcategoryName
FROM tb_eventDetails ed
LEFT OUTER JOIN tb_event ev
ON ed.eventDetailID = ev.eventDetailID
LEFT OUTER JOIN tb_eventLocation el
ON ed.locationID = el.locationID
LEFT OUTER JOIN tb_eventType et
ON ed.typeID = et.typeID
LEFT OUTER JOIN tb_eventSubType est
ON ed.subtypeID = est.subtypeID
LEFT OUTER JOIN tb_eventSponsor es
ON ed.sponsorID = es.sponsorID
LEFT OUTER JOIN tb_eventSubSponsor ess
ON ed.subSponsorID = ess.subSponsorID
LEFT OUTER JOIN tb_eventCategories ec
ON ed.categoryID = ec.eventCategoryID
WHERE ev.eventID = 80335
AND eventStatus = 1 |
|
|
DataSource | |
Detail | string | available columns are [EVENTDETAILID, RECURRENCEID, CONTACTNAME, CONTACTPHONE, CONTACTEMAIL, ALLDAY, TITLE, TYPEID, SUBTYPEID, SPONSORID, CATEGORYID, SUBSPONSORID, RECURRENCETYPE, LOCATIONID, ADDRESS, ROOM, DESCRIPTION, URL, ADMISSIONINFO, STARTDATETIME, ENDDATETIME, TYPETITLE, SUBTYPETITLE, LOCATIONNAME, MARKERID, SPONSORNAME, SUBSPONSORNAME, EVENTCATEGORYNAME] |
|
ErrorCode | |
Extended_Info | |
ExtendedInfo | |
Message | string | Column [EVENTTICKETS] not found in query |
|
NativeErrorCode | |
queryError | string | SELECT ed.eventDetailID, ed.recurrenceID, ed.contactName, ed.contactPhone, ed.contactEmail, ed.allDay, ed.title, ed.typeID, ed.subtypeID, ed.sponsorID, ed.categoryID,
ed.subSponsorID, ed.recurrenceType, ed.locationID, ed.address, ed.room, ed.description, ed.url, ed.admissionInfo, ev.startDateTime, ev.endDateTime, ed.categoryID, et.typeTitle, est.subtypeTitle, el.locationName, el.markerID, es.sponsorName, ess.subSponsorName, ec.eventcategoryName
FROM tb_eventDetails ed
LEFT OUTER JOIN tb_event ev
ON ed.eventDetailID = ev.eventDetailID
LEFT OUTER JOIN tb_eventLocation el
ON ed.locationID = el.locationID
LEFT OUTER JOIN tb_eventType et
ON ed.typeID = et.typeID
LEFT OUTER JOIN tb_eventSubType est
ON ed.subtypeID = est.subtypeID
LEFT OUTER JOIN tb_eventSponsor es
ON ed.sponsorID = es.sponsorID
LEFT OUTER JOIN tb_eventSubSponsor ess
ON ed.subSponsorID = ess.subSponsorID
LEFT OUTER JOIN tb_eventCategories ec
ON ed.categoryID = ec.eventCategoryID
WHERE ev.eventID = 80335
AND eventStatus = 1 |
|
Sql | string | SELECT ed.eventDetailID, ed.recurrenceID, ed.contactName, ed.contactPhone, ed.contactEmail, ed.allDay, ed.title, ed.typeID, ed.subtypeID, ed.sponsorID, ed.categoryID,
ed.subSponsorID, ed.recurrenceType, ed.locationID, ed.address, ed.room, ed.description, ed.url, ed.admissionInfo, ev.startDateTime, ev.endDateTime, ed.categoryID, et.typeTitle, est.subtypeTitle, el.locationName, el.markerID, es.sponsorName, ess.subSponsorName, ec.eventcategoryName
FROM tb_eventDetails ed
LEFT OUTER JOIN tb_event ev
ON ed.eventDetailID = ev.eventDetailID
LEFT OUTER JOIN tb_eventLocation el
ON ed.locationID = el.locationID
LEFT OUTER JOIN tb_eventType et
ON ed.typeID = et.typeID
LEFT OUTER JOIN tb_eventSubType est
ON ed.subtypeID = est.subtypeID
LEFT OUTER JOIN tb_eventSponsor es
ON ed.sponsorID = es.sponsorID
LEFT OUTER JOIN tb_eventSubSponsor ess
ON ed.subSponsorID = ess.subSponsorID
LEFT OUTER JOIN tb_eventCategories ec
ON ed.categoryID = ec.eventCategoryID
WHERE ev.eventID = 80335
AND eventStatus = 1 |
|
SQLState | |
StackTrace | string | lucee.runtime.exp.DatabaseException: Column [EVENTTICKETS] not found in query
at lucee.runtime.type.QueryImpl.getAt(QueryImpl.java:1152)
at lucee.runtime.type.QueryImpl.get(QueryImpl.java:2071)
at lucee.runtime.util.VariableUtilImpl.get(VariableUtilImpl.java:278)
at lucee.runtime.PageContextImpl.get(PageContextImpl.java:1569)
at __138.__138.usu.templateresources._resources.calendar.includes.event_cfm$cf$i9y.call(../../usu/templateresources/_resources/calendar/includes/event.cfm:157)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1058)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:950)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:931)
at __138.__138.usu.templateresources._resources.calendar.index_cfm$cf$hue.call(../../usu/templateresources/_resources/calendar/index.cfm:9)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1058)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:950)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:931)
at fsenate.calendar.index_cfm$cf$i8d.call(/fsenate/calendar/index.cfm:1)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1058)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:950)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:221)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2494)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2480)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2451)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1219)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1165)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:367)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Unknown Source)
|
|
TagContext | Array | 1 | Struct | codePrintHTML | string | 155: <p>#admissionInfo#</p><br>
156: </cfif><br>
<b>157: <cfif $.eventDetails.event.eventTickets NEQ ""></b><br>
158: <h3 class="h4 underlined"><strong>Event Tickets</strong></h3><br>
159: <p>#eventTickets#</p><br>
|
| codePrintPlain | string | 155: <p>#admissionInfo#</p>
156: </cfif>
157: <cfif $.eventDetails.event.eventTickets NEQ "">
158: <h3 class="h4 underlined"><strong>Event Tickets</strong></h3>
159: <p>#eventTickets#</p>
|
| column | | id | | line | | Raw_Trace | string | __138.__138.usu.templateresources._resources.calendar.includes.event_cfm$cf$i9y.call(../../usu/templateresources/_resources/calendar/includes/event.cfm:157) |
| template | string | /u/web/domains/usu/templateresources/_resources/calendar/includes/event.cfm |
| type | |
| 2 | Struct | codePrintHTML | string | 7: <div class="container"><br>
8: <cfif IsDefined('url.id') AND IsNumeric(url.id)><br>
<b>9: <cfinclude template="includes/event.cfm"/></b><br>
10: <cfelse><br>
11: <cfinclude template="includes/list.cfm"/><br>
|
| codePrintPlain | string | 7: <div class="container">
8: <cfif IsDefined('url.id') AND IsNumeric(url.id)>
9: <cfinclude template="includes/event.cfm"/>
10: <cfelse>
11: <cfinclude template="includes/list.cfm"/>
|
| column | | id | | line | | Raw_Trace | string | __138.__138.usu.templateresources._resources.calendar.index_cfm$cf$hue.call(../../usu/templateresources/_resources/calendar/index.cfm:9) |
| template | string | /u/web/domains/usu/templateresources/_resources/calendar/index.cfm |
| type | |
| 3 | Struct | codePrintHTML | string | <b>1: <cfinclude template="#application.pathInfo.pagesDeep#usu/templateresources/_resources/calendar/index.cfm"/></b><br>
|
| codePrintPlain | string | 1: <cfinclude template="#application.pathInfo.pagesDeep#usu/templateresources/_resources/calendar/index.cfm"/>
|
| column | | id | | line | | Raw_Trace | string | fsenate.calendar.index_cfm$cf$i8d.call(/fsenate/calendar/index.cfm:1) |
| template | string | /u/web/domains/usu/www/fsenate/calendar/index.cfm |
| type | |
|
|
type | |
where | |