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 b.sortorder' at line 37
SQLState 42000
StackTrace com.mysql.jdbc.exceptions.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 b.sortorder' at line 37 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715) at com.mysql.jdbc.Connection.execSQL(Connection.java:3243) at com.mysql.jdbc.Connection.execSQL(Connection.java:3172) at com.mysql.jdbc.Statement.execute(Statement.java:706) at com.mysql.jdbc.Statement.execute(Statement.java:783) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1220) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfproperty2ecfc1792831388$funcADVANCEDSEARCH.runFunction(G:\wwwbull\components\property.cfc:819) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at cflisting2ecfm323047883._factor0(G:\wwwbull\listing.cfm:68) at cflisting2ecfm323047883._factor1(G:\wwwbull\listing.cfm:38) at cflisting2ecfm323047883._factor8(G:\wwwbull\listing.cfm:1) at cflisting2ecfm323047883.runPage(G:\wwwbull\listing.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 819
RAW_TRACE at cfproperty2ecfc1792831388$funcADVANCEDSEARCH.runFunction(G:\wwwbull\components\property.cfc:819)
TEMPLATE G:\wwwbull\components\property.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 68
RAW_TRACE at cflisting2ecfm323047883._factor0(G:\wwwbull\listing.cfm:68)
TEMPLATE G:\wwwbull\listing.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_LISTING
LINE 38
RAW_TRACE at cflisting2ecfm323047883._factor1(G:\wwwbull\listing.cfm:38)
TEMPLATE G:\wwwbull\listing.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_LISTING
LINE 1
RAW_TRACE at cflisting2ecfm323047883._factor8(G:\wwwbull\listing.cfm:1)
TEMPLATE G:\wwwbull\listing.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_LISTING
LINE 1
RAW_TRACE at cflisting2ecfm323047883.runPage(G:\wwwbull\listing.cfm:1)
TEMPLATE G:\wwwbull\listing.cfm
TYPE CFML
Type com.mysql.jdbc.exceptions.MySQLSyntaxErrorException
DataSource bull
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 b.sortorder' at line 37
ErrorCode 42000
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 b.sortorder' at line 37
SQLState 42000
StackTrace com.mysql.jdbc.exceptions.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 b.sortorder' at line 37 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715) at com.mysql.jdbc.Connection.execSQL(Connection.java:3243) at com.mysql.jdbc.Connection.execSQL(Connection.java:3172) at com.mysql.jdbc.Statement.execute(Statement.java:706) at com.mysql.jdbc.Statement.execute(Statement.java:783) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1220) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfproperty2ecfc1792831388$funcADVANCEDSEARCH.runFunction(G:\wwwbull\components\property.cfc:819) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at cflisting2ecfm323047883._factor0(G:\wwwbull\listing.cfm:68) at cflisting2ecfm323047883._factor1(G:\wwwbull\listing.cfm:38) at cflisting2ecfm323047883._factor8(G:\wwwbull\listing.cfm:1) at cflisting2ecfm323047883.runPage(G:\wwwbull\listing.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 819
RAW_TRACE at cfproperty2ecfc1792831388$funcADVANCEDSEARCH.runFunction(G:\wwwbull\components\property.cfc:819)
TEMPLATE G:\wwwbull\components\property.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 68
RAW_TRACE at cflisting2ecfm323047883._factor0(G:\wwwbull\listing.cfm:68)
TEMPLATE G:\wwwbull\listing.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_LISTING
LINE 38
RAW_TRACE at cflisting2ecfm323047883._factor1(G:\wwwbull\listing.cfm:38)
TEMPLATE G:\wwwbull\listing.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_LISTING
LINE 1
RAW_TRACE at cflisting2ecfm323047883._factor8(G:\wwwbull\listing.cfm:1)
TEMPLATE G:\wwwbull\listing.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_LISTING
LINE 1
RAW_TRACE at cflisting2ecfm323047883.runPage(G:\wwwbull\listing.cfm:1)
TEMPLATE G:\wwwbull\listing.cfm
TYPE CFML
Type com.mysql.jdbc.exceptions.MySQLSyntaxErrorException
SQLState 42000
Sql SELECT a.pid AS propertyid, a.type AS propertytypeid, a.heading, a.price, a.adrs1 AS address1, a.adrs2 AS address2, a.city, a.stateid, a.acode AS zipcode, a.pdesc AS description, a.active AS activeyn, a.loopnet, a.countyid, a.pricetypeid, a.bshowprice, b.type AS propertytype, b.sortorder, e.pricetype, f.statename AS state, a.viewlevel, a.propsize FROM property a, type b, pricetype e, states f WHERE a.type = b.tid AND a.pricetypeid = e.pricetypeid AND a.stateid = f.stateid AND a.active = 1 AND a.publishyn = 1 AND (a.viewlevel = 'P' OR a.viewlevel IS NULL) AND a.pid IN () ORDER BY b.sortorder
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:583) at cfproperty2ecfc1792831388$funcADVANCEDSEARCH.runFunction(G:\wwwbull\components\property.cfc:819) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:192) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:448) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:308) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2272) at cflisting2ecfm323047883._factor0(G:\wwwbull\listing.cfm:68) at cflisting2ecfm323047883._factor1(G:\wwwbull\listing.cfm:38) at cflisting2ecfm323047883._factor8(G:\wwwbull\listing.cfm:1) at cflisting2ecfm323047883.runPage(G:\wwwbull\listing.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: com.mysql.jdbc.exceptions.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 b.sortorder' at line 37 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715) at com.mysql.jdbc.Connection.execSQL(Connection.java:3243) at com.mysql.jdbc.Connection.execSQL(Connection.java:3172) at com.mysql.jdbc.Statement.execute(Statement.java:706) at com.mysql.jdbc.Statement.execute(Statement.java:783) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1220) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) ... 47 more
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 819
RAW_TRACE at cfproperty2ecfc1792831388$funcADVANCEDSEARCH.runFunction(G:\wwwbull\components\property.cfc:819)
TEMPLATE G:\wwwbull\components\property.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 68
RAW_TRACE at cflisting2ecfm323047883._factor0(G:\wwwbull\listing.cfm:68)
TEMPLATE G:\wwwbull\listing.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_LISTING
LINE 38
RAW_TRACE at cflisting2ecfm323047883._factor1(G:\wwwbull\listing.cfm:38)
TEMPLATE G:\wwwbull\listing.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_LISTING
LINE 1
RAW_TRACE at cflisting2ecfm323047883._factor8(G:\wwwbull\listing.cfm:1)
TEMPLATE G:\wwwbull\listing.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_LISTING
LINE 1
RAW_TRACE at cflisting2ecfm323047883.runPage(G:\wwwbull\listing.cfm:1)
TEMPLATE G:\wwwbull\listing.cfm
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 b.sortorder' at line 37
where [empty string]