Lucee 5.2.9.31 Error (database)
Message
Detail Value '44380neu2243252DemenzenBuch Hardcover#Claus-Werner Wallesch; Hans Förstl9783131369123&https://www.lehmanns.de/media/24243750,2., aktualisierte und überarbeitete Auflage89.99089.9999910.00neinDR?lehmannsmedia22968837???1 Demenzen10000-00-00 00:00:00?sofort lieferbar<https://www.lehmanns.de/cart/add/title_id/22968837?p=desimed2lehmannsmedia44???,DE,Y053GE' can not be represented as java.sql.Timestamp
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 '2019-06-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 Java
DriverVersion mysql-connector-java-5.1.40 ( Revision: 402933ef52cad9aa82624e80acbea46e3a701ce6 )
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:
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
  at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:937)
  at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:559)
  at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:5934)
  at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5624)
  at lucee.runtime.query.caster.TimestampCast.toCFType(TimestampCast.java:34)
  at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:475)
  at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:290)
  at lucee.runtime.type.QueryImpl.(QueryImpl.java:226)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:951)
  at lucee.runtime.tag.Query.doEndTag(Query.java:700)
  at shop.artikelqueries_cfm$cf.call(/shop/artikelqueries.cfm:199)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
  at shop.artikellistea_cfm$cf.call(/shop/artikellisteA.cfm:85)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
  at desicare.makehtml_cfm$cf.call(/desicare/makehtml.cfm:11)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
  at go.go_prodgruppe_cfm$cf.call(/go/go_prodgruppe.cfm:34)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
  at error.error404_cfm$cf.call(/error/error404.cfm:777)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:66)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:45)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2464)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2454)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2427)
  at lucee.runtime.engine.Request.exe(Request.java:44)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1090)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1038)
  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.05.19 13:03:50 MESZ