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.

Dynamic SQL Error; SQL error code = -104; Token unknown - line 3, column 12; . [SQLState:42000, ISC error code:335544634]
 
The error occurred in /storage/web/cfc/ecm45/custom/erboristeria/catalogo2016.cfc: line 540
Called from /storage/web/e/erboristeriadottorcassani_it/web/blk/catalogoofferte1/head.cfm: line 41
Called from /storage/web/cfc/ecm45/pagina.cfc: line 155
Called from /storage/web/cfc/ecm45/pagina.cfc: line 106
Called from /storage/web/cfc/ecm45/pagina.cfc: line 98
Called from /storage/web/cfc/ecm45/pagina.cfc: line 92
Called from /storage/web/cfc/ecm45/pagina.cfc: line 75
Called from /storage/web/cfc/ecm45/pagina.cfc: line 17
Called from /storage/web/e/erboristeriadottorcassani_it/web/index.cfm: line 63
Called from /storage/web/e/erboristeriadottorcassani_it/web/Application.cfc: line 118
Called from /storage/web/cfc/ecm45/custom/erboristeria/catalogo2016.cfc: line 540
Called from /storage/web/e/erboristeriadottorcassani_it/web/blk/catalogoofferte1/head.cfm: line 41
Called from /storage/web/cfc/ecm45/pagina.cfc: line 155
Called from /storage/web/cfc/ecm45/pagina.cfc: line 106
Called from /storage/web/cfc/ecm45/pagina.cfc: line 98
Called from /storage/web/cfc/ecm45/pagina.cfc: line 92
Called from /storage/web/cfc/ecm45/pagina.cfc: line 75
Called from /storage/web/cfc/ecm45/pagina.cfc: line 17
Called from /storage/web/e/erboristeriadottorcassani_it/web/index.cfm: line 63
Called from /storage/web/e/erboristeriadottorcassani_it/web/Application.cfc: line 118
538 : 					ORDER BY PRODOTTO.SCONTO desc
539 : 				</cfcase>
540 : 				<cfdefaultcase>
541 : 					ORDER BY PRODOTTO.OFFERTADAL desc
542 : 				</cfdefaultcase>

SQLSTATE   42000
DATASOURCE   erboristeriadottorcassani_fb4
VENDORERRORCODE   335544634
SQL    SELECT FIRST 36 SKIP -36 PRODOTTO.ID, PRODOTTO.PRODOTTOCAT_CID, PRODOTTO.HOMEPAGE, PRODOTTO.OFFERTA, PRODOTTO.USATO, PRODOTTO.NOVITA, PRODOTTO.SCONTO, PRODOTTORIGA.NOME, PRODOTTORIGA.ABSTRACT, PRODOTTO.PREZZO, PRODOTTO.IVA, PRODOTTO.PREZZOIVATO, PRODOTTO.IMPORTOIVA, PRODOTTO.VARIANTEINOFF, PRODOTTO.ACQUISTABILE, PRODOTTO.GIACENZA, PRODOTTO.SCORTA, PRODOTTO.RIASSORTIMENTO, PRODOTTO.UDMPREZZOUNITARIO, PRODOTTO.PREZZOVENDITA, PRODOTTO.PREZZOVENDITAIVATO, PRODOTTO.PREZZIDIVERSI,PRODOTTO.MARCA_CID,PRODOTTO.LINEA_CID, PRODOTTO.PREZZOOFFERTA, PRODOTTO.PREZZOOFFERTAIVATO, PRODOTTO.IMPORTOIVAOFFERTA, PRODOTTO.PUBBLICA, PRODOTTO.CONFEZIONEDA, PRODOTTO.FOTO, PRODOTTO.FOTOORIGINALE, PRODOTTO.OFFERTADAL, PRODOTTO.OFFERTAQTMIN, PRODOTTO.OFFERTAAL, PRODOTTO.BANNER, PRODOTTO.CODICE, PRODOTTO.GIACENZA, PRODOTTORIGA.REWRITE, PRODOTTOCATRIGA.NOME AS NOMECAT, PRODOTTOCATRIGA.REWRITE AS REWRITECAT, PRODOTTORIGA.DIDASCALIA, PRODOTTO.BASEBIG, PRODOTTO.BASESMALL, PRODOTTO.ALTEZZABIG, PRODOTTO.ALTEZZASMALL , PRODOTTO.SPEDGRATUITA, PREZZOMINIMO, PRODOTTO.PREZZOMINIMOIVATO, DATAPREZZOMINIMO , MARCARIGA.NOME AS NOMEMARCA, MARCA.FOTO AS LOGOMARCA FROM PRODOTTORIGA, PRODOTTO LEFT JOIN PRODOTTOCATRIGA ON (PRODOTTO.PRODOTTOCAT_CID = PRODOTTOCATRIGA.PRODOTTOCAT_CID AND UPPER(PRODOTTOCATRIGA.LINGUA) = 'IT') LEFT JOIN MARCARIGA ON MARCARIGA.MARCA_CID = PRODOTTO.MARCA_CID AND UPPER(MARCARIGA.LINGUA)='IT' LEFT JOIN MARCA ON PRODOTTO.MARCA_CID = MARCA.ID WHERE PRODOTTO.PUBBLICA = 'S' AND PRODOTTO.ID = PRODOTTORIGA.PRODOTTO_CID AND PRODOTTORIGA.LINGUA = 'IT' AND PRODOTTO.OFFERTA <> 'N' AND ({d '2024-03-29'} >= PRODOTTO.OFFERTADAL AND {d '2024-03-29'} <= PRODOTTO.OFFERTAAL) AND PRODOTTO.VISUALIZZAETICHETTA = 'S' ORDER BY PRODOTTO.OFFERTADAL desc
Resources:

