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: 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.70.174.129
Referrer  
Date/Time   28-Mar-24 10:14 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)