this is an error
{ts '2014-11-23 11:27:01'}
Error Executing Database Query.
C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm
struct
Browser CCBot/2.0 (http://commoncrawl.org/faq/)
DateTime {ts '2014-11-23 11:27:01'}
Diagnostics Error Executing Database Query. Unknown column 'establishmnets.establishmenttype' in 'on clause' <br>The error occurred on line 53.
GeneratedContent [empty string]
HTTPReferer [empty string]
Mailto [empty string]
Message Error Executing Database Query.
QueryString productid=300&mode=list
RemoteAddress 54.224.53.192
RootCause
struct
Cause
struct
ErrorCode 1054
Message Unknown column 'establishmnets.establishmenttype' in 'on clause'
SQLState 42S22
StackTrace com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'establishmnets.establishmenttype' in 'on clause' at sun.reflect.GeneratedConstructorAccessor522.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1051) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2693) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:91) at coldfusion.sql.Executive.executeQuery(Executive.java:1380) at coldfusion.sql.Executive.executeQuery(Executive.java:1127) at coldfusion.sql.Executive.executeQuery(Executive.java:1058) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfRequireEstablishment2ecfm788277089._factor11(C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm:53) at cfRequireEstablishment2ecfm788277089.runPage(C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2dMPS2ecfm1454396115.runPage(C:\Web\CustomScripts\MyPlumbingShowroom\application-MPS.cfm:49) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfm1864723482.runPage(C:\Web\Bravo\home.MyPlumbingShowroom.com\Application.cfm:15) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 53
RAW_TRACE at cfRequireEstablishment2ecfm788277089._factor11(C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm:53)
TEMPLATE C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_REQUIREESTABLISHMENT
LINE 1
RAW_TRACE at cfRequireEstablishment2ecfm788277089.runPage(C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm:1)
TEMPLATE C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 49
RAW_TRACE at cfapplication2dMPS2ecfm1454396115.runPage(C:\Web\CustomScripts\MyPlumbingShowroom\application-MPS.cfm:49)
TEMPLATE C:\Web\CustomScripts\MyPlumbingShowroom\application-MPS.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 15
RAW_TRACE at cfApplication2ecfm1864723482.runPage(C:\Web\Bravo\home.MyPlumbingShowroom.com\Application.cfm:15)
TEMPLATE C:\Web\Bravo\home.MyPlumbingShowroom.com\Application.cfm
TYPE CFML
Type com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
DataSource srlighting
Detail Unknown column 'establishmnets.establishmenttype' in 'on clause'
ErrorCode 42S22
Message Error Executing Database Query.
NativeErrorCode 1054
RootCause
struct
ErrorCode 1054
Message Unknown column 'establishmnets.establishmenttype' in 'on clause'
SQLState 42S22
StackTrace com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'establishmnets.establishmenttype' in 'on clause' at sun.reflect.GeneratedConstructorAccessor522.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1051) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2693) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:91) at coldfusion.sql.Executive.executeQuery(Executive.java:1380) at coldfusion.sql.Executive.executeQuery(Executive.java:1127) at coldfusion.sql.Executive.executeQuery(Executive.java:1058) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfRequireEstablishment2ecfm788277089._factor11(C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm:53) at cfRequireEstablishment2ecfm788277089.runPage(C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2dMPS2ecfm1454396115.runPage(C:\Web\CustomScripts\MyPlumbingShowroom\application-MPS.cfm:49) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfm1864723482.runPage(C:\Web\Bravo\home.MyPlumbingShowroom.com\Application.cfm:15) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 53
RAW_TRACE at cfRequireEstablishment2ecfm788277089._factor11(C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm:53)
TEMPLATE C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_REQUIREESTABLISHMENT
LINE 1
RAW_TRACE at cfRequireEstablishment2ecfm788277089.runPage(C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm:1)
TEMPLATE C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 49
RAW_TRACE at cfapplication2dMPS2ecfm1454396115.runPage(C:\Web\CustomScripts\MyPlumbingShowroom\application-MPS.cfm:49)
TEMPLATE C:\Web\CustomScripts\MyPlumbingShowroom\application-MPS.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 15
RAW_TRACE at cfApplication2ecfm1864723482.runPage(C:\Web\Bravo\home.MyPlumbingShowroom.com\Application.cfm:15)
TEMPLATE C:\Web\Bravo\home.MyPlumbingShowroom.com\Application.cfm
TYPE CFML
Type com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
SQLState 42S22
Sql Select EstablishmentDetaildealers.* From Establishments join establishmentdetaildealers on establishmnets.establishmenttype = establishmentdetaildealers .establishmenttype and establishmnets.establishmentkey = establishmentdetaildealers .establishmentkey Where Establishments.EstablishmentType = (param 1) And Establishments.EstablishmentKey = (param 2)
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfRequireEstablishment2ecfm788277089._factor11(C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm:53) at cfRequireEstablishment2ecfm788277089.runPage(C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2dMPS2ecfm1454396115.runPage(C:\Web\CustomScripts\MyPlumbingShowroom\application-MPS.cfm:49) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfm1864723482.runPage(C:\Web\Bravo\home.MyPlumbingShowroom.com\Application.cfm:15) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'establishmnets.establishmenttype' in 'on clause' at sun.reflect.GeneratedConstructorAccessor522.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1051) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2693) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:91) at coldfusion.sql.Executive.executeQuery(Executive.java:1380) at coldfusion.sql.Executive.executeQuery(Executive.java:1127) at coldfusion.sql.Executive.executeQuery(Executive.java:1058) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) ... 45 more
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 53
RAW_TRACE at cfRequireEstablishment2ecfm788277089._factor11(C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm:53)
TEMPLATE C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_REQUIREESTABLISHMENT
LINE 1
RAW_TRACE at cfRequireEstablishment2ecfm788277089.runPage(C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm:1)
TEMPLATE C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 49
RAW_TRACE at cfapplication2dMPS2ecfm1454396115.runPage(C:\Web\CustomScripts\MyPlumbingShowroom\application-MPS.cfm:49)
TEMPLATE C:\Web\CustomScripts\MyPlumbingShowroom\application-MPS.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 15
RAW_TRACE at cfApplication2ecfm1864723482.runPage(C:\Web\Bravo\home.MyPlumbingShowroom.com\Application.cfm:15)
TEMPLATE C:\Web\Bravo\home.MyPlumbingShowroom.com\Application.cfm
TYPE CFML
Type Database
queryError Unknown column 'establishmnets.establishmenttype' in 'on clause'
where (param 1) = [type='IN', class='java.lang.String', value='W', sqltype='CF_SQL_VARCHAR'] , (param 2) = [type='IN', class='java.lang.Integer', value='108', sqltype='CF_SQL_INTEGER']
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfRequireEstablishment2ecfm788277089._factor11(C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm:53) at cfRequireEstablishment2ecfm788277089.runPage(C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2dMPS2ecfm1454396115.runPage(C:\Web\CustomScripts\MyPlumbingShowroom\application-MPS.cfm:49) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplication2ecfm1864723482.runPage(C:\Web\Bravo\home.MyPlumbingShowroom.com\Application.cfm:15) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'establishmnets.establishmenttype' in 'on clause' at sun.reflect.GeneratedConstructorAccessor522.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1051) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2693) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1364) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:91) at coldfusion.sql.Executive.executeQuery(Executive.java:1380) at coldfusion.sql.Executive.executeQuery(Executive.java:1127) at coldfusion.sql.Executive.executeQuery(Executive.java:1058) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) ... 45 more
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 53
RAW_TRACE at cfRequireEstablishment2ecfm788277089._factor11(C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm:53)
TEMPLATE C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_REQUIREESTABLISHMENT
LINE 1
RAW_TRACE at cfRequireEstablishment2ecfm788277089.runPage(C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm:1)
TEMPLATE C:\Web\TrackerScripts\VTscripts\SysFiles\RequireEstablishment.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 49
RAW_TRACE at cfapplication2dMPS2ecfm1454396115.runPage(C:\Web\CustomScripts\MyPlumbingShowroom\application-MPS.cfm:49)
TEMPLATE C:\Web\CustomScripts\MyPlumbingShowroom\application-MPS.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 15
RAW_TRACE at cfApplication2ecfm1864723482.runPage(C:\Web\Bravo\home.MyPlumbingShowroom.com\Application.cfm:15)
TEMPLATE C:\Web\Bravo\home.MyPlumbingShowroom.com\Application.cfm
TYPE CFML
Template /products/productDetail.cfm
Type coldfusion.runtime.CfErrorWrapper