struct
EVENTNAME onRequestStart
EXCEPTION
struct
Cause
struct
Cause
struct
ErrorCode 1064
Message You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mls.Price DESC' at line 11
SQLState 42000
StackTrace com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mls.Price DESC' at line 11 at sun.reflect.GeneratedConstructorAccessor814.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:395) at com.mysql.jdbc.Util.getInstance(Util.java:370) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1038) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2793) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2742) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:878) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:986) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1537) 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 cfswitches2eagents2ecfm344902928$funcGETLISTINGS.runFunction(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:87) 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.CfJspPage._invokeUDF(CfJspPage.java:3638) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3619) at cfswitches2eagents2ecfm344902928.runPage(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:116) 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 cfApplication2ecfc518698823$funcONREQUESTSTART.runFunction(E:\WEB\StoweRedBarnRealty\public\Application.cfc:182) 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:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:356) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:544) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 87
RAW_TRACE at cfswitches2eagents2ecfm344902928$funcGETLISTINGS.runFunction(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:87)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 116
RAW_TRACE at cfswitches2eagents2ecfm344902928.runPage(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:116)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 182
RAW_TRACE at cfApplication2ecfc518698823$funcONREQUESTSTART.runFunction(E:\WEB\StoweRedBarnRealty\public\Application.cfc:182)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\Application.cfc
TYPE CFML
Type com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
DataSource mlscapecod
Detail You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mls.Price DESC' at line 11
ErrorCode 42000
Exceptions
array
1
struct
class com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
message You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mls.Price DESC' at line 11
Message Error Executing Database Query.
NativeErrorCode 1064
RootCause
struct
ErrorCode 1064
Message You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mls.Price DESC' at line 11
SQLState 42000
StackTrace com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mls.Price DESC' at line 11 at sun.reflect.GeneratedConstructorAccessor814.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:395) at com.mysql.jdbc.Util.getInstance(Util.java:370) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1038) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2793) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2742) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:878) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:986) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1537) 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 cfswitches2eagents2ecfm344902928$funcGETLISTINGS.runFunction(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:87) 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.CfJspPage._invokeUDF(CfJspPage.java:3638) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3619) at cfswitches2eagents2ecfm344902928.runPage(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:116) 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 cfApplication2ecfc518698823$funcONREQUESTSTART.runFunction(E:\WEB\StoweRedBarnRealty\public\Application.cfc:182) 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:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:356) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:544) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 87
RAW_TRACE at cfswitches2eagents2ecfm344902928$funcGETLISTINGS.runFunction(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:87)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 116
RAW_TRACE at cfswitches2eagents2ecfm344902928.runPage(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:116)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 182
RAW_TRACE at cfApplication2ecfc518698823$funcONREQUESTSTART.runFunction(E:\WEB\StoweRedBarnRealty\public\Application.cfc:182)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\Application.cfc
TYPE CFML
Type com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
SQLState 42000
Sql SELECT mls.mlsnumber, mls.LOTSIZEACRES, mls.feedID, mls.officecode, mls.agentcode, mls.town, mls.Price, mls.Waterview, mls.Waterfront, mls.numphotos, mls.status, mls.remarks, mls.propertyType, mls.propertyType, mls.Bedrooms, mls.FullBathrooms, mls.HalfBathrooms, mls.yearbuilt, mls.lotsizesqft, mls.squarefeet, mls.town, replace(concat_ws(" ", mls.streetNumber, mls.streetdirection, mls.streetname, concat(mls.streetsuffix,','), mls.town, concat('VT',','), mls.zipcode)," ,", ",") as fulladdress, replace(concat_ws(" ", mls.streetNumber, mls.streetdirection, mls.streetname, concat(mls.streetsuffix,','), mls.town, concat('VT',','), mls.zipcode)," ,", ",") as priorityaddress, mls.garage, mls.style FROM mls WHERE mls.mlsactive = 1 AND mls.feedID = 5 AND (mls.status = "A" Or mls.status ="C" Or mls.status ="K") AND mls.officecode = "4367" AND mls.agentcode = ORDER BY mls.Price DESC
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 cfswitches2eagents2ecfm344902928$funcGETLISTINGS.runFunction(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:87) 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.CfJspPage._invokeUDF(CfJspPage.java:3638) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3619) at cfswitches2eagents2ecfm344902928.runPage(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:116) 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 cfApplication2ecfc518698823$funcONREQUESTSTART.runFunction(E:\WEB\StoweRedBarnRealty\public\Application.cfc:182) 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:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:356) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:544) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mls.Price DESC' at line 11 at sun.reflect.GeneratedConstructorAccessor814.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:395) at com.mysql.jdbc.Util.getInstance(Util.java:370) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1038) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2793) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2742) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:878) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:986) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1537) 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) ... 67 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 87
RAW_TRACE at cfswitches2eagents2ecfm344902928$funcGETLISTINGS.runFunction(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:87)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 116
RAW_TRACE at cfswitches2eagents2ecfm344902928.runPage(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:116)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 182
RAW_TRACE at cfApplication2ecfc518698823$funcONREQUESTSTART.runFunction(E:\WEB\StoweRedBarnRealty\public\Application.cfc:182)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\Application.cfc
TYPE CFML
Type Database
queryError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mls.Price DESC' at line 11
where [empty string]
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 1064
Message You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mls.Price DESC' at line 11
SQLState 42000
StackTrace com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mls.Price DESC' at line 11 at sun.reflect.GeneratedConstructorAccessor814.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:395) at com.mysql.jdbc.Util.getInstance(Util.java:370) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1038) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2793) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2742) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:878) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:986) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1537) 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 cfswitches2eagents2ecfm344902928$funcGETLISTINGS.runFunction(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:87) 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.CfJspPage._invokeUDF(CfJspPage.java:3638) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3619) at cfswitches2eagents2ecfm344902928.runPage(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:116) 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 cfApplication2ecfc518698823$funcONREQUESTSTART.runFunction(E:\WEB\StoweRedBarnRealty\public\Application.cfc:182) 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:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:356) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:544) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 87
RAW_TRACE at cfswitches2eagents2ecfm344902928$funcGETLISTINGS.runFunction(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:87)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 116
RAW_TRACE at cfswitches2eagents2ecfm344902928.runPage(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:116)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 182
RAW_TRACE at cfApplication2ecfc518698823$funcONREQUESTSTART.runFunction(E:\WEB\StoweRedBarnRealty\public\Application.cfc:182)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\Application.cfc
TYPE CFML
Type com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
DataSource mlscapecod
Detail You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mls.Price DESC' at line 11
ErrorCode 42000
Exceptions
array
1
struct
class com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
message You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mls.Price DESC' at line 11
Message Error Executing Database Query.
NativeErrorCode 1064
RootCause
struct
ErrorCode 1064
Message You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mls.Price DESC' at line 11
SQLState 42000
StackTrace com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mls.Price DESC' at line 11 at sun.reflect.GeneratedConstructorAccessor814.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:395) at com.mysql.jdbc.Util.getInstance(Util.java:370) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1038) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2793) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2742) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:878) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:986) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1537) 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 cfswitches2eagents2ecfm344902928$funcGETLISTINGS.runFunction(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:87) 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.CfJspPage._invokeUDF(CfJspPage.java:3638) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3619) at cfswitches2eagents2ecfm344902928.runPage(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:116) 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 cfApplication2ecfc518698823$funcONREQUESTSTART.runFunction(E:\WEB\StoweRedBarnRealty\public\Application.cfc:182) 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:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:356) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:544) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 87
RAW_TRACE at cfswitches2eagents2ecfm344902928$funcGETLISTINGS.runFunction(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:87)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 116
RAW_TRACE at cfswitches2eagents2ecfm344902928.runPage(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:116)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 182
RAW_TRACE at cfApplication2ecfc518698823$funcONREQUESTSTART.runFunction(E:\WEB\StoweRedBarnRealty\public\Application.cfc:182)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\Application.cfc
TYPE CFML
Type com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
SQLState 42000
Sql SELECT mls.mlsnumber, mls.LOTSIZEACRES, mls.feedID, mls.officecode, mls.agentcode, mls.town, mls.Price, mls.Waterview, mls.Waterfront, mls.numphotos, mls.status, mls.remarks, mls.propertyType, mls.propertyType, mls.Bedrooms, mls.FullBathrooms, mls.HalfBathrooms, mls.yearbuilt, mls.lotsizesqft, mls.squarefeet, mls.town, replace(concat_ws(" ", mls.streetNumber, mls.streetdirection, mls.streetname, concat(mls.streetsuffix,','), mls.town, concat('VT',','), mls.zipcode)," ,", ",") as fulladdress, replace(concat_ws(" ", mls.streetNumber, mls.streetdirection, mls.streetname, concat(mls.streetsuffix,','), mls.town, concat('VT',','), mls.zipcode)," ,", ",") as priorityaddress, mls.garage, mls.style FROM mls WHERE mls.mlsactive = 1 AND mls.feedID = 5 AND (mls.status = "A" Or mls.status ="C" Or mls.status ="K") AND mls.officecode = "4367" AND mls.agentcode = ORDER BY mls.Price DESC
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 cfswitches2eagents2ecfm344902928$funcGETLISTINGS.runFunction(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:87) 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.CfJspPage._invokeUDF(CfJspPage.java:3638) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3619) at cfswitches2eagents2ecfm344902928.runPage(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:116) 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 cfApplication2ecfc518698823$funcONREQUESTSTART.runFunction(E:\WEB\StoweRedBarnRealty\public\Application.cfc:182) 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:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:356) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:544) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mls.Price DESC' at line 11 at sun.reflect.GeneratedConstructorAccessor814.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:395) at com.mysql.jdbc.Util.getInstance(Util.java:370) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1038) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2793) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2742) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:878) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:986) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1537) 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) ... 67 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 87
RAW_TRACE at cfswitches2eagents2ecfm344902928$funcGETLISTINGS.runFunction(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:87)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 116
RAW_TRACE at cfswitches2eagents2ecfm344902928.runPage(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:116)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 182
RAW_TRACE at cfApplication2ecfc518698823$funcONREQUESTSTART.runFunction(E:\WEB\StoweRedBarnRealty\public\Application.cfc:182)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\Application.cfc
TYPE CFML
Type Database
queryError You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mls.Price DESC' at line 11
where [empty string]
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:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:356) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:544) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) 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 cfswitches2eagents2ecfm344902928$funcGETLISTINGS.runFunction(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:87) 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.CfJspPage._invokeUDF(CfJspPage.java:3638) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3619) at cfswitches2eagents2ecfm344902928.runPage(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:116) 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 cfApplication2ecfc518698823$funcONREQUESTSTART.runFunction(E:\WEB\StoweRedBarnRealty\public\Application.cfc:182) 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: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY mls.Price DESC' at line 11 at sun.reflect.GeneratedConstructorAccessor814.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:395) at com.mysql.jdbc.Util.getInstance(Util.java:370) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1038) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2793) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2742) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:878) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:986) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1537) 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) ... 67 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 87
RAW_TRACE at cfswitches2eagents2ecfm344902928$funcGETLISTINGS.runFunction(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:87)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 116
RAW_TRACE at cfswitches2eagents2ecfm344902928.runPage(E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm:116)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\includes\switches.agents.cfm
TYPE CFML
3
struct
COLUMN 0
ID CFINCLUDE
LINE 182
RAW_TRACE at cfApplication2ecfc518698823$funcONREQUESTSTART.runFunction(E:\WEB\StoweRedBarnRealty\public\Application.cfc:182)
TEMPLATE E:\WEB\StoweRedBarnRealty\public\Application.cfc
TYPE CFML
Type Database
name onRequestStart