Catch
Entries: 15
additional
Struct (ordered)
SQL
stringWITH recordSet AS ( SELECT row_number() over(ORDER BY startdate asc) as rowNumber, eventid,templatetype,typeURL,sub_hero_image,sub_avatar_image,templateid,itemExcerpt,itemTitle,itemImageProfile,itemImageHero,itemDescription,itemConditions,itemDate,requesttobook,startdate,startdatetime,enddatetime FROM vw_event_details WHERE 1=1 and webpropertyid= 'B8F11E64-ED77-3DD5-0083-536C2615FA40' and status= 'published' and requesttobook= false and startdatetime BETWEEN DATEADD(dd, DATEDIFF(dd,0,GETDATE ()), 0) and DATEADD(dd, DATEDIFF(dd,0,GETDATE ()), 45) and status = 'published' and DATEADD(day, DATEDIFF(day,0,startdatetime),0) != '2019-04-21 00:00:00.000' ), recordSetCount AS ( SELECT * FROM recordSet ,( SELECT MAX(rowNumber) AS totalRecords FROM recordSet ) as recordCount ,( SELECT min(startdate) AS fltrDateRangeFrom FROM recordSet) as firstDate ,( SELECT max(startdate) AS fltrDateRangeTo FROM recordSet) as lastDate ) SELECT eventid,templatetype,typeURL,sub_hero_image,sub_avatar_image,templateid,itemExcerpt,itemTitle,itemImageProfile,itemImageHero,itemDescription,itemConditions,itemDate,requesttobook,startdate,startdatetime,enddatetime , totalRecords , fltrDateRangeFrom , fltrDateRangeTo FROM recordSetCount where 1=1 and rownumber > 0 and rownumber <= 6 order by startdate asc
DataSource
string
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringcolumn [CITY] not found in query, columns are [EVENTID,TEMPLATETYPE,TYPEURL,SUB_HERO_IMAGE,SUB_AVATAR_IMAGE,TEMPLATEID,ITEMEXCERPT,ITEMTITLE,ITEMIMAGEPROFILE,ITEMIMAGEHERO,ITEMDESCRIPTION,ITEMCONDITIONS,ITEMDATE,REQUESTTOBOOK,STARTDATE,STARTDATETIME,ENDDATETIME,TOTALRECORDS,FLTRDATERANGEFROM,FLTRDATERANGETO]
NativeErrorCode
number-1
queryError
stringWITH recordSet AS ( SELECT row_number() over(ORDER BY startdate asc) as rowNumber, eventid,templatetype,typeURL,sub_hero_image,sub_avatar_image,templateid,itemExcerpt,itemTitle,itemImageProfile,itemImageHero,itemDescription,itemConditions,itemDate,requesttobook,startdate,startdatetime,enddatetime FROM vw_event_details WHERE 1=1 and webpropertyid= 'B8F11E64-ED77-3DD5-0083-536C2615FA40' and status= 'published' and requesttobook= false and startdatetime BETWEEN DATEADD(dd, DATEDIFF(dd,0,GETDATE ()), 0) and DATEADD(dd, DATEDIFF(dd,0,GETDATE ()), 45) and status = 'published' and DATEADD(day, DATEDIFF(day,0,startdatetime),0) != '2019-04-21 00:00:00.000' ), recordSetCount AS ( SELECT * FROM recordSet ,( SELECT MAX(rowNumber) AS totalRecords FROM recordSet ) as recordCount ,( SELECT min(startdate) AS fltrDateRangeFrom FROM recordSet) as firstDate ,( SELECT max(startdate) AS fltrDateRangeTo FROM recordSet) as lastDate ) SELECT eventid,templatetype,typeURL,sub_hero_image,sub_avatar_image,templateid,itemExcerpt,itemTitle,itemImageProfile,itemImageHero,itemDescription,itemConditions,itemDate,requesttobook,startdate,startdatetime,enddatetime , totalRecords , fltrDateRangeFrom , fltrDateRangeTo FROM recordSetCount where 1=1 and rownumber > 0 and rownumber <= 6 order by startdate asc
Sql
stringWITH recordSet AS ( SELECT row_number() over(ORDER BY startdate asc) as rowNumber, eventid,templatetype,typeURL,sub_hero_image,sub_avatar_image,templateid,itemExcerpt,itemTitle,itemImageProfile,itemImageHero,itemDescription,itemConditions,itemDate,requesttobook,startdate,startdatetime,enddatetime FROM vw_event_details WHERE 1=1 and webpropertyid= 'B8F11E64-ED77-3DD5-0083-536C2615FA40' and status= 'published' and requesttobook= false and startdatetime BETWEEN DATEADD(dd, DATEDIFF(dd,0,GETDATE ()), 0) and DATEADD(dd, DATEDIFF(dd,0,GETDATE ()), 45) and status = 'published' and DATEADD(day, DATEDIFF(day,0,startdatetime),0) != '2019-04-21 00:00:00.000' ), recordSetCount AS ( SELECT * FROM recordSet ,( SELECT MAX(rowNumber) AS totalRecords FROM recordSet ) as recordCount ,( SELECT min(startdate) AS fltrDateRangeFrom FROM recordSet) as firstDate ,( SELECT max(startdate) AS fltrDateRangeTo FROM recordSet) as lastDate ) SELECT eventid,templatetype,typeURL,sub_hero_image,sub_avatar_image,templateid,itemExcerpt,itemTitle,itemImageProfile,itemImageHero,itemDescription,itemConditions,itemDate,requesttobook,startdate,startdatetime,enddatetime , totalRecords , fltrDateRangeFrom , fltrDateRangeTo FROM recordSetCount where 1=1 and rownumber > 0 and rownumber <= 6 order by startdate asc
SQLState
string
StackTrace
stringlucee.runtime.exp.DatabaseException: column [CITY] not found in query, columns are [EVENTID,TEMPLATETYPE,TYPEURL,SUB_HERO_IMAGE,SUB_AVATAR_IMAGE,TEMPLATEID,ITEMEXCERPT,ITEMTITLE,ITEMIMAGEPROFILE,ITEMIMAGEHERO,ITEMDESCRIPTION,ITEMCONDITIONS,ITEMDATE,REQUESTTOBOOK,STARTDATE,STARTDATETIME,ENDDATETIME,TOTALRECORDS,FLTRDATERANGEFROM,FLTRDATERANGETO] at lucee.runtime.type.QueryImpl.getAt(QueryImpl.java:1140) at lucee.runtime.type.QueryImpl.get(QueryImpl.java:2048) at lucee.runtime.util.VariableUtilImpl.get(VariableUtilImpl.java:278) at lucee.runtime.PageContextImpl.get(PageContextImpl.java:1557) at controllers.event.c_search_cfm92$cf.call(/controllers/event/c.search.cfm:133) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1046) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:938) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:919) at controllers.c_controller_cfm92$cf.call(/controllers/c.controller.cfm:19) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1046) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:938) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:219) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2482) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2468) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2439) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1198) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1144) 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:764) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) 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
string131: request.data.webproperty = application.cfc.utils.functionHandler(argumentCollection=request.args.webproperty).data;<br> 132: //url.wpid = request.data.webproperty.webpropertyid;<br> <b>133: form.addressInput = request.data.webproperty.city;</b><br> 134: form.autosearch = false;<br> 135: url.wpid = request.data.webproperty.webpropertyid;<br>
codePrintPlain
string131: request.data.webproperty = application.cfc.utils.functionHandler(argumentCollection=request.args.webproperty).data; 132: //url.wpid = request.data.webproperty.webpropertyid; 133: form.addressInput = request.data.webproperty.city; 134: form.autosearch = false; 135: url.wpid = request.data.webproperty.webpropertyid;
column
number0
id
string??
line
number133
Raw_Trace
stringcontrollers.event.c_search_cfm92$cf.call(/controllers/event/c.search.cfm:133)
template
stringD:\Hosting\production\out_newpah\www\controllers\event\c.search.cfm
type
stringcfml
2
Struct
codePrintHTML
string17: <br> 18: try {<br> <b>19: include request.mvc.page.controller;</b><br> 20: if (request.ehcache.page.renderout) {<br> 21: getPageContext().getOut().clearBuffer();<br>
codePrintPlain
string17: 18: try { 19: include request.mvc.page.controller; 20: if (request.ehcache.page.renderout) { 21: getPageContext().getOut().clearBuffer();
column
number0
id
string??
line
number19
Raw_Trace
stringcontrollers.c_controller_cfm92$cf.call(/controllers/c.controller.cfm:19)
template
stringD:\Hosting\production\out_newpah\www\controllers\c.controller.cfm
type
stringcfml
type
stringdatabase
where
string