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 '2024-08-27 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 '380' or shop.prodgruppe2 like '380' or shop.prodgruppe3 like '380') ))
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 83: <cfelse> 84: 85: <cfinclude template="../shop/artikelqueries.cfm"> 86: </cfif> 87: called from /var/www/vhosts/desicare.de/httpdocs/desicare/makehtml.cfm: line 11 9: 10: <cfsavecontent variable="buffer"> 11: <cfinclude template="../shop/#datei#.cfm"> 12: </cfsavecontent> 13: called from /var/www/vhosts/desicare.de/httpdocs/go/go_prodgruppe.cfm: line 34 32: <cfset mobil="ja"> 33: <cfset JSlink="nein"> 34: <cfinclude template="../desicare/makehtml.cfm"> 35: <cfset mobil="nein"> 36: <cfset JSlink="ja"> called from /var/www/vhosts/desicare.de/httpdocs/error/error404.cfm: line 777 775: <cfif (not FileExists('#dateipfad#\#errorshop.htm#.htm'))> 776: <cfset immer = "ja"> 777: <cfinclude template="../go/go_prodgruppe.cfm"> 778: <cfoutput>#buffer#</cfoutput> 779: <cfelse>
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$uw.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$uv.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.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.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	27.07.24 13:00:31 MESZ