
CFCATCH
Catch Entries: 15 | additional | Struct (ordered) | SQL | string | SELECT [group].[group], [group].groupID, [group].private, Pages.title, pages.fileID, pages.caption
FROM [wws_leverettma].dbo.[group], pages, pagescollection
WHERE Pages.ShowInBox = 1
AND Pages.published = 1
AND [group].groupID = Pages.groupID
AND Pages.pagesCollectionID = pagesCollection.pagesCollectionID
AND [group].groupID = 185
AND
(
(startdate is not null and startdate <= '2023/12/09 17:28:43' )
OR startdate is NULL
)
AND
(
(enddate is not null and enddate >= '2023/12/09 17:28:43' )
OR enddate is NULL
)
ORDER BY pagesCollection.sortorder, Pages.sortorder, pages.fileID desc |
| DatabaseName | string | Microsoft SQL Server |
| DatabaseVersion | | DriverName | string | Microsoft JDBC Driver 4.0 for SQL Server |
| DriverVersion | | Datasource | |
| DataSource | | Detail | | ErrorCode | | Extended_Info | | ExtendedInfo | | Message | string | Invalid object name 'pages'. |
| NativeErrorCode | | queryError | string | SELECT [group].[group], [group].groupID, [group].private, Pages.title, pages.fileID, pages.caption
FROM [wws_leverettma].dbo.[group], pages, pagescollection
WHERE Pages.ShowInBox = 1
AND Pages.published = 1
AND [group].groupID = Pages.groupID
AND Pages.pagesCollectionID = pagesCollection.pagesCollectionID
AND [group].groupID = 185
AND
(
(startdate is not null and startdate <= '2023/12/09 17:28:43' )
OR startdate is NULL
)
AND
(
(enddate is not null and enddate >= '2023/12/09 17:28:43' )
OR enddate is NULL
)
ORDER BY pagesCollection.sortorder, Pages.sortorder, pages.fileID desc |
| Sql | string | SELECT [group].[group], [group].groupID, [group].private, Pages.title, pages.fileID, pages.caption
FROM [wws_leverettma].dbo.[group], pages, pagescollection
WHERE Pages.ShowInBox = 1
AND Pages.published = 1
AND [group].groupID = Pages.groupID
AND Pages.pagesCollectionID = pagesCollection.pagesCollectionID
AND [group].groupID = 185
AND
(
(startdate is not null and startdate <= '2023/12/09 17:28:43' )
OR startdate is NULL
)
AND
(
(enddate is not null and enddate >= '2023/12/09 17:28:43' )
OR enddate is NULL
)
ORDER BY pagesCollection.sortorder, Pages.sortorder, pages.fileID desc |
| SQLState | | StackTrace | string | lucee.runtime.exp.DatabaseException: Invalid object name 'pages'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:662)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:319)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:273)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:227)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1112)
at lucee.runtime.tag.Query._doEndTag(Query.java:686)
at lucee.runtime.tag.Query.doEndTag(Query.java:553)
at box_pages_cfm$cf$24v.call(/box_pages.cfm:37)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:829)
at lucee.runtime.tag.CFTag.doInclude(CFTag.java:319)
at lucee.runtime.tag.CFTag.cfmlStartTag(CFTag.java:245)
at lucee.runtime.tag.CFTag.doStartTag(CFTag.java:179)
at content.netsite_1107._layout_leverett_htm$cf$25i.call(/Content/netSite_1107/_layout_leverett.htm:9)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:818)
at onrequestend_cfm$cf$23u.call(/OnRequestEnd.cfm:94)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:83)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2416)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2406)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2381)
at lucee.runtime.engine.Request.exe(Request.java:43)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1170)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116)
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.ajp.AjpProcessor.service(AjpProcessor.java:432)
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:1590)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
|
| TagContext | Array | 1 | Struct | codePrintHTML | string | 35: )<br>
36: ORDER BY <cfif len(trim(attributes.sortorder))>#attributes.sortorder#, </cfif>pagesCollection.sortorder, Pages.sortorder, pages.fileID desc<br>
<b>37: </cfquery></b><br>
38: <cfoutput query="qs_pages"><br>
39: <div class="box_pages"<cfif len(trim(attributes.style))> style="#attributes.style#"</cfif>><br>
|
| codePrintPlain | string | 35: )
36: ORDER BY <cfif len(trim(attributes.sortorder))>#attributes.sortorder#, </cfif>pagesCollection.sortorder, Pages.sortorder, pages.fileID desc
37: </cfquery>
38: <cfoutput query="qs_pages">
39: <div class="box_pages"<cfif len(trim(attributes.style))> style="#attributes.style#"</cfif>>
|
| column | | id | | line | | Raw_Trace | string | box_pages_cfm$cf$24v.call(/box_pages.cfm:37) |
| template | string | E:\Sites\WWS\box_pages.cfm |
| type | |
| 2 | Struct | codePrintHTML | string | 7: <cf_box_bannerad area="2"><br>
8: <cf_box_meta head="" delim="<br><br>" area="5"><br>
<b>9: <cf_box_pages head=""></b><br>
10: <cf_box_nav_group div="side" head="" mode="multi" sub_char="+" depth="3,4,5,6,7,8,9,10" delim_start="" delim="<br>" show_if_empty="no" show_all="no" show_siblings="no"><br>
11: <br><br>
|
| codePrintPlain | string | 7: <cf_box_bannerad area="2">
8: <cf_box_meta head="" delim="<br><br>" area="5">
9: <cf_box_pages head="">
10: <cf_box_nav_group div="side" head="" mode="multi" sub_char="+" depth="3,4,5,6,7,8,9,10" delim_start="" delim="<br>" show_if_empty="no" show_all="no" show_siblings="no">
11: <br>
|
| column | | id | | line | | Raw_Trace | string | content.netsite_1107._layout_leverett_htm$cf$25i.call(/Content/netSite_1107/_layout_leverett.htm:9) |
| template | string | E:\Sites\WWS\Content\NetSite_1107\_layout_leverett.htm |
| type | |
| 3 | Struct | codePrintHTML | string | 92: <cfelseif fileexists("#request.d.rootpath#/#request.s.sitelayout#")><br>
93: <!---<cfoutput>#request.d.rootpath# / #request.s.sitelayout#</cfoutput>---><br>
<b>94: <cfinclude template="#request.s.sitelayout#"></b><br>
95: <cfoutput><!-- #listFirst(request.s.sitelayout,".")# --></cfoutput><br>
96: <cfelse><br>
|
| codePrintPlain | string | 92: <cfelseif fileexists("#request.d.rootpath#/#request.s.sitelayout#")>
93: <!---<cfoutput>#request.d.rootpath# / #request.s.sitelayout#</cfoutput>--->
94: <cfinclude template="#request.s.sitelayout#">
95: <cfoutput><!-- #listFirst(request.s.sitelayout,".")# --></cfoutput>
96: <cfelse>
|
| column | | id | | line | | Raw_Trace | string | onrequestend_cfm$cf$23u.call(/OnRequestEnd.cfm:94) |
| template | string | E:\Sites\WWS\OnRequestEnd.cfm |
| type | |
|
| type | | where | |
SESSION
Session Scope (Memory) Entries: 22 | cfid | string | 19819615-0ecf-4262-a6ab-89d9e499ae17 |
| cftoken | | email | | foreignkey | | groupallot | | L_BANNERAD | | L_DIRECTORY | | L_GROUP | | lastvisit | Date Time (America/New_York) | {ts '2023-12-09 16:28:41'} |
| loggedin | | login | | MEMBERGROUPS | | PUB | | ROLE | Struct | Bad_Email | | Banned | | EDITOR | | G | Struct Entries: 15 | ArchiveArticle | Struct | Delete | | Edit | | Manage | | Publish | | Submit | | Subscribe | | View | |
| calendar | Struct | Delete | | Edit | | Manage | | Publish | | Submit | | Subscribe | | View | |
| corkboard | Struct | Delete | | Edit | | Manage | | Publish | | Submit | | Subscribe | | View | |
| directory | Struct | Delete | | Edit | | Manage | | Publish | | Submit | | Subscribe | | View | |
| files | Struct | Delete | | Edit | | Manage | | Publish | | Submit | | Subscribe | | View | |
| forms | Struct | Delete | | Edit | | Manage | | Publish | | Submit | | Subscribe | | View | |
| groupAdmin | | images | Struct | Delete | | Edit | | Manage | | Publish | | Submit | | Subscribe | | View | |
| mediamixer | Struct | Delete | | Edit | | Manage | | Publish | | Submit | | Subscribe | | View | |
| Member | | pages | Struct | Delete | | Edit | | Manage | | Publish | | Submit | | Subscribe | | View | |
| poll | Struct | Delete | | Edit | | Manage | | Publish | | Submit | | Subscribe | | View | |
| SplashEditor | | Subscriber | | video | Struct | Delete | | Edit | | Manage | | Publish | | Submit | | Subscribe | | View | |
|
| Locked | | MANAGER | | Moderated | | siteAdmin | | Verified | |
| sessionid | string | wws_leverettma_19819615-0ecf-4262-a6ab-89d9e499ae17_0 |
| SHOWEDIT | | showmember | | SHOWTOOLBAR | | timecreated | Date Time (America/New_York) | {ts '2023-12-09 16:28:41'} |
| times_on | | urltoken | string | CFID=19819615-0ecf-4262-a6ab-89d9e499ae17&CFTOKEN=0 |
| userID | |
URL
Scope Entries: 77 | adv | | b | | bookmark | | c | | cache | | close | | cs | | datefrom | | daterequest | | datestat | | dateto | | debug | | digest | | dt | | edit | | end | | error | | f | | feID | | fiu | | foreignkey | | g | | gg | | gm | | gpt | | gs | | gsort | | ID | | keyfind | | locationID | | m | | ma | | member | | msg | | mt | | n | | name | | new | | newthread | | num | | orderby | string | corkboard.postdate desc, corkboard.corkboardID desc |
| p | | page | | path | | pid | | planID | | print | | pupID | | pw | | repid | | return | | return_url | | scope | | searchterm | | show | | showcal | | siteerror | | sortorder | string | [date] DESC, [time] DESC |
| st | | start | | stats | | subject | | subjectID | | submit | | success | | t | | tg | | thispage | | thread | | u | | un | | userID | | vardump | | vcid | | view | | window | | wrap | |
FORM
Scope | edit | | emailTest | | groupid | | ID | | planID | | published | | return_url | | run | | upload_file | |
|