Free Local Delivery over $49
Questions? +64-9-889-9489

Showing 0 results

Catch
Entries: 15
additional
Struct (ordered)
SQL
stringselect product.productid,prod_menutitle,product.prod_handle, defaultproducttype.producttype_handle as pth, currencyconversion.currency_code, product.prod_image1, product.prod_image2, product.prod_image3, product.prod_saleflag, product.prod_newflag, product.prod_saleflagstart, product.prod_newflagstart, product.prod_saleflagfinish, product.prod_newflagfinish, productvariance.var_price, product.prod_reviewaverage, product.prod_reviewcount, producttype.* from product, productwithproducttype, producttype, producttype as defaultproducttype, currencyconversion, productvariance where product.productid = productwithproducttype.productid and productwithproducttype.producttypeid = producttype.producttypeid and producttype.producttype_handle = 'home-and-kitchen' and defaultproducttype.producttypeid = product.defaultproducttypeid and product.prod_basecurrencyid = currencyconversion.currencyid and product.prod_active = 1 and product.prod_deleted is null and product.siteid = 1 and product.productid = productvariance.productid and productvariance.var_default = 1 order by product.prod_title
DataSource
string
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringcolumn [BUSINESSID] not found in query, columns are [PRODUCTID,PROD_MENUTITLE,PROD_HANDLE,PTH,CURRENCY_CODE,PROD_IMAGE1,PROD_IMAGE2,PROD_IMAGE3,PROD_SALEFLAG,PROD_NEWFLAG,PROD_SALEFLAGSTART,PROD_NEWFLAGSTART,PROD_SALEFLAGFINISH,PROD_NEWFLAGFINISH,VAR_PRICE,PROD_REVIEWAVERAGE,PROD_REVIEWCOUNT,PRODUCTTYPEID,PRODUCTTYPE_NAME,PRODUCTTYPE_ORDERNO,PRODUCTTYPE_HANDLE,PRODUCTTYPE_COUNT,PRODUCTTYPE_IMAGE,PRODUCTTYPE_COMPLIANCEONLY,SITEID,PRODUCTTYPE_ACTIVE,PRODUCTTYPE_DELETED,PRODUCTTYPE_STANDARDONLY,PRODUCTTYPE_CLASSTANDARD,PRODUCTTYPE_CLASSCOMPLIANCE,PRODUCTTYPE_METATITLE,PRODUCTTYPE_METAKEYWORDS,PRODUCTTYPE_METADESCRIPTION,PRODUCTTYPE_BREADCRUMBTEXT1,PRODUCTTYPE_BREADCRUMBTEXT2,PRODUCTTYPEGROUPID]
NativeErrorCode
number-1
queryError
stringselect product.productid,prod_menutitle,product.prod_handle, defaultproducttype.producttype_handle as pth, currencyconversion.currency_code, product.prod_image1, product.prod_image2, product.prod_image3, product.prod_saleflag, product.prod_newflag, product.prod_saleflagstart, product.prod_newflagstart, product.prod_saleflagfinish, product.prod_newflagfinish, productvariance.var_price, product.prod_reviewaverage, product.prod_reviewcount, producttype.* from product, productwithproducttype, producttype, producttype as defaultproducttype, currencyconversion, productvariance where product.productid = productwithproducttype.productid and productwithproducttype.producttypeid = producttype.producttypeid and producttype.producttype_handle = 'home-and-kitchen' and defaultproducttype.producttypeid = product.defaultproducttypeid and product.prod_basecurrencyid = currencyconversion.currencyid and product.prod_active = 1 and product.prod_deleted is null and product.siteid = 1 and product.productid = productvariance.productid and productvariance.var_default = 1 order by product.prod_title
Sql
stringselect product.productid,prod_menutitle,product.prod_handle, defaultproducttype.producttype_handle as pth, currencyconversion.currency_code, product.prod_image1, product.prod_image2, product.prod_image3, product.prod_saleflag, product.prod_newflag, product.prod_saleflagstart, product.prod_newflagstart, product.prod_saleflagfinish, product.prod_newflagfinish, productvariance.var_price, product.prod_reviewaverage, product.prod_reviewcount, producttype.* from product, productwithproducttype, producttype, producttype as defaultproducttype, currencyconversion, productvariance where product.productid = productwithproducttype.productid and productwithproducttype.producttypeid = producttype.producttypeid and producttype.producttype_handle = 'home-and-kitchen' and defaultproducttype.producttypeid = product.defaultproducttypeid and product.prod_basecurrencyid = currencyconversion.currencyid and product.prod_active = 1 and product.prod_deleted is null and product.siteid = 1 and product.productid = productvariance.productid and productvariance.var_default = 1 order by product.prod_title
SQLState
string
StackTrace
stringlucee.runtime.exp.DatabaseException: column [BUSINESSID] not found in query, columns are [PRODUCTID,PROD_MENUTITLE,PROD_HANDLE,PTH,CURRENCY_CODE,PROD_IMAGE1,PROD_IMAGE2,PROD_IMAGE3,PROD_SALEFLAG,PROD_NEWFLAG,PROD_SALEFLAGSTART,PROD_NEWFLAGSTART,PROD_SALEFLAGFINISH,PROD_NEWFLAGFINISH,VAR_PRICE,PROD_REVIEWAVERAGE,PROD_REVIEWCOUNT,PRODUCTTYPEID,PRODUCTTYPE_NAME,PRODUCTTYPE_ORDERNO,PRODUCTTYPE_HANDLE,PRODUCTTYPE_COUNT,PRODUCTTYPE_IMAGE,PRODUCTTYPE_COMPLIANCEONLY,SITEID,PRODUCTTYPE_ACTIVE,PRODUCTTYPE_DELETED,PRODUCTTYPE_STANDARDONLY,PRODUCTTYPE_CLASSTANDARD,PRODUCTTYPE_CLASSCOMPLIANCE,PRODUCTTYPE_METATITLE,PRODUCTTYPE_METAKEYWORDS,PRODUCTTYPE_METADESCRIPTION,PRODUCTTYPE_BREADCRUMBTEXT1,PRODUCTTYPE_BREADCRUMBTEXT2,PRODUCTTYPEGROUPID] at lucee.runtime.type.QueryImpl.getAt(QueryImpl.java:922) at lucee.runtime.type.QueryImpl.get(QueryImpl.java:1880) at lucee.runtime.util.VariableUtilImpl.get(VariableUtilImpl.java:263) at lucee.runtime.PageContextImpl.get(PageContextImpl.java:1516) at _public.templates.tmpl_productlist_cfm$cf.call(/public/templates/tmpl_productlist.cfm:27) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805) at system.initialise.renderproductlist_cfm$cf.call(/system/initialise/renderproductlist.cfm:65) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805) at system.templates.productlist_cfm$cf.call(/system/templates/productlist.cfm:11) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2464) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2454) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2427) at lucee.runtime.engine.Request.exe(Request.java:44) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1090) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1038) 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
string25: &lt;cfset prodcount = variables.products.recordcount&gt;<br> 26: &lt;cfquery name=&quot;qry_updatepp&quot; datasource=&quot;#request.site_dsn#&quot;&gt;<br> <b>27: update pageping set businessid = #variables.products.businessid# where pp_key = '#request.sessiondata.pageping_uuid#'</b><br> 28: &lt;/cfquery&gt;<br> 29: &lt;cfloop query=&quot;variables.products&quot;&gt;<br>
codePrintPlain
string25: <cfset prodcount = variables.products.recordcount> 26: <cfquery name="qry_updatepp" datasource="#request.site_dsn#"> 27: update pageping set businessid = #variables.products.businessid# where pp_key = '#request.sessiondata.pageping_uuid#' 28: </cfquery> 29: <cfloop query="variables.products">
column
number0
id
string??
line
number27
Raw_Trace
string_public.templates.tmpl_productlist_cfm$cf.call(/public/templates/tmpl_productlist.cfm:27)
template
stringC:\home\shanghainoodle.co.nz\wwwroot\public\templates\tmpl_productlist.cfm
type
stringcfml
2
Struct
codePrintHTML
string63: <br> 64: &lt;cfscript&gt;<br> <b>65: include &quot;#variables.pageinclude#&quot;;</b><br> 66: &lt;/cfscript&gt;<br>
codePrintPlain
string63: 64: <cfscript> 65: include "#variables.pageinclude#"; 66: </cfscript>
column
number0
id
string??
line
number65
Raw_Trace
stringsystem.initialise.renderproductlist_cfm$cf.call(/system/initialise/renderproductlist.cfm:65)
template
stringC:\home\shanghainoodle.co.nz\wwwroot\system\initialise\renderproductlist.cfm
type
stringcfml
3
Struct
codePrintHTML
string9: <br> 10: //dump(variables.productlist);<br> <b>11: include &quot;../initialise/renderproductlist.cfm&quot;;</b><br> 12: &lt;/cfscript&gt;<br> 13: &lt;!--- &lt;cfdump var=&quot;#variables.productlist#&quot;&gt;<br>
codePrintPlain
string9: 10: //dump(variables.productlist); 11: include "../initialise/renderproductlist.cfm"; 12: </cfscript> 13: <!--- <cfdump var="#variables.productlist#">
column
number0
id
string??
line
number11
Raw_Trace
stringsystem.templates.productlist_cfm$cf.call(/system/templates/productlist.cfm:11)
template
stringC:\home\shanghainoodle.co.nz\wwwroot\system\templates\productlist.cfm
type
stringcfml
type
stringdatabase
where
string




Doh!. Houston, we have a problem. We'll work quick smart to fix it for you. In the meantime please click here to return to the homepage.