struct
EVENTNAME onRequestStart
EXCEPTION
struct
Cause
struct
Cause
struct
ErrorCode 1054
Message [Macromedia][MySQL JDBC Driver][MySQL]Unknown column 'view' in 'where clause'
SQLState 42S22
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][MySQL JDBC Driver][MySQL]Unknown column 'view' in 'where clause' at macromedia.jdbc.mysqlbase.ddcm.b(Unknown Source) at macromedia.jdbc.mysqlbase.ddcm.a(Unknown Source) at macromedia.jdbc.mysqlbase.ddcl.b(Unknown Source) at macromedia.jdbc.mysqlbase.ddcl.a(Unknown Source) at macromedia.jdbc.mysql.MySQLImplConnection.a(Unknown Source) at macromedia.jdbc.mysql.sio.dda.i(Unknown Source) at macromedia.jdbc.mysql.sio.dda.o(Unknown Source) at macromedia.jdbc.mysql.ddg.f(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.e(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.a(Unknown Source) at macromedia.jdbc.mysqlbase.dddt.a(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.x(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.t(Unknown Source) at macromedia.jdbc.mysqlbase.dddt.execute(Unknown Source) at macromedia.jdbc.mysqlbase.dddx.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1553) at coldfusion.sql.Executive.executeQuery(Executive.java:1287) at coldfusion.sql.Executive.executeQuery(Executive.java:1217) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfsales2ecfc78484244$funcGETMLSLISTINGS.runFunction(E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc:351) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:539) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:659) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:468) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3169) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3144) at cfswitches2esales2ecfm124424435._factor31(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:357) at cfswitches2esales2ecfm124424435._factor34(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:353) at cfswitches2esales2ecfm124424435._factor14(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm) at cfswitches2esales2ecfm124424435._factor36(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:345) at cfswitches2esales2ecfm124424435._factor15(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm) at cfswitches2esales2ecfm124424435._factor37(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:307) at cfswitches2esales2ecfm124424435.runPage(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851) at cfcontent_pages2ecfc1038863650$funcGETSECTIONHTML.runFunction(E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc:483) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:539) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:659) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:468) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3169) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3144) at cfApplication2ecfc214318172$funcONREQUESTSTART.runFunction(E:\WEB\RicottaRealEstate\public\Application.cfc:183) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:285) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:473) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:223) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 351
RAW_TRACE at cfsales2ecfc78484244$funcGETMLSLISTINGS.runFunction(E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc:351)
TEMPLATE E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 357
RAW_TRACE at cfswitches2esales2ecfm124424435._factor31(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:357)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE 353
RAW_TRACE at cfswitches2esales2ecfm124424435._factor34(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:353)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE -1
RAW_TRACE at cfswitches2esales2ecfm124424435._factor14(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm)
TEMPLATE E
TYPE CFML
5
struct
COLUMN 0
ID E
LINE 345
RAW_TRACE at cfswitches2esales2ecfm124424435._factor36(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:345)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE -1
RAW_TRACE at cfswitches2esales2ecfm124424435._factor15(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm)
TEMPLATE E
TYPE CFML
7
struct
COLUMN 0
ID E
LINE 307
RAW_TRACE at cfswitches2esales2ecfm124424435._factor37(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:307)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
8
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE 1
RAW_TRACE at cfswitches2esales2ecfm124424435.runPage(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:1)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFINCLUDE
LINE 483
RAW_TRACE at cfcontent_pages2ecfc1038863650$funcGETSECTIONHTML.runFunction(E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc:483)
TEMPLATE E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc
TYPE CFML
10
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 183
RAW_TRACE at cfApplication2ecfc214318172$funcONREQUESTSTART.runFunction(E:\WEB\RicottaRealEstate\public\Application.cfc:183)
TEMPLATE E:\WEB\RicottaRealEstate\public\Application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
DataSource mlscapecod
Detail [Macromedia][MySQL JDBC Driver][MySQL]Unknown column 'view' in 'where clause'
ErrorCode 42S22
Exceptions
array
1
struct
class java.sql.SQLSyntaxErrorException
message [Macromedia][MySQL JDBC Driver][MySQL]Unknown column 'view' in 'where clause'
Message Error Executing Database Query.
NativeErrorCode 1054
RootCause
struct
ErrorCode 1054
Message [Macromedia][MySQL JDBC Driver][MySQL]Unknown column 'view' in 'where clause'
SQLState 42S22
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][MySQL JDBC Driver][MySQL]Unknown column 'view' in 'where clause' at macromedia.jdbc.mysqlbase.ddcm.b(Unknown Source) at macromedia.jdbc.mysqlbase.ddcm.a(Unknown Source) at macromedia.jdbc.mysqlbase.ddcl.b(Unknown Source) at macromedia.jdbc.mysqlbase.ddcl.a(Unknown Source) at macromedia.jdbc.mysql.MySQLImplConnection.a(Unknown Source) at macromedia.jdbc.mysql.sio.dda.i(Unknown Source) at macromedia.jdbc.mysql.sio.dda.o(Unknown Source) at macromedia.jdbc.mysql.ddg.f(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.e(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.a(Unknown Source) at macromedia.jdbc.mysqlbase.dddt.a(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.x(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.t(Unknown Source) at macromedia.jdbc.mysqlbase.dddt.execute(Unknown Source) at macromedia.jdbc.mysqlbase.dddx.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1553) at coldfusion.sql.Executive.executeQuery(Executive.java:1287) at coldfusion.sql.Executive.executeQuery(Executive.java:1217) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfsales2ecfc78484244$funcGETMLSLISTINGS.runFunction(E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc:351) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:539) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:659) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:468) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3169) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3144) at cfswitches2esales2ecfm124424435._factor31(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:357) at cfswitches2esales2ecfm124424435._factor34(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:353) at cfswitches2esales2ecfm124424435._factor14(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm) at cfswitches2esales2ecfm124424435._factor36(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:345) at cfswitches2esales2ecfm124424435._factor15(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm) at cfswitches2esales2ecfm124424435._factor37(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:307) at cfswitches2esales2ecfm124424435.runPage(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851) at cfcontent_pages2ecfc1038863650$funcGETSECTIONHTML.runFunction(E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc:483) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:539) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:659) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:468) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3169) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3144) at cfApplication2ecfc214318172$funcONREQUESTSTART.runFunction(E:\WEB\RicottaRealEstate\public\Application.cfc:183) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:285) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:473) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:223) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 351
RAW_TRACE at cfsales2ecfc78484244$funcGETMLSLISTINGS.runFunction(E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc:351)
TEMPLATE E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 357
RAW_TRACE at cfswitches2esales2ecfm124424435._factor31(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:357)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE 353
RAW_TRACE at cfswitches2esales2ecfm124424435._factor34(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:353)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE -1
RAW_TRACE at cfswitches2esales2ecfm124424435._factor14(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm)
TEMPLATE E
TYPE CFML
5
struct
COLUMN 0
ID E
LINE 345
RAW_TRACE at cfswitches2esales2ecfm124424435._factor36(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:345)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE -1
RAW_TRACE at cfswitches2esales2ecfm124424435._factor15(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm)
TEMPLATE E
TYPE CFML
7
struct
COLUMN 0
ID E
LINE 307
RAW_TRACE at cfswitches2esales2ecfm124424435._factor37(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:307)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
8
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE 1
RAW_TRACE at cfswitches2esales2ecfm124424435.runPage(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:1)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFINCLUDE
LINE 483
RAW_TRACE at cfcontent_pages2ecfc1038863650$funcGETSECTIONHTML.runFunction(E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc:483)
TEMPLATE E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc
TYPE CFML
10
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 183
RAW_TRACE at cfApplication2ecfc214318172$funcONREQUESTSTART.runFunction(E:\WEB\RicottaRealEstate\public\Application.cfc:183)
TEMPLATE E:\WEB\RicottaRealEstate\public\Application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42S22
Sql SELECT mlsdata.zoning,mlsdata.TotalLevels,mlsdata.yearbuilt,mlsdata.fireplace,mlsdata.interiorfeatures,mlsdata.appliances, mlsdata.exteriorfeatures,mlsdata.officelongName,mlsdata.ImprovementAsmt,mlsdata.TitleReferenceBook,mlsdata.AnnualBetterment,mlsdata.apn,mlsdata.SpecialAsmtPending,mlsdata.AnnualTax,mlsdata.taxyear,mlsdata.ASBESTOS,mlsdata.MASSUSECODE,mlsdata.floodzone,mlsdata.leadpaint,mlsdata.UndergroundFuelTnk,mlsdata.LandAssessments,mlsdata.ToBeAssessed, mlsdata.TotalAssessments, mlsdata.reciprocalOfficeName, mls.agentcode, mls.reduced, mls.mlsnumber,mls.feedID,mls.officecode, mls.BuyerBrokerCommission, mls.Officename, mls.agentname, mls.listagentpreferredphone, mls.listagentemail,mls.town,mls.Price,mls.Waterview,mls.Waterfront,mls.numphotos, mls.MAINPHOTOURL,mls.status,mls.remarks,mls.propertyType,mls.propertyType,mls.Bedrooms,mls.FullBathrooms,mls.HalfBathrooms,mls.totalrooms,mls.waterfront,mls.waterview, mls.reducedDate,mlsdata.heatingcooling,mlsdata.garage,mlsdata.basement,mlsdata.basementdescription,mlsdata.pool,mlsdata.dock,mlsdata.dockdescription,mlsdata.sidingdescription,mlsdata.roofdescription,mlsdata.floors,mlsdata.heatingcooling,mlsdata.TopographyLotDesc,mlsdata.hotwaterwaterheat,mlsdata.TitleReferencePage,mlsdata.WaterSewerUtility,mlsdata.originalprice,mlsdata.wateraccess,mlsdata.milestobeach,mlsdata.beachdescription,mlsdata.beachownership,mlsdata.Convenientto,mlsdata.association,mlsdata.assocfeeincludes,mlsdata.SquareFootage, mlsdata.listingdate,mlsdata.dom,mlsdata.WaterFrontDesc,mlsdata.WaterViewDesc,mls.yearbuilt,mls.lotsizesqft,mls.squarefeet,mls.LotSizeAcres,mls.Style,mlsdata.VIRTUALTOURURL,mls.town,mls.agentname,mlsdata.listingagentemail,mlsdata.agentfirstName,mlsdata.agentid,mlsdata.agentlastName,mlsdata.AnnualTax,mlsdata.latcoords,mlsdata.longcoords,mlsdata.areadisplay,mlsdata.city,mlsdata.zipCode,mlsdata.mlsnumber,replace(concat_ws(" ", mlsdata.streetNumber, mlsdata.streetdirection, mlsdata.streetname, concat(mlsdata.streetsuffix,','), mls.village, concat('MA',','), mlsdata.zipcode)," ,", ",") as fulladdress, replace(concat_ws(" ", mlsdata.streetNumber, mlsdata.streetdirection, mlsdata.streetname, concat(mlsdata.streetsuffix,','), mls.village, concat('MA',','), mlsdata.zipcode)," ,", ",") as priorityaddress, mlsdata.photourllist from mls INNER JOIN mlsdata ON mls.mlsnumber=mlsdata.mlsnumber WHERE mls.mlsactive = 1 and mls.feedID = 1 AND mls.officecode = (param 1) and mls.mlsnumber = view
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:866) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfsales2ecfc78484244$funcGETMLSLISTINGS.runFunction(E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc:351) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:539) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:659) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:468) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3169) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3144) at cfswitches2esales2ecfm124424435._factor31(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:357) at cfswitches2esales2ecfm124424435._factor34(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:353) at cfswitches2esales2ecfm124424435._factor14(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm) at cfswitches2esales2ecfm124424435._factor36(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:345) at cfswitches2esales2ecfm124424435._factor15(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm) at cfswitches2esales2ecfm124424435._factor37(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:307) at cfswitches2esales2ecfm124424435.runPage(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851) at cfcontent_pages2ecfc1038863650$funcGETSECTIONHTML.runFunction(E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc:483) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:539) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:659) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:468) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3169) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3144) at cfApplication2ecfc214318172$funcONREQUESTSTART.runFunction(E:\WEB\RicottaRealEstate\public\Application.cfc:183) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:285) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:473) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:223) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][MySQL JDBC Driver][MySQL]Unknown column 'view' in 'where clause' at macromedia.jdbc.mysqlbase.ddcm.b(Unknown Source) at macromedia.jdbc.mysqlbase.ddcm.a(Unknown Source) at macromedia.jdbc.mysqlbase.ddcl.b(Unknown Source) at macromedia.jdbc.mysqlbase.ddcl.a(Unknown Source) at macromedia.jdbc.mysql.MySQLImplConnection.a(Unknown Source) at macromedia.jdbc.mysql.sio.dda.i(Unknown Source) at macromedia.jdbc.mysql.sio.dda.o(Unknown Source) at macromedia.jdbc.mysql.ddg.f(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.e(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.a(Unknown Source) at macromedia.jdbc.mysqlbase.dddt.a(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.x(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.t(Unknown Source) at macromedia.jdbc.mysqlbase.dddt.execute(Unknown Source) at macromedia.jdbc.mysqlbase.dddx.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1553) at coldfusion.sql.Executive.executeQuery(Executive.java:1287) at coldfusion.sql.Executive.executeQuery(Executive.java:1217) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) ... 87 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 351
RAW_TRACE at cfsales2ecfc78484244$funcGETMLSLISTINGS.runFunction(E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc:351)
TEMPLATE E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 357
RAW_TRACE at cfswitches2esales2ecfm124424435._factor31(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:357)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE 353
RAW_TRACE at cfswitches2esales2ecfm124424435._factor34(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:353)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE -1
RAW_TRACE at cfswitches2esales2ecfm124424435._factor14(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm)
TEMPLATE E
TYPE CFML
5
struct
COLUMN 0
ID E
LINE 345
RAW_TRACE at cfswitches2esales2ecfm124424435._factor36(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:345)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE -1
RAW_TRACE at cfswitches2esales2ecfm124424435._factor15(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm)
TEMPLATE E
TYPE CFML
7
struct
COLUMN 0
ID E
LINE 307
RAW_TRACE at cfswitches2esales2ecfm124424435._factor37(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:307)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
8
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE 1
RAW_TRACE at cfswitches2esales2ecfm124424435.runPage(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:1)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFINCLUDE
LINE 483
RAW_TRACE at cfcontent_pages2ecfc1038863650$funcGETSECTIONHTML.runFunction(E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc:483)
TEMPLATE E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc
TYPE CFML
10
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 183
RAW_TRACE at cfApplication2ecfc214318172$funcONREQUESTSTART.runFunction(E:\WEB\RicottaRealEstate\public\Application.cfc:183)
TEMPLATE E:\WEB\RicottaRealEstate\public\Application.cfc
TYPE CFML
Type Database
queryError [Macromedia][MySQL JDBC Driver][MySQL]Unknown column 'view' in 'where clause'
where (param 1) = [type='IN', class='java.lang.String', value='RICO', sqltype='cf_sql_varchar']
Detail An exception occurred while invoking an event handler method from Application.cfc. The method name is: onRequestStart.
Message Event handler exception.
RootCause
struct
Cause
struct
ErrorCode 1054
Message [Macromedia][MySQL JDBC Driver][MySQL]Unknown column 'view' in 'where clause'
SQLState 42S22
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][MySQL JDBC Driver][MySQL]Unknown column 'view' in 'where clause' at macromedia.jdbc.mysqlbase.ddcm.b(Unknown Source) at macromedia.jdbc.mysqlbase.ddcm.a(Unknown Source) at macromedia.jdbc.mysqlbase.ddcl.b(Unknown Source) at macromedia.jdbc.mysqlbase.ddcl.a(Unknown Source) at macromedia.jdbc.mysql.MySQLImplConnection.a(Unknown Source) at macromedia.jdbc.mysql.sio.dda.i(Unknown Source) at macromedia.jdbc.mysql.sio.dda.o(Unknown Source) at macromedia.jdbc.mysql.ddg.f(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.e(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.a(Unknown Source) at macromedia.jdbc.mysqlbase.dddt.a(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.x(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.t(Unknown Source) at macromedia.jdbc.mysqlbase.dddt.execute(Unknown Source) at macromedia.jdbc.mysqlbase.dddx.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1553) at coldfusion.sql.Executive.executeQuery(Executive.java:1287) at coldfusion.sql.Executive.executeQuery(Executive.java:1217) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfsales2ecfc78484244$funcGETMLSLISTINGS.runFunction(E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc:351) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:539) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:659) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:468) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3169) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3144) at cfswitches2esales2ecfm124424435._factor31(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:357) at cfswitches2esales2ecfm124424435._factor34(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:353) at cfswitches2esales2ecfm124424435._factor14(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm) at cfswitches2esales2ecfm124424435._factor36(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:345) at cfswitches2esales2ecfm124424435._factor15(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm) at cfswitches2esales2ecfm124424435._factor37(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:307) at cfswitches2esales2ecfm124424435.runPage(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851) at cfcontent_pages2ecfc1038863650$funcGETSECTIONHTML.runFunction(E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc:483) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:539) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:659) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:468) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3169) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3144) at cfApplication2ecfc214318172$funcONREQUESTSTART.runFunction(E:\WEB\RicottaRealEstate\public\Application.cfc:183) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:285) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:473) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:223) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 351
RAW_TRACE at cfsales2ecfc78484244$funcGETMLSLISTINGS.runFunction(E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc:351)
TEMPLATE E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 357
RAW_TRACE at cfswitches2esales2ecfm124424435._factor31(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:357)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE 353
RAW_TRACE at cfswitches2esales2ecfm124424435._factor34(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:353)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE -1
RAW_TRACE at cfswitches2esales2ecfm124424435._factor14(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm)
TEMPLATE E
TYPE CFML
5
struct
COLUMN 0
ID E
LINE 345
RAW_TRACE at cfswitches2esales2ecfm124424435._factor36(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:345)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE -1
RAW_TRACE at cfswitches2esales2ecfm124424435._factor15(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm)
TEMPLATE E
TYPE CFML
7
struct
COLUMN 0
ID E
LINE 307
RAW_TRACE at cfswitches2esales2ecfm124424435._factor37(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:307)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
8
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE 1
RAW_TRACE at cfswitches2esales2ecfm124424435.runPage(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:1)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFINCLUDE
LINE 483
RAW_TRACE at cfcontent_pages2ecfc1038863650$funcGETSECTIONHTML.runFunction(E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc:483)
TEMPLATE E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc
TYPE CFML
10
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 183
RAW_TRACE at cfApplication2ecfc214318172$funcONREQUESTSTART.runFunction(E:\WEB\RicottaRealEstate\public\Application.cfc:183)
TEMPLATE E:\WEB\RicottaRealEstate\public\Application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
DataSource mlscapecod
Detail [Macromedia][MySQL JDBC Driver][MySQL]Unknown column 'view' in 'where clause'
ErrorCode 42S22
Exceptions
array
1
struct
class java.sql.SQLSyntaxErrorException
message [Macromedia][MySQL JDBC Driver][MySQL]Unknown column 'view' in 'where clause'
Message Error Executing Database Query.
NativeErrorCode 1054
RootCause
struct
ErrorCode 1054
Message [Macromedia][MySQL JDBC Driver][MySQL]Unknown column 'view' in 'where clause'
SQLState 42S22
StackTrace java.sql.SQLSyntaxErrorException: [Macromedia][MySQL JDBC Driver][MySQL]Unknown column 'view' in 'where clause' at macromedia.jdbc.mysqlbase.ddcm.b(Unknown Source) at macromedia.jdbc.mysqlbase.ddcm.a(Unknown Source) at macromedia.jdbc.mysqlbase.ddcl.b(Unknown Source) at macromedia.jdbc.mysqlbase.ddcl.a(Unknown Source) at macromedia.jdbc.mysql.MySQLImplConnection.a(Unknown Source) at macromedia.jdbc.mysql.sio.dda.i(Unknown Source) at macromedia.jdbc.mysql.sio.dda.o(Unknown Source) at macromedia.jdbc.mysql.ddg.f(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.e(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.a(Unknown Source) at macromedia.jdbc.mysqlbase.dddt.a(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.x(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.t(Unknown Source) at macromedia.jdbc.mysqlbase.dddt.execute(Unknown Source) at macromedia.jdbc.mysqlbase.dddx.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1553) at coldfusion.sql.Executive.executeQuery(Executive.java:1287) at coldfusion.sql.Executive.executeQuery(Executive.java:1217) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfsales2ecfc78484244$funcGETMLSLISTINGS.runFunction(E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc:351) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:539) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:659) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:468) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3169) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3144) at cfswitches2esales2ecfm124424435._factor31(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:357) at cfswitches2esales2ecfm124424435._factor34(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:353) at cfswitches2esales2ecfm124424435._factor14(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm) at cfswitches2esales2ecfm124424435._factor36(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:345) at cfswitches2esales2ecfm124424435._factor15(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm) at cfswitches2esales2ecfm124424435._factor37(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:307) at cfswitches2esales2ecfm124424435.runPage(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851) at cfcontent_pages2ecfc1038863650$funcGETSECTIONHTML.runFunction(E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc:483) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:539) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:659) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:468) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3169) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3144) at cfApplication2ecfc214318172$funcONREQUESTSTART.runFunction(E:\WEB\RicottaRealEstate\public\Application.cfc:183) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:285) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:473) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:223) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 351
RAW_TRACE at cfsales2ecfc78484244$funcGETMLSLISTINGS.runFunction(E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc:351)
TEMPLATE E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 357
RAW_TRACE at cfswitches2esales2ecfm124424435._factor31(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:357)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE 353
RAW_TRACE at cfswitches2esales2ecfm124424435._factor34(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:353)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE -1
RAW_TRACE at cfswitches2esales2ecfm124424435._factor14(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm)
TEMPLATE E
TYPE CFML
5
struct
COLUMN 0
ID E
LINE 345
RAW_TRACE at cfswitches2esales2ecfm124424435._factor36(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:345)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE -1
RAW_TRACE at cfswitches2esales2ecfm124424435._factor15(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm)
TEMPLATE E
TYPE CFML
7
struct
COLUMN 0
ID E
LINE 307
RAW_TRACE at cfswitches2esales2ecfm124424435._factor37(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:307)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
8
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE 1
RAW_TRACE at cfswitches2esales2ecfm124424435.runPage(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:1)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFINCLUDE
LINE 483
RAW_TRACE at cfcontent_pages2ecfc1038863650$funcGETSECTIONHTML.runFunction(E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc:483)
TEMPLATE E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc
TYPE CFML
10
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 183
RAW_TRACE at cfApplication2ecfc214318172$funcONREQUESTSTART.runFunction(E:\WEB\RicottaRealEstate\public\Application.cfc:183)
TEMPLATE E:\WEB\RicottaRealEstate\public\Application.cfc
TYPE CFML
Type java.sql.SQLSyntaxErrorException
SQLState 42S22
Sql SELECT mlsdata.zoning,mlsdata.TotalLevels,mlsdata.yearbuilt,mlsdata.fireplace,mlsdata.interiorfeatures,mlsdata.appliances, mlsdata.exteriorfeatures,mlsdata.officelongName,mlsdata.ImprovementAsmt,mlsdata.TitleReferenceBook,mlsdata.AnnualBetterment,mlsdata.apn,mlsdata.SpecialAsmtPending,mlsdata.AnnualTax,mlsdata.taxyear,mlsdata.ASBESTOS,mlsdata.MASSUSECODE,mlsdata.floodzone,mlsdata.leadpaint,mlsdata.UndergroundFuelTnk,mlsdata.LandAssessments,mlsdata.ToBeAssessed, mlsdata.TotalAssessments, mlsdata.reciprocalOfficeName, mls.agentcode, mls.reduced, mls.mlsnumber,mls.feedID,mls.officecode, mls.BuyerBrokerCommission, mls.Officename, mls.agentname, mls.listagentpreferredphone, mls.listagentemail,mls.town,mls.Price,mls.Waterview,mls.Waterfront,mls.numphotos, mls.MAINPHOTOURL,mls.status,mls.remarks,mls.propertyType,mls.propertyType,mls.Bedrooms,mls.FullBathrooms,mls.HalfBathrooms,mls.totalrooms,mls.waterfront,mls.waterview, mls.reducedDate,mlsdata.heatingcooling,mlsdata.garage,mlsdata.basement,mlsdata.basementdescription,mlsdata.pool,mlsdata.dock,mlsdata.dockdescription,mlsdata.sidingdescription,mlsdata.roofdescription,mlsdata.floors,mlsdata.heatingcooling,mlsdata.TopographyLotDesc,mlsdata.hotwaterwaterheat,mlsdata.TitleReferencePage,mlsdata.WaterSewerUtility,mlsdata.originalprice,mlsdata.wateraccess,mlsdata.milestobeach,mlsdata.beachdescription,mlsdata.beachownership,mlsdata.Convenientto,mlsdata.association,mlsdata.assocfeeincludes,mlsdata.SquareFootage, mlsdata.listingdate,mlsdata.dom,mlsdata.WaterFrontDesc,mlsdata.WaterViewDesc,mls.yearbuilt,mls.lotsizesqft,mls.squarefeet,mls.LotSizeAcres,mls.Style,mlsdata.VIRTUALTOURURL,mls.town,mls.agentname,mlsdata.listingagentemail,mlsdata.agentfirstName,mlsdata.agentid,mlsdata.agentlastName,mlsdata.AnnualTax,mlsdata.latcoords,mlsdata.longcoords,mlsdata.areadisplay,mlsdata.city,mlsdata.zipCode,mlsdata.mlsnumber,replace(concat_ws(" ", mlsdata.streetNumber, mlsdata.streetdirection, mlsdata.streetname, concat(mlsdata.streetsuffix,','), mls.village, concat('MA',','), mlsdata.zipcode)," ,", ",") as fulladdress, replace(concat_ws(" ", mlsdata.streetNumber, mlsdata.streetdirection, mlsdata.streetname, concat(mlsdata.streetsuffix,','), mls.village, concat('MA',','), mlsdata.zipcode)," ,", ",") as priorityaddress, mlsdata.photourllist from mls INNER JOIN mlsdata ON mls.mlsnumber=mlsdata.mlsnumber WHERE mls.mlsactive = 1 and mls.feedID = 1 AND mls.officecode = (param 1) and mls.mlsnumber = view
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:866) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfsales2ecfc78484244$funcGETMLSLISTINGS.runFunction(E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc:351) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:539) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:659) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:468) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3169) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3144) at cfswitches2esales2ecfm124424435._factor31(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:357) at cfswitches2esales2ecfm124424435._factor34(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:353) at cfswitches2esales2ecfm124424435._factor14(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm) at cfswitches2esales2ecfm124424435._factor36(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:345) at cfswitches2esales2ecfm124424435._factor15(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm) at cfswitches2esales2ecfm124424435._factor37(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:307) at cfswitches2esales2ecfm124424435.runPage(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851) at cfcontent_pages2ecfc1038863650$funcGETSECTIONHTML.runFunction(E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc:483) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:539) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:659) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:468) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3169) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3144) at cfApplication2ecfc214318172$funcONREQUESTSTART.runFunction(E:\WEB\RicottaRealEstate\public\Application.cfc:183) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:285) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:473) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:223) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][MySQL JDBC Driver][MySQL]Unknown column 'view' in 'where clause' at macromedia.jdbc.mysqlbase.ddcm.b(Unknown Source) at macromedia.jdbc.mysqlbase.ddcm.a(Unknown Source) at macromedia.jdbc.mysqlbase.ddcl.b(Unknown Source) at macromedia.jdbc.mysqlbase.ddcl.a(Unknown Source) at macromedia.jdbc.mysql.MySQLImplConnection.a(Unknown Source) at macromedia.jdbc.mysql.sio.dda.i(Unknown Source) at macromedia.jdbc.mysql.sio.dda.o(Unknown Source) at macromedia.jdbc.mysql.ddg.f(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.e(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.a(Unknown Source) at macromedia.jdbc.mysqlbase.dddt.a(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.x(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.t(Unknown Source) at macromedia.jdbc.mysqlbase.dddt.execute(Unknown Source) at macromedia.jdbc.mysqlbase.dddx.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1553) at coldfusion.sql.Executive.executeQuery(Executive.java:1287) at coldfusion.sql.Executive.executeQuery(Executive.java:1217) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) ... 87 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 351
RAW_TRACE at cfsales2ecfc78484244$funcGETMLSLISTINGS.runFunction(E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc:351)
TEMPLATE E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 357
RAW_TRACE at cfswitches2esales2ecfm124424435._factor31(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:357)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE 353
RAW_TRACE at cfswitches2esales2ecfm124424435._factor34(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:353)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE -1
RAW_TRACE at cfswitches2esales2ecfm124424435._factor14(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm)
TEMPLATE E
TYPE CFML
5
struct
COLUMN 0
ID E
LINE 345
RAW_TRACE at cfswitches2esales2ecfm124424435._factor36(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:345)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE -1
RAW_TRACE at cfswitches2esales2ecfm124424435._factor15(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm)
TEMPLATE E
TYPE CFML
7
struct
COLUMN 0
ID E
LINE 307
RAW_TRACE at cfswitches2esales2ecfm124424435._factor37(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:307)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
8
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE 1
RAW_TRACE at cfswitches2esales2ecfm124424435.runPage(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:1)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFINCLUDE
LINE 483
RAW_TRACE at cfcontent_pages2ecfc1038863650$funcGETSECTIONHTML.runFunction(E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc:483)
TEMPLATE E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc
TYPE CFML
10
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 183
RAW_TRACE at cfApplication2ecfc214318172$funcONREQUESTSTART.runFunction(E:\WEB\RicottaRealEstate\public\Application.cfc:183)
TEMPLATE E:\WEB\RicottaRealEstate\public\Application.cfc
TYPE CFML
Type Database
queryError [Macromedia][MySQL JDBC Driver][MySQL]Unknown column 'view' in 'where clause'
where (param 1) = [type='IN', class='java.lang.String', value='RICO', sqltype='cf_sql_varchar']
StackTrace coldfusion.runtime.EventHandlerException: Event handler exception. at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:293) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:473) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:223) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:866) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfsales2ecfc78484244$funcGETMLSLISTINGS.runFunction(E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc:351) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:539) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:659) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:468) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3169) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3144) at cfswitches2esales2ecfm124424435._factor31(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:357) at cfswitches2esales2ecfm124424435._factor34(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:353) at cfswitches2esales2ecfm124424435._factor14(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm) at cfswitches2esales2ecfm124424435._factor36(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:345) at cfswitches2esales2ecfm124424435._factor15(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm) at cfswitches2esales2ecfm124424435._factor37(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:307) at cfswitches2esales2ecfm124424435.runPage(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851) at cfcontent_pages2ecfc1038863650$funcGETSECTIONHTML.runFunction(E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc:483) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:539) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:659) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:468) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3169) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3144) at cfApplication2ecfc214318172$funcONREQUESTSTART.runFunction(E:\WEB\RicottaRealEstate\public\Application.cfc:183) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:285) ... 38 more Caused by: java.sql.SQLSyntaxErrorException: [Macromedia][MySQL JDBC Driver][MySQL]Unknown column 'view' in 'where clause' at macromedia.jdbc.mysqlbase.ddcm.b(Unknown Source) at macromedia.jdbc.mysqlbase.ddcm.a(Unknown Source) at macromedia.jdbc.mysqlbase.ddcl.b(Unknown Source) at macromedia.jdbc.mysqlbase.ddcl.a(Unknown Source) at macromedia.jdbc.mysql.MySQLImplConnection.a(Unknown Source) at macromedia.jdbc.mysql.sio.dda.i(Unknown Source) at macromedia.jdbc.mysql.sio.dda.o(Unknown Source) at macromedia.jdbc.mysql.ddg.f(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.e(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.a(Unknown Source) at macromedia.jdbc.mysqlbase.dddt.a(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.x(Unknown Source) at macromedia.jdbc.mysqlbase.ddey.t(Unknown Source) at macromedia.jdbc.mysqlbase.dddt.execute(Unknown Source) at macromedia.jdbc.mysqlbase.dddx.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1553) at coldfusion.sql.Executive.executeQuery(Executive.java:1287) at coldfusion.sql.Executive.executeQuery(Executive.java:1217) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) ... 87 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 351
RAW_TRACE at cfsales2ecfc78484244$funcGETMLSLISTINGS.runFunction(E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc:351)
TEMPLATE E:\WEB\RicottaRealEstate\public\cfcs\sales.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 357
RAW_TRACE at cfswitches2esales2ecfm124424435._factor31(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:357)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE 353
RAW_TRACE at cfswitches2esales2ecfm124424435._factor34(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:353)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE -1
RAW_TRACE at cfswitches2esales2ecfm124424435._factor14(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm)
TEMPLATE E
TYPE CFML
5
struct
COLUMN 0
ID E
LINE 345
RAW_TRACE at cfswitches2esales2ecfm124424435._factor36(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:345)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE -1
RAW_TRACE at cfswitches2esales2ecfm124424435._factor15(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm)
TEMPLATE E
TYPE CFML
7
struct
COLUMN 0
ID E
LINE 307
RAW_TRACE at cfswitches2esales2ecfm124424435._factor37(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:307)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
8
struct
COLUMN 0
ID CF_SWITCHES.SALES
LINE 1
RAW_TRACE at cfswitches2esales2ecfm124424435.runPage(E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm:1)
TEMPLATE E:\WEB\RicottaRealEstate\public\includes\switches.sales.cfm
TYPE CFML
9
struct
COLUMN 0
ID CFINCLUDE
LINE 483
RAW_TRACE at cfcontent_pages2ecfc1038863650$funcGETSECTIONHTML.runFunction(E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc:483)
TEMPLATE E:\WEB\GlobalAdmin\public\admin\modules\content\r1\content_pages.cfc
TYPE CFML
10
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 183
RAW_TRACE at cfApplication2ecfc214318172$funcONREQUESTSTART.runFunction(E:\WEB\RicottaRealEstate\public\Application.cfc:183)
TEMPLATE E:\WEB\RicottaRealEstate\public\Application.cfc
TYPE CFML
Type Database
name onRequestStart