exception
Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT FavorID, DisplayText FROM Favor ORDER BY FavorID ASC
DatabaseName
stringMySQL
DatabaseVersion
string5.6.13-log
DriverName
stringMySQL-AB JDBC Driver
DriverVersion
stringmysql-connector-java-5.1.20 ( Revision: tonci.grgin@oracle.com-20111003110438-qfydx066wsbydkbw )
Datasource
stringtestimonials
DataSource
stringtestimonials
Detail
stringSELECT command denied to user 'sandalintl_user'@'torpsandalsintswb2.sandals.com' for table 'Favor'
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
string
NativeErrorCode
number1142
queryError
stringSELECT FavorID, DisplayText FROM Favor ORDER BY FavorID ASC
Sql
stringSELECT FavorID, DisplayText FROM Favor ORDER BY FavorID ASC
SQLState
string42000
StackTrace
stringlucee.runtime.exp.DatabaseException: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2677) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2627) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:841) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:293) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:273) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:226) at lucee.runtime.tag.Query.executeDatasoure(Query.java:951) at lucee.runtime.tag.Query.doEndTag(Query.java:700) at services.testimonials.testimonialsdao_cfc$cf.udfCall(/model/services/testimonials/testimonialsDAO.cfc:15) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:693) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1997) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1718) at services.testimonials.testimonialsservice_cfc$cf.udfCall(/model/services/testimonials/testimonialsService.cfc:229) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:693) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1997) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1718) at general_cfc$cf.udfCall2(/controllers/general.cfc:117) at general_cfc$cf.udfCall(/controllers/general.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:695) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2014) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:833) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:826) at lucee.runtime.util.VariableUtilImpl.callFunction(VariableUtilImpl.java:740) at lucee.runtime.interpreter.ref.func.UDFCall.getValue(UDFCall.java:65) at lucee.runtime.interpreter.CFMLExpressionInterpreter.interpret(CFMLExpressionInterpreter.java:220) at lucee.runtime.functions.dynamicEvaluation.Evaluate._call(Evaluate.java:109) at lucee.runtime.functions.dynamicEvaluation.Evaluate.call(Evaluate.java:102) at lucee.runtime.functions.dynamicEvaluation.Evaluate.call(Evaluate.java:43) at fw.corfield.framework_cfc$cf.udfCall7(/fw/corfield/framework.cfc:1198) at fw.corfield.framework_cfc$cf.udfCall(/fw/corfield/framework.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:803) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1718) at fw.corfield.framework_cfc$cf.udfCall4(/fw/corfield/framework.cfc:677) at fw.corfield.framework_cfc$cf.udfCall(/fw/corfield/framework.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:693) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1997) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:438) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2464) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2454) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2427) at lucee.runtime.engine.Request.exe(Request.java:44) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1090) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1038) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:677) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:784) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:802) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1410) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
TagContext
Array
1
Struct
codePrintHTML
string13: FROM Favor<br> 14: ORDER BY FavorID ASC<br> <b>15: &lt;/cfquery&gt;</b><br> 16: <br> 17: &lt;cfreturn qryCategories /&gt;<br>
codePrintPlain
string13: FROM Favor 14: ORDER BY FavorID ASC 15: </cfquery> 16: 17: <cfreturn qryCategories />
column
number0
id
string??
line
number15
Raw_Trace
stringservices.testimonials.testimonialsdao_cfc$cf.udfCall(/model/services/testimonials/testimonialsDAO.cfc:15)
template
string/webroot/FR/model/services/testimonials/testimonialsDAO.cfc
type
stringcfml
2
Struct
codePrintHTML
string227: <br> 228: &lt;cftry&gt;<br> <b>229: &lt;cfset qryCategories = getTestimonialsDAO().getQryCategories() /&gt;</b><br> 230: &lt;cfcatch&gt;<br> 231: &lt;cfset qryCategories = queryNew('') /&gt;<br>
codePrintPlain
string227: 228: <cftry> 229: <cfset qryCategories = getTestimonialsDAO().getQryCategories() /> 230: <cfcatch> 231: <cfset qryCategories = queryNew('') />
column
number0
id
string??
line
number229
Raw_Trace
stringservices.testimonials.testimonialsservice_cfc$cf.udfCall(/model/services/testimonials/testimonialsService.cfc:229)
template
string/webroot/FR/model/services/testimonials/testimonialsService.cfc
type
stringcfml
3
Struct
codePrintHTML
string115: &lt;/cfif&gt;<br> 116: &lt;cfset rc.testimonialsInfo = {} /&gt;<br> <b>117: &lt;cfset rc.testimonialsInfo.categories = getTestimonialsService().getCategories() /&gt;</b><br> 118: &lt;cfset rc.pagCollection.queryToPaginate = getTestimonialsService().getTestimonials(rc.countryCode, rc.rst_code, rc.categoryID, rc.brandID, rc.exceptTsmID) /&gt;<br> 119: &lt;!---&lt;cfset rc.tsmImages = getTestimonialsService().getTestimonialImages(rc.tsmID, rc.imgID) /&gt;---&gt;<br>
codePrintPlain
string115: </cfif> 116: <cfset rc.testimonialsInfo = {} /> 117: <cfset rc.testimonialsInfo.categories = getTestimonialsService().getCategories() /> 118: <cfset rc.pagCollection.queryToPaginate = getTestimonialsService().getTestimonials(rc.countryCode, rc.rst_code, rc.categoryID, rc.brandID, rc.exceptTsmID) /> 119: <!---<cfset rc.tsmImages = getTestimonialsService().getTestimonialImages(rc.tsmID, rc.imgID) />--->
column
number0
id
string??
line
number117
Raw_Trace
stringgeneral_cfc$cf.udfCall2(/controllers/general.cfc:117)
template
string/webroot/FR/controllers/general.cfc
type
stringcfml
4
Struct
codePrintHTML
string1196: try {<br> 1197: frameworkTrace( 'calling #lifecycle# controller', tuple.subsystem, tuple.section, method );<br> <b>1198: evaluate( 'cfc.#method#( rc = request.context )' );</b><br> 1199: } catch ( any e ) {<br> 1200: setCfcMethodFailureInfo( cfc, method );<br>
codePrintPlain
string1196: try { 1197: frameworkTrace( 'calling #lifecycle# controller', tuple.subsystem, tuple.section, method ); 1198: evaluate( 'cfc.#method#( rc = request.context )' ); 1199: } catch ( any e ) { 1200: setCfcMethodFailureInfo( cfc, method );
column
number0
id
string??
line
number1198
Raw_Trace
stringfw.corfield.framework_cfc$cf.udfCall7(/fw/corfield/framework.cfc:1198)
template
string/webroot/FR/www/fw/corfield/framework.cfc
type
stringcfml
5
Struct
codePrintHTML
string675: doController( tuple, 'start' &amp; tuple.item, 'start' );<br> 676: if ( structKeyExists( request._fw1, 'abortController' ) ) abortController();<br> <b>677: doController( tuple, tuple.item, 'item' );</b><br> 678: if ( structKeyExists( request._fw1, 'abortController' ) ) abortController();<br> 679: }<br>
codePrintPlain
string675: doController( tuple, 'start' & tuple.item, 'start' ); 676: if ( structKeyExists( request._fw1, 'abortController' ) ) abortController(); 677: doController( tuple, tuple.item, 'item' ); 678: if ( structKeyExists( request._fw1, 'abortController' ) ) abortController(); 679: }
column
number0
id
string??
line
number677
Raw_Trace
stringfw.corfield.framework_cfc$cf.udfCall4(/fw/corfield/framework.cfc:677)
template
string/webroot/FR/www/fw/corfield/framework.cfc
type
stringcfml
type
stringdatabase
where
string