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/AtlasRealEstate/view.cfm: line 20
Called from D:/inetpub/wwwroot/Websites/Brokers/AtlasRealEstate/view.cfm: line 1
Called from D:/inetpub/wwwroot/Websites/Brokers/AtlasRealEstate/view.cfm: line 1
Called from D:/inetpub/wwwroot/Websites/Brokers/AtlasRealEstate/query_redirect.cfm: line 11
Called from D:/inetpub/wwwroot/RealSmartPro/Includes/STATLISTINGVIEWS.cfm: line 9
Called from D:/inetpub/wwwroot/Websites/Brokers/AtlasRealEstate/view.cfm: line 20
Called from D:/inetpub/wwwroot/Websites/Brokers/AtlasRealEstate/view.cfm: line 1
Called from D:/inetpub/wwwroot/Websites/Brokers/AtlasRealEstate/view.cfm: line 1
Called from D:/inetpub/wwwroot/Websites/Brokers/AtlasRealEstate/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 20:30:52'}, Visitors = LEFT(CONCAT('182328817,',Visitors), 1000) |
|
Resources:
|
Browser |
claudebot |
Remote Address |
18.232.88.17 |
Referrer |
|
Date/Time |
28-Mar-24 08:30 PM |
|
Stack Trace
|
at cfSTATLISTINGVIEWS2ecfm819963804.runPage(D:/inetpub/wwwroot/RealSmartPro/Includes/STATLISTINGVIEWS.cfm:9) at cfview2ecfm1646730115._factor1(D:/inetpub/wwwroot/Websites/Brokers/AtlasRealEstate/view.cfm:20) at cfview2ecfm1646730115._factor26(D:/inetpub/wwwroot/Websites/Brokers/AtlasRealEstate/view.cfm:1) at cfview2ecfm1646730115.runPage(D:/inetpub/wwwroot/Websites/Brokers/AtlasRealEstate/view.cfm:1) at cfquery_redirect2ecfm939261646.runPage(D:/inetpub/wwwroot/Websites/Brokers/AtlasRealEstate/query_redirect.cfm:11)
at cfSTATLISTINGVIEWS2ecfm819963804.runPage(D:/inetpub/wwwroot/RealSmartPro/Includes/STATLISTINGVIEWS.cfm:9) at cfview2ecfm1646730115._factor1(D:/inetpub/wwwroot/Websites/Brokers/AtlasRealEstate/view.cfm:20) at cfview2ecfm1646730115._factor26(D:/inetpub/wwwroot/Websites/Brokers/AtlasRealEstate/view.cfm:1) at cfview2ecfm1646730115.runPage(D:/inetpub/wwwroot/Websites/Brokers/AtlasRealEstate/view.cfm:1) at cfquery_redirect2ecfm939261646.runPage(D:/inetpub/wwwroot/Websites/Brokers/AtlasRealEstate/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 cfview2ecfm1646730115._factor1(D:\inetpub\wwwroot\Websites\Brokers\AtlasRealEstate\view.cfm:20)
at cfview2ecfm1646730115._factor26(D:\inetpub\wwwroot\Websites\Brokers\AtlasRealEstate\view.cfm:1)
at cfview2ecfm1646730115.runPage(D:\inetpub\wwwroot\Websites\Brokers\AtlasRealEstate\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_redirect2ecfm939261646.runPage(D:\inetpub\wwwroot\Websites\Brokers\AtlasRealEstate\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)
|
|