Catch
Entries: 15
additional
Struct (ordered)
SQL
stringselect * from basket,basketitem,product,productvariance,producttype, currencyconversion where basketitem.basketid = 313 and basketitem.productvarianceid = and basketitem.productvarianceid = productvariance.productvarianceid and productvariance.productid = product.productid and producttype.producttypeid = product.defaultproducttypeid and basket.basketid = basketitem.basketid and basket.basket_basecurrencyid = currencyconversion.currencyid and basket.siteid = 1
DatabaseName
stringMySQL
DatabaseVersion
string5.7.10
DriverName
stringMySQL Connector/J
DriverVersion
stringmysql-connector-java-8.0.15 (Revision: 79a4336f140499bd22dd07f02b708e163844e3d5)
Datasource
stringshanghainoodle
DataSource
stringshanghainoodle
Detail
stringYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and basketitem.productvarianceid = productvariance.productvarianceid and produ' at line 6
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
string
NativeErrorCode
number1064
queryError
stringselect * from basket,basketitem,product,productvariance,producttype, currencyconversion where basketitem.basketid = 313 and basketitem.productvarianceid = and basketitem.productvarianceid = productvariance.productvarianceid and productvariance.productid = product.productid and producttype.producttypeid = product.defaultproducttypeid and basket.basketid = basketitem.basketid and basket.basket_basecurrencyid = currencyconversion.currencyid and basket.siteid = 1
Sql
stringselect * from basket,basketitem,product,productvariance,producttype, currencyconversion where basketitem.basketid = 313 and basketitem.productvarianceid = and basketitem.productvarianceid = productvariance.productvarianceid and productvariance.productid = product.productid and producttype.producttypeid = product.defaultproducttypeid and basket.basketid = basketitem.basketid and basket.basket_basecurrencyid = currencyconversion.currencyid and basket.siteid = 1
SQLState
string42000
StackTrace
stringlucee.runtime.exp.DatabaseException: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:782) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:666) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:293) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:273) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:226) at lucee.runtime.tag.Query.executeDatasoure(Query.java:951) at lucee.runtime.tag.Query.doEndTag(Query.java:700) at basket_cfc$cf.udfCall(/dataobjects/basket.cfc:48) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:695) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2010) at lucee.runtime.tag.Invoke.doComponent(Invoke.java:221) at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:194) at basket_cfc$cf.udfCall(/siteactions/basket.cfc:218) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:695) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2010) at lucee.runtime.tag.Invoke.doComponent(Invoke.java:221) at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:194) at system.initialise.manageactions_cfm$cf.call(/system/initialise/manageactions.cfm:24) 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
string46: and<br> 47: basket.siteid = #request.siteid#<br> <b>48: &lt;/cfquery&gt;</b><br> 49: &lt;cfreturn qry_getbasketitem&gt;<br> 50: &lt;/cffunction&gt;<br>
codePrintPlain
string46: and 47: basket.siteid = #request.siteid# 48: </cfquery> 49: <cfreturn qry_getbasketitem> 50: </cffunction>
column
number0
id
string??
line
number48
Raw_Trace
stringbasket_cfc$cf.udfCall(/dataobjects/basket.cfc:48)
template
stringC:\home\shanghainoodle.co.nz\wwwroot\system\dataobjects\basket.cfc
type
stringcfml
2
Struct
codePrintHTML
string216: &lt;cfinvokeargument name=&quot;productvarianceid&quot; value=&quot;#prodvariance.productvarianceid#&quot;&gt;<br> 217: &lt;cfinvokeargument name=&quot;subscriptionfrequencyid&quot; value=&quot;#request.requestdata.frequency#&quot;&gt;<br> <b>218: &lt;/cfinvoke&gt;</b><br> 219: <br> 220: &lt;cfset requestresponse.basketitemdata = basketitemdata&gt;<br>
codePrintPlain
string216: <cfinvokeargument name="productvarianceid" value="#prodvariance.productvarianceid#"> 217: <cfinvokeargument name="subscriptionfrequencyid" value="#request.requestdata.frequency#"> 218: </cfinvoke> 219: 220: <cfset requestresponse.basketitemdata = basketitemdata>
column
number0
id
string??
line
number218
Raw_Trace
stringbasket_cfc$cf.udfCall(/siteactions/basket.cfc:218)
template
stringC:\home\shanghainoodle.co.nz\wwwroot\system\siteactions\basket.cfc
type
stringcfml
3
Struct
codePrintHTML
string22: &lt;/cfscript&gt;<br> 23: <br> <b>24: &lt;cfinvoke component = &quot;#request.getcomponent#&quot; method=&quot;#request.getmethod#&quot; returnvariable=&quot;requestresponse&quot;&gt;&lt;/cfinvoke&gt;</b><br> 25: &lt;cfif request.requestdata.showdebug eq 1&gt;<br> 26: Data In:<br>
codePrintPlain
string22: </cfscript> 23: 24: <cfinvoke component = "#request.getcomponent#" method="#request.getmethod#" returnvariable="requestresponse"></cfinvoke> 25: <cfif request.requestdata.showdebug eq 1> 26: Data In:
column
number0
id
string??
line
number24
Raw_Trace
stringsystem.initialise.manageactions_cfm$cf.call(/system/initialise/manageactions.cfm:24)
template
stringC:\home\shanghainoodle.co.nz\wwwroot\system\initialise\manageactions.cfm
type
stringcfml
type
stringdatabase
where
string
CGI Scope
Entries: 47
auth_password
string
auth_type
string
auth_user
string
cert_cookie
string
cert_flags
string
cert_issuer
string
cert_keysize
string256
cert_secretkeysize
string4096
cert_serialnumber
string
cert_server_issuer
stringC=US, O=Let's Encrypt, CN=R3
cert_server_subject
stringCN=shanghainoodle.co.nz
cert_subject
string
cf_template_path
stringC:\home\shanghainoodle.co.nz\wwwroot\system\initialise\manageactions.cfm
content_length
string0
content_type
string
context_path
string
gateway_interface
stringCGI/1.1
http_accept
stringtext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
http_accept_encoding
string
http_accept_language
string
http_connection
stringClose
http_cookie
stringCF_CLIENT__HC=379; CF_CLIENT__LV=1611069838006; CF_CLIENT__TC=1611069185066; FPK=Tc1yDn5Qd9L7; NOMNOMNOM=GZtcy54OpXda5bPe; SESSIONUID=tCT11vBumwtM; cfid=298187ee-c12f-4439-ac9d-f5a24e92d12c; cftoken=0; PHPSESSID=7jk9tsclv17vcndgi9rojg30f0; SS_MID=891db2cb-9b0f-4682-ac11-0de24b442dd9kk3dw2oz; vid=6e2d2032-50be-4312-b9c7-5f3b60152e45; host=oneagency.nz
http_host
stringshanghainoodle.co.nz
http_referer
stringhttps://shanghainoodle.co.nz/assets/scripts/sitescripts.js
http_user_agent
stringMozilla/5.0 (compatible; NLNZ_IAHarvester2021/3.3.0 +https://natlib.govt.nz/publishers-and-authors/web-harvesting/domain-harvest)
https
stringon
https_keysize
string256
https_secretkeysize
string
https_server_issuer
stringC=US, O=Let's Encrypt, CN=R3
https_server_subject
stringCN=shanghainoodle.co.nz
local_addr
string184.175.93.231
local_host
stringVPS-742-69-A47
path_info
string
path_translated
stringC:\home\shanghainoodle.co.nz\wwwroot\system\initialise\manageactions.cfm
query_string
stringkey=
remote_addr
string207.241.234.200
remote_host
string207.241.234.200
remote_user
string
request_method
stringGET
request_url
stringhttps://shanghainoodle.co.nz/system/initialise/manageactions.cfm?key=
script_name
string/system/initialise/manageactions.cfm
server_name
stringshanghainoodle.co.nz
server_port
string443
server_port_secure
string1
server_protocol
stringHTTP/1.0
server_software
string
web_server_api
string