Scope Arguments
11
Catch
Entries: 15
additional
Struct
SQL
string SELECT DATE(cards.timestamp) AS date, rarity.name, rarity.id, COUNT(*) AS count, COUNT(*) / total.count * 100 AS percent FROM cards INNER JOIN monsters ON cards.card_detail_id = monsters.id INNER JOIN rarity ON monsters.rarity = rarity.id INNER JOIN ( SELECT DATE(cards.timestamp) AS date, COUNT(*) AS count FROM cards INNER JOIN monsters ON cards.card_detail_id = monsters.id INNER JOIN rarity ON monsters.rarity = rarity.id GROUP BY DATE(cards.timestamp) ) AS total ON DATE(cards.timestamp) = total.date WHERE 1 = 1 AND cards.timestamp >= DATE_ADD(CURRENT_TIMESTAMP, INTERVAL -7 day) AND cards.card_uid LIKE 'G-%' GROUP BY DATE(cards.timestamp), rarity.name, rarity.id, total.count ORDER BY DATE(cards.timestamp), rarity.id
DatabaseName
stringMySQL
DatabaseVersion
string5.6.42-log
DriverName
stringMySQL-AB JDBC Driver
DriverVersion
stringmysql-connector-java-5.1.20 ( Revision: tonci.grgin@oracle.com-20111003110438-qfydx066wsbydkbw )
Datasource
stringsteemmonsters
DataSource
stringsteemmonsters
Detail
stringTable 'steemmonsters.cards' doesn't exist
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
string
NativeErrorCode
number1146
queryError
string SELECT DATE(cards.timestamp) AS date, rarity.name, rarity.id, COUNT(*) AS count, COUNT(*) / total.count * 100 AS percent FROM cards INNER JOIN monsters ON cards.card_detail_id = monsters.id INNER JOIN rarity ON monsters.rarity = rarity.id INNER JOIN ( SELECT DATE(cards.timestamp) AS date, COUNT(*) AS count FROM cards INNER JOIN monsters ON cards.card_detail_id = monsters.id INNER JOIN rarity ON monsters.rarity = rarity.id GROUP BY DATE(cards.timestamp) ) AS total ON DATE(cards.timestamp) = total.date WHERE 1 = 1 AND cards.timestamp >= DATE_ADD(CURRENT_TIMESTAMP, INTERVAL -7 day) AND cards.card_uid LIKE 'G-%' GROUP BY DATE(cards.timestamp), rarity.name, rarity.id, total.count ORDER BY DATE(cards.timestamp), rarity.id
Sql
string SELECT DATE(cards.timestamp) AS date, rarity.name, rarity.id, COUNT(*) AS count, COUNT(*) / total.count * 100 AS percent FROM cards INNER JOIN monsters ON cards.card_detail_id = monsters.id INNER JOIN rarity ON monsters.rarity = rarity.id INNER JOIN ( SELECT DATE(cards.timestamp) AS date, COUNT(*) AS count FROM cards INNER JOIN monsters ON cards.card_detail_id = monsters.id INNER JOIN rarity ON monsters.rarity = rarity.id GROUP BY DATE(cards.timestamp) ) AS total ON DATE(cards.timestamp) = total.date WHERE 1 = 1 AND cards.timestamp >= DATE_ADD(CURRENT_TIMESTAMP, INTERVAL -7 day) AND cards.card_uid LIKE 'G-%' GROUP BY DATE(cards.timestamp), rarity.name, rarity.id, total.count ORDER BY DATE(cards.timestamp), rarity.id
SQLState
string42S02
StackTrace
string at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method):-2 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62):62 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45):45 at java.lang.reflect.Constructor.newInstance(Constructor.java:422):422 at com.mysql.jdbc.Util.handleNewInstance(Util.java:411):411 at com.mysql.jdbc.Util.getInstance(Util.java:386):386 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052):1052 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096):4096 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028):4028 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490):2490 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651):2651 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2677):2677 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2627):2627 at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:841):841 at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681):681 at lucee.runtime.db.driver.state.StateUtil.execute(StateUtil.java:37):37 at lucee.runtime.db.driver.state.StateStatement.execute(StateStatement.java:43):43 at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:232):232 at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:244):244 at lucee.runtime.tag.Query.executeDatasoure(Query.java:815):815 at lucee.runtime.tag.Query.doEndTag(Query.java:610):610 at subsystems.steemmonsters.controllers.charts_cfc$cf.udfCall(/subsystems/steemmonsters/controllers/charts.cfc:227):227 at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112):112 at lucee.runtime.type.UDFImpl._call(UDFImpl.java:329):329 at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:217):217 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524 at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1780):1780 at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:776):776 at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:770):770 at lucee.runtime.util.VariableUtilImpl.callFunction(VariableUtilImpl.java:731):731 at lucee.runtime.interpreter.ref.func.UDFCall.getValue(UDFCall.java:65):65 at lucee.runtime.interpreter.CFMLExpressionInterpreter.interpret(CFMLExpressionInterpreter.java:217):217 at lucee.runtime.functions.dynamicEvaluation.Evaluate._call(Evaluate.java:109):109 at lucee.runtime.functions.dynamicEvaluation.Evaluate.call(Evaluate.java:102):102 at lucee.runtime.functions.dynamicEvaluation.Evaluate.call(Evaluate.java:43):43 at zero.zero_cfc$cf.udfCall5(/zero/zero.cfc:1975):1975 at zero.zero_cfc$cf.udfCall(/zero/zero.cfc):-1 at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112):112 at lucee.runtime.type.UDFImpl._call(UDFImpl.java:329):329 at lucee.runtime.type.UDFImpl.call(UDFImpl.java:230):230 at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:766):766 at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:745):745 at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1601):1601 at zero.one_cfc$cf.udfCall5(/zero/one.cfc:835):835 at zero.one_cfc$cf.udfCall(/zero/one.cfc):-1 at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112):112 at lucee.runtime.type.UDFImpl._call(UDFImpl.java:329):329 at lucee.runtime.type.UDFImpl.call(UDFImpl.java:230):230 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:532):532 at lucee.runtime.SuperComponent.call(SuperComponent.java:80):80 at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:745):745 at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1601):1601 at zero.zero_cfc$cf.udfCall8(/zero/zero.cfc:2760):2760 at zero.zero_cfc$cf.udfCall(/zero/zero.cfc):-1 at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112):112 at lucee.runtime.type.UDFImpl._call(UDFImpl.java:329):329 at lucee.runtime.type.UDFImpl.call(UDFImpl.java:230):230 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524 at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1763):1763 at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:414):414 at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:223):223 at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:37):37 at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2276):2276 at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2239):2239 at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:460):460 at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:47):47 at javax.servlet.http.HttpServlet.service(HttpServlet.java:729):729 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291):291 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239):239 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217):217 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106):106 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502):502 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142):142 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79):79 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88):88 at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:676):676 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518):518 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091):1091 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673):673 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500):1500 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456):1456 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142):1142 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617):617 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61):61 at java.lang.Thread.run(Thread.java:745):745
TagContext
Array
1
Struct
codePrintHTML
string225: &quot;;<br> 226: query name=&quot;results&quot; datasource=&quot;steemmonsters&quot; {<br> <b>227: echo(sql);</b><br> 228: }<br> 229: <br>
codePrintPlain
string225: "; 226: query name="results" datasource="steemmonsters" { 227: echo(sql); 228: } 229:
column
number0
id
string??
line
number227
Raw_Trace
stringsubsystems.steemmonsters.controllers.charts_cfc$cf.udfCall(/subsystems/steemmonsters/controllers/charts.cfc:227)
template
string/var/www/steemmonstersdb.com/subsystems/steemmonsters/controllers/charts.cfc
type
stringcfml
2
Struct
codePrintHTML
string1973: // request._zero.controllerResult = evaluate( 'cfc.#method#( argumentCollection = argsToPass)' );<br> 1974: try {<br> <b>1975: request._zero.controllerResult = evaluate( 'cfc.#method#( argumentCollection = argsToPass)' );</b><br> 1976: } catch(any e){<br> 1977: <br>
codePrintPlain
string1973: // request._zero.controllerResult = evaluate( 'cfc.#method#( argumentCollection = argsToPass)' ); 1974: try { 1975: request._zero.controllerResult = evaluate( 'cfc.#method#( argumentCollection = argsToPass)' ); 1976: } catch(any e){ 1977:
column
number0
id
string??
line
number1975
Raw_Trace
stringzero.zero_cfc$cf.udfCall5(/zero/zero.cfc:1975)
template
string/var/www/steemmonstersdb.com/zero/zero.cfc
type
stringcfml
3
Struct
codePrintHTML
string833: if ( structKeyExists( request._fw1, 'abortController' ) ) abortController();<br> 834: }<br> <b>835: doController( tuple, tuple.item, 'item' );</b><br> 836: if ( structKeyExists( request._fw1, 'abortController' ) ) abortController();<br> 837: }<br>
codePrintPlain
string833: if ( structKeyExists( request._fw1, 'abortController' ) ) abortController(); 834: } 835: doController( tuple, tuple.item, 'item' ); 836: if ( structKeyExists( request._fw1, 'abortController' ) ) abortController(); 837: }
column
number0
id
string??
line
number835
Raw_Trace
stringzero.one_cfc$cf.udfCall5(/zero/one.cfc:835)
template
string/var/www/steemmonstersdb.com/zero/one.cfc
type
stringcfml
4
Struct
codePrintHTML
string2758: var finalOutput = &quot;&quot;;<br> 2759: savecontent variable=&quot;finalOutput&quot; {<br> <b>2760: super.onRequest();</b><br> 2761: }<br> 2762: request._zero.htmlOut = finalOutput;<br>
codePrintPlain
string2758: var finalOutput = ""; 2759: savecontent variable="finalOutput" { 2760: super.onRequest(); 2761: } 2762: request._zero.htmlOut = finalOutput;
column
number0
id
string??
line
number2760
Raw_Trace
stringzero.zero_cfc$cf.udfCall8(/zero/zero.cfc:2760)
template
string/var/www/steemmonstersdb.com/zero/zero.cfc
type
stringcfml
type
stringdatabase
where
string
22
stringdoController