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.

Table 'location_knd.Offres_Courantes' doesn't exist
 
The error occurred in /var/www/cfcs/f_dl_LADP/offre.cfc: line 1067
Called from /var/www/DL_ladp2015/fiche-produit.cfm: line 36
Called from /var/www/DL_ladp2015/fiche-produit.cfm: line 1
Called from /var/www/DL_ladp2015/Application.cfc: line 139
Called from /var/www/cfcs/f_dl_LADP/offre.cfc: line 1067
Called from /var/www/DL_ladp2015/fiche-produit.cfm: line 36
Called from /var/www/DL_ladp2015/fiche-produit.cfm: line 1
Called from /var/www/DL_ladp2015/Application.cfc: line 139
1065 : 						,CASE WHEN date_format(Offre_DateCreation,'%d/%m/%y')=date_format(Offre_DateCreation,'%d/%m/%y') THEN DATE_ADD(offre_datecreation,INTERVAL #arguments.nHeuresVIP# HOUR) ELSE DATE_ADD(offre_dateconvention,INTERVAL #arguments.nHeuresVIP# HOUR) END as Offre_compteur2
1066 : 						from Offres_Courantes
1067 : 						where offre_dossier ='#arguments.offre_dossier#'
1068 : 						and (offre_enattentevalidation IS NULL or offre_enattentevalidation=0)
1069 : 						and offre_dateConvention IS NOT NULL

SQLSTATE   42S02
DATASOURCE   directe-location
VENDORERRORCODE   1146
SQL    select *, CASE WHEN Offre_quartierBis<>'' then Offre_quartierBis WHEN Offre_Quartier<>'' then Offre_quartier ELSE ''END as quartier2, CASE WHEN date_format(Offre_DateCreation,'%d/%m/%y')=date_format(Offre_DateConvention,'%d/%m/%y') THEN offre_datecreation ELSE offre_dateConvention END as Offre_compteur ,CASE WHEN date_format(Offre_DateCreation,'%d/%m/%y')=date_format(Offre_DateCreation,'%d/%m/%y') THEN DATE_ADD(offre_datecreation,INTERVAL 24 HOUR) ELSE DATE_ADD(offre_dateconvention,INTERVAL 24 HOUR) END as Offre_compteur2 from Offres_Courantes where offre_dossier ='30-0182-21' and (offre_enattentevalidation IS NULL or offre_enattentevalidation=0) and offre_dateConvention IS NOT NULL and offre_dateConvention <> '' and 150=150
Resources:

Browser   claudebot
Remote Address   172.70.134.99
Referrer  
Date/Time   28-Mar-24 11:01 PM
Stack Trace
at cfoffre2ecfc447484038$funcGETJUSTONEOFFREFORSITE.runFunction(/var/www/cfcs/f_dl_LADP/offre.cfc:1067) at cffiche2dproduit2ecfm411542080._factor5(/var/www/DL_ladp2015/fiche-produit.cfm:36) at cffiche2dproduit2ecfm411542080.runPage(/var/www/DL_ladp2015/fiche-produit.cfm:1) at cfApplication2ecfc1145985520$funcONREQUEST.runFunction(/var/www/DL_ladp2015/Application.cfc:139) at cfoffre2ecfc447484038$funcGETJUSTONEOFFREFORSITE.runFunction(/var/www/cfcs/f_dl_LADP/offre.cfc:1067) at cffiche2dproduit2ecfm411542080._factor5(/var/www/DL_ladp2015/fiche-produit.cfm:36) at cffiche2dproduit2ecfm411542080.runPage(/var/www/DL_ladp2015/fiche-produit.cfm:1) at cfApplication2ecfc1145985520$funcONREQUEST.runFunction(/var/www/DL_ladp2015/Application.cfc:139)

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'location_knd.Offres_Courantes' doesn't exist
	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:406)
	at com.mysql.jdbc.Util.getInstance(Util.java:381)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:838)
	at com.intergral.fusionreactor.jdbc.jdbc42.StatementSurrogate2.execute(StatementSurrogate2.java:49)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1479)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1229)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1159)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1185)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:814)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:767)
	at cfoffre2ecfc447484038$funcGETJUSTONEOFFREFORSITE.runFunction(/var/www/cfcs/f_dl_LADP/offre.cfc:1067)
	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:533)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:648)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:457)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2424)
	at cffiche2dproduit2ecfm411542080._factor5(/var/www/DL_ladp2015/fiche-produit.cfm:36)
	at cffiche2dproduit2ecfm411542080.runPage(/var/www/DL_ladp2015/fiche-produit.cfm:1)
	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:2991)
	at cfApplication2ecfc1145985520$funcONREQUEST.runFunction(/var/www/DL_ladp2015/Application.cfc:139)
	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:643)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402)
	at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108)
	at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:301)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:462)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:142)
	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 coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:121)
	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 sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:483)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:97)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:472)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:312)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:192)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:507)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
	at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:483)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:79)
	at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:483)
	at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:53)
	at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:199)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
	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)