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 D:/inetpub/wwwroot/RealSmartPro/Includes/STATLISTINGVIEWS.cfm: line 9
Called from D:/inetpub/wwwroot/Websites/Brokers/LibertyWayRealty/view.cfm: line 20
Called from D:/inetpub/wwwroot/Websites/Brokers/LibertyWayRealty/view.cfm: line 1
Called from D:/inetpub/wwwroot/Websites/Brokers/LibertyWayRealty/view.cfm: line 1
Called from D:/inetpub/wwwroot/Websites/Brokers/LibertyWayRealty/query_redirect.cfm: line 11
Called from D:/inetpub/wwwroot/RealSmartPro/Includes/STATLISTINGVIEWS.cfm: line 9
Called from D:/inetpub/wwwroot/Websites/Brokers/LibertyWayRealty/view.cfm: line 20
Called from D:/inetpub/wwwroot/Websites/Brokers/LibertyWayRealty/view.cfm: line 1
Called from D:/inetpub/wwwroot/Websites/Brokers/LibertyWayRealty/view.cfm: line 1
Called from D:/inetpub/wwwroot/Websites/Brokers/LibertyWayRealty/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, lastviewed = #CreateODBCDateTime(Now())#, Visitors = <cfif isDefined("cookie.ContactID") and IsNumeric(cookie.ContactID)>LEFT(CONCAT('c#cookie.ContactID#,',Visitors), 1000)<cfelse>LEFT(CONCAT('#REReplace(cgi.remote_addr,"\.","","all")#,',Visitors), 1000)</cfif>
10 : </CFQUERY>
11 : </cfif>

SQLSTATE   22001
DATASOURCE   RealEstateStats
VENDORERRORCODE   1406
SQL    INSERT INTO stats_listing (mls,mls_id,price,address,city,zip,listdate,listingid) VALUES ('rcomi20230040707','realcomp2',3900000,'1010 Lake Shore Road','Village of Grosse Pointe Shores','48236',{ts '2023-05-24 00:00:00'},'1010LakeShore48236') ON DUPLICATE KEY UPDATE DetailViewsO = DetailViewsO+1, Today = Today+1, lastviewed = {ts '2024-03-28 08:01:57'}, Visitors = LEFT(CONCAT('44202128177,',Visitors), 1000)
Resources:

Browser   claudebot
Remote Address   44.202.128.177
Referrer  
Date/Time   28-Mar-24 08:01 AM
Stack Trace
at cfSTATLISTINGVIEWS2ecfm819963804.runPage(D:/inetpub/wwwroot/RealSmartPro/Includes/STATLISTINGVIEWS.cfm:9) at cfview2ecfm1442192425._factor1(D:/inetpub/wwwroot/Websites/Brokers/LibertyWayRealty/view.cfm:20) at cfview2ecfm1442192425._factor26(D:/inetpub/wwwroot/Websites/Brokers/LibertyWayRealty/view.cfm:1) at cfview2ecfm1442192425.runPage(D:/inetpub/wwwroot/Websites/Brokers/LibertyWayRealty/view.cfm:1) at cfquery_redirect2ecfm1103179095.runPage(D:/inetpub/wwwroot/Websites/Brokers/LibertyWayRealty/query_redirect.cfm:11) at cfSTATLISTINGVIEWS2ecfm819963804.runPage(D:/inetpub/wwwroot/RealSmartPro/Includes/STATLISTINGVIEWS.cfm:9) at cfview2ecfm1442192425._factor1(D:/inetpub/wwwroot/Websites/Brokers/LibertyWayRealty/view.cfm:20) at cfview2ecfm1442192425._factor26(D:/inetpub/wwwroot/Websites/Brokers/LibertyWayRealty/view.cfm:1) at cfview2ecfm1442192425.runPage(D:/inetpub/wwwroot/Websites/Brokers/LibertyWayRealty/view.cfm:1) at cfquery_redirect2ecfm1103179095.runPage(D:/inetpub/wwwroot/Websites/Brokers/LibertyWayRealty/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:4185)
	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:2793)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2742)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:878)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:986)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1451)
	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 cfSTATLISTINGVIEWS2ecfm819963804.runPage(D:\inetpub\wwwroot\RealSmartPro\Includes\STATLISTINGVIEWS.cfm:9)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
	at cfview2ecfm1442192425._factor1(D:\inetpub\wwwroot\Websites\Brokers\LibertyWayRealty\view.cfm:20)
	at cfview2ecfm1442192425._factor26(D:\inetpub\wwwroot\Websites\Brokers\LibertyWayRealty\view.cfm:1)
	at cfview2ecfm1442192425.runPage(D:\inetpub\wwwroot\Websites\Brokers\LibertyWayRealty\view.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
	at cfquery_redirect2ecfm1103179095.runPage(D:\inetpub\wwwroot\Websites\Brokers\LibertyWayRealty\query_redirect.cfm:11)
	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.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.seefusion.Filter.doFilter(Filter.java:109)
	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 com.seefusion.SeeFusionValve.invoke(SeeFusionValve.java:52)
	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.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)