Exception in onError

The action main.topic failed.

Unable to find a view for 'main.error' action.

'/views/main/error.cfm' does not exist. (FW1.viewNotFound)

Exception
Catch
additional
Struct
code
string
Detail
string'/views/main/error.cfm' does not exist.
ErrorCode
string
Extended_Info
string
ExtendedInfo
string
Message
stringUnable to find a view for 'main.error' action.
StackTrace
stringUnable to find a view for 'main.error' action. at org.corfield.framework_cfc$cf.udfCall8(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc:1485):1485 at org.corfield.framework_cfc$cf.udfCall(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:109):109 at railo.runtime.type.UDFImpl._call(UDFImpl.java:326):326 at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214):214 at railo.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:773):773 at railo.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:771):771 at railo.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1573):1573 at org.corfield.framework_cfc$cf.udfCall9(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc:1763):1763 at org.corfield.framework_cfc$cf.udfCall(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:109):109 at railo.runtime.type.UDFImpl._call(UDFImpl.java:326):326 at railo.runtime.type.UDFImpl.call(UDFImpl.java:227):227 at railo.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:764):764 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:740):740 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1563):1563 at org.corfield.framework_cfc$cf.udfCall3(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc:580):580 at org.corfield.framework_cfc$cf.udfCall(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:109):109 at railo.runtime.type.UDFImpl._call(UDFImpl.java:326):326 at railo.runtime.type.UDFImpl.call(UDFImpl.java:227):227 at railo.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:764):764 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:740):740 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1563):1563 at org.corfield.framework_cfc$cf.udfCall4(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc:667):667 at org.corfield.framework_cfc$cf.udfCall(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:109):109 at railo.runtime.type.UDFImpl._call(UDFImpl.java:326):326 at railo.runtime.type.UDFImpl.call(UDFImpl.java:227):227 at railo.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:764):764 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:740):740 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1563):1563 at org.corfield.framework_cfc$cf.udfCall3(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc:566):566 at org.corfield.framework_cfc$cf.udfCall(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:109):109 at railo.runtime.type.UDFImpl._call(UDFImpl.java:326):326 at railo.runtime.type.UDFImpl.call(UDFImpl.java:227):227 at railo.runtime.ComponentImpl._call(ComponentImpl.java:639):639 at railo.runtime.ComponentImpl._call(ComponentImpl.java:522):522 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1754):1754 at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:404):404 at railo.runtime.listener.ModernAppListener.onError(ModernAppListener.java:391):391 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2239):2239 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2195):2195 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:353):353 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29 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:472):472 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:407):407 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(ThreadPoolExecutor.java:1145):1145 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615):615 at java.lang.Thread.run(Thread.java:745):745
TagContext
Array
1
Struct
codePrintHTML
string1483: <br> 1484: private void function raiseException( string type, string message, string detail ) {<br> <b>1485: throw( type = type, message = message, detail = detail );</b><br> 1486: }<br> 1487: <br>
codePrintPlain
string1483: 1484: private void function raiseException( string type, string message, string detail ) { 1485: throw( type = type, message = message, detail = detail ); 1486: } 1487:
column
number0
id
string??
line
number1485
Raw_Trace
stringorg.corfield.framework_cfc$cf.udfCall8(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc:1485)
template
string/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc
type
stringcfml
2
Struct
codePrintHTML
string1761: private void function viewNotFound() {<br> 1762: raiseException( type=&quot;FW1.viewNotFound&quot;, message=&quot;Unable to find a view for '#request.action#' action.&quot;,<br> <b>1763: detail=&quot;'#request.missingView#' does not exist.&quot; );</b><br> 1764: }<br> 1765: <br>
codePrintPlain
string1761: private void function viewNotFound() { 1762: raiseException( type="FW1.viewNotFound", message="Unable to find a view for '#request.action#' action.", 1763: detail="'#request.missingView#' does not exist." ); 1764: } 1765:
column
number0
id
string??
line
number1763
Raw_Trace
stringorg.corfield.framework_cfc$cf.udfCall9(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc:1763)
template
string/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc
type
stringcfml
3
Struct
codePrintHTML
string578: public void function onMissingView( struct rc ) {<br> 579: // unable to find a matching view - fail with a nice exception<br> <b>580: viewNotFound();</b><br> 581: // if we got here, we would return the string to be rendered<br> 582: // but viewNotFound() throws an exception...<br>
codePrintPlain
string578: public void function onMissingView( struct rc ) { 579: // unable to find a matching view - fail with a nice exception 580: viewNotFound(); 581: // if we got here, we would return the string to be rendered 582: // but viewNotFound() throws an exception...
column
number0
id
string??
line
number580
Raw_Trace
stringorg.corfield.framework_cfc$cf.udfCall3(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc:580)
template
string/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc
type
stringcfml
4
Struct
codePrintHTML
string665: out = internalView( request.view );<br> 666: } else {<br> <b>667: out = onMissingView( request.context );</b><br> 668: }<br> 669: for ( i = 1; i &lt;= arrayLen(request.layouts); i = i + 1 ) {<br>
codePrintPlain
string665: out = internalView( request.view ); 666: } else { 667: out = onMissingView( request.context ); 668: } 669: for ( i = 1; i <= arrayLen(request.layouts); i = i + 1 ) {
column
number0
id
string??
line
number667
Raw_Trace
stringorg.corfield.framework_cfc$cf.udfCall4(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc:667)
template
string/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc
type
stringcfml
5
Struct
codePrintHTML
string564: <br> 565: setupRequestWrapper( false );<br> <b>566: onRequest( '' );</b><br> 567: } catch ( any e ) {<br> 568: failure( e, 'onError' );<br>
codePrintPlain
string564: 565: setupRequestWrapper( false ); 566: onRequest( '' ); 567: } catch ( any e ) { 568: failure( e, 'onError' );
column
number0
id
string??
line
number566
Raw_Trace
stringorg.corfield.framework_cfc$cf.udfCall3(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc:566)
template
string/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc
type
stringcfml
type
stringFW1.viewNotFound

Original exception in onRequest

The action main.topic failed.

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 p.name, ap.orderID, ap.id' at line 7 (database)

Exception
Struct
Entries: 15
additional
Struct
SQL
string select p.id as paperID, p.name as title, p.year, a.id as authorID, a.firstname, a.surname, a.employment, a.location, t.id as topicID, t.name as topic from papers p left join authorspapers ap on p.id = ap.paperID left join authors a on ap.authorID = a.id left join keyarea t on p.keyAreaID = t.id where t.id = order by p.name, ap.orderID, ap.id
DatabaseName
stringMySQL
DatabaseVersion
string5.5.28
DriverName
stringMySQL-AB JDBC Driver
DriverVersion
stringmysql-connector-java-5.0.8 ( Revision: ${svn.Revision} )
Datasource
stringpolicing
DataSource
stringpolicing
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 'order by p.name, ap.orderID, ap.id' at line 7
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
string
NativeErrorCode
number1064
queryError
string select p.id as paperID, p.name as title, p.year, a.id as authorID, a.firstname, a.surname, a.employment, a.location, t.id as topicID, t.name as topic from papers p left join authorspapers ap on p.id = ap.paperID left join authors a on ap.authorID = a.id left join keyarea t on p.keyAreaID = t.id where t.id = order by p.name, ap.orderID, ap.id
Sql
string select p.id as paperID, p.name as title, p.year, a.id as authorID, a.firstname, a.surname, a.employment, a.location, t.id as topicID, t.name as topic from papers p left join authorspapers ap on p.id = ap.paperID left join authors a on ap.authorID = a.id left join keyarea t on p.keyAreaID = t.id where t.id = order by p.name, ap.orderID, ap.id
SQLState
string42000
StackTrace
string at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936):936 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985):2985 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631):1631 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723):1723 at com.mysql.jdbc.Connection.execSQL(Connection.java:3277):3277 at com.mysql.jdbc.Connection.execSQL(Connection.java:3206):3206 at com.mysql.jdbc.Statement.execute(Statement.java:727):727 at railo.runtime.db.driver.state.StateUtil.execute(StateUtil.java:35):35 at railo.runtime.db.driver.state.StateStatement.execute(StateStatement.java:41):41 at railo.runtime.type.util.QueryUtil.execute(QueryUtil.java:230):230 at railo.runtime.type.QueryImpl.<init>(QueryImpl.java:240):240 at railo.runtime.tag.Query.executeDatasoure(Query.java:703):703 at railo.runtime.tag.Query.doEndTag(Query.java:547):547 at views.main.topic_cfm$cf.call(/Web/acrs.org.au/arsrpe/views/main/topic.cfm:11):11 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:925):925 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:829):829 at org.corfield.framework_cfc$cf.udfCall7(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc:1368):1368 at org.corfield.framework_cfc$cf.udfCall(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:109):109 at railo.runtime.type.UDFImpl._call(UDFImpl.java:326):326 at railo.runtime.type.UDFImpl.call(UDFImpl.java:227):227 at railo.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:764):764 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:740):740 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1563):1563 at org.corfield.framework_cfc$cf.udfCall4(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc:665):665 at org.corfield.framework_cfc$cf.udfCall(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:109):109 at railo.runtime.type.UDFImpl._call(UDFImpl.java:326):326 at railo.runtime.type.UDFImpl.call(UDFImpl.java:227):227 at railo.runtime.ComponentImpl._call(ComponentImpl.java:639):639 at railo.runtime.ComponentImpl._call(ComponentImpl.java:522):522 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1754):1754 at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:404):404 at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:220):220 at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:34):34 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2228):2228 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2195):2195 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:353):353 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29 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:472):472 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:407):407 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(ThreadPoolExecutor.java:1145):1145 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615):615 at java.lang.Thread.run(Thread.java:745):745
TagContext
Array
1
Struct
codePrintHTML
string9: where t.id = #rc.id#<br> 10: order by p.name, ap.orderID, ap.id<br> <b>11: &lt;/cfquery&gt;</b><br> 12: <br> 13: &lt;h2&gt;&lt;cfoutput&gt;#papers.topic#&lt;/cfoutput&gt;&lt;/h2&gt;<br>
codePrintPlain
string9: where t.id = #rc.id# 10: order by p.name, ap.orderID, ap.id 11: </cfquery> 12: 13: <h2><cfoutput>#papers.topic#</cfoutput></h2>
column
number0
id
string??
line
number11
Raw_Trace
stringviews.main.topic_cfm$cf.call(/Web/acrs.org.au/arsrpe/views/main/topic.cfm:11)
template
string/Web/acrs.org.au/arsrpe/views/main/topic.cfm
type
stringcfml
2
Struct
codePrintHTML
string1366: var response = '';<br> 1367: savecontent variable=&quot;response&quot; {<br> <b>1368: include '#viewPath#';</b><br> 1369: }<br> 1370: return response;<br>
codePrintPlain
string1366: var response = ''; 1367: savecontent variable="response" { 1368: include '#viewPath#'; 1369: } 1370: return response;
column
number0
id
string??
line
number1368
Raw_Trace
stringorg.corfield.framework_cfc$cf.udfCall7(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc:1368)
template
string/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc
type
stringcfml
3
Struct
codePrintHTML
string663: <br> 664: if ( structKeyExists(request, 'view') ) {<br> <b>665: out = internalView( request.view );</b><br> 666: } else {<br> 667: out = onMissingView( request.context );<br>
codePrintPlain
string663: 664: if ( structKeyExists(request, 'view') ) { 665: out = internalView( request.view ); 666: } else { 667: out = onMissingView( request.context );
column
number0
id
string??
line
number665
Raw_Trace
stringorg.corfield.framework_cfc$cf.udfCall4(/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc:665)
template
string/Web/acrs.org.au/arsrpe/org/corfield/framework.cfc
type
stringcfml
type
stringdatabase
where
string