Deadline to Enter:Ends: August 15th
Cart

Sweepstakes Ends In:

  • 00

    Days

  • :
  • 00

    Hours

  • :
  • 00

    Minutes

  • :
  • 00

    Seconds
Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT promopointid FROM _btljucd_promo_points WHERE favoritesloginid = AND orderproductid IN ()
DatabaseName
stringMySQL
DatabaseVersion
string5.7.12
DriverName
stringMySQL Connector/J
DriverVersion
stringmysql-connector-j-8.3.0 (Revision: 805f872a57875f311cb82487efcfb070411a3fa0)
Datasource
stringresponse
DataSource
stringresponse
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
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 orderproductid IN ()' at line 4
NativeErrorCode
number1064
queryError
stringSELECT promopointid FROM _btljucd_promo_points WHERE favoritesloginid = AND orderproductid IN ()
Sql
stringSELECT promopointid FROM _btljucd_promo_points WHERE favoritesloginid = AND orderproductid IN ()
SQLState
string42000
StackTrace
stringlucee.runtime.exp.DatabaseException: You 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 orderproductid IN ()' at line 4 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:770) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:653) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:297) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:243) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1130) at lucee.runtime.tag.Query._doEndTag(Query.java:697) at lucee.runtime.tag.Query.doEndTag(Query.java:562) at custom._2612.omsfinalizeorder_cfm$cf.call(/custom/2612/omsFinalizeOrder.cfm:108) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1060) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:952) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:933) at templates.basetemplate._blank_cfm$cf.call(/templates/BaseTemplate/_blank.cfm:46) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1060) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:952) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:933) at index_cfm$cf.call(/index.cfm:97) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1060) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:952) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:220) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2716) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2702) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2673) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1259) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1205) 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 com.seefusion.Filter.doFilter(Filter.java:109) 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 com.seefusion.SeeFusionValve.invoke(SeeFusionValve.java:52) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800) 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
string106: &nbsp;&nbsp;WHERE&nbsp;favoritesloginid&nbsp;=&nbsp;#getOrder.favoritesloginid#<br> 107: &nbsp;&nbsp;AND&nbsp;orderproductid&nbsp;IN&nbsp;(#ValueList(getOrder.orderproductid)#)<br> <b>108: &lt;/cfquery&gt;</b><br> 109: &lt;cfset&nbsp;membershipCreated&nbsp;=&nbsp;false&gt;<br> 110: &lt;cfif&nbsp;getPoints.RecordCount&nbsp;EQ&nbsp;0&gt;<br>
codePrintPlain
string106: WHERE favoritesloginid = #getOrder.favoritesloginid# 107: AND orderproductid IN (#ValueList(getOrder.orderproductid)#) 108: </cfquery> 109: <cfset membershipCreated = false> 110: <cfif getPoints.RecordCount EQ 0>
column
number0
id
string??
line
number108
Raw_Trace
stringcustom._2612.omsfinalizeorder_cfm$cf.call(/custom/2612/omsFinalizeOrder.cfm:108)
template
string/var/efs/www/omnia/custom/2612/omsFinalizeOrder.cfm
type
stringcfml
2
Struct
codePrintHTML
string44: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#request.currentContent#<br> 45: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfif&nbsp;isDefined(&quot;request.getContent&quot;)&nbsp;AND&nbsp;request.getContent.useIncludeContentAfter&nbsp;neq&nbsp;&quot;&quot;&nbsp;AND&nbsp;(NOT&nbsp;isDefined(&quot;url.editPage&quot;)&nbsp;OR&nbsp;(isDefined(&quot;url.editPage&quot;)&nbsp;AND&nbsp;url.editPage&nbsp;eq&nbsp;0))&gt;<br> <b>46: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;#request.getContent.useIncludeContentAfter#&quot;&gt;</b><br> 47: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfif&gt;<br> 48: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/div&gt;&nbsp;&lt;!---&nbsp;/&nbsp;close&nbsp;savecontent&nbsp;---&gt;<br>
codePrintPlain
string44: #request.currentContent# 45: <cfif isDefined("request.getContent") AND request.getContent.useIncludeContentAfter neq "" AND (NOT isDefined("url.editPage") OR (isDefined("url.editPage") AND url.editPage eq 0))> 46: <cfinclude template="#request.getContent.useIncludeContentAfter#"> 47: </cfif> 48: </div> <!--- / close savecontent --->
column
number0
id
string??
line
number46
Raw_Trace
stringtemplates.basetemplate._blank_cfm$cf.call(/templates/BaseTemplate/_blank.cfm:46)
template
string/var/efs/www/omnia/templates/BaseTemplate/_blank.cfm
type
stringcfml
3
Struct
codePrintHTML
string95: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;templates/#request.getPage.themeName#/directoryDetail.cfm&quot;&gt;<br> 96: &nbsp;&nbsp;&nbsp;&lt;cfelse&gt;<br> <b>97: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;templates/#request.getPage.themeName#/#request.getPage.templateFile#&quot;&gt;</b><br> 98: &nbsp;&nbsp;&nbsp;&lt;/cfif&gt;<br> 99: &lt;/cfif&gt;<br>
codePrintPlain
string95: <cfinclude template="templates/#request.getPage.themeName#/directoryDetail.cfm"> 96: <cfelse> 97: <cfinclude template="templates/#request.getPage.themeName#/#request.getPage.templateFile#"> 98: </cfif> 99: </cfif>
column
number0
id
string??
line
number97
Raw_Trace
stringindex_cfm$cf.call(/index.cfm:97)
template
string/var/efs/www/omnia/index.cfm
type
stringcfml
type
stringdatabase
where
string