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.

Data truncation: Data too long for column 'City' at row 1
 
The error occurred in C:\inetpub\wwwroot\realestateonline\Includes\STATLISTINGVIEWS.cfm: line 9
Called from C:\inetpub\wwwroot\AmericanAssociates\view.cfm: line 47
Called from C:\inetpub\wwwroot\AmericanAssociates\view.cfm: line 2
Called from C:\inetpub\wwwroot\AmericanAssociates\view.cfm: line 1
Called from C:\inetpub\wwwroot\AmericanAssociates\query_redirect.cfm: line 11
Called from C:\inetpub\wwwroot\realestateonline\Includes\STATLISTINGVIEWS.cfm: line 9
Called from C:\inetpub\wwwroot\AmericanAssociates\view.cfm: line 47
Called from C:\inetpub\wwwroot\AmericanAssociates\view.cfm: line 2
Called from C:\inetpub\wwwroot\AmericanAssociates\view.cfm: line 1
Called from C:\inetpub\wwwroot\AmericanAssociates\query_redirect.cfm: line 11
7 : VALUES ('#GetHomes.mls#','#mls_id#',#GetHomes.price#,'#reReplace(tempaddress, "  ", " ", "ALL")#','#GetHomes.city#','#GetHomes.zip#'<cfif isDefined("GetHomes.listdate")>,#CreateODBCdatetime(GetHomes.listdate)#</cfif>,'#REReplace(reReplace(templisting,'[[:space:]]','','ALL'),'[^0-9A-Za-z ]','','all')#')
8 : ON DUPLICATE KEY UPDATE <cfif GetHomes.Broker_Order contains "1"><cfif SiteType is "Broker">DetailViewsB = DetailViewsB+1,<cfelse>DetailViewsA = DetailViewsA+1,</cfif><cfelse>DetailViewsO = DetailViewsO+1,</cfif>
9 :  Today = Today+1, Visitors = <cfif isDefined("cookie.ContactID") and IsNumeric(cookie.ContactID)>LEFT(CONCAT('c#cookie.ContactID#,',Visitors), 5000)<cfelse>LEFT(CONCAT('#REReplace(cgi.remote_addr,"\.","","all")#,',Visitors), 5000)</cfif>
10 : </CFQUERY>
11 : </cfif>

SQL    INSERT INTO stats_listing (mls,mls_id,price,address,city,zip,listdate,listingid) VALUES ('mrsmi50004191','realcomp2',8500000,'824 LAKESHORE ','Village of Grosse Pointe Shores','48236',{ts '2020-01-23 00:00:00'},'824LAKESHORE48236') ON DUPLICATE KEY UPDATE DetailViewsO = DetailViewsO+1, Today = Today+1, Visitors = LEFT(CONCAT('5416557161,',Visitors), 5000)
DATASOURCE   RealEstateStats
SQLSTATE   01004
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   54.165.57.161
Referrer  
Date/Time   08-Dec-21 04:04 AM
Stack Trace
at cfSTATLISTINGVIEWS2ecfm2121376329.runPage(C:\inetpub\wwwroot\realestateonline\Includes\STATLISTINGVIEWS.cfm:9) at cfview2ecfm530345731._factor5(C:\inetpub\wwwroot\AmericanAssociates\view.cfm:47) at cfview2ecfm530345731._factor33(C:\inetpub\wwwroot\AmericanAssociates\view.cfm:2) at cfview2ecfm530345731.runPage(C:\inetpub\wwwroot\AmericanAssociates\view.cfm:1) at cfquery_redirect2ecfm887604138.runPage(C:\inetpub\wwwroot\AmericanAssociates\query_redirect.cfm:11) at cfSTATLISTINGVIEWS2ecfm2121376329.runPage(C:\inetpub\wwwroot\realestateonline\Includes\STATLISTINGVIEWS.cfm:9) at cfview2ecfm530345731._factor5(C:\inetpub\wwwroot\AmericanAssociates\view.cfm:47) at cfview2ecfm530345731._factor33(C:\inetpub\wwwroot\AmericanAssociates\view.cfm:2) at cfview2ecfm530345731.runPage(C:\inetpub\wwwroot\AmericanAssociates\view.cfm:1) at cfquery_redirect2ecfm887604138.runPage(C:\inetpub\wwwroot\AmericanAssociates\query_redirect.cfm:11)

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'City' at row 1
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2973)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2927)
	at com.mysql.jdbc.Statement.execute(Statement.java:535)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
	at coldfusion.sql.Executive.executeQuery(Executive.java:719)
	at coldfusion.sql.Executive.executeQuery(Executive.java:652)
	at coldfusion.sql.Executive.executeQuery(Executive.java:613)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:499)
	at cfSTATLISTINGVIEWS2ecfm2121376329.runPage(C:\inetpub\wwwroot\realestateonline\Includes\STATLISTINGVIEWS.cfm:9)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
	at cfview2ecfm530345731._factor5(C:\inetpub\wwwroot\AmericanAssociates\view.cfm:47)
	at cfview2ecfm530345731._factor33(C:\inetpub\wwwroot\AmericanAssociates\view.cfm:2)
	at cfview2ecfm530345731.runPage(C:\inetpub\wwwroot\AmericanAssociates\view.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
	at cfquery_redirect2ecfm887604138.runPage(C:\inetpub\wwwroot\AmericanAssociates\query_redirect.cfm:11)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
	at coldfusion.CfmServlet.service(CfmServlet.java:107)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	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 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:91)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)