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 ('mrsmi58050158979','realcomp2',989000,'21 Stillmeadow Street','Village of Grosse Pointe Shores','48236',{ts '2024-10-22 00:00:00'},'21Stillmeadow48236')
ON DUPLICATE KEY UPDATE DetailViewsO = DetailViewsO+1,
Today = Today+1, Visitors = LEFT(CONCAT('3145162235,',Visitors), 5000) |
| DATASOURCE |
RealEstateStats |
| SQLSTATE |
01004 |
|
|
Resources:
|
| Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| Remote Address |
3.145.162.235 |
| Referrer |
|
| Date/Time |
05-Nov-24 06:34 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)
|
|