Catch
Entries: 15

additional

Struct (ordered)

SQL

string

WITH 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

string

Microsoft SQL Server

DatabaseVersion

string

15.00.2101

DriverName

string

Microsoft JDBC Driver 7.2 for SQL Server

DriverVersion

string

7.2.2.0

Datasource

string

pah.production

DataSource

string

pah.production

Detail

string

ErrorCode

string

Extended_Info

string

ExtendedInfo

string

Message

string

Invalid column name 'highlight'.

NativeErrorCode

number

207

queryError

string

Sql

string

SQLState

string

S0001

StackTrace

string

lucee.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

Struct

codePrintHTML

string

536: 537: 538: </cfquery> 539: </cfif> 540: <cfcatch>

codePrintPlain

string

536: 537: 538: </cfquery> 539: </cfif> 540: <cfcatch>

column

number

string

line

number

538

Raw_Trace

string

models.webproperty_cfc$cf$3iv.udfCall1(/models/webproperty.cfc:538)

template

string

D:\Hosting\production\out_newpah\www\models\webproperty.cfc

type

string

cfml

Struct

codePrintHTML

string

1154: */ 1155: cfc.webproperty = new models.webproperty(); 1156: variables.responseOBJ = cfc.webproperty[#ev.function#](argumentCollection=arguments); 1157: /* 1158: var obj = createObject("component","models.webproperty");

codePrintPlain

string

1154: */ 1155: cfc.webproperty = new models.webproperty(); 1156: variables.responseOBJ = cfc.webproperty[#ev.function#](argumentCollection=arguments); 1157: /* 1158: var obj = createObject("component","models.webproperty");

column

number

string

line

number

1156

Raw_Trace

string

models.utils_cfc$cf.udfCall5(/models/utils.cfc:1156)

template

string

D:\Hosting\production\out_newpah\www\models\utils.cfc

type

string

cfml

Struct

codePrintHTML

string

140: */ 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();

codePrintPlain

string

140: */ 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

number

string

line

number

142

Raw_Trace

string

controllers.c_webproperty_profile_cfm736$cf.call(/controllers/c.webproperty.profile.cfm:142)

template

string

D:\Hosting\production\out_newpah\www\controllers\c.webproperty.profile.cfm

type

string

cfml

type

string

database

where

string