CFCATCH

Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT count (*) as c FROM [wws_hampmusic].dbo.files as v, filescollection as vc WHERE v.filescollectionID = vc.filescollectionID AND v.published = 1 AND vc.archived = 0 AND v.groupID = 201
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string11.00.5058
DriverName
stringMicrosoft JDBC Driver 4.0 for SQL Server
DriverVersion
string4.0.2206.100
Datasource
stringManager_WWS
DataSource
stringManager_WWS
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringInvalid object name 'filescollection'.
NativeErrorCode
number208
queryError
stringSELECT count (*) as c FROM [wws_hampmusic].dbo.files as v, filescollection as vc WHERE v.filescollectionID = vc.filescollectionID AND v.published = 1 AND vc.archived = 0 AND v.groupID = 201
Sql
stringSELECT count (*) as c FROM [wws_hampmusic].dbo.files as v, filescollection as vc WHERE v.filescollectionID = vc.filescollectionID AND v.published = 1 AND vc.archived = 0 AND v.groupID = 201
SQLState
stringS0002
StackTrace
stringlucee.runtime.exp.DatabaseException: Invalid object name 'filescollection'. 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 fileviews_cfm$cf$u6.call(/fileViews.cfm:36) 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 files_cfm$cf$z4.call(/files.cfm:2) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837) at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:64) 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
string34: &lt;cfif url.g&gt;AND v.groupID = #url.g#&lt;/cfif&gt;<br> 35: &lt;cfif url.userid&gt;AND v.userID = #url.userid#&lt;/cfif&gt;<br> <b>36: &lt;/cfquery&gt;</b><br> 37: &lt;cfif url.view eq &quot;&quot;&gt;<br> 38: &lt;cfset url.view = request.f[request.d.thispage][&quot;viewmode&quot;]&gt;<br>
codePrintPlain
string34: <cfif url.g>AND v.groupID = #url.g#</cfif> 35: <cfif url.userid>AND v.userID = #url.userid#</cfif> 36: </cfquery> 37: <cfif url.view eq ""> 38: <cfset url.view = request.f[request.d.thispage]["viewmode"]>
column
number0
id
string??
line
number36
Raw_Trace
stringfileviews_cfm$cf$u6.call(/fileViews.cfm:36)
template
stringE:\Sites\WWS\fileViews.cfm
type
stringcfml
2
Struct
codePrintHTML
string1: &lt;cfsavecontent variable=&quot;request.pagecontent&quot;&gt;<br> <b>2: &lt;cfinclude template=&quot;fileViews.cfm&quot;&gt;</b><br> 3: &lt;/cfsavecontent&gt;<br> 4: <br>
codePrintPlain
string1: <cfsavecontent variable="request.pagecontent"> 2: <cfinclude template="fileViews.cfm"> 3: </cfsavecontent> 4:
column
number0
id
string??
line
number2
Raw_Trace
stringfiles_cfm$cf$z4.call(/files.cfm:2)
template
stringE:\Sites\WWS\files.cfm
type
stringcfml
type
stringdatabase
where
string

SESSION

Session Scope (Memory)
Entries: 22
cfid
string50458cd6-4bbc-43a6-826d-515f14c59cab
cftoken
string0
email
string
foreignkey
string
groupallot
string0
L_BANNERAD
string
L_DIRECTORY
number0
L_GROUP
number0
lastvisit
Date Time (America/New_York)
{ts '2022-06-28 21:35:31'}
loggedin
stringno
login
string
MEMBERGROUPS
string
PUB
number0
ROLE
Struct
Bad_Email
number0
Banned
number0
EDITOR
number0
G
Struct
Entries: 15
ArchiveArticle
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
calendar
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
corkboard
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
directory
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
files
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
forms
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
groupAdmin
number0
images
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
mediamixer
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
Member
number0
pages
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
poll
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
SplashEditor
number0
Subscriber
number0
video
Struct
Delete
number0
Edit
number0
Manage
number0
Publish
number0
Submit
number0
Subscribe
number0
View
number0
Locked
number0
MANAGER
number0
Moderated
number0
siteAdmin
number0
Verified
number0
sessionid
stringwws_hampmusic_50458cd6-4bbc-43a6-826d-515f14c59cab_0
SHOWEDIT
number1
showmember
string0
SHOWTOOLBAR
number1
timecreated
Date Time (America/New_York)
{ts '2022-06-28 21:35:31'}
times_on
string0
urltoken
stringCFID=50458cd6-4bbc-43a6-826d-515f14c59cab&CFTOKEN=0
userID
string0

URL

Scope
Entries: 76
adv
string0
b
string0
bookmark
string0
c
number0
cache
string
close
string0
cs
number0
datefrom
string
daterequest
string06/28/2022
datestat
string
dateto
string
debug
string0
digest
number0
dt
number0
edit
string
end
string
error
string
f
string0
feID
string0
fiu
string
foreignkey
string
g
number201
gg
string201
gm
string
gpt
number31
gs
string
gsort
stringsitesort
ID
number0
keyfind
string
locationID
string0
m
number0
ma
string0
member
string
msg
string
mt
string0
n
number0
name
string
new
stringno
newthread
string0
num
number25
p
string0
page
string
path
string201
pid
string0
planID
number0
print
number0
pupID
string0
pw
string
repid
string
return
stringdisplay
return_url
string
scope
number201
searchterm
string
show
string
showcal
number1
siteerror
string
sortorder
string[date] DESC, [time] DESC
st
string1
start
string0
stats
stringfull
subject
string
subjectID
string0
submit
string
success
string0
t
number0
tg
number201
thispage
string
thread
number0
u
number0
un
string
userID
number0
vardump
string0
vcid
number0
view
string
window
stringmainPage
wrap
string1

FORM

Scope
edit
string
emailTest
string0
groupid
number201
ID
stringurl.id
planID
string0
published
string0
return_url
string
run
string0
upload_file
string