Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

Unknown column 'DatePhoto' in 'field list'
 
The error occurred in D:/webfolder/thelighthouserealestate/html/components/homefinder.cfc: line 232
Called from D:/webfolder/thelighthouserealestate/html/search-results_detail.cfm: line 83
Called from D:/webfolder/thelighthouserealestate/html/search-results_detail.cfm: line 1
Called from D:/webfolder/thelighthouserealestate/html/components/homefinder.cfc: line 232
Called from D:/webfolder/thelighthouserealestate/html/search-results_detail.cfm: line 83
Called from D:/webfolder/thelighthouserealestate/html/search-results_detail.cfm: line 1
230 : 							'' as offname
231 : 					FROM 	residentialproperty_unsold mls
232 : 					WHERE 	ListingID = <cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#variables.tempvarID#" maxlength="10" null="No">
233 : 				</cfquery>
234 : 				<cfreturn qryProperty>

VENDORERRORCODE   1054
SQLSTATE   42S22
SQL    SELECT BATHS, Bath34Size as tQBath, BathsPartial as hbath, BedRoomMasterDimensions as mbrsize, Bedroom2Size as bdrm2size, Bedroom3Size as bdrm3size, Bedrooms as bdrms, DenSize as DEN_SIZE, DiningRoomSize as ddin, FamilyRoomSize as dfam, SqFtTotal as sqft_n, ListingID as MLS_Number, KitchenSize as dkit, ListPrice as LIST_PRICE, LotSizeArea AS acres, LivingRoomSize as liv_siz, Zoning, DateChange as MOD_DATE_TIME, DatePhoto as P_MOD_DATE_TIME, PublicRemarks as remark, TotalRooms as n_rms, SchoolDistrict as school, SchoolElementary as sch_elem, JuniorHighSchool as sch_jr, SchoolHigh as sch_high, SeasonalYN AS SEASONAL, StateOrProvince as STATE, ListingStatus AS STATUS, TaxAmount as taxes_n, TaxYear as tax_yr, OfficialTown as town, YearBuilt as yr_blt, PropertyType AS prop_fmt, ListingAgentID, ListingFirmID, PhotoCount as photos, WaterBodyName as wtrname, WaterFrontage as wtr_fdtg, StreetNameIDX as street_name, StreetNumberIDX as street_no, AuctioneerLicNo as auctioneer_lic, VirtualTourURL as virt_url, PostalCode as zip, HeatingAndCooling, HeatFuel, Amenities, Style, '' as agtname, '' as offname FROM residentialproperty_unsold mls WHERE ListingID = (param 1)
DATASOURCE   retsv2_homefinder_ds
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   54.163.20.57
Referrer  
Date/Time   19-Nov-18 10:19 AM
Stack Trace
at cfhomefinder2ecfc46968301$funcRETURNPROPERTYDETAIL.runFunction(D:/webfolder/thelighthouserealestate/html/components/homefinder.cfc:232) at cfsearch2dresults_detail2ecfm1786487983._factor17(D:/webfolder/thelighthouserealestate/html/search-results_detail.cfm:83) at cfsearch2dresults_detail2ecfm1786487983.runPage(D:/webfolder/thelighthouserealestate/html/search-results_detail.cfm:1) at cfhomefinder2ecfc46968301$funcRETURNPROPERTYDETAIL.runFunction(D:/webfolder/thelighthouserealestate/html/components/homefinder.cfc:232) at cfsearch2dresults_detail2ecfm1786487983._factor17(D:/webfolder/thelighthouserealestate/html/search-results_detail.cfm:83) at cfsearch2dresults_detail2ecfm1786487983.runPage(D:/webfolder/thelighthouserealestate/html/search-results_detail.cfm:1)

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'DatePhoto' in 'field list'
	at sun.reflect.GeneratedConstructorAccessor753.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	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:2799)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2139)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1363)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1467)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1201)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1131)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688)
	at cfhomefinder2ecfc46968301$funcRETURNPROPERTYDETAIL.runFunction(D:\webfolder\thelighthouserealestate\html\components\homefinder.cfc:232)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369)
	at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:395)
	at cfsearch2dresults_detail2ecfm1786487983._factor17(D:\webfolder\thelighthouserealestate\html\search-results_detail.cfm:83)
	at cfsearch2dresults_detail2ecfm1786487983.runPage(D:\webfolder\thelighthouserealestate\html\search-results_detail.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
	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 com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doRequestNoFilter(FusionReactorCoreFilter.java:712)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFusionRequest(FusionReactorCoreFilter.java:341)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:246)
	at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:121)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
	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$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:662)