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.
Unknown column 'ALLARGAMENTO_A14' in 'where clause'
The error occurred in /var/www/html/enser/Query/Prodotti/SelOggetti.cfm: line 24 Called from /var/www/html/enser/Prodotti/Prodotti_view.cfm: line 73 Called from /var/www/html/enser/Inside.cfm: line 27 Called from /var/www/html/enser/Query/Prodotti/SelOggetti.cfm: line 24 Called from /var/www/html/enser/Prodotti/Prodotti_view.cfm: line 73 Called from /var/www/html/enser/Inside.cfm: line 27
22 : </cfif>
23 : <cfif isdefined('url.codcatoggetto2') and url.codcatoggetto neq "">
24 : and cod in (select cod_oggetto from categorie_oggetti where tipo_oggetto='Prodotti' and cod_categoria = (select cod from categorie where url_rew = '#url.codcatoggetto2#'))
25 : </cfif>
26 : </cfif>
SQLSTATE
42S22
DATASOURCE
enser
VENDORERRORCODE
1054
SQL
SELECT * FROM prodotti
WHERE VISUALIZZA = 1 and lingua = 'IT'
AND (url_rew = 'ALLARGAMENTO_A14' or cod = ALLARGAMENTO_A14)
ORDER BY ORDINE desc, cod desc
Search the Knowledge Base to find a solution to your problem.
Browser
claudebot
Remote Address
54.175.59.242
Referrer
Date/Time
29-Mar-24 12:29 PM
Stack Trace
at cfSelOggetti2ecfm273568049.runPage(/var/www/html/enser/Query/Prodotti/SelOggetti.cfm:24) at cfProdotti_view2ecfm266170799.runPage(/var/www/html/enser/Prodotti/Prodotti_view.cfm:73) at cfInside2ecfm928390187.runPage(/var/www/html/enser/Inside.cfm:27)
at cfSelOggetti2ecfm273568049.runPage(/var/www/html/enser/Query/Prodotti/SelOggetti.cfm:24) at cfProdotti_view2ecfm266170799.runPage(/var/www/html/enser/Prodotti/Prodotti_view.cfm:73) at cfInside2ecfm928390187.runPage(/var/www/html/enser/Inside.cfm:27)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'ALLARGAMENTO_A14' in 'where clause'
at sun.reflect.GeneratedConstructorAccessor783.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 cfSelOggetti2ecfm273568049.runPage(/var/www/html/enser/Query/Prodotti/SelOggetti.cfm:24)
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_view2ecfm266170799.runPage(/var/www/html/enser/Prodotti/Prodotti_view.cfm:73)
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 cfInside2ecfm928390187.runPage(/var/www/html/enser/Inside.cfm:27)
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)