Lucee 5.3.8.206 Error (database)
Message Zero date value prohibited
SQL SELECT shop.kdnr,
shop.prodgruppe,
shop.zustand,
shop.ID,
shop.artikel,
shop.artikelart,
shop.autor,
shop.artikelid,
shop.bild1,
shop.bild2,
shop.zusatz1,
shop.preis,
shop.child,
shop.npreis,
shop.stkzahl,
shop.lieferstatus,
shop.versandkosten,
shop.nurprofi,
shop.zielgruppe,
shop.spreisbisdat,
shop.anbieter,
shop.kdartnr,
shop.artikelnr,
shop.marke,
shop.muttername,
shop.ampel,
shop.htm,
shop.htmldat,
shop.offline,
shop.lieferbarkeit,
shop.urlextern,
shop.liefertage,
mail.name1,
mail.firmakdnr,
mail.geschl,
mail.plz,
mail.land,
isbnrubri.pttechnik,
isbnrubri.fachrichtung
FROM (mail INNER JOIN shop ON mail.Name1 = shop.anbieter) LEFT JOIN isbnrubri ON shop.artikelid = isbnrubri.ISBNNR
where (mail.agbdat is not null and (shop.ampel is null or shop.ampel like "1" or shop.ampel like "2")

and (((shop.spreisbisdat > now()) and (shop.spreisbisdat < {ts '2022-02-28 00:00:00'})) or shop.spreisbisdat is null)

and shop.lieferkdnr not like '71'
and shop.lieferkdnr not like '963'
and (shop.ID > 0)
and shop.child <> '1'
and preis <> '0.00'
and preis <> ''
and preis <> '0'
and sprache like 'd'
and (
(shop.del <> '1')

and (shop.prodgruppe like '375' or shop.prodgruppe2 like '375' or shop.prodgruppe3 like '375')

))
DatabaseName MySQL
DatabaseVersion 5.5.5-10.0.12-MariaDB-log
DriverName MySQL Connector/J
DriverVersion mysql-connector-java-8.0.24 (Revision: 4f7120a617b9d5efb9dedda9064b9896db424a60)
Datasource physiobookss3
Stacktrace The Error Occurred in
/var/www/vhosts/desicare.de/httpdocs/shop/artikelqueries.cfm: line 199
197: </cfif>
198: ))
199: </CFQUERY>

called from /var/www/vhosts/desicare.de/httpdocs/shop/artikellisteA.cfm: line 85
called from /var/www/vhosts/desicare.de/httpdocs/desicare/makehtml.cfm: line 11
called from /var/www/vhosts/desicare.de/httpdocs/go/go_prodgruppe.cfm: line 34
called from /var/www/vhosts/desicare.de/httpdocs/error/error404.cfm: line 777
Java Stacktrace lucee.runtime.exp.DatabaseException: Zero date value prohibited
  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:99)
  at com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(ResultSetImpl.java:972)
  at lucee.runtime.query.caster.TimestampCast.toCFType(TimestampCast.java:40)
  at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:706)
  at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:304)
  at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:1134)
  at lucee.runtime.tag.Query._doEndTag(Query.java:699)
  at lucee.runtime.tag.Query.doEndTag(Query.java:565)
  at shop.artikelqueries_cfm$cf.call(/shop/artikelqueries.cfm:199)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1034)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:926)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:907)
  at shop.artikellistea_cfm$cf.call(/shop/artikellisteA.cfm:85)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1034)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:926)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:907)
  at desicare.makehtml_cfm$cf$4mk.call(/desicare/makehtml.cfm:11)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1034)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:926)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:907)
  at go.go_prodgruppe_cfm$cf$4x8.call(/go/go_prodgruppe.cfm:34)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1034)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:926)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:907)
  at error.error404_cfm$cf.call(/error/error404.cfm:777)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1034)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:926)
  at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:65)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:45)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2460)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2450)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2421)
  at lucee.runtime.engine.Request.exe(Request.java:45)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1179)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1125)
  at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102)
  at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
  at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  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)
 
Timestamp 28.01.22 09:11:59 MEZ