struct
DataSource outfitter
Detail Table 'outfitter.ot_category' doesn't exist
ErrorCode 42S02
Message Error Executing Database Query.
NativeErrorCode 1146
RootCause
struct
ErrorCode 1146
Message Table 'outfitter.ot_category' doesn't exist
SQLState 42S02
StackTrace java.sql.SQLException: Table 'outfitter.ot_category' doesn't exist at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695) at com.mysql.jdbc.Connection.execSQL(Connection.java:2998) at com.mysql.jdbc.Connection.execSQL(Connection.java:2927) at com.mysql.jdbc.Statement.execute(Statement.java:535) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212) at coldfusion.sql.Executive.executeQuery(Executive.java:753) at coldfusion.sql.Executive.executeQuery(Executive.java:675) at coldfusion.sql.Executive.executeQuery(Executive.java:636) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500) at cfproduct_index2ecfm670402095.runPage(C:\inetpub\wwwroot\outfittershop\display\product_index.cfm:22) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cfindex2ecfm1852586938._factor1(C:\inetpub\wwwroot\outfittershop\index.cfm:24) at cfindex2ecfm1852586938._factor22(C:\inetpub\wwwroot\outfittershop\index.cfm:20) at cfindex2ecfm1852586938.runPage(C:\inetpub\wwwroot\outfittershop\index.cfm:1) 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.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.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)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 22
RAW_TRACE at cfproduct_index2ecfm670402095.runPage(C:\inetpub\wwwroot\outfittershop\display\product_index.cfm:22)
TEMPLATE C:\inetpub\wwwroot\outfittershop\display\product_index.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 24
RAW_TRACE at cfindex2ecfm1852586938._factor1(C:\inetpub\wwwroot\outfittershop\index.cfm:24)
TEMPLATE C:\inetpub\wwwroot\outfittershop\index.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_INDEX
LINE 20
RAW_TRACE at cfindex2ecfm1852586938._factor22(C:\inetpub\wwwroot\outfittershop\index.cfm:20)
TEMPLATE C:\inetpub\wwwroot\outfittershop\index.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_INDEX
LINE 1
RAW_TRACE at cfindex2ecfm1852586938.runPage(C:\inetpub\wwwroot\outfittershop\index.cfm:1)
TEMPLATE C:\inetpub\wwwroot\outfittershop\index.cfm
TYPE CFML
Type java.sql.SQLException
SQLState 42S02
Sql select * from ot_category where category like 'A%' and thumbname is not null order by category
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580) at cfproduct_index2ecfm670402095.runPage(C:\inetpub\wwwroot\outfittershop\display\product_index.cfm:22) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915) at cfindex2ecfm1852586938._factor1(C:\inetpub\wwwroot\outfittershop\index.cfm:24) at cfindex2ecfm1852586938._factor22(C:\inetpub\wwwroot\outfittershop\index.cfm:20) at cfindex2ecfm1852586938.runPage(C:\inetpub\wwwroot\outfittershop\index.cfm:1) 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.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.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)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 22
RAW_TRACE at cfproduct_index2ecfm670402095.runPage(C:\inetpub\wwwroot\outfittershop\display\product_index.cfm:22)
TEMPLATE C:\inetpub\wwwroot\outfittershop\display\product_index.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 24
RAW_TRACE at cfindex2ecfm1852586938._factor1(C:\inetpub\wwwroot\outfittershop\index.cfm:24)
TEMPLATE C:\inetpub\wwwroot\outfittershop\index.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_INDEX
LINE 20
RAW_TRACE at cfindex2ecfm1852586938._factor22(C:\inetpub\wwwroot\outfittershop\index.cfm:20)
TEMPLATE C:\inetpub\wwwroot\outfittershop\index.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_INDEX
LINE 1
RAW_TRACE at cfindex2ecfm1852586938.runPage(C:\inetpub\wwwroot\outfittershop\index.cfm:1)
TEMPLATE C:\inetpub\wwwroot\outfittershop\index.cfm
TYPE CFML
Type Database
queryError Table 'outfitter.ot_category' doesn't exist
where [empty string]