Kiawah Island is a residential resort community approximately 20 miles south of Charleston. The community is about 11 square miles and has a population of about 1,600 full time residents which swells in the summer tourism months. The island features miles of Beaches, several pools, shops, and six award winning golf courses. The island was home to the 1991 Ryder Cup, 2012 PGA Championship and future home to the 2021 PGA championship. Guest can also stay at the five star rated Sanctuary Inn at Kiawah. There are numerous homes and villas available for rent on a weekly basis. Homes and villas on the island range from about $150,000 to multimillion dollar estates that are home to the worlds rich and famous.
| Lucee 5.3.1.102 Error (database) | |
| Message | Unknown column 'Kiawah Island' 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 "Kiawah Island" ) 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 'Kiawah Island' 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 10:51:43 PM EDT |