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 | | DriverName | string | Microsoft JDBC Driver 7.2 for SQL Server |
| DriverVersion | | Datasource | |
|
DataSource | |
Detail | |
ErrorCode | |
Extended_Info | |
ExtendedInfo | |
Message | string | Invalid column name 'highlight'. |
|
NativeErrorCode | |
queryError | 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 |
|
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 |
|
SQLState | |
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 | 1 | Struct | codePrintHTML | string | 536: <br>
537: <br>
<b>538: </cfquery></b><br>
539: </cfif><br>
540: <cfcatch><br>
|
| codePrintPlain | string | 536:
537:
538: </cfquery>
539: </cfif>
540: <cfcatch>
|
| column | | id | | line | | 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 | |
| 2 | Struct | codePrintHTML | string | 1154: */<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("component","models.webproperty");<br>
|
| 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 | | id | | line | | Raw_Trace | string | models.utils_cfc$cf.udfCall5(/models/utils.cfc:1156) |
| template | string | D:\Hosting\production\out_newpah\www\models\utils.cfc |
| type | |
| 3 | Struct | codePrintHTML | string | 140: */<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 | 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 | | id | | line | | 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 | |
|
|
type | |
where | |