Catch
Entries: 15
additional
Struct
SQL
string SELECT TOP 4 * FROM yafIssue WHERE objectID NOT IN ('4E062140-2960-11E2-84A9005056A302E6') AND status IN ('approved') ORDER BY DateTimecreated DESC
DatabaseName
string MySQL
DatabaseVersion
string 5.6.21-log
DriverName
string MySQL-AB JDBC Driver
DriverVersion
string mysql-connector-java-5.1.20 ( Revision: tonci.grgin@oracle.com-20111003110438-qfydx066wsbydkbw )
Datasource
string defence
DataSource
string defence
Detail
string 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 '4 * FROM yafIssue WHERE objectID NOT IN ('4E062140-2960-11E2-84A9005056A302E' at line 1
ErrorCode
string 0
Extended_Info
string
ExtendedInfo
string
Message
string
NativeErrorCode
number 1064
queryError
string SELECT TOP 4 * FROM yafIssue WHERE objectID NOT IN ('4E062140-2960-11E2-84A9005056A302E6') AND status IN ('approved') ORDER BY DateTimecreated DESC
Sql
string SELECT TOP 4 * FROM yafIssue WHERE objectID NOT IN ('4E062140-2960-11E2-84A9005056A302E6') AND status IN ('approved') ORDER BY DateTimecreated DESC
SQLState
string 42000
StackTrace
string at sun.reflect.GeneratedConstructorAccessor202.newInstance(Unknown Source):-1 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45):45 at java.lang.reflect.Constructor.newInstance(Constructor.java:526):526 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 com.intergral.fusionreactor.jdbc.StatementSurrogate.execute(StatementSurrogate.java:161):161 at railo.runtime.db.driver.state.StateUtil.execute(StateUtil.java:19):19 at railo.runtime.db.driver.state.StateStatement.execute(StateStatement.java:25):25 at railo.runtime.type.util.QueryUtil.execute(QueryUtil.java:214):214 at railo.runtime.type.QueryImpl.<init>(QueryImpl.java:224):224 at railo.runtime.tag.Query.executeDatasoure(Query.java:694):694 at railo.runtime.tag.Query.doEndTag(Query.java:533):533 at plugins.skinadmsite.webskin.yafissue.displaybody_cfm$cf.call(/farcry/plugins/skinAdmSite/webskin/yafIssue/displayBody.cfm:16):16 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:913):913 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:817):817 at core.packages.fourq.fourq_cfc$cf.udfCall1(/farcry/core/packages/fourq/fourq.cfc:449):449 at core.packages.fourq.fourq_cfc$cf.udfCall(/farcry/core/packages/fourq/fourq.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:92):92 at railo.runtime.type.UDFImpl._call(UDFImpl.java:306):306 at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:194):194 at railo.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:757):757 at railo.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:755):755 at railo.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1564):1564 at core.packages.fourq.fourq_cfc$cf.udfCall1(/farcry/core/packages/fourq/fourq.cfc:342):342 at core.packages.fourq.fourq_cfc$cf.udfCall(/farcry/core/packages/fourq/fourq.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:92):92 at railo.runtime.type.UDFImpl._call(UDFImpl.java:306):306 at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:194):194 at railo.runtime.ComponentImpl._call(ComponentImpl.java:624):624 at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506 at railo.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1751):1751 at railo.runtime.tag.Invoke.doComponent(Invoke.java:203):203 at railo.runtime.tag.Invoke.doEndTag(Invoke.java:176):176 at core.tags.webskin.view_cfm$cf.call(/farcry/core/tags/webskin/view.cfm:140):140 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:913):913 at railo.runtime.tag.CFTag.doInclude(CFTag.java:304):304 at railo.runtime.tag.CFTag.cfmlStartTag(CFTag.java:226):226 at railo.runtime.tag.CFTag.doStartTag(CFTag.java:158):158 at plugins.skinadmsite.webskin.types.displaypagestandard_cfm$cf.call(/farcry/plugins/skinAdmSite/webskin/types/displayPageStandard.cfm:25):25 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:913):913 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:817):817 at core.packages.fourq.fourq_cfc$cf.udfCall1(/farcry/core/packages/fourq/fourq.cfc:449):449 at core.packages.fourq.fourq_cfc$cf.udfCall(/farcry/core/packages/fourq/fourq.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:92):92 at railo.runtime.type.UDFImpl._call(UDFImpl.java:306):306 at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:194):194 at railo.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:757):757 at railo.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:755):755 at railo.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1564):1564 at core.packages.fourq.fourq_cfc$cf.udfCall1(/farcry/core/packages/fourq/fourq.cfc:342):342 at core.packages.fourq.fourq_cfc$cf.udfCall(/farcry/core/packages/fourq/fourq.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:92):92 at railo.runtime.type.UDFImpl._call(UDFImpl.java:306):306 at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:194):194 at railo.runtime.ComponentImpl._call(ComponentImpl.java:624):624 at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506 at railo.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1751):1751 at railo.runtime.tag.Invoke.doComponent(Invoke.java:203):203 at railo.runtime.tag.Invoke.doEndTag(Invoke.java:176):176 at core.tags.webskin.view_cfm$cf.call(/farcry/core/tags/webskin/view.cfm:140):140 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:913):913 at railo.runtime.tag.CFTag.doInclude(CFTag.java:304):304 at railo.runtime.tag.CFTag.cfmlStartTag(CFTag.java:226):226 at railo.runtime.tag.CFTag.doStartTag(CFTag.java:158):158 at core.tags.navajo.display_cfm$cf.call(/farcry/core/tags/navajo/display.cfm:232):232 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:913):913 at railo.runtime.tag.CFTag.doInclude(CFTag.java:304):304 at railo.runtime.tag.CFTag.cfmlStartTag(CFTag.java:226):226 at railo.runtime.tag.CFTag.doStartTag(CFTag.java:158):158 at index_cfm$cf.call(/index.cfm:8):8 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:913):913 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:865):865 at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:206):206 at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:18):18 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2218):2218 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2185):2185 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:332):332 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29 at javax.servlet.http.HttpServlet.service(HttpServlet.java:727):727 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303):303 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241):241 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208 at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source):-1 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43):43 at java.lang.reflect.Method.invoke(Method.java:606):606 at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:97):97 at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:472):472 at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:312):312 at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:192):192 at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:507):507 at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36):36 at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source):-1 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43):43 at java.lang.reflect.Method.invoke(Method.java:606):606 at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:79):79 at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source):-1 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43):43 at java.lang.reflect.Method.invoke(Method.java:606):606 at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:53):53 at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41):41 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java):-1 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220):220 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122):122 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501):501 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171):171 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102):102 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116):116 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408):408 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040):1040 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607):607 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314):314 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145):1145 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615):615 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
string 14: WHERE objectID NOT IN ('#stoBj.objectid#') AND status IN ('#ListChangeDelims(request.mode.lValidStatus,&quot;','&quot;,&quot;,&quot;)#') <br> 15: ORDER BY DateTimecreated DESC<br> <b>16: &lt;/cfquery&gt;</b><br> 17: <br> 18: &lt;cfoutput&gt;<br>
codePrintPlain
string 14: WHERE objectID NOT IN ('#stoBj.objectid#') AND status IN ('#ListChangeDelims(request.mode.lValidStatus,"','",",")#') 15: ORDER BY DateTimecreated DESC 16: </cfquery> 17: 18: <cfoutput>
column
number 0
id
string ??
line
number 16
Raw_Trace
string plugins.skinadmsite.webskin.yafissue.displaybody_cfm$cf.call(/farcry/plugins/skinAdmSite/webskin/yafIssue/displayBody.cfm:16)
template
string /farcry/plugins/skinAdmSite/webskin/yafIssue/displayBody.cfm
type
string cfml
2
Struct
codePrintHTML
string 447: <br> 448: &lt;!--- INCLUDE THE WEBSKIN ---&gt;<br> <b>449: &lt;cfinclude template=&quot;#arguments.WebskinPath#&quot;&gt;</b><br> 450: <br> 451: &lt;/farcry:traceWebskin&gt;<br>
codePrintPlain
string 447: 448: <!--- INCLUDE THE WEBSKIN ---> 449: <cfinclude template="#arguments.WebskinPath#"> 450: 451: </farcry:traceWebskin>
column
number 0
id
string ??
line
number 449
Raw_Trace
string core.packages.fourq.fourq_cfc$cf.udfCall1(/farcry/core/packages/fourq/fourq.cfc:449)
template
string /farcry/core/packages/fourq/fourq.cfc
type
string cfml
3
Struct
codePrintHTML
string 340: onExitProcess=&quot;#arguments.onExitProcess#&quot;,<br> 341: dsn=&quot;#arguments.dsn#&quot;,<br> <b>342: bAllowTrace=&quot;#arguments.bAllowTrace#&quot;) /&gt;</b><br> 343: <br> 344: &lt;cfelseif structKeyExists(arguments, &quot;alternateHTML&quot;)&gt;<br>
codePrintPlain
string 340: onExitProcess="#arguments.onExitProcess#", 341: dsn="#arguments.dsn#", 342: bAllowTrace="#arguments.bAllowTrace#") /> 343: 344: <cfelseif structKeyExists(arguments, "alternateHTML")>
column
number 0
id
string ??
line
number 342
Raw_Trace
string core.packages.fourq.fourq_cfc$cf.udfCall1(/farcry/core/packages/fourq/fourq.cfc:342)
template
string /farcry/core/packages/fourq/fourq.cfc
type
string cfml
4
Struct
codePrintHTML
string 138: &lt;cfinvokeargument name=&quot;alternateHTML&quot; value=&quot;#attributes.alternateHTML#&quot; /&gt;<br> 139: &lt;/cfif&gt;<br> <b>140: &lt;/cfinvoke&gt;</b><br> 141: <br> 142: &lt;cfelse&gt;<br>
codePrintPlain
string 138: <cfinvokeargument name="alternateHTML" value="#attributes.alternateHTML#" /> 139: </cfif> 140: </cfinvoke> 141: 142: <cfelse>
column
number 0
id
string ??
line
number 140
Raw_Trace
string core.tags.webskin.view_cfm$cf.call(/farcry/core/tags/webskin/view.cfm:140)
template
string /farcry/core/tags/webskin/view.cfm
type
string cfml
5
Struct
codePrintHTML
string 23: &lt;/cfoutput&gt;<br> 24: <br> <b>25: &lt;skin:view objectid=&quot;#stobj.objectid#&quot; typename=&quot;#stobj.typename#&quot; template=&quot;#url.bodyView#&quot; /&gt;</b><br> 26: <br> 27: &lt;con:container label=&quot;#stobj.objectID#_body&quot; /&gt; <br>
codePrintPlain
string 23: </cfoutput> 24: 25: <skin:view objectid="#stobj.objectid#" typename="#stobj.typename#" template="#url.bodyView#" /> 26: 27: <con:container label="#stobj.objectID#_body" />
column
number 0
id
string ??
line
number 25
Raw_Trace
string plugins.skinadmsite.webskin.types.displaypagestandard_cfm$cf.call(/farcry/plugins/skinAdmSite/webskin/types/displayPageStandard.cfm:25)
template
string /farcry/plugins/skinAdmSite/webskin/types/displayPageStandard.cfm
type
string cfml
6
Struct
codePrintHTML
string 447: <br> 448: &lt;!--- INCLUDE THE WEBSKIN ---&gt;<br> <b>449: &lt;cfinclude template=&quot;#arguments.WebskinPath#&quot;&gt;</b><br> 450: <br> 451: &lt;/farcry:traceWebskin&gt;<br>
codePrintPlain
string 447: 448: <!--- INCLUDE THE WEBSKIN ---> 449: <cfinclude template="#arguments.WebskinPath#"> 450: 451: </farcry:traceWebskin>
column
number 0
id
string ??
line
number 449
Raw_Trace
string core.packages.fourq.fourq_cfc$cf.udfCall1(/farcry/core/packages/fourq/fourq.cfc:449)
template
string /farcry/core/packages/fourq/fourq.cfc
type
string cfml
7
Struct
codePrintHTML
string 340: onExitProcess=&quot;#arguments.onExitProcess#&quot;,<br> 341: dsn=&quot;#arguments.dsn#&quot;,<br> <b>342: bAllowTrace=&quot;#arguments.bAllowTrace#&quot;) /&gt;</b><br> 343: <br> 344: &lt;cfelseif structKeyExists(arguments, &quot;alternateHTML&quot;)&gt;<br>
codePrintPlain
string 340: onExitProcess="#arguments.onExitProcess#", 341: dsn="#arguments.dsn#", 342: bAllowTrace="#arguments.bAllowTrace#") /> 343: 344: <cfelseif structKeyExists(arguments, "alternateHTML")>
column
number 0
id
string ??
line
number 342
Raw_Trace
string core.packages.fourq.fourq_cfc$cf.udfCall1(/farcry/core/packages/fourq/fourq.cfc:342)
template
string /farcry/core/packages/fourq/fourq.cfc
type
string cfml
8
Struct
codePrintHTML
string 138: &lt;cfinvokeargument name=&quot;alternateHTML&quot; value=&quot;#attributes.alternateHTML#&quot; /&gt;<br> 139: &lt;/cfif&gt;<br> <b>140: &lt;/cfinvoke&gt;</b><br> 141: <br> 142: &lt;cfelse&gt;<br>
codePrintPlain
string 138: <cfinvokeargument name="alternateHTML" value="#attributes.alternateHTML#" /> 139: </cfif> 140: </cfinvoke> 141: 142: <cfelse>
column
number 0
id
string ??
line
number 140
Raw_Trace
string core.tags.webskin.view_cfm$cf.call(/farcry/core/tags/webskin/view.cfm:140)
template
string /farcry/core/tags/webskin/view.cfm
type
string cfml
9
Struct
codePrintHTML
string 230: &lt;!--- All else fails, try the standard page webskin ---&gt;<br> 231: &lt;cfif application.fapi.hasWebskin(typename=&quot;#stobj.typename#&quot;, webskin=&quot;#stWebskins.page#&quot;)&gt;<br> <b>232: &lt;skin:view objectid=&quot;#stobj.objectid#&quot; typename=&quot;#stobj.typename#&quot; webskin=&quot;#stWebskins.page#&quot; /&gt;</b><br> 233: &lt;cfelse&gt;<br> 234: &lt;cfset application.fc.lib.error.showErrorPage(&quot;404 Page missing&quot;,application.fc.lib.error.create404Error(&quot;I was looking at the type: #stobj.typename# and couldn't find a #stWebskins.page#. You'll want to create the default view for this object. To do that, create a #stWebskins.page#.cfm webskin in the webskin folder in a directory named #stobj.typename#.&quot;)) /&gt;<br>
codePrintPlain
string 230: <!--- All else fails, try the standard page webskin ---> 231: <cfif application.fapi.hasWebskin(typename="#stobj.typename#", webskin="#stWebskins.page#")> 232: <skin:view objectid="#stobj.objectid#" typename="#stobj.typename#" webskin="#stWebskins.page#" /> 233: <cfelse> 234: <cfset application.fc.lib.error.showErrorPage("404 Page missing",application.fc.lib.error.create404Error("I was looking at the type: #stobj.typename# and couldn't find a #stWebskins.page#. You'll want to create the default view for this object. To do that, create a #stWebskins.page#.cfm webskin in the webskin folder in a directory named #stobj.typename#.")) />
column
number 0
id
string ??
line
number 232
Raw_Trace
string core.tags.navajo.display_cfm$cf.call(/farcry/core/tags/navajo/display.cfm:232)
template
string /farcry/core/tags/navajo/display.cfm
type
string cfml
10
Struct
codePrintHTML
string 6: &lt;/cfif&gt;<br> 7: <br> <b>8: &lt;nj:display&gt;</b><br> 9: <br> 10: &lt;cfsetting enablecfoutputonly=&quot;No&quot;&gt;<br>
codePrintPlain
string 6: </cfif> 7: 8: <nj:display> 9: 10: <cfsetting enablecfoutputonly="No">
column
number 0
id
string ??
line
number 8
Raw_Trace
string index_cfm$cf.call(/index.cfm:8)
template
string /index.cfm
type
string cfml
type
string database
where
string