OfficiaNet - Online Business Networking Directory

OfficiaNet - Building Better Business
Sign Up for Free Membership of OfficiaNet - the next stage of evolution for business networking
Officianet - Online Business Networking

Already a Member?
OfficiaNet Members Log In

Membership of our Business Networking section is FREE
OfficiaNet Business Networking

Online Business Networking
Sign Up for Membership of OfficiaNet B2B Business Networking
OfficiaNet Online Project Management Solution

Lucee 5.3.5.92 Error (database)
Message Zero date value prohibited
SQL SELECT *
FROM userprofiles
Where userprofiles.NewsItemID = '105'
AND Active = 1
DatabaseName MySQL
DatabaseVersion 5.6.37
DriverName MySQL Connector/J
DriverVersion mysql-connector-java-8.0.15 (Revision: 79a4336f140499bd22dd07f02b708e163844e3d5)
Datasource offician_i8d
Stacktrace The Error Occurred in
/home/offician/public_html/directory/profileview.cfm: line 7
5: Where userprofiles.NewsItemID = '#url.profileitem#'
6: AND Active = 1
7: </cfquery>
8: <cfif UserProfile.RecordCount IS 0>
9: <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:1059)
  at lucee.runtime.query.caster.TimestampCast.toCFType(TimestampCast.java:40)
  at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:493)
  at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:288)
  at lucee.runtime.type.QueryImpl.(QueryImpl.java:225)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:1091)
  at lucee.runtime.tag.Query._doEndTag(Query.java:672)
  at lucee.runtime.tag.Query.doEndTag(Query.java:552)
  at directory.profileview_cfm$cf$27o0.call(/directory/profileview.cfm:7)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:836)
  at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:64)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2415)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2405)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2380)
  at lucee.runtime.engine.Request.exe(Request.java:43)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1126)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1072)
  at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
  at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  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:53)
  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:202)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:747)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:860)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
  at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.base/java.lang.Thread.run(Unknown Source)
 
Timestamp 06/06/2020 03:37:48 GMT