Exception in onRequestStart

The action productdetailsview.productdetails failed.

column [TOPNAV_COLOR] not found in query, columns are [EMPLOYEEID,FIRST_NAME,LAST_NAME,EMAIL,PHONE1,PHONE2,ADDRESS1,ADDRESS2,CITY,STATE,COUNTRY,ZIP,BADGE_NO,PERMISSIONS_LEVEL,LOCATION,DEPARTMENT,POSITION,EMPLOYEE_STATUS,EMAIL_STATUS,APPROVAL_EMAIL,RESET_EMAIL,RESET_PHONE1,RESET_PASSWORD,EMPLOYMENT_START_DATE,POSITIONAL_SUPERVISOR,IS_DELETED]

(database)

Exception
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT ed.id as employeeID,ed.first_name,ed.last_name,ed.email,ed.phone1,ed.phone2,ed.address1,ed.address2,ed.city, ed.state,ed.country,ed.zip,ed.badge_no,ed.permissions_level,ed.location,ed.department,ed.position, ed.employee_status,ed.email_status,ed.approval_email, reset_email,reset_phone1, reset_password, employment_start_date, ed.positional_supervisor, ed.is_deleted FROM employee_details ed WHERE ed.site_id=8 ORDER BY ed.is_deleted, TRIM(ed.last_name) ASC
DataSource
string
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringcolumn [TOPNAV_COLOR] not found in query, columns are [EMPLOYEEID,FIRST_NAME,LAST_NAME,EMAIL,PHONE1,PHONE2,ADDRESS1,ADDRESS2,CITY,STATE,COUNTRY,ZIP,BADGE_NO,PERMISSIONS_LEVEL,LOCATION,DEPARTMENT,POSITION,EMPLOYEE_STATUS,EMAIL_STATUS,APPROVAL_EMAIL,RESET_EMAIL,RESET_PHONE1,RESET_PASSWORD,EMPLOYMENT_START_DATE,POSITIONAL_SUPERVISOR,IS_DELETED]
NativeErrorCode
number-1
queryError
stringSELECT ed.id as employeeID,ed.first_name,ed.last_name,ed.email,ed.phone1,ed.phone2,ed.address1,ed.address2,ed.city, ed.state,ed.country,ed.zip,ed.badge_no,ed.permissions_level,ed.location,ed.department,ed.position, ed.employee_status,ed.email_status,ed.approval_email, reset_email,reset_phone1, reset_password, employment_start_date, ed.positional_supervisor, ed.is_deleted FROM employee_details ed WHERE ed.site_id=8 ORDER BY ed.is_deleted, TRIM(ed.last_name) ASC
Sql
stringSELECT ed.id as employeeID,ed.first_name,ed.last_name,ed.email,ed.phone1,ed.phone2,ed.address1,ed.address2,ed.city, ed.state,ed.country,ed.zip,ed.badge_no,ed.permissions_level,ed.location,ed.department,ed.position, ed.employee_status,ed.email_status,ed.approval_email, reset_email,reset_phone1, reset_password, employment_start_date, ed.positional_supervisor, ed.is_deleted FROM employee_details ed WHERE ed.site_id=8 ORDER BY ed.is_deleted, TRIM(ed.last_name) ASC
SQLState
string
StackTrace
stringlucee.runtime.exp.DatabaseException: column [TOPNAV_COLOR] not found in query, columns are [EMPLOYEEID,FIRST_NAME,LAST_NAME,EMAIL,PHONE1,PHONE2,ADDRESS1,ADDRESS2,CITY,STATE,COUNTRY,ZIP,BADGE_NO,PERMISSIONS_LEVEL,LOCATION,DEPARTMENT,POSITION,EMPLOYEE_STATUS,EMAIL_STATUS,APPROVAL_EMAIL,RESET_EMAIL,RESET_PHONE1,RESET_PASSWORD,EMPLOYMENT_START_DATE,POSITIONAL_SUPERVISOR,IS_DELETED] 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 application_cfc$cf$1.udfCall(/Application.cfc:323) 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 application_cfc$cf$1.udfCall(/Application.cfc:89) 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.udfCall4(/org/corfield/framework.cfc:1223) 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:642) 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:133) 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
string321: &lt;cfset APPLICATION.layoutDetails = APPLICATION.getsiteManagerService().getsiteLayoutDetails(siteID=APPLICATION.siteDetails.site_id)&gt;<br> 322: &lt;cfparam name=&quot;APPLICATION.hueSaturarion&quot; default=&quot;0&quot;&gt;<br> <b>323: &lt;cfset APPLICATION.topnav_color = (len(trim(APPLICATION.layoutDetails.topnav_color)) eq 0) ? &quot;##4a4a4a&quot; : APPLICATION.layoutDetails.topnav_color&gt;</b><br> 324: &lt;cfset APPLICATION.background_color = (len(trim(APPLICATION.layoutDetails.background_color)) eq 0) ? &quot;##f1f1f1&quot; : APPLICATION.layoutDetails.background_color&gt;<br> 325: &lt;cfset APPLICATION.footer_color = (len(trim(APPLICATION.layoutDetails.footer_color)) eq 0) ? &quot;##4a4a4a&quot; : APPLICATION.layoutDetails.footer_color&gt; <br>
codePrintPlain
string321: <cfset APPLICATION.layoutDetails = APPLICATION.getsiteManagerService().getsiteLayoutDetails(siteID=APPLICATION.siteDetails.site_id)> 322: <cfparam name="APPLICATION.hueSaturarion" default="0"> 323: <cfset APPLICATION.topnav_color = (len(trim(APPLICATION.layoutDetails.topnav_color)) eq 0) ? "##4a4a4a" : APPLICATION.layoutDetails.topnav_color> 324: <cfset APPLICATION.background_color = (len(trim(APPLICATION.layoutDetails.background_color)) eq 0) ? "##f1f1f1" : APPLICATION.layoutDetails.background_color> 325: <cfset APPLICATION.footer_color = (len(trim(APPLICATION.layoutDetails.footer_color)) eq 0) ? "##4a4a4a" : APPLICATION.layoutDetails.footer_color>
column
number0
id
string??
line
number323
Raw_Trace
stringapplication_cfc$cf$1.udfCall(/Application.cfc:323)
template
stringC:\sites\websam\site\Application.cfc
type
stringcfml
2
Struct
codePrintHTML
string87: &lt;cfsetting showdebugoutput=#APPLICATION.devmode#&gt;<br> 88: <br> <b>89: &lt;cfset setAppVars()&gt;</b><br> 90: <br> 91: &lt;cfif structKeyExists(URL, &quot;checkout&quot;) and !structKeyExists(FORM, &quot;checkoutStep&quot;)&gt;<br>
codePrintPlain
string87: <cfsetting showdebugoutput=#APPLICATION.devmode#> 88: 89: <cfset setAppVars()> 90: 91: <cfif structKeyExists(URL, "checkout") and !structKeyExists(FORM, "checkoutStep")>
column
number0
id
string??
line
number89
Raw_Trace
stringapplication_cfc$cf$1.udfCall(/Application.cfc:89)
template
stringC:\sites\websam\site\Application.cfc
type
stringcfml
3
Struct
codePrintHTML
string1221: rc = request.context;<br> 1222: setupSubsystemWrapper( request.subsystem );<br> <b>1223: setupRequest();</b><br> 1224: }<br> 1225: <br>
codePrintPlain
string1221: rc = request.context; 1222: setupSubsystemWrapper( request.subsystem ); 1223: setupRequest(); 1224: } 1225:
column
number0
id
string??
line
number1223
Raw_Trace
stringorg.corfield.framework_cfc$cf.udfCall4(/org/corfield/framework.cfc:1223)
template
stringC:\sites\websam\site\org\corfield\framework.cfc
type
stringcfml
4
Struct
codePrintHTML
string640: structDelete(variables, 'onError');<br> 641: } else {<br> <b>642: setupRequestWrapper( true );</b><br> 643: }<br> 644: }<br>
codePrintPlain
string640: structDelete(variables, 'onError'); 641: } else { 642: setupRequestWrapper( true ); 643: } 644: }
column
number0
id
string??
line
number642
Raw_Trace
stringorg.corfield.framework_cfc$cf.udfCall2(/org/corfield/framework.cfc:642)
template
stringC:\sites\websam\site\org\corfield\framework.cfc
type
stringcfml
type
stringdatabase
where
string