Captain’s log Stardate 61775.7

On the heels of a 10 point Obama defeat, and chaos looming for the Democratic nomination, I will find my serenity back in the ColdFusion Logs.

We left off two days ago looking at the application.log.  It gives us glimpses into the overall errors and general location of said errors.  But sometimes the errors aren’t all that clear (as if programming is to begin with?).  Sometimes you get mystery lines like this:

“Error”,”jrpp-984″,”04/18/08″,”23:39:05″,”myStore”,”Error Executing Database Query.Syntax error or access violation: 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 ” at line 3 The specific sequence of files included or processed is: path:\somefile.cfm, line: 398 “

When this error is not exactly helpful, we must turn to our exception.log.  Now, sometimes this won’t help either, and you’ll just need to start working through process of elimination, but what you will find in the exception.log is a matching stack trace of the offending event, because sometimes you will need to know what page is being called where and when:

“Error”,”jrpp-984″,”04/18/08″,”23:39:05″,”myStore”,”Error Executing Database Query.Syntax error or access violation: 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 ” at line 3 The specific sequence of files included or processed is: path:\somefile.cfm, line: 398 ”
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
 at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580)
 at cfquickStore_catalog2ecfm1185780249._factor36(path:\somefile.cfm:398)
 at cfquickStore_catalog2ecfm1185780249._factor41(path:\somefile.cfm:308)
 at cfquickStore_catalog2ecfm1185780249._factor47(path:\somefile.cfm:238)
 at cfquickStore_catalog2ecfm1185780249._factor59(path:\somefile.cfm:43)
 at cfquickStore_catalog2ecfm1185780249.runPage(path:\somefile.cfm:1)
 at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
 at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:63)
 at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:255)
 at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1925)
 at cfquickStore2ecfm1866029631._factor9(path:\somefile.cfm:277)
 at cfquickStore2ecfm1866029631.runPage(path:\somefile.cfm:1)
 at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
 at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:63)
 at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:255)
 at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1925)
 at cfindex2ecfm1381767393.runPage(path:\somefile.cfm:161)
 at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
 at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
 at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
 at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225)
 at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
 at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
 at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
 at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
 at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
 at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
 at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
 at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
 at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
 at coldfusion.CfmServlet.service(CfmServlet.java:107)
 at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
 at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
 at com.seefusion.Filter.doFilter(Filter.java:34)
 at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500)
 at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
 at jrun.servlet.FilterChain.service(FilterChain.java:101)
 at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
 at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
 at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
 at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
 at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
 at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
 at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
 at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
 at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

So sometimes these are useful, sometimes they are not.  There are other places to look, we can continue on…. another day.