QUESTO SITO UTILIZZA ALCUNI 'COOKIE': VUOI SAPERNE DI PIU'?   

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.

Column 'Cod' in where clause is ambiguous
 
The error occurred in /var/www/html/solcoravenna/Query/News/SelOggetti.cfm: line 34
Called from /var/www/html/solcoravenna/News/News_view.cfm: line 2
Called from /var/www/html/solcoravenna/Inside.cfm: line 100
Called from /var/www/html/solcoravenna/Query/News/SelOggetti.cfm: line 34
Called from /var/www/html/solcoravenna/News/News_view.cfm: line 2
Called from /var/www/html/solcoravenna/Inside.cfm: line 100
32 : 	</cfif>	
33 : 	<cfif isdefined('URL.SelCategoria') AND URL.SelCategoria NEQ "">
34 : 		AND #Lcase(SESSION.TIPO_OGGETTO)#.COD IN (SELECT COD_OGGETTO FROM categorie_oggetti WHERE COD_CATEGORIA = #URL.SelCategoria#)
35 : 	</cfif>
36 : 	ORDER BY DATA DESC

SQLSTATE   23000
DATASOURCE   solcoravenna
VENDORERRORCODE   1052
SQL    SELECT news.*,categorie.titolo,categorie.url_rew as urlcat FROM categorie, categorie_oggetti, news WHERE categorie_oggetti.cod_oggetto = news.cod and categorie_oggetti.cod_categoria = categorie.cod and news.VISUALIZZA = 1 AND news.LINGUA = 'IT' AND categorie.LINGUA = 'IT' AND categorie.url_rew = 'Rassegna_stampa' and categorie.oggetto = categorie_oggetti.tipo_oggetto AND Cod = '11' and data <= '2018-10-20' ORDER BY DATA DESC
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   54.224.150.24
Referrer  
Date/Time   20-Oct-18 10:45 AM
Stack Trace
at cfSelOggetti2ecfm740352985.runPage(/var/www/html/solcoravenna/Query/News/SelOggetti.cfm:34) at cfNews_view2ecfm2054402133.runPage(/var/www/html/solcoravenna/News/News_view.cfm:2) at cfInside2ecfm2094141594.runPage(/var/www/html/solcoravenna/Inside.cfm:100) at cfSelOggetti2ecfm740352985.runPage(/var/www/html/solcoravenna/Query/News/SelOggetti.cfm:34) at cfNews_view2ecfm2054402133.runPage(/var/www/html/solcoravenna/News/News_view.cfm:2) at cfInside2ecfm2094141594.runPage(/var/www/html/solcoravenna/Inside.cfm:100)

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'Cod' in where clause is ambiguous
	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:935)
	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 cfSelOggetti2ecfm740352985.runPage(/var/www/html/solcoravenna/Query/News/SelOggetti.cfm:34)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	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:3000)
	at cfNews_view2ecfm2054402133.runPage(/var/www/html/solcoravenna/News/News_view.cfm:2)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	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:3000)
	at cfInside2ecfm2094141594.runPage(/var/www/html/solcoravenna/Inside.cfm:100)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	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.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:459)
	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)