CFCATCH

Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT title, subtitle, fileID, groupID, published, caption, showtitle, userid FROM Pages WHERE pagescollectionID = 111 AND published = 1 AND groupID = 202 AND ( (startdate is not null and startdate <= '2021/10/17 07:45:13' ) OR startdate is NULL ) AND ( (enddate is not null and enddate >= '2021/10/17 07:45:13' ) OR enddate is NULL ) ORDER BY sortorder, posteddate desc
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string11.00.5058
DriverName
stringMicrosoft JDBC Driver 4.0 for SQL Server
DriverVersion
string4.0.2206.100
Datasource
stringwws_hilltownconnect
DataSource
stringwws_hilltownconnect
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringInvalid column name 'showtitle'.
NativeErrorCode
number207
queryError
stringSELECT title, subtitle, fileID, groupID, published, caption, showtitle, userid FROM Pages WHERE pagescollectionID = 111 AND published = 1 AND groupID = 202 AND ( (startdate is not null and startdate <= '2021/10/17 07:45:13' ) OR startdate is NULL ) AND ( (enddate is not null and enddate >= '2021/10/17 07:45:13' ) OR enddate is NULL ) ORDER BY sortorder, posteddate desc
Sql
stringSELECT title, subtitle, fileID, groupID, published, caption, showtitle, userid FROM Pages WHERE pagescollectionID = 111 AND published = 1 AND groupID = 202 AND ( (startdate is not null and startdate <= '2021/10/17 07:45:13' ) OR startdate is NULL ) AND ( (enddate is not null and enddate >= '2021/10/17 07:45:13' ) OR enddate is NULL ) ORDER BY sortorder, posteddate desc
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: Invalid column name 'showtitle'. 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 pages_cfm$cf$bq.call(/pages.cfm:64) 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
string62: )<br> 63: ORDER BY sortorder, posteddate desc<br> <b>64: &lt;/cfquery&gt;</b><br> 65: &lt;cfif qs_p2.recordCount&gt;<br> 66: &lt;div class=&quot;collection_item&quot; &lt;cfif not url.id&gt;style=&quot;padding-left:10px;&quot;&lt;/cfif&gt;&gt;<br>
codePrintPlain
string62: ) 63: ORDER BY sortorder, posteddate desc 64: </cfquery> 65: <cfif qs_p2.recordCount> 66: <div class="collection_item" <cfif not url.id>style="padding-left:10px;"</cfif>>
column
number0
id
string??
line
number64
Raw_Trace
stringpages_cfm$cf$bq.call(/pages.cfm:64)
template
stringE:\Sites\WWS\pages.cfm
type
stringcfml
type
stringdatabase
where
string

SESSION

Session Scope (Memory)
Entries: 22
cfid
string767d989c-5785-440f-8404-b50bcf1aa8e4
cftoken
string0
email
string
foreignkey
string
groupallot
string0
L_BANNERAD
string
L_DIRECTORY
number0
L_GROUP
number0
lastvisit
Date Time (America/New_York)
{ts '2021-10-17 07:45:13'}
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_hilltownconnect_767d989c-5785-440f-8404-b50bcf1aa8e4_0
SHOWEDIT
number1
showmember
string0
SHOWTOOLBAR
number1
timecreated
Date Time (America/New_York)
{ts '2021-10-17 07:45:13'}
times_on
string0
urltoken
stringCFID=767d989c-5785-440f-8404-b50bcf1aa8e4&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
string10/17/2021
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
number202
gg
number0
gm
string
gpt
number32
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
string202
pid
string0
planID
number0
print
number0
pupID
string0
pw
string
repid
string
return
stringdisplay
return_url
string
scope
number202
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
number202
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
number202
ID
stringurl.id
planID
string0
published
string0
return_url
string
run
string0
upload_file
string