Catch
Entries: 15
additional
Struct (ordered)
SQL
stringWITH recordSet AS ( SELECT row_number() over(order by wpd.webpropertyName asc) as rowNumber ,wpd.webpropertyID ,wpd.companyID ,wpd.webpropertyName ,wpd.webpropertyNameAlias ,wpd.metatitle ,wpd.metadescription ,wpd.metakeywords ,ISNULL(''+cod.baseDomain,'') + ISNULL('/'+cod.webpropertyslug,'') + wpd.slug as slug ,wpd.address1 ,wpd.address2 , ISNULL(wpd.address1,'') + ISNULL(', '+wpd.address2,'') + ISNULL(', '+wpd.city,'') + ISNULL(', '+wpd.postalCode,'') as formattedAddress ,wpd.contactNumber1 ,wpd.lat ,wpd.lng ,wpd.region ,wpd.regionid ,wpd.city ,wpd.postalCode ,ISNULL ( wpd.avatar , '/assets/img/avatar/default_avatar_1.jpg' ) +'?'+replace(convert(varchar(8), wpd.modified, 112)+convert(varchar(8), wpd.modified, 114), ':','') as 'avatar' ,wpd.status ,wpd.openTimes ,wpd.openDate ,cod.companyName ,wpd.refid ,wpd.statusmessage ,wpd.workshopcapacity ,wpd.classcapacity ,bookinghtml ,attributes = STUFF(( SELECT ',' + convert(nvarchar(36),wpa.attributeid) FROM webproperty_attributes wpa WHERE wpa.webpropertyid = wpd.webpropertyID FOR XML PATH('') ), 1, 1, '') ,attributesstr = '{'+ STUFF(( SELECT ',"' + convert(nvarchar(36),wpa.attributeid) + '"={"label"="'+ convert(nvarchar(50),sa.attrname)+'","value"="'+ ISNULL(convert(nvarchar(150),wpa.description),'')+'"}' FROM webproperty_attributes wpa inner join sys_attribute sa on (wpa.attributeid = sa.attributeid) WHERE wpa.webpropertyid = wpd.webpropertyID FOR XML PATH('') ), 1, 1, '') +'}' ,attributesarr = '['+ STUFF(( SELECT ',{"id"="' + convert(nvarchar(36),wpa.attributeid) + '","label"="'+ convert(nvarchar(50),sa.attrname)+'","value"="'+ ISNULL(convert(nvarchar(150),wpa.description),'')+'","highlight"="'+ CAST(wpa.highlight AS varchar) +'"}' FROM webproperty_attributes wpa inner join sys_attribute sa on (wpa.attributeid = sa.attributeid) WHERE wpa.webpropertyid = wpd.webpropertyID and sa.subcategoryid != '352dd397-5414-4c7a-b5c1-bb61adfda1ce' FOR XML PATH('') ), 1, 1, '') +']' FROM webproperty_details wpd inner join company_details cod on (cod.companyid = wpd.companyid) WHERE 0 = 0 and cod.webpropertyslug = 'groom-room' and wpd.active = true AND wpd.webpropertyNameAlias = 'meanwood' ), recordSetCount AS ( SELECT * FROM recordSet ,(SELECT MAX(rowNumber) AS totalRecords FROM recordSet) AS recordCount ) SELECT * FROM recordSetCount
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string15.00.2101
DriverName
stringMicrosoft JDBC Driver 7.2 for SQL Server
DriverVersion
string7.2.2.0
Datasource
stringpah.production
DataSource
stringpah.production
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringInvalid column name 'highlight'.
NativeErrorCode
number207
queryError
stringWITH recordSet AS ( SELECT row_number() over(order by wpd.webpropertyName asc) as rowNumber ,wpd.webpropertyID ,wpd.companyID ,wpd.webpropertyName ,wpd.webpropertyNameAlias ,wpd.metatitle ,wpd.metadescription ,wpd.metakeywords ,ISNULL(''+cod.baseDomain,'') + ISNULL('/'+cod.webpropertyslug,'') + wpd.slug as slug ,wpd.address1 ,wpd.address2 , ISNULL(wpd.address1,'') + ISNULL(', '+wpd.address2,'') + ISNULL(', '+wpd.city,'') + ISNULL(', '+wpd.postalCode,'') as formattedAddress ,wpd.contactNumber1 ,wpd.lat ,wpd.lng ,wpd.region ,wpd.regionid ,wpd.city ,wpd.postalCode ,ISNULL ( wpd.avatar , '/assets/img/avatar/default_avatar_1.jpg' ) +'?'+replace(convert(varchar(8), wpd.modified, 112)+convert(varchar(8), wpd.modified, 114), ':','') as 'avatar' ,wpd.status ,wpd.openTimes ,wpd.openDate ,cod.companyName ,wpd.refid ,wpd.statusmessage ,wpd.workshopcapacity ,wpd.classcapacity ,bookinghtml ,attributes = STUFF(( SELECT ',' + convert(nvarchar(36),wpa.attributeid) FROM webproperty_attributes wpa WHERE wpa.webpropertyid = wpd.webpropertyID FOR XML PATH('') ), 1, 1, '') ,attributesstr = '{'+ STUFF(( SELECT ',"' + convert(nvarchar(36),wpa.attributeid) + '"={"label"="'+ convert(nvarchar(50),sa.attrname)+'","value"="'+ ISNULL(convert(nvarchar(150),wpa.description),'')+'"}' FROM webproperty_attributes wpa inner join sys_attribute sa on (wpa.attributeid = sa.attributeid) WHERE wpa.webpropertyid = wpd.webpropertyID FOR XML PATH('') ), 1, 1, '') +'}' ,attributesarr = '['+ STUFF(( SELECT ',{"id"="' + convert(nvarchar(36),wpa.attributeid) + '","label"="'+ convert(nvarchar(50),sa.attrname)+'","value"="'+ ISNULL(convert(nvarchar(150),wpa.description),'')+'","highlight"="'+ CAST(wpa.highlight AS varchar) +'"}' FROM webproperty_attributes wpa inner join sys_attribute sa on (wpa.attributeid = sa.attributeid) WHERE wpa.webpropertyid = wpd.webpropertyID and sa.subcategoryid != '352dd397-5414-4c7a-b5c1-bb61adfda1ce' FOR XML PATH('') ), 1, 1, '') +']' FROM webproperty_details wpd inner join company_details cod on (cod.companyid = wpd.companyid) WHERE 0 = 0 and cod.webpropertyslug = 'groom-room' and wpd.active = true AND wpd.webpropertyNameAlias = 'meanwood' ), recordSetCount AS ( SELECT * FROM recordSet ,(SELECT MAX(rowNumber) AS totalRecords FROM recordSet) AS recordCount ) SELECT * FROM recordSetCount
Sql
stringWITH recordSet AS ( SELECT row_number() over(order by wpd.webpropertyName asc) as rowNumber ,wpd.webpropertyID ,wpd.companyID ,wpd.webpropertyName ,wpd.webpropertyNameAlias ,wpd.metatitle ,wpd.metadescription ,wpd.metakeywords ,ISNULL(''+cod.baseDomain,'') + ISNULL('/'+cod.webpropertyslug,'') + wpd.slug as slug ,wpd.address1 ,wpd.address2 , ISNULL(wpd.address1,'') + ISNULL(', '+wpd.address2,'') + ISNULL(', '+wpd.city,'') + ISNULL(', '+wpd.postalCode,'') as formattedAddress ,wpd.contactNumber1 ,wpd.lat ,wpd.lng ,wpd.region ,wpd.regionid ,wpd.city ,wpd.postalCode ,ISNULL ( wpd.avatar , '/assets/img/avatar/default_avatar_1.jpg' ) +'?'+replace(convert(varchar(8), wpd.modified, 112)+convert(varchar(8), wpd.modified, 114), ':','') as 'avatar' ,wpd.status ,wpd.openTimes ,wpd.openDate ,cod.companyName ,wpd.refid ,wpd.statusmessage ,wpd.workshopcapacity ,wpd.classcapacity ,bookinghtml ,attributes = STUFF(( SELECT ',' + convert(nvarchar(36),wpa.attributeid) FROM webproperty_attributes wpa WHERE wpa.webpropertyid = wpd.webpropertyID FOR XML PATH('') ), 1, 1, '') ,attributesstr = '{'+ STUFF(( SELECT ',"' + convert(nvarchar(36),wpa.attributeid) + '"={"label"="'+ convert(nvarchar(50),sa.attrname)+'","value"="'+ ISNULL(convert(nvarchar(150),wpa.description),'')+'"}' FROM webproperty_attributes wpa inner join sys_attribute sa on (wpa.attributeid = sa.attributeid) WHERE wpa.webpropertyid = wpd.webpropertyID FOR XML PATH('') ), 1, 1, '') +'}' ,attributesarr = '['+ STUFF(( SELECT ',{"id"="' + convert(nvarchar(36),wpa.attributeid) + '","label"="'+ convert(nvarchar(50),sa.attrname)+'","value"="'+ ISNULL(convert(nvarchar(150),wpa.description),'')+'","highlight"="'+ CAST(wpa.highlight AS varchar) +'"}' FROM webproperty_attributes wpa inner join sys_attribute sa on (wpa.attributeid = sa.attributeid) WHERE wpa.webpropertyid = wpd.webpropertyID and sa.subcategoryid != '352dd397-5414-4c7a-b5c1-bb61adfda1ce' FOR XML PATH('') ), 1, 1, '') +']' FROM webproperty_details wpd inner join company_details cod on (cod.companyid = wpd.companyid) WHERE 0 = 0 and cod.webpropertyslug = 'groom-room' and wpd.active = true AND wpd.webpropertyNameAlias = 'meanwood' ), recordSetCount AS ( SELECT * FROM recordSet ,(SELECT MAX(rowNumber) AS totalRecords FROM recordSet) AS recordCount ) SELECT * FROM recordSetCount
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: Invalid column name 'highlight'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1621) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:592) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:522) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2935) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:503) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:328) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:296) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1134) at lucee.runtime.tag.Query._doEndTag(Query.java:699) at lucee.runtime.tag.Query.doEndTag(Query.java:565) at models.webproperty_cfc$cf$3iv.udfCall1(/models/webproperty.cfc:538) at models.webproperty_cfc$cf$3iv.udfCall(/models/webproperty.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:585) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1951) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1784) at models.utils_cfc$cf.udfCall5(/models/utils.cfc:1156) at models.utils_cfc$cf.udfCall(/models/utils.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:585) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1951) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1784) at controllers.c_webproperty_profile_cfm736$cf.call(/controllers/c.webproperty.profile.cfm:142) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1046) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:938) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:219) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2482) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2468) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2439) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1198) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1144) 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:764) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
1
Struct
codePrintHTML
string536: <br> 537: <br> <b>538: &lt;/cfquery&gt;</b><br> 539: &lt;/cfif&gt;<br> 540: &lt;cfcatch&gt;<br>
codePrintPlain
string536: 537: 538: </cfquery> 539: </cfif> 540: <cfcatch>
column
number0
id
string??
line
number538
Raw_Trace
stringmodels.webproperty_cfc$cf$3iv.udfCall1(/models/webproperty.cfc:538)
template
stringD:\Hosting\production\out_newpah\www\models\webproperty.cfc
type
stringcfml
2
Struct
codePrintHTML
string1154: */<br> 1155: cfc.webproperty = new models.webproperty();<br> <b>1156: variables.responseOBJ = cfc.webproperty[#ev.function#](argumentCollection=arguments);</b><br> 1157: /*<br> 1158: var obj = createObject(&quot;component&quot;,&quot;models.webproperty&quot;);<br>
codePrintPlain
string1154: */ 1155: cfc.webproperty = new models.webproperty(); 1156: variables.responseOBJ = cfc.webproperty[#ev.function#](argumentCollection=arguments); 1157: /* 1158: var obj = createObject("component","models.webproperty");
column
number0
id
string??
line
number1156
Raw_Trace
stringmodels.utils_cfc$cf.udfCall5(/models/utils.cfc:1156)
template
stringD:\Hosting\production\out_newpah\www\models\utils.cfc
type
stringcfml
3
Struct
codePrintHTML
string140: */<br> 141: cfc.utils = new models.utils();<br> <b>142: request.data.webproperty = cfc.utils.functionHandler(argumentCollection = args.webproperty).data</b><br> 143: //cfcwebproperty = new models.webproperty();<br> 144: //cfcutils= new models.utils();<br>
codePrintPlain
string140: */ 141: cfc.utils = new models.utils(); 142: request.data.webproperty = cfc.utils.functionHandler(argumentCollection = args.webproperty).data 143: //cfcwebproperty = new models.webproperty(); 144: //cfcutils= new models.utils();
column
number0
id
string??
line
number142
Raw_Trace
stringcontrollers.c_webproperty_profile_cfm736$cf.call(/controllers/c.webproperty.profile.cfm:142)
template
stringD:\Hosting\production\out_newpah\www\controllers\c.webproperty.profile.cfm
type
stringcfml
type
stringdatabase
where
string