Exception in onRequest

The action productdetailsview.productdetails failed.

column [BACKGROUND_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 [BACKGROUND_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 [BACKGROUND_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 layouts.sitelayouts.wrapper_header_cfm$cf.call(/layouts/siteLayouts/wrapper_header.cfm:65) 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 layouts.sitelayouts.wrapper_cfm$cf.call(/layouts/siteLayouts/wrapper.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 layouts.productdetailsview.productdetails_cfm$cf$3a.call(/layouts/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:1513) 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:556) 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
string63: <br> 64: &lt;cfoutput&gt;<br> <b>65: &lt;body class=&quot;d-flex flex-column min-vh-100&quot; style=&quot;background-color: :#APPLICATION.layoutDetails .background_color#;&quot;&gt;</b><br> 66: &lt;/cfoutput&gt;<br> 67: <br>
codePrintPlain
string63: 64: <cfoutput> 65: <body class="d-flex flex-column min-vh-100" style="background-color: :#APPLICATION.layoutDetails .background_color#;"> 66: </cfoutput> 67:
column
number0
id
string??
line
number65
Raw_Trace
stringlayouts.sitelayouts.wrapper_header_cfm$cf.call(/layouts/siteLayouts/wrapper_header.cfm:65)
template
stringC:\sites\websam\site\layouts\siteLayouts\wrapper_header.cfm
type
stringcfml
2
Struct
codePrintHTML
string<b>1: &lt;cfinclude template=&quot;/layouts/siteLayouts/wrapper_header.cfm&quot;&gt; </b><br> 2: <br> 3: &lt;!--- &lt;body class=&quot;d-flex flex-column min-vh-100&quot;&gt; ---&gt;<br>
codePrintPlain
string1: <cfinclude template="/layouts/siteLayouts/wrapper_header.cfm"> 2: 3: <!--- <body class="d-flex flex-column min-vh-100"> --->
column
number0
id
string??
line
number1
Raw_Trace
stringlayouts.sitelayouts.wrapper_cfm$cf.call(/layouts/siteLayouts/wrapper.cfm:1)
template
stringC:\sites\websam\site\layouts\siteLayouts\wrapper.cfm
type
stringcfml
3
Struct
codePrintHTML
string<b>1: &lt;cfinclude template=&quot;/layouts/siteLayouts/wrapper.cfm&quot;&gt;</b><br> 2: &lt;!--- &lt;cfoutput&gt;<br> 3: &lt;!DOCTYPE html&gt;<br>
codePrintPlain
string1: <cfinclude template="/layouts/siteLayouts/wrapper.cfm"> 2: <!--- <cfoutput> 3: <!DOCTYPE html>
column
number0
id
string??
line
number1
Raw_Trace
stringlayouts.productdetailsview.productdetails_cfm$cf$3a.call(/layouts/productdetailsview/productDetails.cfm:1)
template
stringC:\sites\websam\site\layouts\productDetailsView\productDetails.cfm
type
stringcfml
4
Struct
codePrintHTML
string1511: &lt;/cfif&gt;<br> 1512: <br> <b>1513: &lt;cfsavecontent variable='response'&gt;&lt;cfinclude template=&quot;#layoutPath#&quot;/&gt;&lt;/cfsavecontent&gt;</b><br> 1514: <br> 1515: &lt;cfreturn response /&gt;<br>
codePrintPlain
string1511: </cfif> 1512: 1513: <cfsavecontent variable='response'><cfinclude template="#layoutPath#"/></cfsavecontent> 1514: 1515: <cfreturn response />
column
number0
id
string??
line
number1513
Raw_Trace
stringorg.corfield.framework_cfc$cf.udfCall7(/org/corfield/framework.cfc:1513)
template
stringC:\sites\websam\site\org\corfield\framework.cfc
type
stringcfml
5
Struct
codePrintHTML
string554: break;<br> 555: }<br> <b>556: out = internalLayout( request.layouts[i], out );</b><br> 557: }<br> 558: writeOutput( out );<br>
codePrintPlain
string554: break; 555: } 556: out = internalLayout( request.layouts[i], out ); 557: } 558: writeOutput( out );
column
number0
id
string??
line
number556
Raw_Trace
stringorg.corfield.framework_cfc$cf.udfCall2(/org/corfield/framework.cfc:556)
template
stringC:\sites\websam\site\org\corfield\framework.cfc
type
stringcfml
type
stringdatabase
where
string