Error Executing Database Query.
|
Data truncation: BIGINT UNSIGNED value is out of range in '(69 * (`pinkvacationrentals`.`v`.`Latitude` - 52)) ^ 2 + (42 * (`pinkvacationrentals`.`v`.`Longitude` - 5)) ^ 2'
|
|
The error occurred in D:/home/pinkvacationrentals.com/wwwroot/venue/listings/qry_get_venues.cfm: line 512
Called from D:/home/pinkvacationrentals.com/wwwroot/venue/listings/qry_get_venues.cfm: line 1
Called from D:/home/pinkvacationrentals.com/wwwroot/venue/fbx_Switch.cfm: line 142
Called from D:/home/pinkvacationrentals.com/wwwroot/venue/fbx_Switch.cfm: line 136
Called from D:/home/pinkvacationrentals.com/wwwroot/venue/fbx_Switch.cfm: line 1
Called from D:/home/pinkvacationrentals.com/wwwroot/fbx_fusebox30_CF50_turbo.cfm: line 201
Called from D:/home/pinkvacationrentals.com/wwwroot/fbx_fusebox30_CF50_turbo.cfm: line 197
Called from D:/home/pinkvacationrentals.com/wwwroot/fbx_fusebox30_CF50_turbo.cfm: line 196
Called from D:/home/pinkvacationrentals.com/wwwroot/fbx_fusebox30_CF50_turbo.cfm: line 1
Called from D:/home/pinkvacationrentals.com/wwwroot/index.cfm: line 26
Called from D:/home/pinkvacationrentals.com/wwwroot/venue/listings/qry_get_venues.cfm: line 512
Called from D:/home/pinkvacationrentals.com/wwwroot/venue/listings/qry_get_venues.cfm: line 1
Called from D:/home/pinkvacationrentals.com/wwwroot/venue/fbx_Switch.cfm: line 142
Called from D:/home/pinkvacationrentals.com/wwwroot/venue/fbx_Switch.cfm: line 136
Called from D:/home/pinkvacationrentals.com/wwwroot/venue/fbx_Switch.cfm: line 1
Called from D:/home/pinkvacationrentals.com/wwwroot/fbx_fusebox30_CF50_turbo.cfm: line 201
Called from D:/home/pinkvacationrentals.com/wwwroot/fbx_fusebox30_CF50_turbo.cfm: line 197
Called from D:/home/pinkvacationrentals.com/wwwroot/fbx_fusebox30_CF50_turbo.cfm: line 196
Called from D:/home/pinkvacationrentals.com/wwwroot/fbx_fusebox30_CF50_turbo.cfm: line 1
Called from D:/home/pinkvacationrentals.com/wwwroot/index.cfm: line 26
|
510 : <cfelseif attributes.sort is "type">
511 : VT.TypeName, V.Name
512 : <cfelse>
513 : M.Listing_Level DESC, RAND()
514 : </cfif>
|
|
SQLSTATE |
22001 |
DATASOURCE |
pinkvacationrentals |
VENDORERRORCODE |
1690 |
SQL |
SELECT DISTINCT V.User_id, V.Venue_ID, V.VenueType_ID, V.Name, V.Contact_Firstname, V.Contact_Lastname, V.Contact_Title, V.Address, V.City, V.State, V.Zip, V.CountryCode, V.Neighborhood, V.ShowAddress, V.Metro_ID, V.Phone, V.Phone2, V.WebURL, V.Short_Desc, V.sm_Image, V.lg_Image, V.highWeek, V.lowWeek, V.Lg_title, V.Type1, V.Editorial, V.Priority, V.Latitude, V.Longitude, V.TypeKeywords, M.Listing_Level, V.listing_level as Listing_levelV, VT.TypeName, VT.MapMarker, F.UserFavorite_ID as IsFavorite, P.Headline, P.Offer, P.Description, P.Conditions, P.Lg_Image as PromoImage
, SQRT((( (param 1) * (latitude - (param 2) ) )^2)
+(( (param 3) * (longitude - (param 4) ) )^2)) as dist
FROM (
((Venues V INNER JOIN VenueTypes VT ON V.VenueType_ID = VT.VenueType_ID)
LEFT OUTER JOIN UserFavorites F on (F.Detail_ID = V.Venue_ID AND F.Detail_Type = 'venue') )
LEFT JOIN Memberships M on (M.Detail_ID = V.Venue_ID AND M.Membership_Type = 'venue' AND (M.Start IS NULL OR M.Start <= (param 5) ) AND (M.Expire IS NULL OR M.Expire >= (param 6) ) AND M.Valid = 1)
)
LEFT JOIN VenuePromotions P ON (P.Venue_ID = V.Venue_ID AND (P.Display_Start IS NULL OR P.Display_Start <= (param 7) ) AND (P.Display_End IS NULL OR P.Display_End >= (param 8) ) AND P.Live = 1 AND P.Approved = 1)
WHERE
V.Venue_ID IN (
SELECT DISTINCT X.Venue_ID FROM
Venues X
WHERE X.VenueType_ID = (param 9) )
AND
latitude between (param 10) AND (param 11) AND
longitude between (param 12) AND (param 13) AND
V.Live = 1 AND
V.Approved = 1
Order by
M.Listing_Level DESC, RAND()
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
172.71.222.144 |
Referrer |
|
Date/Time |
28-Mar-24 10:51 AM |
|
Stack Trace
|
at cfqry_get_venues2ecfm2076419384._factor12(D:/home/pinkvacationrentals.com/wwwroot/venue/listings/qry_get_venues.cfm:512) at cfqry_get_venues2ecfm2076419384.runPage(D:/home/pinkvacationrentals.com/wwwroot/venue/listings/qry_get_venues.cfm:1) at cffbx_Switch2ecfm472556310._factor0(D:/home/pinkvacationrentals.com/wwwroot/venue/fbx_Switch.cfm:142) at cffbx_Switch2ecfm472556310._factor28(D:/home/pinkvacationrentals.com/wwwroot/venue/fbx_Switch.cfm:136) at cffbx_Switch2ecfm472556310.runPage(D:/home/pinkvacationrentals.com/wwwroot/venue/fbx_Switch.cfm:1) at cffbx_fusebox30_CF50_turbo2ecfm617888917._factor1(D:/home/pinkvacationrentals.com/wwwroot/fbx_fusebox30_CF50_turbo.cfm:201) at cffbx_fusebox30_CF50_turbo2ecfm617888917._factor2(D:/home/pinkvacationrentals.com/wwwroot/fbx_fusebox30_CF50_turbo.cfm:197) at cffbx_fusebox30_CF50_turbo2ecfm617888917._factor6(D:/home/pinkvacationrentals.com/wwwroot/fbx_fusebox30_CF50_turbo.cfm:196) at cffbx_fusebox30_CF50_turbo2ecfm617888917.runPage(D:/home/pinkvacationrentals.com/wwwroot/fbx_fusebox30_CF50_turbo.cfm:1) at cfindex2ecfm83463254.runPage(D:/home/pinkvacationrentals.com/wwwroot/index.cfm:26)
at cfqry_get_venues2ecfm2076419384._factor12(D:/home/pinkvacationrentals.com/wwwroot/venue/listings/qry_get_venues.cfm:512) at cfqry_get_venues2ecfm2076419384.runPage(D:/home/pinkvacationrentals.com/wwwroot/venue/listings/qry_get_venues.cfm:1) at cffbx_Switch2ecfm472556310._factor0(D:/home/pinkvacationrentals.com/wwwroot/venue/fbx_Switch.cfm:142) at cffbx_Switch2ecfm472556310._factor28(D:/home/pinkvacationrentals.com/wwwroot/venue/fbx_Switch.cfm:136) at cffbx_Switch2ecfm472556310.runPage(D:/home/pinkvacationrentals.com/wwwroot/venue/fbx_Switch.cfm:1) at cffbx_fusebox30_CF50_turbo2ecfm617888917._factor1(D:/home/pinkvacationrentals.com/wwwroot/fbx_fusebox30_CF50_turbo.cfm:201) at cffbx_fusebox30_CF50_turbo2ecfm617888917._factor2(D:/home/pinkvacationrentals.com/wwwroot/fbx_fusebox30_CF50_turbo.cfm:197) at cffbx_fusebox30_CF50_turbo2ecfm617888917._factor6(D:/home/pinkvacationrentals.com/wwwroot/fbx_fusebox30_CF50_turbo.cfm:196) at cffbx_fusebox30_CF50_turbo2ecfm617888917.runPage(D:/home/pinkvacationrentals.com/wwwroot/fbx_fusebox30_CF50_turbo.cfm:1) at cfindex2ecfm83463254.runPage(D:/home/pinkvacationrentals.com/wwwroot/index.cfm:26)
com.mysql.jdbc.MysqlDataTruncation: Data truncation: BIGINT UNSIGNED value is out of range in '(69 * (`pinkvacationrentals`.`v`.`Latitude` - 52)) ^ 2 + (42 * (`pinkvacationrentals`.`v`.`Longitude` - 5)) ^ 2'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3876)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1971)
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3306)
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:463)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3040)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2288)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2681)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1192)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1583)
at coldfusion.sql.Executive.executeQuery(Executive.java:1317)
at coldfusion.sql.Executive.executeQuery(Executive.java:1247)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794)
at cfqry_get_venues2ecfm2076419384._factor12(D:\home\pinkvacationrentals.com\wwwroot\venue\listings\qry_get_venues.cfm:512)
at cfqry_get_venues2ecfm2076419384.runPage(D:\home\pinkvacationrentals.com\wwwroot\venue\listings\qry_get_venues.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329)
at cffbx_Switch2ecfm472556310._factor0(D:\home\pinkvacationrentals.com\wwwroot\venue\fbx_Switch.cfm:142)
at cffbx_Switch2ecfm472556310._factor28(D:\home\pinkvacationrentals.com\wwwroot\venue\fbx_Switch.cfm:136)
at cffbx_Switch2ecfm472556310.runPage(D:\home\pinkvacationrentals.com\wwwroot\venue\fbx_Switch.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329)
at cffbx_fusebox30_CF50_turbo2ecfm617888917._factor1(D:\home\pinkvacationrentals.com\wwwroot\fbx_fusebox30_CF50_turbo.cfm:201)
at cffbx_fusebox30_CF50_turbo2ecfm617888917._factor2(D:\home\pinkvacationrentals.com\wwwroot\fbx_fusebox30_CF50_turbo.cfm:197)
at cffbx_fusebox30_CF50_turbo2ecfm617888917._factor6(D:\home\pinkvacationrentals.com\wwwroot\fbx_fusebox30_CF50_turbo.cfm:196)
at cffbx_fusebox30_CF50_turbo2ecfm617888917.runPage(D:\home\pinkvacationrentals.com\wwwroot\fbx_fusebox30_CF50_turbo.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329)
at cfindex2ecfm83463254.runPage(D:\home\pinkvacationrentals.com\wwwroot\index.cfm:26)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:595)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
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:226)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at jdk.internal.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:280)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at java.base/javax.security.auth.Subject.doAsPrivileged(Subject.java:550)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:311)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:170)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:221)
at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:145)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:143)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at jdk.internal.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:280)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at java.base/javax.security.auth.Subject.doAsPrivileged(Subject.java:550)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:311)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:253)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:187)
at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:145)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:143)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at jdk.internal.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:280)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at java.base/javax.security.auth.Subject.doAsPrivileged(Subject.java:550)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:311)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:253)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:187)
at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:145)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:143)
at com.seefusion.Filter.doFilter(Filter.java:49)
at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500)
at jdk.internal.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:280)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at java.base/javax.security.auth.Subject.doAsPrivileged(Subject.java:550)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:311)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:253)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:187)
at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:145)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:143)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
|
|