Smyrna High School

Bulldogs  ·  Smyrna, TN

Smyrna High School

Bulldogs  ·  Smyrna, TN

Printable Report @smyrnaathletics

Catch
Entries: 15
additional
Struct
SQL
string SELECT Year(gameDateTime) AS gameYear, gameDateTime, championshipid, bracketGameID, Left(bracketGameID, 1) AS round, isConsolation, IF(topSchoolID = 457, bottomSchoolID, topSchoolID) AS opponentSchoolID, IF(topSchoolID = 457, bottomSchoolName, topSchoolName) AS opponentSchool, IF(topSchoolScore > bottomSchoolScore, topSchoolID, bottomSchoolID) AS winningSchoolID, IF(topSchoolScore > bottomSchoolScore, topSchoolName, bottomSchoolName) AS winningSchool, IF(topSchoolScore > bottomSchoolScore, topSchoolScore, bottomSchoolScore) AS winningScore, IF(topSchoolScore < bottomSchoolScore, topSchoolID, bottomSchoolID) AS defeatedSchoolID, IF(topSchoolScore < bottomSchoolScore, topSchoolName, bottomSchoolName) AS defeatedSchool, IF(topSchoolScore < bottomSchoolScore, topSchoolScore, bottomSchoolScore) AS defeatedScore, IF( (topSchoolID = 457 AND topSchoolScore > bottomSchoolScore) OR (bottomSchoolID = 457 AND topSchoolScore < bottomSchoolScore), 1, 0) AS win, IF( (topSchoolID = 457 AND topSchoolScore < bottomSchoolScore) OR (bottomSchoolID = 457 AND topSchoolScore > bottomSchoolScore), 1, 0) AS loss FROM championship_events WHERE sportid = 1 AND schoolType = "high" AND seriesNew = "state" AND gameDateTime IS NOT NULL AND (topSchoolID = 457 OR bottomSchoolID = 457) ORDER BY gameDateTime, displayGameNumber DESC
DatabaseName
stringMySQL
DatabaseVersion
string5.7.13-log
DriverName
stringMySQL Connector Java
DriverVersion
stringmysql-connector-java-5.1.36 ( Revision: 4fc1f969f740409a4e03750316df2c0e429f3dc8 )
Datasource
stringproduction
DataSource
stringproduction
Detail
stringUnknown column 'seriesNew' in 'where clause'
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
string
NativeErrorCode
number1054
queryError
string SELECT Year(gameDateTime) AS gameYear, gameDateTime, championshipid, bracketGameID, Left(bracketGameID, 1) AS round, isConsolation, IF(topSchoolID = 457, bottomSchoolID, topSchoolID) AS opponentSchoolID, IF(topSchoolID = 457, bottomSchoolName, topSchoolName) AS opponentSchool, IF(topSchoolScore > bottomSchoolScore, topSchoolID, bottomSchoolID) AS winningSchoolID, IF(topSchoolScore > bottomSchoolScore, topSchoolName, bottomSchoolName) AS winningSchool, IF(topSchoolScore > bottomSchoolScore, topSchoolScore, bottomSchoolScore) AS winningScore, IF(topSchoolScore < bottomSchoolScore, topSchoolID, bottomSchoolID) AS defeatedSchoolID, IF(topSchoolScore < bottomSchoolScore, topSchoolName, bottomSchoolName) AS defeatedSchool, IF(topSchoolScore < bottomSchoolScore, topSchoolScore, bottomSchoolScore) AS defeatedScore, IF( (topSchoolID = 457 AND topSchoolScore > bottomSchoolScore) OR (bottomSchoolID = 457 AND topSchoolScore < bottomSchoolScore), 1, 0) AS win, IF( (topSchoolID = 457 AND topSchoolScore < bottomSchoolScore) OR (bottomSchoolID = 457 AND topSchoolScore > bottomSchoolScore), 1, 0) AS loss FROM championship_events WHERE sportid = 1 AND schoolType = "high" AND seriesNew = "state" AND gameDateTime IS NOT NULL AND (topSchoolID = 457 OR bottomSchoolID = 457) ORDER BY gameDateTime, displayGameNumber DESC
Sql
string SELECT Year(gameDateTime) AS gameYear, gameDateTime, championshipid, bracketGameID, Left(bracketGameID, 1) AS round, isConsolation, IF(topSchoolID = 457, bottomSchoolID, topSchoolID) AS opponentSchoolID, IF(topSchoolID = 457, bottomSchoolName, topSchoolName) AS opponentSchool, IF(topSchoolScore > bottomSchoolScore, topSchoolID, bottomSchoolID) AS winningSchoolID, IF(topSchoolScore > bottomSchoolScore, topSchoolName, bottomSchoolName) AS winningSchool, IF(topSchoolScore > bottomSchoolScore, topSchoolScore, bottomSchoolScore) AS winningScore, IF(topSchoolScore < bottomSchoolScore, topSchoolID, bottomSchoolID) AS defeatedSchoolID, IF(topSchoolScore < bottomSchoolScore, topSchoolName, bottomSchoolName) AS defeatedSchool, IF(topSchoolScore < bottomSchoolScore, topSchoolScore, bottomSchoolScore) AS defeatedScore, IF( (topSchoolID = 457 AND topSchoolScore > bottomSchoolScore) OR (bottomSchoolID = 457 AND topSchoolScore < bottomSchoolScore), 1, 0) AS win, IF( (topSchoolID = 457 AND topSchoolScore < bottomSchoolScore) OR (bottomSchoolID = 457 AND topSchoolScore > bottomSchoolScore), 1, 0) AS loss FROM championship_events WHERE sportid = 1 AND schoolType = "high" AND seriesNew = "state" AND gameDateTime IS NOT NULL AND (topSchoolID = 457 OR bottomSchoolID = 457) ORDER BY gameDateTime, displayGameNumber DESC
SQLState
string42S22
StackTrace
string at sun.reflect.GeneratedConstructorAccessor39.newInstance(Unknown Source):-1 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source):-1 at java.lang.reflect.Constructor.newInstance(Unknown Source):-1 at com.mysql.jdbc.Util.handleNewInstance(Util.java:400):400 at com.mysql.jdbc.Util.getInstance(Util.java:383):383 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980):980 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847):3847 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783):3783 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447):2447 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594):2594 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541):2541 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499):2499 at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:844):844 at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:748):748 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:243):243 at lucee.runtime.tag.Query.executeDatasoure(Query.java:815):815 at lucee.runtime.tag.Query.doEndTag(Query.java:610):610 at school.sport_cfm$cf.call(/school/sport.cfm:115):115 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:957):957 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:861):861 at school.index_cfm$cf.call(/school/index.cfm:26):26 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:957):957 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909 at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:225):225 at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:37):37 at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2271):2271 at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2234):2234 at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:456):456 at lucee.loader.servlet.CFMLServlet.service(Unknown Source):-1 at javax.servlet.http.HttpServlet.service(HttpServlet.java:728):728 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305):305 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222):222 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123):123 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502):502 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171):171 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99):99 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118):118 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408):408 at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200):200 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589):589 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310):310 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source):-1 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source):-1 at java.lang.Thread.run(Unknown Source):-1
TagContext
Array
1
Struct
codePrintHTML
string113: AND (topSchoolID = #school.id# OR bottomSchoolID = #school.id#)<br> 114: ORDER BY gameDateTime, displayGameNumber DESC<br> <b>115: &lt;/cfquery&gt;</b><br> 116: <br> 117: &lt;cfquery name=&quot;appearances&quot; datasource=&quot;#request.datasource#&quot;&gt;<br>
codePrintPlain
string113: AND (topSchoolID = #school.id# OR bottomSchoolID = #school.id#) 114: ORDER BY gameDateTime, displayGameNumber DESC 115: </cfquery> 116: 117: <cfquery name="appearances" datasource="#request.datasource#">
column
number0
id
string??
line
number115
Raw_Trace
stringschool.sport_cfm$cf.call(/school/sport.cfm:115)
template
stringC:\home\tssaa.org\subdomains\champs\school\sport.cfm
type
stringcfml
2
Struct
codePrintHTML
string24: &lt;cfinclude template=&quot;tournament.cfm&quot;&gt;<br> 25: &lt;cfelseif isDefined(&quot;url.sportid&quot;)&gt;<br> <b>26: &lt;cfinclude template=&quot;sport.cfm&quot;&gt;</b><br> 27: &lt;cfelse&gt;<br> 28: &lt;cfinclude template=&quot;school.cfm&quot;&gt;<br>
codePrintPlain
string24: <cfinclude template="tournament.cfm"> 25: <cfelseif isDefined("url.sportid")> 26: <cfinclude template="sport.cfm"> 27: <cfelse> 28: <cfinclude template="school.cfm">
column
number0
id
string??
line
number26
Raw_Trace
stringschool.index_cfm$cf.call(/school/index.cfm:26)
template
stringC:\home\tssaa.org\subdomains\champs\school\index.cfm
type
stringcfml
type
stringdatabase
where
string