| 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 '2023-07-06 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 '214' or shop.prodgruppe2 like '214' or shop.prodgruppe3 like '214') )) |
| 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 122 120: </cfif>called from /var/www/vhosts/desicare.de/httpdocs/shop/artikellisteA.cfm: line 85 83: <cfelse>called from /var/www/vhosts/desicare.de/httpdocs/shop/shop-kundenstartA.cfm: line 464 462: <cfelse>called from /var/www/vhosts/desicare.de/httpdocs/error/error404.cfm: line 832 830: <cfinclude template="../shop/shop-kunden.cfm"> |
| 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:122) 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 shop.shop_kundenstarta_cfm225$cf.call(/shop/shop-kundenstartA.cfm:464) 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:832) 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 | 06.06.23 03:57:24 MESZ |
