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/mondotoys.com/products_category.cfm: line 92
Called from D:/inetpub/wwwroot/mondotoys.com/products_category.cfm: line 70
Called from D:/inetpub/wwwroot/mondotoys.com/products_category.cfm: line 2
Called from D:/inetpub/wwwroot/mondotoys.com/products_category.cfm: line 1
Called from D:/inetpub/wwwroot/mondotoys.com/application.cfc: line 203
Called from D:/inetpub/wwwroot/mondotoys.com/products_category.cfm: line 92
Called from D:/inetpub/wwwroot/mondotoys.com/products_category.cfm: line 70
Called from D:/inetpub/wwwroot/mondotoys.com/products_category.cfm: line 2
Called from D:/inetpub/wwwroot/mondotoys.com/products_category.cfm: line 1
Called from D:/inetpub/wwwroot/mondotoys.com/application.cfc: line 203
90 :         </cfquery>
91 :         <cfquery name="q_subtree" datasource="webmondo">
92 :          select * from v_struttura_albero_#lingua# where lpos >= #q_root.lpos# and rpos<= #q_root.rpos# order by lpos
93 :         </cfquery>
94 :         <cfloop query="q_subtree">

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

Browser   claudebot
Remote Address   3.236.145.110
Referrer   http://mondotoys.com/products_category.cfm?id=765
Date/Time   28-Mar-24 05:37 PM
Stack Trace
at cfproducts_category2ecfm1760827629._factor2(D:/inetpub/wwwroot/mondotoys.com/products_category.cfm:92) at cfproducts_category2ecfm1760827629._factor4(D:/inetpub/wwwroot/mondotoys.com/products_category.cfm:70) at cfproducts_category2ecfm1760827629._factor8(D:/inetpub/wwwroot/mondotoys.com/products_category.cfm:2) at cfproducts_category2ecfm1760827629.runPage(D:/inetpub/wwwroot/mondotoys.com/products_category.cfm:1) at cfapplication2ecfc1695475352$funcONREQUEST.runFunction(D:/inetpub/wwwroot/mondotoys.com/application.cfc:203) at cfproducts_category2ecfm1760827629._factor2(D:/inetpub/wwwroot/mondotoys.com/products_category.cfm:92) at cfproducts_category2ecfm1760827629._factor4(D:/inetpub/wwwroot/mondotoys.com/products_category.cfm:70) at cfproducts_category2ecfm1760827629._factor8(D:/inetpub/wwwroot/mondotoys.com/products_category.cfm:2) at cfproducts_category2ecfm1760827629.runPage(D:/inetpub/wwwroot/mondotoys.com/products_category.cfm:1) at cfapplication2ecfc1695475352$funcONREQUEST.runFunction(D:/inetpub/wwwroot/mondotoys.com/application.cfc:203)

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_category2ecfm1760827629._factor2(D:\inetpub\wwwroot\mondotoys.com\products_category.cfm:92)
	at cfproducts_category2ecfm1760827629._factor4(D:\inetpub\wwwroot\mondotoys.com\products_category.cfm:70)
	at cfproducts_category2ecfm1760827629._factor8(D:\inetpub\wwwroot\mondotoys.com\products_category.cfm:2)
	at cfproducts_category2ecfm1760827629.runPage(D:\inetpub\wwwroot\mondotoys.com\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 cfapplication2ecfc1695475352$funcONREQUEST.runFunction(D:\inetpub\wwwroot\mondotoys.com\application.cfc:203)
	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)