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.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and rpos<= order by lpos' at line 1
 
The error occurred in D:/inetpub/wwwroot/mondosport/products_category.cfm: line 95
Called from D:/inetpub/wwwroot/mondosport/products_category.cfm: line 76
Called from D:/inetpub/wwwroot/mondosport/products_category.cfm: line 70
Called from D:/inetpub/wwwroot/mondosport/products_category.cfm: line 2
Called from D:/inetpub/wwwroot/mondosport/products_category.cfm: line 1
Called from D:/inetpub/wwwroot/mondosport/application.cfc: line 177
Called from D:/inetpub/wwwroot/mondosport/products_category.cfm: line 95
Called from D:/inetpub/wwwroot/mondosport/products_category.cfm: line 76
Called from D:/inetpub/wwwroot/mondosport/products_category.cfm: line 70
Called from D:/inetpub/wwwroot/mondosport/products_category.cfm: line 2
Called from D:/inetpub/wwwroot/mondosport/products_category.cfm: line 1
Called from D:/inetpub/wwwroot/mondosport/application.cfc: line 177
93 :         </cfquery>
94 :         <cfquery name="q_subtree" datasource="webmondo">
95 :          select * from v_struttura_albero_#lingua# where lpos >= #q_root.lpos# and rpos<= #q_root.rpos# order by lpos
96 :         </cfquery>
97 :         <cfloop query="q_subtree">

SQLSTATE   42000
DATASOURCE   webmondo
VENDORERRORCODE   1064
SQL    select * from v_struttura_albero_it where lpos >= and rpos<= order by lpos
Resources:

Browser   claudebot
Remote Address   54.234.233.157
Referrer   http://mondo-sports.com/products_category.cfm?id=891
Date/Time   29-Mar-24 03:03 PM
Stack Trace
at cfproducts_category2ecfm510862691._factor1(D:/inetpub/wwwroot/mondosport/products_category.cfm:95) at cfproducts_category2ecfm510862691._factor2(D:/inetpub/wwwroot/mondosport/products_category.cfm:76) at cfproducts_category2ecfm510862691._factor4(D:/inetpub/wwwroot/mondosport/products_category.cfm:70) at cfproducts_category2ecfm510862691._factor8(D:/inetpub/wwwroot/mondosport/products_category.cfm:2) at cfproducts_category2ecfm510862691.runPage(D:/inetpub/wwwroot/mondosport/products_category.cfm:1) at cfapplication2ecfc279868270$funcONREQUEST.runFunction(D:/inetpub/wwwroot/mondosport/application.cfc:177) at cfproducts_category2ecfm510862691._factor1(D:/inetpub/wwwroot/mondosport/products_category.cfm:95) at cfproducts_category2ecfm510862691._factor2(D:/inetpub/wwwroot/mondosport/products_category.cfm:76) at cfproducts_category2ecfm510862691._factor4(D:/inetpub/wwwroot/mondosport/products_category.cfm:70) at cfproducts_category2ecfm510862691._factor8(D:/inetpub/wwwroot/mondosport/products_category.cfm:2) at cfproducts_category2ecfm510862691.runPage(D:/inetpub/wwwroot/mondosport/products_category.cfm:1) at cfapplication2ecfc279868270$funcONREQUEST.runFunction(D:/inetpub/wwwroot/mondosport/application.cfc:177)

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and rpos<=  order by lpos' at line 1
	at jdk.internal.reflect.GeneratedConstructorAccessor235.newInstance(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2439)
	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:829)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:923)
	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 cfproducts_category2ecfm510862691._factor1(D:\inetpub\wwwroot\mondosport\products_category.cfm:95)
	at cfproducts_category2ecfm510862691._factor2(D:\inetpub\wwwroot\mondosport\products_category.cfm:76)
	at cfproducts_category2ecfm510862691._factor4(D:\inetpub\wwwroot\mondosport\products_category.cfm:70)
	at cfproducts_category2ecfm510862691._factor8(D:\inetpub\wwwroot\mondosport\products_category.cfm:2)
	at cfproducts_category2ecfm510862691.runPage(D:\inetpub\wwwroot\mondosport\products_category.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 cfapplication2ecfc279868270$funcONREQUEST.runFunction(D:\inetpub\wwwroot\mondosport\application.cfc:177)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438)
	at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115)
	at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:551)
	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:227)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	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:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:121)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	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)