Rushland Plantation is a community of 125 home sites resting on a protected 500 private acres and surrounded by tidal marshes and the Intracoastal Waterway. This nature lover's paradise is located on Johns Island just off of River Road and minutes from Downtown Charleston. Multiple community docks, an open-air pavilion and a pool located along the waterway allow residents to enjoy the surrounding area. Natural conservation areas, greenways, freshwater lagoons and parks provide opportunities to experience all the Lowcountry has to offer. An award-winning bird habitat, Rushland is home to a large variety waterfowl and birds. Deep water, lagoon, marsh view homesites, and custom homes are available and range from 1/3 acre to 2 acre estates.
| Lucee 5.3.1.102 Error (database) | |
| Message | Unknown column 'Rushland' in 'where clause' |
| SQL | SELECT mastertable.street_number,mastertable.street_name,mastertable.city,mastertable.zip_code,mastertable.state,mastertable.mlsnumber,mastertable.mlsid,mastertable.wsid,mastertable.unit_number,mastertable.list_price,mastertable.subdivision,mastertable.bedrooms,mastertable.baths_full,mastertable.acreage,mastertable.zoning,mastertable.kind,mastertable.photo_link,mastertable.addressdisplayyn,mastertable.legaladdress,mastertable.shortsale,mastertable.foreclosure,property_dates.created_at,mastertable.longitude,mastertable.latitude FROM mastertable Inner Join property_dates where mastertable.MLSNumber = property_dates.mlsnumber and mastertable.mlsid = '3' and property_dates.mlsid = '3' and mastertable.mlsid = property_dates.mlsid and mastertable.wsid = property_dates.wsid and ( mastertable.subdivision rlike "Rushland" or mastertable.subdivision rlike "Rushland Plantation" ) order by list_price DESC |
| DatabaseName | MySQL |
| DatabaseVersion | 8.0.19 |
| DriverName | MySQL Connector/J |
| DriverVersion | mysql-connector-java-8.0.15 (Revision: 79a4336f140499bd22dd07f02b708e163844e3d5) |
| Datasource | mlsmaster30 |
| Stacktrace | The Error Occurred in E:\inetpub\wwwroot\domains\askfrankrealestate.com\htdocs\mls\components\neighborhood-listings.cfm: line 28 26: )called from E:\inetpub\wwwroot\domains\askfrankrealestate.com\htdocs\mls\charleston-neighborhood.cfm: line 81 79: <p><cfoutput>#getneighborhoodinfo.hoodinfo#</cfoutput></p> |
| Java Stacktrace | lucee.runtime.exp.DatabaseException: Unknown column 'Rushland' in 'where clause' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:782) at com.mysql.cj.jdbc.StatementImpl.$fr$execute(StatementImpl.java:666) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:286) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:267) at lucee.runtime.type.QueryImpl. at lucee.runtime.tag.Query.executeDatasoure(Query.java:1044) at lucee.runtime.tag.Query._doEndTag(Query.java:644) at lucee.runtime.tag.Query.doEndTag(Query.java:537) at mls.components.neighborhood_listings_cfm585$cf.call(/mls/components/neighborhood-listings.cfm:28) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:911) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:803) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:785) at mls.charleston_neighborhood_cfm495$cf.call(/mls/charleston-neighborhood.cfm:81) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:911) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:803) at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:64) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2367) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2357) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2332) at lucee.runtime.engine.Request.exe(Request.java:43) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1045) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:991) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at sun.reflect.GeneratedMethodAccessor61.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.doHttpServletRequest(FusionReactorRequestHandler.java:344) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:801) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at sun.reflect.GeneratedMethodAccessor60.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.GeneratedMethodAccessor59.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:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:478) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1434) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) 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) |
| Timestamp | 6/4/20 11:46:55 PM EDT |