Error Executing Database Query.
|
Table 'realtrac_v2mlsgrid.condominium' doesn't exist
|
|
The error occurred in /home/studio11prod/public_html/_global/queries/realestate.cfm: line 72
Called from /home/studio11prod/public_html/_global/queries/realestate.cfm: line 1
Called from /home/studio11prod/public_html/_global/queries/index.cfm: line 4
Called from /home/studio11prod/public_html/_RealEstate/properties/index.cfm: line 1
Called from /home/studio11prod/public_html/_global/queries/realestate.cfm: line 72
Called from /home/studio11prod/public_html/_global/queries/realestate.cfm: line 1
Called from /home/studio11prod/public_html/_global/queries/index.cfm: line 4
Called from /home/studio11prod/public_html/_RealEstate/properties/index.cfm: line 1
|
70 : WHERE ListAgent IN (#agentList#) OR ListAgent2 IN (#agentList#) OR ListAgent3 IN (#agentList#)
71 : </cfif>
72 : <cfif SESSION.PropertySorting EQ 1>ORDER BY ListDate DESC, Price<cfelseif SESSION.PropertySorting EQ 2>ORDER BY Price DESC<cfelse>ORDER BY Price</cfif>
73 : </cfquery>
74 :
|
|
SQLSTATE |
42S02 |
DATASOURCE |
MLSgridDATA |
VENDORERRORCODE |
1146 |
SQL |
SELECT *
FROM condominium
WHERE ListAgent IN (2348,2348,5985,38174,5941,5958,38348,28377,7550,29244,35335,41557,1404,40783,34054,5930,5985,38174,5941,5958,38348,28377,7550,29244,35335,41557,1404,40783,34054,5930,28540,5959,29927,5954,7565,39425,5987,33088,5991,5993,40542,5919,5943,37270,40650,682,41784,5944,5938,35267,5946,5945,24813,35138,5950,39424,5953,5960,5961,5963,5933,28881,29018,5979,41003,5982,40165) OR ListAgent2 IN (2348,2348,5985,38174,5941,5958,38348,28377,7550,29244,35335,41557,1404,40783,34054,5930,5985,38174,5941,5958,38348,28377,7550,29244,35335,41557,1404,40783,34054,5930,28540,5959,29927,5954,7565,39425,5987,33088,5991,5993,40542,5919,5943,37270,40650,682,41784,5944,5938,35267,5946,5945,24813,35138,5950,39424,5953,5960,5961,5963,5933,28881,29018,5979,41003,5982,40165) OR ListAgent3 IN (2348,2348,5985,38174,5941,5958,38348,28377,7550,29244,35335,41557,1404,40783,34054,5930,5985,38174,5941,5958,38348,28377,7550,29244,35335,41557,1404,40783,34054,5930,28540,5959,29927,5954,7565,39425,5987,33088,5991,5993,40542,5919,5943,37270,40650,682,41784,5944,5938,35267,5946,5945,24813,35138,5950,39424,5953,5960,5961,5963,5933,28881,29018,5979,41003,5982,40165)
ORDER BY Price |
|
Resources:
|
Browser |
claudebot |
Remote Address |
34.237.245.80 |
Referrer |
http://darlahunley.com/featuredlist/condominium/1.html |
Date/Time |
19-Mar-24 03:30 AM |
|
Stack Trace
|
at cfrealestate2ecfm208651717._factor55(/home/studio11prod/public_html/_global/queries/realestate.cfm:72) at cfrealestate2ecfm208651717.runPage(/home/studio11prod/public_html/_global/queries/realestate.cfm:1) at cfindex2ecfm1875175175.runPage(/home/studio11prod/public_html/_global/queries/index.cfm:4) at cfindex2ecfm1675806038.runPage(/home/studio11prod/public_html/_RealEstate/properties/index.cfm:1)
at cfrealestate2ecfm208651717._factor55(/home/studio11prod/public_html/_global/queries/realestate.cfm:72) at cfrealestate2ecfm208651717.runPage(/home/studio11prod/public_html/_global/queries/realestate.cfm:1) at cfindex2ecfm1875175175.runPage(/home/studio11prod/public_html/_global/queries/index.cfm:4) at cfindex2ecfm1675806038.runPage(/home/studio11prod/public_html/_RealEstate/properties/index.cfm:1)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'realtrac_v2mlsgrid.condominium' doesn't exist
at sun.reflect.GeneratedConstructorAccessor523.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:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2491)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2449)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
at com.mysql.jdbc.StatementImpl.$fr$execute(StatementImpl.java:939)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1485)
at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
at cfrealestate2ecfm208651717._factor55(/home/studio11prod/public_html/_global/queries/realestate.cfm:72)
at cfrealestate2ecfm208651717.runPage(/home/studio11prod/public_html/_global/queries/realestate.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
at cfindex2ecfm1875175175.runPage(/home/studio11prod/public_html/_global/queries/index.cfm:4)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
at cfindex2ecfm1675806038.runPage(/home/studio11prod/public_html/_RealEstate/properties/index.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
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:219)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
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:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:764)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:793)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
|
|