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 MariaDB server version for the right syntax to use near ')) group by prodotti.cod ORDER BY titolo' at line 20
 
The error occurred in /var/www/html/ingpini/Query/Prodotti/SelOggetti.cfm: line 83
Called from /var/www/html/ingpini/Prodotti/Prodotti_elenco.cfm: line 2
Called from /var/www/html/ingpini/Inside.cfm: line 108
Called from /var/www/html/ingpini/Query/Prodotti/SelOggetti.cfm: line 83
Called from /var/www/html/ingpini/Prodotti/Prodotti_elenco.cfm: line 2
Called from /var/www/html/ingpini/Inside.cfm: line 108
 
81 : 				AND COD_PARTNER = #URL.codpar#
82 : 			</cfif>
83 : 			<cfif URL.AREA EQ "SUPPORTO" AND URL.SEZIONE EQ "DOWNLOAD">
84 : 				AND ALLEGATO <> ''
85 : 			</cfif>
SQLSTATE   42000
DATASOURCE   ingpini
VENDORERRORCODE   1064
SQL    SELECT prodotti.* , a.url_rew as url1,b.url_rew as url2 , a.titolo as tit1,b.titolo as tit2 FROM prodotti left outer join categorie a on prodotti.cat1 = a.cod and prodotti.lingua = a.lingua and a.oggetto = 'Prodotti' left outer join categorie b on prodotti.cat2 = b.cod and prodotti.lingua = b.lingua and b.oggetto = 'Prodotti' WHERE prodotti.VISUALIZZA = 1 and prodotti.lingua = 'IT' AND prodotti.cod in (select cod_oggetto from categorie_oggetti where cod_categoria in ()) group by prodotti.cod ORDER BY titolo
Resources:

Browser   Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
Remote Address   188.9.84.237
Referrer   http://ing-pini.it/IT/Prodotti/PlanetaryGearboxes
Date/Time   19-Jan-22 06:25 PM
Stack Trace
at cfSelOggetti2ecfm1982501872.runPage(/var/www/html/ingpini/Query/Prodotti/SelOggetti.cfm:83) at cfProdotti_elenco2ecfm1400180440.runPage(/var/www/html/ingpini/Prodotti/Prodotti_elenco.cfm:2) at cfInside2ecfm223596535.runPage(/var/www/html/ingpini/Inside.cfm:108) at cfSelOggetti2ecfm1982501872.runPage(/var/www/html/ingpini/Query/Prodotti/SelOggetti.cfm:83) at cfProdotti_elenco2ecfm1400180440.runPage(/var/www/html/ingpini/Prodotti/Prodotti_elenco.cfm:2) at cfInside2ecfm223596535.runPage(/var/www/html/ingpini/Inside.cfm:108) 

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
			
        
	group by prodotti.cod
        ORDER BY 
		titolo' at line 20
	at sun.reflect.GeneratedConstructorAccessor1399.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503)
	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:927)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1485)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
	at cfSelOggetti2ecfm1982501872.runPage(/var/www/html/ingpini/Query/Prodotti/SelOggetti.cfm:83)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
	at cfProdotti_elenco2ecfm1400180440.runPage(/var/www/html/ingpini/Prodotti/Prodotti_elenco.cfm:2)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
	at cfInside2ecfm223596535.runPage(/var/www/html/ingpini/Inside.cfm:108)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	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:58)
	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:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)