Auto e Moto
Card Regalo
Casa, Giardino e Animali
Cibo, Bevande e Divertimento
Elettronica e Informatica
Hotel
Integratore
Mare
Moda
Occhiali
Orologi e Gioielli
Pavimenti, Rivestimenti e Arredo bagno
Piercing
Ristoranti
Salute e Bellezza
Sanitaria Ortopedia

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 ')) and prodotti.outlet = 0 and( da' at line 48

The error occurred in /var/www/html/compracomodo/Query/Prodotti/SelOggetti.cfm: line 43
Called from /var/www/html/compracomodo/Query/Prodotti/SelOggetti.cfm: line 1
Called from /var/www/html/compracomodo/SubMenuCategorie.cfm: line 371
Called from /var/www/html/compracomodo/SubMenuCategorie.cfm: line 1
Called from /var/www/html/compracomodo/Inside.cfm: line 59
Called from /var/www/html/compracomodo/Query/Prodotti/SelOggetti.cfm: line 43
Called from /var/www/html/compracomodo/Query/Prodotti/SelOggetti.cfm: line 1
Called from /var/www/html/compracomodo/SubMenuCategorie.cfm: line 371
Called from /var/www/html/compracomodo/SubMenuCategorie.cfm: line 1
Called from /var/www/html/compracomodo/Inside.cfm: line 59

41 : </cfif>   
42 : 
43 : <cfquery name="SelOggetti" datasource="#origine#">
44 : 
45 : 	SELECT

SQLSTATE	42000
DATASOURCE	compracomodo
VENDORERRORCODE	1064
SQL	SELECT min(prodotti.prezzo) as prezzomin, max(prodotti.prezzo) as prezzomax, min(prodotti.prezzo_offerta) as prezzooffmin, max(prodotti.prezzo_offerta) as prezzooffmax, ((prodotti.prezzo-(prodotti.prezzosconto_perc/100))+((prodotti.prezzo-(prodotti.prezzosconto_perc/100)))) as prezzoscontivagen ,((prodotti.prezzo-(prodotti.prezzosconto_perc/100))+((prodotti.prezzo-(prodotti.prezzosconto_perc/100)))) as prezzoscontivadet ,prodotti.*, aziende.titolo as titpartner,aziende.ecommerce,aziende.via,aziende.cap,aziende.citta,aziende.provincia, aziende.dominio,aziende.telefono,aziende.latitudine,aziende.longitudine,aziende.latitudine2,aziende.longitudine2,aziende.latitudine3,aziende.longitudine3,aziende.latitudine4,aziende.longitudine4,aziende.latitudine5,aziende.longitudine5,titololatlong1,titololatlong2,titololatlong3,titololatlong4,titololatlong5,zoom , a.url_rew as url1,b.url_rew as url2,c.url_rew as url3 , a.titolo as tit1,b.titolo as tit2,c.titolo as tit3 ,parametri_aziende.prodotti_senza_prezzo FROM prodotti inner join aziende on prodotti.cod_azienda = aziende.cod and aziende.visualizza = 1 left outer join parametri_aziende on prodotti.cod_azienda = parametri_aziende.cod_azienda and parametri_aziende.cod_azienda = 0 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' left outer join categorie c on prodotti.cat3 = c.cod and prodotti.lingua = c.lingua and c.oggetto = 'Prodotti' left outer join disponibilita on prodotti.cod = disponibilita.cod_prodotto left outer join colori on disponibilita.cod_colore = colori.cod left outer join taglie on disponibilita.cod_taglia = taglie.cod WHERE prodotti.VISUALIZZA = 1 and prodotti.lingua = 'IT' AND cancellato = '0' AND prodotti.cod in (select cod_oggetto from categorie_oggetti where cod_categoria in ()) and prodotti.outlet = 0 and( data_scadenza_attiva = '0' or (data_scadenza_attiva = '1' and data_scadenza >= now())) and acquistabile = '1' and prodotti.prezzo > 0.00 group by prodotti.cod ORDER BY ordine,rand()

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address	35.172.111.47
Referrer
Date/Time	06-Jun-23 05:40 PM

Stack Trace

at cfSelOggetti2ecfm359572280._factor19(/var/www/html/compracomodo/Query/Prodotti/SelOggetti.cfm:43) at cfSelOggetti2ecfm359572280.runPage(/var/www/html/compracomodo/Query/Prodotti/SelOggetti.cfm:1) at cfSubMenuCategorie2ecfm1756618713._factor8(/var/www/html/compracomodo/SubMenuCategorie.cfm:371) at cfSubMenuCategorie2ecfm1756618713.runPage(/var/www/html/compracomodo/SubMenuCategorie.cfm:1) at cfInside2ecfm1182625450.runPage(/var/www/html/compracomodo/Inside.cfm:59) at cfSelOggetti2ecfm359572280._factor19(/var/www/html/compracomodo/Query/Prodotti/SelOggetti.cfm:43) at cfSelOggetti2ecfm359572280.runPage(/var/www/html/compracomodo/Query/Prodotti/SelOggetti.cfm:1) at cfSubMenuCategorie2ecfm1756618713._factor8(/var/www/html/compracomodo/SubMenuCategorie.cfm:371) at cfSubMenuCategorie2ecfm1756618713.runPage(/var/www/html/compracomodo/SubMenuCategorie.cfm:1) at cfInside2ecfm1182625450.runPage(/var/www/html/compracomodo/Inside.cfm:59)

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 '))
			
    	and prodotti.outlet = 0
    
    	 
         
         and( da' at line 48
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	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 cfSelOggetti2ecfm359572280._factor19(/var/www/html/compracomodo/Query/Prodotti/SelOggetti.cfm:43)
	at cfSelOggetti2ecfm359572280.runPage(/var/www/html/compracomodo/Query/Prodotti/SelOggetti.cfm:1)
	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 cfSubMenuCategorie2ecfm1756618713._factor8(/var/www/html/compracomodo/SubMenuCategorie.cfm:371)
	at cfSubMenuCategorie2ecfm1756618713.runPage(/var/www/html/compracomodo/SubMenuCategorie.cfm:1)
	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 cfInside2ecfm1182625450.runPage(/var/www/html/compracomodo/Inside.cfm:59)
	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)