Browser   claudebot
Remote Address   44.222.146.114
Referrer  
Date/Time   29-Mar-24 12:42 AM
Stack Trace
at cfcatalogo20162ecfc694465184$funcELENCOPRODOTTIOFFERTA.runFunction(/storage/web/cfc/ecm45/custom/erboristeria/catalogo2016.cfc:540) at cfhead2ecfm2055003708.runPage(/storage/web/e/erboristeriadottorcassani_it/web/blk/catalogoofferte1/head.cfm:41) at cfpagina2ecfc358220906$funcSOSTITUISCIBLOCCHI._factor4(/storage/web/cfc/ecm45/pagina.cfc:155) at cfpagina2ecfc358220906$funcSOSTITUISCIBLOCCHI._factor5(/storage/web/cfc/ecm45/pagina.cfc:106) at cfpagina2ecfc358220906$funcSOSTITUISCIBLOCCHI._factor6(/storage/web/cfc/ecm45/pagina.cfc:98) at cfpagina2ecfc358220906$funcSOSTITUISCIBLOCCHI.runFunction(/storage/web/cfc/ecm45/pagina.cfc:92) at cfpagina2ecfc358220906$funcGETPAGINACOMPLETA._factor2(/storage/web/cfc/ecm45/pagina.cfc:75) at cfpagina2ecfc358220906$funcGETPAGINACOMPLETA.runFunction(/storage/web/cfc/ecm45/pagina.cfc:17) at cfindex2ecfm1967644563.runPage(/storage/web/e/erboristeriadottorcassani_it/web/index.cfm:63) at cfApplication2ecfc1853311360$funcONREQUEST.runFunction(/storage/web/e/erboristeriadottorcassani_it/web/Application.cfc:118) at cfcatalogo20162ecfc694465184$funcELENCOPRODOTTIOFFERTA.runFunction(/storage/web/cfc/ecm45/custom/erboristeria/catalogo2016.cfc:540) at cfhead2ecfm2055003708.runPage(/storage/web/e/erboristeriadottorcassani_it/web/blk/catalogoofferte1/head.cfm:41) at cfpagina2ecfc358220906$funcSOSTITUISCIBLOCCHI._factor4(/storage/web/cfc/ecm45/pagina.cfc:155) at cfpagina2ecfc358220906$funcSOSTITUISCIBLOCCHI._factor5(/storage/web/cfc/ecm45/pagina.cfc:106) at cfpagina2ecfc358220906$funcSOSTITUISCIBLOCCHI._factor6(/storage/web/cfc/ecm45/pagina.cfc:98) at cfpagina2ecfc358220906$funcSOSTITUISCIBLOCCHI.runFunction(/storage/web/cfc/ecm45/pagina.cfc:92) at cfpagina2ecfc358220906$funcGETPAGINACOMPLETA._factor2(/storage/web/cfc/ecm45/pagina.cfc:75) at cfpagina2ecfc358220906$funcGETPAGINACOMPLETA.runFunction(/storage/web/cfc/ecm45/pagina.cfc:17) at cfindex2ecfm1967644563.runPage(/storage/web/e/erboristeriadottorcassani_it/web/index.cfm:63) at cfApplication2ecfc1853311360$funcONREQUEST.runFunction(/storage/web/e/erboristeriadottorcassani_it/web/Application.cfc:118)

