Exception in onRequest

The action productdetailsview.productdetails failed.

column [PRICE_LEVEL] not found in query, columns are [LAYOUTID,SITE_ID,LAYOUT_TYPE,FILE_EXT,TOPNAV_COLOR,BACKGROUND_COLOR,FOOTER_COLOR,NAV_TEXT_COLOR,FOOTER_TEXT_COLOR,BODY_TEXT_COLOR,BODY_LINK_COLOR,PRIMARY_BUTTON_COLOR,SECONDARY_BUTTON_COLOR,THIRD_BUTTON_COLOR,PRODUCT_NAV_LINK_COLOR,PRODUCT_NAV_BACKGROUND_COLOR]

(database)

Exception
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT ld.id as layoutID,ld.site_id,ld.layout_type,ld.file_ext,ld.topnav_color, ld.background_color,ld.footer_color,nav_text_color,footer_text_color,body_text_color , body_link_color, primary_button_color, secondary_button_color, body_link_color, primary_button_color, secondary_button_color, third_button_color, product_nav_link_color, product_nav_background_color FROM site_layout_details ld WHERE ld.site_id=8
DataSource
string
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringcolumn [PRICE_LEVEL] not found in query, columns are [LAYOUTID,SITE_ID,LAYOUT_TYPE,FILE_EXT,TOPNAV_COLOR,BACKGROUND_COLOR,FOOTER_COLOR,NAV_TEXT_COLOR,FOOTER_TEXT_COLOR,BODY_TEXT_COLOR,BODY_LINK_COLOR,PRIMARY_BUTTON_COLOR,SECONDARY_BUTTON_COLOR,THIRD_BUTTON_COLOR,PRODUCT_NAV_LINK_COLOR,PRODUCT_NAV_BACKGROUND_COLOR]
NativeErrorCode
number-1
queryError
stringSELECT ld.id as layoutID,ld.site_id,ld.layout_type,ld.file_ext,ld.topnav_color, ld.background_color,ld.footer_color,nav_text_color,footer_text_color,body_text_color , body_link_color, primary_button_color, secondary_button_color, body_link_color, primary_button_color, secondary_button_color, third_button_color, product_nav_link_color, product_nav_background_color FROM site_layout_details ld WHERE ld.site_id=8
Sql
stringSELECT ld.id as layoutID,ld.site_id,ld.layout_type,ld.file_ext,ld.topnav_color, ld.background_color,ld.footer_color,nav_text_color,footer_text_color,body_text_color , body_link_color, primary_button_color, secondary_button_color, body_link_color, primary_button_color, secondary_button_color, third_button_color, product_nav_link_color, product_nav_background_color FROM site_layout_details ld WHERE ld.site_id=8
SQLState
string
StackTrace
stringlucee.runtime.exp.DatabaseException: column [PRICE_LEVEL] not found in query, columns are [LAYOUTID,SITE_ID,LAYOUT_TYPE,FILE_EXT,TOPNAV_COLOR,BACKGROUND_COLOR,FOOTER_COLOR,NAV_TEXT_COLOR,FOOTER_TEXT_COLOR,BODY_TEXT_COLOR,BODY_LINK_COLOR,PRIMARY_BUTTON_COLOR,SECONDARY_BUTTON_COLOR,THIRD_BUTTON_COLOR,PRODUCT_NAV_LINK_COLOR,PRODUCT_NAV_BACKGROUND_COLOR] at lucee.runtime.type.QueryImpl.getAt(QueryImpl.java:1140) at lucee.runtime.type.QueryImpl.get(QueryImpl.java:2048) at lucee.runtime.util.VariableUtilImpl.get(VariableUtilImpl.java:278) at lucee.runtime.PageContextImpl.get(PageContextImpl.java:1539) at model.gateway.sitemanager_cfc$cf.udfCall4(/model/gateway/siteManager.cfc:637) at model.gateway.sitemanager_cfc$cf.udfCall(/model/gateway/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766) at model.service.sitemanager_cfc$cf.udfCall4(/model/service/siteManager.cfc:235) at model.service.sitemanager_cfc$cf.udfCall(/model/service/siteManager.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:685) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1766) at layouts.sitelayouts.siteproductdisplay_cfm$cf$39.call(/layouts/siteLayouts/siteProductDisplay.cfm:109) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1034) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:926) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:907) at views.productdetailsview.productdetails_cfm$cf$38.call(/views/productdetailsview/productDetails.cfm:1) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1034) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:926) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:907) at org.corfield.framework_cfc$cf.udfCall7(/org/corfield/framework.cfc:1539) at org.corfield.framework_cfc$cf.udfCall(/org/corfield/framework.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:785) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747) at org.corfield.framework_cfc$cf.udfCall2(/org/corfield/framework.cfc:548) at org.corfield.framework_cfc$cf.udfCall(/org/corfield/framework.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:684) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1911) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:437) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2460) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2450) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2421) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1179) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1125) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) 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:52) 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:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:479) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748)
TagContext
Array
1
Struct
codePrintHTML
string635: 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> 636: FROM alteration_details ad<br> <b>637: INNER JOIN product_price_levels ppl ON ad.id=ppl.alteration_id AND ppl.price_level_id= #VARIABLES.siteLevelDetails.price_level#</b><br> 638: WHERE ad.product_id=&lt;cfqueryparam value=&quot;#ARGUMENTS.productID#&quot; cfsqltype=&quot;cf_sql_bigint&quot; &gt;<br> 639: &lt;/cfquery&gt;<br>
codePrintPlain
string635: 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 636: FROM alteration_details ad 637: INNER JOIN product_price_levels ppl ON ad.id=ppl.alteration_id AND ppl.price_level_id= #VARIABLES.siteLevelDetails.price_level# 638: WHERE ad.product_id=<cfqueryparam value="#ARGUMENTS.productID#" cfsqltype="cf_sql_bigint" > 639: </cfquery>
column
number0
id
string??
line
number637
Raw_Trace
stringmodel.gateway.sitemanager_cfc$cf.udfCall4(/model/gateway/siteManager.cfc:637)
template
stringC:\sites\websam\site\model\gateway\siteManager.cfc
type
stringcfml
2
Struct
codePrintHTML
string233: &lt;cfargument name=&quot;productID&quot; type=&quot;numeric&quot; required=&quot;true&quot;&gt;<br> 234: &lt;cfargument name=&quot;siteID&quot; type=&quot;numeric&quot; required=&quot;true&quot;&gt;<br> <b>235: &lt;cfreturn APPLICATION.getsiteManagerGateway().getAlterationDetails(productID=ARGUMENTS.productID,siteID=ARGUMENTS.siteID)&gt;</b><br> 236: &lt;/cffunction&gt;<br> 237: <br>
codePrintPlain
string233: <cfargument name="productID" type="numeric" required="true"> 234: <cfargument name="siteID" type="numeric" required="true"> 235: <cfreturn APPLICATION.getsiteManagerGateway().getAlterationDetails(productID=ARGUMENTS.productID,siteID=ARGUMENTS.siteID)> 236: </cffunction> 237:
column
number0
id
string??
line
number235
Raw_Trace
stringmodel.service.sitemanager_cfc$cf.udfCall4(/model/service/siteManager.cfc:235)
template
stringC:\sites\websam\site\model\service\siteManager.cfc
type
stringcfml
3
Struct
codePrintHTML
string107: &lt;cfset VARIABLES.employeeList=APPLICATION.getsiteManagerService().getAllEmployeeDetails(siteID=SESSION.siteID)&gt;<br> 108: &lt;cfset VARIABLES.logoList=APPLICATION.getsiteManagerService().getLogoList(siteID=SESSION.siteID)&gt;<br> <b>109: &lt;cfset VARIABLES.alterationDetails=APPLICATION.getsiteManagerService().getAlterationDetails(productID=VARIABLES.productID,siteID=SESSION.siteID)&gt;</b><br> 110: &lt;cfset VARIABLES.siteTextLocationDetails=APPLICATION.getsiteManagerService().getSiteTextLocationDetails(productID=VARIABLES.productID,siteID=SESSION.siteID)&gt;<br> 111: &lt;cfset VARIABLES.siteLogoLocationDetails=APPLICATION.getsiteManagerService().getSiteLogoLocationDetails(productID=VARIABLES.productID,siteID=SESSION.siteID)&gt;<br>
codePrintPlain
string107: <cfset VARIABLES.employeeList=APPLICATION.getsiteManagerService().getAllEmployeeDetails(siteID=SESSION.siteID)> 108: <cfset VARIABLES.logoList=APPLICATION.getsiteManagerService().getLogoList(siteID=SESSION.siteID)> 109: <cfset VARIABLES.alterationDetails=APPLICATION.getsiteManagerService().getAlterationDetails(productID=VARIABLES.productID,siteID=SESSION.siteID)> 110: <cfset VARIABLES.siteTextLocationDetails=APPLICATION.getsiteManagerService().getSiteTextLocationDetails(productID=VARIABLES.productID,siteID=SESSION.siteID)> 111: <cfset VARIABLES.siteLogoLocationDetails=APPLICATION.getsiteManagerService().getSiteLogoLocationDetails(productID=VARIABLES.productID,siteID=SESSION.siteID)>
column
number0
id
string??
line
number109
Raw_Trace
stringlayouts.sitelayouts.siteproductdisplay_cfm$cf$39.call(/layouts/siteLayouts/siteProductDisplay.cfm:109)
template
stringC:\sites\websam\site\layouts\siteLayouts\siteProductDisplay.cfm
type
stringcfml
4
Struct
codePrintHTML
string<b>1: &lt;cfinclude template=&quot;/layouts/siteLayouts/siteProductDisplay.cfm&quot;&gt;</b><br>
codePrintPlain
string1: <cfinclude template="/layouts/siteLayouts/siteProductDisplay.cfm">
column
number0
id
string??
line
number1
Raw_Trace
stringviews.productdetailsview.productdetails_cfm$cf$38.call(/views/productdetailsview/productDetails.cfm:1)
template
stringC:\sites\websam\site\views\productDetailsView\productDetails.cfm
type
stringcfml
5
Struct
codePrintHTML
string1537: &lt;/cfif&gt;<br> 1538: <br> <b>1539: &lt;cfsavecontent variable='response'&gt;&lt;cfinclude template=&quot;#viewPath#&quot;/&gt;&lt;/cfsavecontent&gt;</b><br> 1540: <br> 1541: &lt;cfreturn response /&gt;<br>
codePrintPlain
string1537: </cfif> 1538: 1539: <cfsavecontent variable='response'><cfinclude template="#viewPath#"/></cfsavecontent> 1540: 1541: <cfreturn response />
column
number0
id
string??
line
number1539
Raw_Trace
stringorg.corfield.framework_cfc$cf.udfCall7(/org/corfield/framework.cfc:1539)
template
stringC:\sites\websam\site\org\corfield\framework.cfc
type
stringcfml
6
Struct
codePrintHTML
string546: <br> 547: if ( structKeyExists(request, 'view') ) {<br> <b>548: out = internalView( request.view );</b><br> 549: } else {<br> 550: out = onMissingView( request.context );<br>
codePrintPlain
string546: 547: if ( structKeyExists(request, 'view') ) { 548: out = internalView( request.view ); 549: } else { 550: out = onMissingView( request.context );
column
number0
id
string??
line
number548
Raw_Trace
stringorg.corfield.framework_cfc$cf.udfCall2(/org/corfield/framework.cfc:548)
template
stringC:\sites\websam\site\org\corfield\framework.cfc
type
stringcfml
type
stringdatabase
where
string