CFCATCH
Catch
Entries: 15 | | additional | | Struct (ordered) | | SQL | | string | SELECT [group].[group], [group].groupID, [group].private, Pages.title, pages.fileID, pages.caption
FROM [wws_hilltownconnect].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 = 198
AND
(
(startdate is not null and startdate <= '2023/10/01 14:21:05' )
OR startdate is NULL
)
AND
(
(enddate is not null and enddate >= '2023/10/01 14:21:05' )
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_hilltownconnect].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 = 198
AND
(
(startdate is not null and startdate <= '2023/10/01 14:21:05' )
OR startdate is NULL
)
AND
(
(enddate is not null and enddate >= '2023/10/01 14:21:05' )
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_hilltownconnect].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 = 198
AND
(
(startdate is not null and startdate <= '2023/10/01 14:21:05' )
OR startdate is NULL
)
AND
(
(enddate is not null and enddate >= '2023/10/01 14:21:05' )
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.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 _layouts._layout_cupola_group_htm$cf$q1.call(/_layouts/_layout_cupola_group.htm:10)
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.call(/OnRequestEnd.cfm:90)
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.call(/box_pages.cfm:37) |
| | template | | string | E:\Sites\WWS\box_pages.cfm |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 8: <cf_box_bannerad area="2"><br>
9: <cf_box_meta head="" delim="<br><br>" area="5"><br>
<b>10: <cf_box_pages head=""></b><br>
11: <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>
12: <br><br>
|
| | codePrintPlain | | string | 8: <cf_box_bannerad area="2">
9: <cf_box_meta head="" delim="<br><br>" area="5">
10: <cf_box_pages head="">
11: <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">
12: <br>
|
| | column | | | id | | | line | | | Raw_Trace | | string | _layouts._layout_cupola_group_htm$cf$q1.call(/_layouts/_layout_cupola_group.htm:10) |
| | template | | string | E:\Sites\WWS\_layouts\_layout_cupola_group.htm |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 88: </cfif><br>
89: <cfif fileexists("#request.d.rootpath#/#listFirst(request.s.sitelayout,".")#_#request.d.thispage#.htm")><br>
<b>90: <cfinclude template="#listFirst(request.s.sitelayout,".")#_#request.d.thispage#.htm"></b><br>
91: <cfoutput><!-- #listFirst(request.s.sitelayout,".")#_#listFirst(request.d.thispage,"_")# --></cfoutput><br>
92: <cfelseif fileexists("#request.d.rootpath#/#request.s.sitelayout#")><br>
|
| | codePrintPlain | | string | 88: </cfif>
89: <cfif fileexists("#request.d.rootpath#/#listFirst(request.s.sitelayout,".")#_#request.d.thispage#.htm")>
90: <cfinclude template="#listFirst(request.s.sitelayout,".")#_#request.d.thispage#.htm">
91: <cfoutput><!-- #listFirst(request.s.sitelayout,".")#_#listFirst(request.d.thispage,"_")# --></cfoutput>
92: <cfelseif fileexists("#request.d.rootpath#/#request.s.sitelayout#")>
|
| | column | | | id | | | line | | | Raw_Trace | | string | onrequestend_cfm$cf.call(/OnRequestEnd.cfm:90) |
| | template | | string | E:\Sites\WWS\OnRequestEnd.cfm |
| | type | |
|
| | type | | | where | |
SESSION
Session Scope (Memory)
Entries: 21 | | cfid | | string | 4a71d4bc-0d0e-4d9c-a757-782fedec3719 |
| | cftoken | | | email | | | foreignkey | | | groupallot | | | L_BANNERAD | | | L_DIRECTORY | | | L_GROUP | | | lastvisit | | Date Time (America/New_York) | | {ts '2023-10-01 14:21:05'} |
| | loggedin | | | login | | | MEMBERGROUPS | | | 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_hilltownconnect_4a71d4bc-0d0e-4d9c-a757-782fedec3719_0 |
| | SHOWEDIT | | | showmember | | | SHOWTOOLBAR | | | timecreated | | Date Time (America/New_York) | | {ts '2023-10-01 14:21:05'} |
| | times_on | | | urltoken | | string | CFID=4a71d4bc-0d0e-4d9c-a757-782fedec3719&CFTOKEN=0 |
| | userID | |
URL
Scope
Entries: 76 | | 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 | | | 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 | |
|