java.sql.SQLSyntaxErrorException: Dynamic SQL Error; SQL error code = -104; Token unknown - line 3, column 12; . [SQLState:42000, ISC error code:335544634]
	at org.firebirdsql.gds.ng.FbExceptionBuilder$Type$1.createSQLException(FbExceptionBuilder.java:534)
	at org.firebirdsql.gds.ng.FbExceptionBuilder.toFlatSQLException(FbExceptionBuilder.java:304)
	at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readStatusVector(AbstractWireOperations.java:140)
	at org.firebirdsql.gds.ng.wire.AbstractWireOperations.processOperation(AbstractWireOperations.java:204)
	at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readSingleResponse(AbstractWireOperations.java:171)
	at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readResponse(AbstractWireOperations.java:155)
	at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readGenericResponse(AbstractWireOperations.java:257)
	at org.firebirdsql.gds.ng.wire.AbstractFbWireDatabase.readGenericResponse(AbstractFbWireDatabase.java:201)
	at org.firebirdsql.gds.ng.wire.version11.V11Statement.prepare(V11Statement.java:89)
	at org.firebirdsql.jdbc.FBStatement.prepareFixedStatement(FBStatement.java:881)
	at org.firebirdsql.jdbc.FBStatement.internalExecute(FBStatement.java:868)
	at org.firebirdsql.jdbc.FBStatement.executeImpl(FBStatement.java:496)
	at org.firebirdsql.jdbc.FBStatement.execute(FBStatement.java:482)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1495)
	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 cfcatalogo20162ecfc694465184$funcELENCOPRODOTTIOFFERTA.runFunction(/storage/web/cfc/ecm45/custom/erboristeria/catalogo2016.cfc:540)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489)
	at cfhead2ecfm2055003708.runPage(/storage/web/e/erboristeriadottorcassani_it/web/blk/catalogoofferte1/head.cfm:41)
	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 cfpagina2ecfc358220906$funcSOSTITUISCIBLOCCHI._factor4(/storage/web/cfc/ecm45/pagina.cfc:155)
	at cfpagina2ecfc358220906$funcSOSTITUISCIBLOCCHI._factor5(/storage/web/cfc/ecm45/pagina.cfc:106)
	at cfpagina2ecfc358220906$funcSOSTITUISCIBLOCCHI._factor6(/storage/web/cfc/ecm45/pagina.cfc:98)
	at cfpagina2ecfc358220906$funcSOSTITUISCIBLOCCHI.runFunction(/storage/web/cfc/ecm45/pagina.cfc:92)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231)
	at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2865)
	at cfpagina2ecfc358220906$funcGETPAGINACOMPLETA._factor2(/storage/web/cfc/ecm45/pagina.cfc:75)
	at cfpagina2ecfc358220906$funcGETPAGINACOMPLETA.runFunction(/storage/web/cfc/ecm45/pagina.cfc:17)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489)
	at cfindex2ecfm1967644563.runPage(/storage/web/e/erboristeriadottorcassani_it/web/index.cfm:63)
	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 cfApplication2ecfc1853311360$funcONREQUEST.runFunction(/storage/web/e/erboristeriadottorcassani_it/web/Application.cfc:118)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405)
	at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108)
	at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:301)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:470)
	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.ha.session.JvmRouteBinderValve.invoke(JvmRouteBinderValve.java:207)
	at org.apache.catalina.ha.tcp.ReplicationValve.invoke(ReplicationValve.java:333)
	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:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.firebirdsql.jdbc.FBSQLExceptionInfo: Dynamic SQL Error