| Railo 2.0.1.001 Error (Database) |
| Message |
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 'ORDER BY correct DESC, total
LIMIT 0, 500' at line 5 |
| Detail |
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 'ORDER BY correct DESC, total
LIMIT 0, 500' at line 5 |
| SQL |
SELECT s.*, m.name
FROM bigones_standings s
LEFT JOIN t_members m ON m.id = s.userid
WHERE contestid =
ORDER BY correct DESC, total
LIMIT 0, 500
|
| Stacktrace |
The Error Occurred in
C:\www\states\components\bigones\contest.cfc: line 176
174: FROM bigones_standings s
175: LEFT JOIN t_members m ON m.id = s.userid
176: WHERE contestid = #Variables.ContestID#
177: ORDER BY correct DESC, total
178: LIMIT 0, 500
called fromC:\www\states\bigones\standings.cfm: line 35
33: <cfset contest=request.com.bigones.init(url.contestid)>
34: <cfset season=request.com.season.init(contest.getSeasonID())>
35: <cfset standings=contest.queryStandings()>
36: </cfif>
37:
|
| Java Stacktrace |
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 'ORDER BY correct DESC, total
LIMIT 0, 500' at line 5
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936):936
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934):2934
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616):1616
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708):1708
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249):3249
at com.mysql.jdbc.Connection.execSQL(Connection.java:3178):3178
at com.mysql.jdbc.Statement.execute(Statement.java:711):711
at railo.runtime.type.QueryImpl.(Unknown Source):-1
at railo.runtime.tag.Query.a(Unknown Source):-1
at railo.runtime.tag.Query.doEndTag(Unknown Source):-1
at components.bigones.contest$cfc.udfCall2(C:\www\states\components\bigones\contest.cfc:176):176
at components.bigones.contest$cfc.udfCall(C:\www\states\components\bigones\contest.cfc):-1
at railo.runtime.type.UDF.implementation(Unknown Source):-1
at railo.runtime.type.UDF.a(Unknown Source):-1
at railo.runtime.type.UDF.call(Unknown Source):-1
at railo.runtime.ComponentImpl.a(Unknown Source):-1
at railo.runtime.ComponentImpl._call(Unknown Source):-1
at railo.runtime.ComponentImpl.call(Unknown Source):-1
at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(Unknown Source):-1
at railo.runtime.PageContextImpl.getFunction(Unknown Source):-1
at bigones.standings$cfm.call(C:\www\states\bigones\standings.cfm:35):35
at railo.runtime.PageContextImpl.include(Unknown Source):-1
at railo.runtime.listener.ClassicAppListener._onRequest(Unknown Source):-1
at railo.runtime.listener.MixedAppListener.onRequest(Unknown Source):-1
at railo.runtime.PageContextImpl.execute(Unknown Source):-1
at railo.runtime.engine.CFMLEngineImpl.serviceCFML(Unknown Source):-1
at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32):32
at javax.servlet.http.HttpServlet.service(HttpServlet.java:91):91
at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103):103
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:175):175
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:240):240
at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:424):424
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:481):481
at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:685):685
at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:607):607
at java.lang.Thread.run(Unknown Source):-1
|
