Catch
Entries: 18 |
| additional | | Struct (ordered) | | SQL | | string | SELECT ad.id as alterationID,ad.category_id,ad.product_id,ad.alteration_name,ppl.product_price,ad.alteration_description,ad.alteration_ext,ad.alteration_color
FROM alteration_details ad
INNER JOIN product_price_levels ppl ON ad.id=ppl.alteration_id AND ppl.price_level_id= 1
WHERE ad.product_id=271 |
|
|
| Cause | Struct
Entries: 15 | | additional | | Struct (ordered) | | SQL | | string | SELECT ad.id as alterationID,ad.category_id,ad.product_id,ad.alteration_name,ppl.product_price,ad.alteration_description,ad.alteration_ext,ad.alteration_color
FROM alteration_details ad
INNER JOIN product_price_levels ppl ON ad.id=ppl.alteration_id AND ppl.price_level_id= 1
WHERE ad.product_id=271 |
|
| | DataSource | | | Detail | | string | available columns are [ALTERATIONID, CATEGORY_ID, PRODUCT_ID, ALTERATION_NAME, PRODUCT_PRICE, ALTERATION_DESCRIPTION, ALTERATION_EXT, ALTERATION_COLOR] |
| | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | Message | | string | Column [PRICE_LEVEL] not found in query |
| | NativeErrorCode | | | queryError | | string | SELECT ad.id as alterationID,ad.category_id,ad.product_id,ad.alteration_name,ppl.product_price,ad.alteration_description,ad.alteration_ext,ad.alteration_color
FROM alteration_details ad
INNER JOIN product_price_levels ppl ON ad.id=ppl.alteration_id AND ppl.price_level_id= 1
WHERE ad.product_id=271 |
| | Sql | | string | SELECT ad.id as alterationID,ad.category_id,ad.product_id,ad.alteration_name,ppl.product_price,ad.alteration_description,ad.alteration_ext,ad.alteration_color
FROM alteration_details ad
INNER JOIN product_price_levels ppl ON ad.id=ppl.alteration_id AND ppl.price_level_id= 1
WHERE ad.product_id=271 |
| | SQLState | | | StackTrace | | string | lucee.runtime.exp.DatabaseException: Column [PRICE_LEVEL] not found in query
at lucee.runtime.type.QueryImpl.getAt(QueryImpl.java:1149)
at lucee.runtime.type.QueryImpl.get(QueryImpl.java:2076)
at lucee.runtime.util.VariableUtilImpl.get(VariableUtilImpl.java:280)
at lucee.runtime.PageContextImpl.vs(PageContextImpl.java:1397)
at model.gateway.sitemanager_cfc$cf$3.udfCall5(/model/gateway/siteManager.cfc:1197)
at model.gateway.sitemanager_cfc$cf$3.udfCall(/model/gateway/siteManager.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:723)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2120)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2107)
at model.service.sitemanager_cfc$cf$2.udfCall4(/model/service/siteManager.cfc:228)
at model.service.sitemanager_cfc$cf$2.udfCall(/model/service/siteManager.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:723)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2120)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2107)
at layouts.sitelayouts.siteproductdisplay_cfm$cf.call(/layouts/siteLayouts/siteProductDisplay.cfm:176)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987)
at views.productdetailsview.productdetails_cfm$cf.call(/views/productdetailsview/productdetails.cfm:1)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987)
at framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993)
at framework.one_cfc$cf.udfCall(/framework/one.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075)
at framework.one_cfc$cf.udfCall6(/framework/one.cfc:921)
at framework.one_cfc$cf.udfCall(/framework/one.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:477)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2810)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2797)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2768)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1109)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1066)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:130)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:79)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
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:420)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:59)
at java.base/java.lang.Thread.run(Unknown Source)
|
| | TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 1195: SELECT ad.id as alterationID,ad.category_id,ad.product_id,ad.alteration_name,ppl.product_price,ad.alteration_description,ad.alteration_ext,ad.alteration_color<br>
1196: FROM alteration_details ad<br>
<b>1197: INNER JOIN product_price_levels ppl ON ad.id=ppl.alteration_id AND ppl.price_level_id= #VARIABLES.siteLevelDetails.price_level#</b><br>
1198: WHERE ad.product_id=<cfqueryparam value="#ARGUMENTS.productID#" cfsqltype="cf_sql_bigint" ><br>
1199: </cfquery><br>
|
| | codePrintPlain | | string | 1195: SELECT ad.id as alterationID,ad.category_id,ad.product_id,ad.alteration_name,ppl.product_price,ad.alteration_description,ad.alteration_ext,ad.alteration_color
1196: FROM alteration_details ad
1197: INNER JOIN product_price_levels ppl ON ad.id=ppl.alteration_id AND ppl.price_level_id= #VARIABLES.siteLevelDetails.price_level#
1198: WHERE ad.product_id=<cfqueryparam value="#ARGUMENTS.productID#" cfsqltype="cf_sql_bigint" >
1199: </cfquery>
|
| | column | | | id | | | line | | | Raw_Trace | | string | model.gateway.sitemanager_cfc$cf$3.udfCall5(/model/gateway/siteManager.cfc:1197) |
| | template | | string | C:\sites\websam\site\model\gateway\siteManager.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 226: <cfargument name="productID" type="numeric" required="true"><br>
227: <cfargument name="siteID" type="numeric" required="true"><br>
<b>228: <cfreturn APPLICATION.getsiteManagerGateway().getAlterationDetails(productID=ARGUMENTS.productID,siteID=ARGUMENTS.siteID)></b><br>
229: </cffunction><br>
230: <br>
|
| | codePrintPlain | | string | 226: <cfargument name="productID" type="numeric" required="true">
227: <cfargument name="siteID" type="numeric" required="true">
228: <cfreturn APPLICATION.getsiteManagerGateway().getAlterationDetails(productID=ARGUMENTS.productID,siteID=ARGUMENTS.siteID)>
229: </cffunction>
230:
|
| | column | | | id | | | line | | | Raw_Trace | | string | model.service.sitemanager_cfc$cf$2.udfCall4(/model/service/siteManager.cfc:228) |
| | template | | string | C:\sites\websam\site\model\service\siteManager.cfc |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 174: <!--- <cfset VARIABLES.employeeList=APPLICATION.getsiteManagerService().getAllEmployeeDetails(siteID=APPLICATION.siteDetails.site_id)> ---><br>
175: <cfset VARIABLES.logoList=APPLICATION.getsiteManagerService().getLogoList(siteID=APPLICATION.siteDetails.site_id)><br>
<b>176: <cfset VARIABLES.alterationDetails=APPLICATION.getsiteManagerService().getAlterationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)></b><br>
177: <cfset VARIABLES.siteTextLocationDetails=APPLICATION.getsiteManagerService().getSiteTextLocationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)><br>
178: <cfset VARIABLES.siteLogoLocationDetails=APPLICATION.getsiteManagerService().getSiteLogoLocationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)><br>
|
| | codePrintPlain | | string | 174: <!--- <cfset VARIABLES.employeeList=APPLICATION.getsiteManagerService().getAllEmployeeDetails(siteID=APPLICATION.siteDetails.site_id)> --->
175: <cfset VARIABLES.logoList=APPLICATION.getsiteManagerService().getLogoList(siteID=APPLICATION.siteDetails.site_id)>
176: <cfset VARIABLES.alterationDetails=APPLICATION.getsiteManagerService().getAlterationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)>
177: <cfset VARIABLES.siteTextLocationDetails=APPLICATION.getsiteManagerService().getSiteTextLocationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)>
178: <cfset VARIABLES.siteLogoLocationDetails=APPLICATION.getsiteManagerService().getSiteLogoLocationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)>
|
| | column | | | id | | | line | | | Raw_Trace | | string | layouts.sitelayouts.siteproductdisplay_cfm$cf.call(/layouts/siteLayouts/siteProductDisplay.cfm:176) |
| | template | | string | C:\sites\websam\site\layouts\siteLayouts\siteProductDisplay.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | <b>1: <cfinclude template="/layouts/siteLayouts/siteProductDisplay.cfm"></b><br>
|
| | codePrintPlain | | string | 1: <cfinclude template="/layouts/siteLayouts/siteProductDisplay.cfm">
|
| | column | | | id | | | line | | | Raw_Trace | | string | views.productdetailsview.productdetails_cfm$cf.call(/views/productdetailsview/productdetails.cfm:1) |
| | template | | string | C:\sites\websam\site\views\productdetailsview\productdetails.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 1991: response = '';<br>
1992: savecontent variable="response" {<br>
<b>1993: include '#viewPath#';</b><br>
1994: }<br>
1995: }<br>
|
| | codePrintPlain | | string | 1991: response = '';
1992: savecontent variable="response" {
1993: include '#viewPath#';
1994: }
1995: }
|
| | column | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 919: if ( structKeyExists(request._fw1, 'view') ) {<br>
920: internalFrameworkTrace( 'rendering #request._fw1.view#' );<br>
<b>921: out = internalView( request._fw1.view );</b><br>
922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) {<br>
923: internalFrameworkTrace( 'viewNotFound() called' );<br>
|
| | codePrintPlain | | string | 919: if ( structKeyExists(request._fw1, 'view') ) {
920: internalFrameworkTrace( 'rendering #request._fw1.view#' );
921: out = internalView( request._fw1.view );
922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) {
923: internalFrameworkTrace( 'viewNotFound() called' );
|
| | column | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
|
| | type | | | where | |
|
| DataSource | |
| Detail | | string | available columns are [ALTERATIONID, CATEGORY_ID, PRODUCT_ID, ALTERATION_NAME, PRODUCT_PRICE, ALTERATION_DESCRIPTION, ALTERATION_EXT, ALTERATION_COLOR] |
|
| ErrorCode | |
| Extended_Info | |
| ExtendedInfo | |
| Message | | string | Column [PRICE_LEVEL] not found in query |
|
| name | |
| NativeErrorCode | |
| queryError | | string | SELECT ad.id as alterationID,ad.category_id,ad.product_id,ad.alteration_name,ppl.product_price,ad.alteration_description,ad.alteration_ext,ad.alteration_color
FROM alteration_details ad
INNER JOIN product_price_levels ppl ON ad.id=ppl.alteration_id AND ppl.price_level_id= 1
WHERE ad.product_id=271 |
|
| rootCause | Struct
Entries: 15 | | additional | | Struct (ordered) | | SQL | | string | SELECT ad.id as alterationID,ad.category_id,ad.product_id,ad.alteration_name,ppl.product_price,ad.alteration_description,ad.alteration_ext,ad.alteration_color
FROM alteration_details ad
INNER JOIN product_price_levels ppl ON ad.id=ppl.alteration_id AND ppl.price_level_id= 1
WHERE ad.product_id=271 |
|
| | DataSource | | | Detail | | string | available columns are [ALTERATIONID, CATEGORY_ID, PRODUCT_ID, ALTERATION_NAME, PRODUCT_PRICE, ALTERATION_DESCRIPTION, ALTERATION_EXT, ALTERATION_COLOR] |
| | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | Message | | string | Column [PRICE_LEVEL] not found in query |
| | NativeErrorCode | | | queryError | | string | SELECT ad.id as alterationID,ad.category_id,ad.product_id,ad.alteration_name,ppl.product_price,ad.alteration_description,ad.alteration_ext,ad.alteration_color
FROM alteration_details ad
INNER JOIN product_price_levels ppl ON ad.id=ppl.alteration_id AND ppl.price_level_id= 1
WHERE ad.product_id=271 |
| | Sql | | string | SELECT ad.id as alterationID,ad.category_id,ad.product_id,ad.alteration_name,ppl.product_price,ad.alteration_description,ad.alteration_ext,ad.alteration_color
FROM alteration_details ad
INNER JOIN product_price_levels ppl ON ad.id=ppl.alteration_id AND ppl.price_level_id= 1
WHERE ad.product_id=271 |
| | SQLState | | | StackTrace | | string | lucee.runtime.exp.DatabaseException: Column [PRICE_LEVEL] not found in query
at lucee.runtime.type.QueryImpl.getAt(QueryImpl.java:1149)
at lucee.runtime.type.QueryImpl.get(QueryImpl.java:2076)
at lucee.runtime.util.VariableUtilImpl.get(VariableUtilImpl.java:280)
at lucee.runtime.PageContextImpl.vs(PageContextImpl.java:1397)
at model.gateway.sitemanager_cfc$cf$3.udfCall5(/model/gateway/siteManager.cfc:1197)
at model.gateway.sitemanager_cfc$cf$3.udfCall(/model/gateway/siteManager.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:723)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2120)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2107)
at model.service.sitemanager_cfc$cf$2.udfCall4(/model/service/siteManager.cfc:228)
at model.service.sitemanager_cfc$cf$2.udfCall(/model/service/siteManager.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:723)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2120)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2107)
at layouts.sitelayouts.siteproductdisplay_cfm$cf.call(/layouts/siteLayouts/siteProductDisplay.cfm:176)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987)
at views.productdetailsview.productdetails_cfm$cf.call(/views/productdetailsview/productdetails.cfm:1)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987)
at framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993)
at framework.one_cfc$cf.udfCall(/framework/one.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075)
at framework.one_cfc$cf.udfCall6(/framework/one.cfc:921)
at framework.one_cfc$cf.udfCall(/framework/one.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:477)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2810)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2797)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2768)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1109)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1066)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:130)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:79)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
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:420)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:59)
at java.base/java.lang.Thread.run(Unknown Source)
|
| | TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 1195: SELECT ad.id as alterationID,ad.category_id,ad.product_id,ad.alteration_name,ppl.product_price,ad.alteration_description,ad.alteration_ext,ad.alteration_color<br>
1196: FROM alteration_details ad<br>
<b>1197: INNER JOIN product_price_levels ppl ON ad.id=ppl.alteration_id AND ppl.price_level_id= #VARIABLES.siteLevelDetails.price_level#</b><br>
1198: WHERE ad.product_id=<cfqueryparam value="#ARGUMENTS.productID#" cfsqltype="cf_sql_bigint" ><br>
1199: </cfquery><br>
|
| | codePrintPlain | | string | 1195: SELECT ad.id as alterationID,ad.category_id,ad.product_id,ad.alteration_name,ppl.product_price,ad.alteration_description,ad.alteration_ext,ad.alteration_color
1196: FROM alteration_details ad
1197: INNER JOIN product_price_levels ppl ON ad.id=ppl.alteration_id AND ppl.price_level_id= #VARIABLES.siteLevelDetails.price_level#
1198: WHERE ad.product_id=<cfqueryparam value="#ARGUMENTS.productID#" cfsqltype="cf_sql_bigint" >
1199: </cfquery>
|
| | column | | | id | | | line | | | Raw_Trace | | string | model.gateway.sitemanager_cfc$cf$3.udfCall5(/model/gateway/siteManager.cfc:1197) |
| | template | | string | C:\sites\websam\site\model\gateway\siteManager.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 226: <cfargument name="productID" type="numeric" required="true"><br>
227: <cfargument name="siteID" type="numeric" required="true"><br>
<b>228: <cfreturn APPLICATION.getsiteManagerGateway().getAlterationDetails(productID=ARGUMENTS.productID,siteID=ARGUMENTS.siteID)></b><br>
229: </cffunction><br>
230: <br>
|
| | codePrintPlain | | string | 226: <cfargument name="productID" type="numeric" required="true">
227: <cfargument name="siteID" type="numeric" required="true">
228: <cfreturn APPLICATION.getsiteManagerGateway().getAlterationDetails(productID=ARGUMENTS.productID,siteID=ARGUMENTS.siteID)>
229: </cffunction>
230:
|
| | column | | | id | | | line | | | Raw_Trace | | string | model.service.sitemanager_cfc$cf$2.udfCall4(/model/service/siteManager.cfc:228) |
| | template | | string | C:\sites\websam\site\model\service\siteManager.cfc |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 174: <!--- <cfset VARIABLES.employeeList=APPLICATION.getsiteManagerService().getAllEmployeeDetails(siteID=APPLICATION.siteDetails.site_id)> ---><br>
175: <cfset VARIABLES.logoList=APPLICATION.getsiteManagerService().getLogoList(siteID=APPLICATION.siteDetails.site_id)><br>
<b>176: <cfset VARIABLES.alterationDetails=APPLICATION.getsiteManagerService().getAlterationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)></b><br>
177: <cfset VARIABLES.siteTextLocationDetails=APPLICATION.getsiteManagerService().getSiteTextLocationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)><br>
178: <cfset VARIABLES.siteLogoLocationDetails=APPLICATION.getsiteManagerService().getSiteLogoLocationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)><br>
|
| | codePrintPlain | | string | 174: <!--- <cfset VARIABLES.employeeList=APPLICATION.getsiteManagerService().getAllEmployeeDetails(siteID=APPLICATION.siteDetails.site_id)> --->
175: <cfset VARIABLES.logoList=APPLICATION.getsiteManagerService().getLogoList(siteID=APPLICATION.siteDetails.site_id)>
176: <cfset VARIABLES.alterationDetails=APPLICATION.getsiteManagerService().getAlterationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)>
177: <cfset VARIABLES.siteTextLocationDetails=APPLICATION.getsiteManagerService().getSiteTextLocationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)>
178: <cfset VARIABLES.siteLogoLocationDetails=APPLICATION.getsiteManagerService().getSiteLogoLocationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)>
|
| | column | | | id | | | line | | | Raw_Trace | | string | layouts.sitelayouts.siteproductdisplay_cfm$cf.call(/layouts/siteLayouts/siteProductDisplay.cfm:176) |
| | template | | string | C:\sites\websam\site\layouts\siteLayouts\siteProductDisplay.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | <b>1: <cfinclude template="/layouts/siteLayouts/siteProductDisplay.cfm"></b><br>
|
| | codePrintPlain | | string | 1: <cfinclude template="/layouts/siteLayouts/siteProductDisplay.cfm">
|
| | column | | | id | | | line | | | Raw_Trace | | string | views.productdetailsview.productdetails_cfm$cf.call(/views/productdetailsview/productdetails.cfm:1) |
| | template | | string | C:\sites\websam\site\views\productdetailsview\productdetails.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 1991: response = '';<br>
1992: savecontent variable="response" {<br>
<b>1993: include '#viewPath#';</b><br>
1994: }<br>
1995: }<br>
|
| | codePrintPlain | | string | 1991: response = '';
1992: savecontent variable="response" {
1993: include '#viewPath#';
1994: }
1995: }
|
| | column | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 919: if ( structKeyExists(request._fw1, 'view') ) {<br>
920: internalFrameworkTrace( 'rendering #request._fw1.view#' );<br>
<b>921: out = internalView( request._fw1.view );</b><br>
922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) {<br>
923: internalFrameworkTrace( 'viewNotFound() called' );<br>
|
| | codePrintPlain | | string | 919: if ( structKeyExists(request._fw1, 'view') ) {
920: internalFrameworkTrace( 'rendering #request._fw1.view#' );
921: out = internalView( request._fw1.view );
922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) {
923: internalFrameworkTrace( 'viewNotFound() called' );
|
| | column | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
|
| | type | | | where | |
|
| Sql | | string | SELECT ad.id as alterationID,ad.category_id,ad.product_id,ad.alteration_name,ppl.product_price,ad.alteration_description,ad.alteration_ext,ad.alteration_color
FROM alteration_details ad
INNER JOIN product_price_levels ppl ON ad.id=ppl.alteration_id AND ppl.price_level_id= 1
WHERE ad.product_id=271 |
|
| SQLState | |
| StackTrace | | string | lucee.runtime.exp.DatabaseException: Column [PRICE_LEVEL] not found in query
at lucee.runtime.type.QueryImpl.getAt(QueryImpl.java:1149)
at lucee.runtime.type.QueryImpl.get(QueryImpl.java:2076)
at lucee.runtime.util.VariableUtilImpl.get(VariableUtilImpl.java:280)
at lucee.runtime.PageContextImpl.vs(PageContextImpl.java:1397)
at model.gateway.sitemanager_cfc$cf$3.udfCall5(/model/gateway/siteManager.cfc:1197)
at model.gateway.sitemanager_cfc$cf$3.udfCall(/model/gateway/siteManager.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:723)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2120)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2107)
at model.service.sitemanager_cfc$cf$2.udfCall4(/model/service/siteManager.cfc:228)
at model.service.sitemanager_cfc$cf$2.udfCall(/model/service/siteManager.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:723)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2120)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2107)
at layouts.sitelayouts.siteproductdisplay_cfm$cf.call(/layouts/siteLayouts/siteProductDisplay.cfm:176)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987)
at views.productdetailsview.productdetails_cfm$cf.call(/views/productdetailsview/productdetails.cfm:1)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:987)
at framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993)
at framework.one_cfc$cf.udfCall(/framework/one.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075)
at framework.one_cfc$cf.udfCall6(/framework/one.cfc:921)
at framework.one_cfc$cf.udfCall(/framework/one.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:722)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:595)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2101)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:477)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2810)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2797)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2768)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1109)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1066)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:130)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:79)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
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:420)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:59)
at java.base/java.lang.Thread.run(Unknown Source)
|
|
| TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 1195: SELECT ad.id as alterationID,ad.category_id,ad.product_id,ad.alteration_name,ppl.product_price,ad.alteration_description,ad.alteration_ext,ad.alteration_color<br>
1196: FROM alteration_details ad<br>
<b>1197: INNER JOIN product_price_levels ppl ON ad.id=ppl.alteration_id AND ppl.price_level_id= #VARIABLES.siteLevelDetails.price_level#</b><br>
1198: WHERE ad.product_id=<cfqueryparam value="#ARGUMENTS.productID#" cfsqltype="cf_sql_bigint" ><br>
1199: </cfquery><br>
|
| | codePrintPlain | | string | 1195: SELECT ad.id as alterationID,ad.category_id,ad.product_id,ad.alteration_name,ppl.product_price,ad.alteration_description,ad.alteration_ext,ad.alteration_color
1196: FROM alteration_details ad
1197: INNER JOIN product_price_levels ppl ON ad.id=ppl.alteration_id AND ppl.price_level_id= #VARIABLES.siteLevelDetails.price_level#
1198: WHERE ad.product_id=<cfqueryparam value="#ARGUMENTS.productID#" cfsqltype="cf_sql_bigint" >
1199: </cfquery>
|
| | column | | | id | | | line | | | Raw_Trace | | string | model.gateway.sitemanager_cfc$cf$3.udfCall5(/model/gateway/siteManager.cfc:1197) |
| | template | | string | C:\sites\websam\site\model\gateway\siteManager.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 226: <cfargument name="productID" type="numeric" required="true"><br>
227: <cfargument name="siteID" type="numeric" required="true"><br>
<b>228: <cfreturn APPLICATION.getsiteManagerGateway().getAlterationDetails(productID=ARGUMENTS.productID,siteID=ARGUMENTS.siteID)></b><br>
229: </cffunction><br>
230: <br>
|
| | codePrintPlain | | string | 226: <cfargument name="productID" type="numeric" required="true">
227: <cfargument name="siteID" type="numeric" required="true">
228: <cfreturn APPLICATION.getsiteManagerGateway().getAlterationDetails(productID=ARGUMENTS.productID,siteID=ARGUMENTS.siteID)>
229: </cffunction>
230:
|
| | column | | | id | | | line | | | Raw_Trace | | string | model.service.sitemanager_cfc$cf$2.udfCall4(/model/service/siteManager.cfc:228) |
| | template | | string | C:\sites\websam\site\model\service\siteManager.cfc |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 174: <!--- <cfset VARIABLES.employeeList=APPLICATION.getsiteManagerService().getAllEmployeeDetails(siteID=APPLICATION.siteDetails.site_id)> ---><br>
175: <cfset VARIABLES.logoList=APPLICATION.getsiteManagerService().getLogoList(siteID=APPLICATION.siteDetails.site_id)><br>
<b>176: <cfset VARIABLES.alterationDetails=APPLICATION.getsiteManagerService().getAlterationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)></b><br>
177: <cfset VARIABLES.siteTextLocationDetails=APPLICATION.getsiteManagerService().getSiteTextLocationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)><br>
178: <cfset VARIABLES.siteLogoLocationDetails=APPLICATION.getsiteManagerService().getSiteLogoLocationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)><br>
|
| | codePrintPlain | | string | 174: <!--- <cfset VARIABLES.employeeList=APPLICATION.getsiteManagerService().getAllEmployeeDetails(siteID=APPLICATION.siteDetails.site_id)> --->
175: <cfset VARIABLES.logoList=APPLICATION.getsiteManagerService().getLogoList(siteID=APPLICATION.siteDetails.site_id)>
176: <cfset VARIABLES.alterationDetails=APPLICATION.getsiteManagerService().getAlterationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)>
177: <cfset VARIABLES.siteTextLocationDetails=APPLICATION.getsiteManagerService().getSiteTextLocationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)>
178: <cfset VARIABLES.siteLogoLocationDetails=APPLICATION.getsiteManagerService().getSiteLogoLocationDetails(productID=VARIABLES.productID,siteID=APPLICATION.siteDetails.site_id)>
|
| | column | | | id | | | line | | | Raw_Trace | | string | layouts.sitelayouts.siteproductdisplay_cfm$cf.call(/layouts/siteLayouts/siteProductDisplay.cfm:176) |
| | template | | string | C:\sites\websam\site\layouts\siteLayouts\siteProductDisplay.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | <b>1: <cfinclude template="/layouts/siteLayouts/siteProductDisplay.cfm"></b><br>
|
| | codePrintPlain | | string | 1: <cfinclude template="/layouts/siteLayouts/siteProductDisplay.cfm">
|
| | column | | | id | | | line | | | Raw_Trace | | string | views.productdetailsview.productdetails_cfm$cf.call(/views/productdetailsview/productdetails.cfm:1) |
| | template | | string | C:\sites\websam\site\views\productdetailsview\productdetails.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 1991: response = '';<br>
1992: savecontent variable="response" {<br>
<b>1993: include '#viewPath#';</b><br>
1994: }<br>
1995: }<br>
|
| | codePrintPlain | | string | 1991: response = '';
1992: savecontent variable="response" {
1993: include '#viewPath#';
1994: }
1995: }
|
| | column | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCallc(/framework/one.cfc:1993) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 919: if ( structKeyExists(request._fw1, 'view') ) {<br>
920: internalFrameworkTrace( 'rendering #request._fw1.view#' );<br>
<b>921: out = internalView( request._fw1.view );</b><br>
922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) {<br>
923: internalFrameworkTrace( 'viewNotFound() called' );<br>
|
| | codePrintPlain | | string | 919: if ( structKeyExists(request._fw1, 'view') ) {
920: internalFrameworkTrace( 'rendering #request._fw1.view#' );
921: out = internalView( request._fw1.view );
922: } else if ( structKeyExists(request._fw1, 'omvInProgress') ) {
923: internalFrameworkTrace( 'viewNotFound() called' );
|
| | column | | | id | | | line | | | Raw_Trace | | string | framework.one_cfc$cf.udfCall6(/framework/one.cfc:921) |
| | template | | string | C:\sites\websam\site\framework\one.cfc |
| | type | |
|
|
| type | |
| where | |