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 lingua = 'IT' and oggetto = 'Prodotti' and visualizza = '1'' at line 4
 
The error occurred in /var/www/html/ingpini/Query/Prodotti/SelOggetti.cfm: line 37
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 37
Called from /var/www/html/ingpini/Prodotti/Prodotti_elenco.cfm: line 2
Called from /var/www/html/ingpini/Inside.cfm: line 108
35 :             select cod
36 :             from categorie
37 :             where padre = #selcodcat1.cod#
38 :             and lingua = 'IT' and oggetto = 'Prodotti' and visualizza = '1'
39 :         </cfquery>

SQLSTATE   42000
DATASOURCE   ingpini
VENDORERRORCODE   1064
SQL    select cod from categorie where padre = and lingua = 'IT' and oggetto = 'Prodotti' and visualizza = '1'
Resources:

Browser   Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
Remote Address   188.9.84.237
Referrer   http://ing-pini.it/Default.cfm?cookies=1&
Date/Time   19-Jan-22 06:14 PM
Stack Trace
at cfSelOggetti2ecfm1982501872.runPage(/var/www/html/ingpini/Query/Prodotti/SelOggetti.cfm:37) 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:37) 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 'and lingua = 'IT' and oggetto = 'Prodotti' and visualizza = '1'' at line 4
	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:37)
	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)