|
CFCATCH
Catch
Entries: 15 | | additional | | Struct (ordered) | | SQL | | string | SELECT [group].[group], [group].groupID, [group].private, Pages.title, pages.fileID, pages.caption
FROM [wws_NorthfieldBernardston].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/03/29 13:30:10' )
OR startdate is NULL
)
AND
(
(enddate is not null and enddate >= '2023/03/29 13:30:10' )
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_NorthfieldBernardston].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/03/29 13:30:10' )
OR startdate is NULL
)
AND
(
(enddate is not null and enddate >= '2023/03/29 13:30:10' )
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_NorthfieldBernardston].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/03/29 13:30:10' )
OR startdate is NULL
)
AND
(
(enddate is not null and enddate >= '2023/03/29 13:30:10' )
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$xz.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_1113._layout_nb_htm$cf$13y.call(/Content/netSite_1113/_layout_nb.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$xl.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$xz.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_1113._layout_nb_htm$cf$13y.call(/Content/netSite_1113/_layout_nb.htm:9) |
| | template | | string | E:\Sites\WWS\Content\NetSite_1113\_layout_nb.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$xl.call(/OnRequestEnd.cfm:94) |
| | template | | string | E:\Sites\WWS\OnRequestEnd.cfm |
| | type | |
|
| | type | | | where | |
SESSION
Session Scope (Memory)
Entries: 22 | | cfid | | string | 9324687c-5cb4-4e51-a6c1-f30370f291ae |
| | cftoken | | | email | | | foreignkey | | | groupallot | | | L_BANNERAD | | | L_DIRECTORY | | | L_GROUP | | | lastvisit | | Date Time (America/New_York) | | {ts '2023-03-29 13:30:09'} |
| | 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_NorthfieldBernardston_9324687c-5cb4-4e51-a6c1-f30370f291ae_0 |
| | SHOWEDIT | | | showmember | | | SHOWTOOLBAR | | | timecreated | | Date Time (America/New_York) | | {ts '2023-03-29 13:30:09'} |
| | times_on | | | urltoken | | string | CFID=9324687c-5cb4-4e51-a6c1-f30370f291ae&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 | |
|