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/_search_products.cfm: line 45
Called from C:/home/ilovecomm.com/wwwroot/_search_products.cfm: line 4
Called from C:/home/ilovecomm.com/wwwroot/_search_products.cfm: line 1
Called from C:/home/ilovecomm.com/wwwroot/index.cfm: line 600
Called from C:/home/ilovecomm.com/wwwroot/index.cfm: line 1
Called from C:/home/ilovecomm.com/wwwroot/_search_products.cfm: line 45
Called from C:/home/ilovecomm.com/wwwroot/_search_products.cfm: line 4
Called from C:/home/ilovecomm.com/wwwroot/_search_products.cfm: line 1
Called from C:/home/ilovecomm.com/wwwroot/index.cfm: line 600
Called from C:/home/ilovecomm.com/wwwroot/index.cfm: line 1
43 : 			select idshop
44 : 			from shops
45 : 			where  ROUND(6363 * sqrt(POWER(RADIANS(#session.box.Lat#) - RADIANS(shops.lat) , 2) + POWER(RADIANS(#session.box.Lng#) - RADIANS(shops.lng) , 2)),2) < #zoneonedist#
46 : 		</cfquery>
47 : 		<!---recupero setting fascia 1 search_shops_max_radius--->

SQLSTATE   HY000
DATASOURCE   ilovecomm
VENDORERRORCODE   174
SQL    select idshop from shops where ROUND(6363 * sqrt(POWER(RADIANS() - RADIANS(shops.lat) , 2) + POWER(RADIANS() - RADIANS(shops.lng) , 2)),2) <2
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   216.73.216.223
Referrer  
Date/Time   15-Dec-25 11:18 PM
Stack Trace
at cf_search_products2ecfm1169056740._factor4(C:/home/ilovecomm.com/wwwroot/_search_products.cfm:45) at cf_search_products2ecfm1169056740._factor25(C:/home/ilovecomm.com/wwwroot/_search_products.cfm:4) at cf_search_products2ecfm1169056740.runPage(C:/home/ilovecomm.com/wwwroot/_search_products.cfm:1) at cfindex2ecfm846459967._factor13(C:/home/ilovecomm.com/wwwroot/index.cfm:600) at cfindex2ecfm846459967.runPage(C:/home/ilovecomm.com/wwwroot/index.cfm:1) at cf_search_products2ecfm1169056740._factor4(C:/home/ilovecomm.com/wwwroot/_search_products.cfm:45) at cf_search_products2ecfm1169056740._factor25(C:/home/ilovecomm.com/wwwroot/_search_products.cfm:4) at cf_search_products2ecfm1169056740.runPage(C:/home/ilovecomm.com/wwwroot/_search_products.cfm:1) at cfindex2ecfm846459967._factor13(C:/home/ilovecomm.com/wwwroot/index.cfm:600) at cfindex2ecfm846459967.runPage(C:/home/ilovecomm.com/wwwroot/index.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 cf_search_products2ecfm1169056740._factor4(C:\home\ilovecomm.com\wwwroot\_search_products.cfm:45)
	at cf_search_products2ecfm1169056740._factor25(C:\home\ilovecomm.com\wwwroot\_search_products.cfm:4)
	at cf_search_products2ecfm1169056740.runPage(C:\home\ilovecomm.com\wwwroot\_search_products.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:4286)
	at cfindex2ecfm846459967._factor13(C:\home\ilovecomm.com\wwwroot\index.cfm:600)
	at cfindex2ecfm846459967.runPage(C:\home\ilovecomm.com\wwwroot\index.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.ApplicationFilter.invoke(ApplicationFilter.java:597)
	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)