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.

[Macromedia][SQLServer JDBC Driver][SQLServer]The radians function requires 1 argument(s).
 
The error occurred in C:/home/ilovecomm.com/wwwroot/Application.cfm: line 577
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 372
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 298
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 240
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 231
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 169
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 1
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 577
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 372
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 298
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 240
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 231
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 169
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 1
575 : 	
576 : 					
577 : 					<cfquery name="test_pagination" datasource="#app_datasource#">
578 : 						SELECT idoffer,shops.lat, shops.lng, offer
579 : 						FROM offers

SQLSTATE   HY000
DATASOURCE   ilovecomm
VENDORERRORCODE   174
SQL    SELECT idoffer,shops.lat, shops.lng, offer FROM offers INNER JOIN shops ON offers.shoppnt = shops.idshop WHERE offers.enable <> 0 AND shops.enable <> 0 AND offers.categorypnt is not null AND offers.keyword_pnt is not null AND ROUND(6363 * sqrt(POWER(RADIANS() - RADIANS(shops.lat) , 2) + POWER(RADIANS() - RADIANS(shops.lng) , 2)),2)<40
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   3.141.46.110
Referrer  
Date/Time   18-Apr-25 01:42 PM
Stack Trace
at cfApplication2ecfm1411979233._factor6(C:/home/ilovecomm.com/wwwroot/Application.cfm:577) at cfApplication2ecfm1411979233._factor14(C:/home/ilovecomm.com/wwwroot/Application.cfm:372) at cfApplication2ecfm1411979233._factor75(C:/home/ilovecomm.com/wwwroot/Application.cfm:298) at cfApplication2ecfm1411979233._factor79(C:/home/ilovecomm.com/wwwroot/Application.cfm:240) at cfApplication2ecfm1411979233._factor81(C:/home/ilovecomm.com/wwwroot/Application.cfm:231) at cfApplication2ecfm1411979233._factor167(C:/home/ilovecomm.com/wwwroot/Application.cfm:169) at cfApplication2ecfm1411979233.runPage(C:/home/ilovecomm.com/wwwroot/Application.cfm:1) at cfApplication2ecfm1411979233._factor6(C:/home/ilovecomm.com/wwwroot/Application.cfm:577) at cfApplication2ecfm1411979233._factor14(C:/home/ilovecomm.com/wwwroot/Application.cfm:372) at cfApplication2ecfm1411979233._factor75(C:/home/ilovecomm.com/wwwroot/Application.cfm:298) at cfApplication2ecfm1411979233._factor79(C:/home/ilovecomm.com/wwwroot/Application.cfm:240) at cfApplication2ecfm1411979233._factor81(C:/home/ilovecomm.com/wwwroot/Application.cfm:231) at cfApplication2ecfm1411979233._factor167(C:/home/ilovecomm.com/wwwroot/Application.cfm:169) at cfApplication2ecfm1411979233.runPage(C:/home/ilovecomm.com/wwwroot/Application.cfm:1)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]The radians function requires 1 argument(s).
	at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddm.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1567)
	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 cfApplication2ecfm1411979233._factor6(C:\home\ilovecomm.com\wwwroot\Application.cfm:577)
	at cfApplication2ecfm1411979233._factor14(C:\home\ilovecomm.com\wwwroot\Application.cfm:372)
	at cfApplication2ecfm1411979233._factor75(C:\home\ilovecomm.com\wwwroot\Application.cfm:298)
	at cfApplication2ecfm1411979233._factor79(C:\home\ilovecomm.com\wwwroot\Application.cfm:240)
	at cfApplication2ecfm1411979233._factor81(C:\home\ilovecomm.com\wwwroot\Application.cfm:231)
	at cfApplication2ecfm1411979233._factor167(C:\home\ilovecomm.com\wwwroot\Application.cfm:169)
	at cfApplication2ecfm1411979233.runPage(C:\home\ilovecomm.com\wwwroot\Application.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.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:474)
	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.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 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)