Catch
Entries: 18 |
| additional | | Struct (ordered) | | SQL | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
Webinar_list.webinar_starttime, Webinar_list.webinar_endTime
FROM course_list
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND Webinar_list.webinar_dt + Webinar_list.webinar_starttime >= getdate()
ORDER BY Webinar_list.webinar_dt |
| | DatabaseName | | string | Microsoft SQL Server |
| | DatabaseVersion | | | DriverName | | string | Microsoft JDBC Driver 12.6 for SQL Server |
| | DriverVersion | | | Datasource | |
|
| Cause | Struct
Entries: 15 | | additional | | Struct (ordered) | | SQL | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
Webinar_list.webinar_starttime, Webinar_list.webinar_endTime
FROM course_list
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND Webinar_list.webinar_dt + Webinar_list.webinar_starttime >= getdate()
ORDER BY Webinar_list.webinar_dt |
| | DatabaseName | | string | Microsoft SQL Server |
| | DatabaseVersion | | | DriverName | | string | Microsoft JDBC Driver 12.6 for SQL Server |
| | DriverVersion | | | Datasource | |
| | DataSource | | | Detail | | | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | Message | | string | The data types datetime and time are incompatible in the add operator. |
| | NativeErrorCode | | | queryError | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
Webinar_list.webinar_starttime, Webinar_list.webinar_endTime
FROM course_list
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND Webinar_list.webinar_dt + Webinar_list.webinar_starttime >= getdate()
ORDER BY Webinar_list.webinar_dt |
| | Sql | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
Webinar_list.webinar_starttime, Webinar_list.webinar_endTime
FROM course_list
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND Webinar_list.webinar_dt + Webinar_list.webinar_starttime >= getdate()
ORDER BY Webinar_list.webinar_dt |
| | SQLState | | | StackTrace | | string | lucee.runtime.exp.DatabaseException: The data types datetime and time are incompatible in the add operator.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1752)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:946)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:840)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7748)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4410)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:293)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:263)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:813)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:296)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:242)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1128)
at lucee.runtime.tag.Query._doEndTag(Query.java:695)
at lucee.runtime.tag.Query.doEndTag(Query.java:560)
at ceu.course_list_cfm$cf.call(/ceu/course_list.cfm:54)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1016)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:921)
at application_cfc$cf.udfCall_000002(/Application.cfc:513)
at application_cfc$cf.udfCall(/Application.cfc:476)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:476)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2725)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2712)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2683)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1159)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:42)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Unknown Source)
|
| | TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 52: AND Webinar_list.webinar_dt + Webinar_list.webinar_starttime >= getdate()<br>
53: ORDER BY Webinar_list.webinar_dt<br>
<b>54: </CFQUERY></b><br>
55: <br>
56: <CFloop QUERY="GetCourseList"><br>
|
| | codePrintPlain | | string | 52: AND Webinar_list.webinar_dt + Webinar_list.webinar_starttime >= getdate()
53: ORDER BY Webinar_list.webinar_dt
54: </CFQUERY>
55:
56: <CFloop QUERY="GetCourseList">
|
| | column | | | id | | | line | | | Raw_Trace | | string | ceu.course_list_cfm$cf.call(/ceu/course_list.cfm:54) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/ceu/course_list.cfm |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 511: <cfinclude template="#ARGUMENTS.targetPage#"><br>
512: <cfelse><br>
<b>513: <cfinclude template="#ARGUMENTS.targetPage#"></b><br>
514: </cfif><br>
515: </cffunction><br>
|
| | codePrintPlain | | string | 511: <cfinclude template="#ARGUMENTS.targetPage#">
512: <cfelse>
513: <cfinclude template="#ARGUMENTS.targetPage#">
514: </cfif>
515: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall_000002(/Application.cfc:513) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 474: <br>
475: <cffunction name="onRequest"><br>
<b>476: <cfargument name="targetPage" type="String" required=true/></b><br>
477: <br>
478: <cfif cgi.remote_addr NEQ '127.0.0.1'><br>
|
| | codePrintPlain | | string | 474:
475: <cffunction name="onRequest">
476: <cfargument name="targetPage" type="String" required=true/>
477:
478: <cfif cgi.remote_addr NEQ '127.0.0.1'>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall(/Application.cfc:476) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
|
| | type | | | where | |
|
| DataSource | |
| Detail | |
| ErrorCode | |
| Extended_Info | |
| ExtendedInfo | |
| Message | | string | The data types datetime and time are incompatible in the add operator. |
|
| name | |
| NativeErrorCode | |
| queryError | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
Webinar_list.webinar_starttime, Webinar_list.webinar_endTime
FROM course_list
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND Webinar_list.webinar_dt + Webinar_list.webinar_starttime >= getdate()
ORDER BY Webinar_list.webinar_dt |
|
| rootCause | Struct
Entries: 15 | | additional | | Struct (ordered) | | SQL | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
Webinar_list.webinar_starttime, Webinar_list.webinar_endTime
FROM course_list
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND Webinar_list.webinar_dt + Webinar_list.webinar_starttime >= getdate()
ORDER BY Webinar_list.webinar_dt |
| | DatabaseName | | string | Microsoft SQL Server |
| | DatabaseVersion | | | DriverName | | string | Microsoft JDBC Driver 12.6 for SQL Server |
| | DriverVersion | | | Datasource | |
| | DataSource | | | Detail | | | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | Message | | string | The data types datetime and time are incompatible in the add operator. |
| | NativeErrorCode | | | queryError | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
Webinar_list.webinar_starttime, Webinar_list.webinar_endTime
FROM course_list
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND Webinar_list.webinar_dt + Webinar_list.webinar_starttime >= getdate()
ORDER BY Webinar_list.webinar_dt |
| | Sql | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
Webinar_list.webinar_starttime, Webinar_list.webinar_endTime
FROM course_list
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND Webinar_list.webinar_dt + Webinar_list.webinar_starttime >= getdate()
ORDER BY Webinar_list.webinar_dt |
| | SQLState | | | StackTrace | | string | lucee.runtime.exp.DatabaseException: The data types datetime and time are incompatible in the add operator.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1752)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:946)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:840)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7748)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4410)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:293)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:263)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:813)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:296)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:242)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1128)
at lucee.runtime.tag.Query._doEndTag(Query.java:695)
at lucee.runtime.tag.Query.doEndTag(Query.java:560)
at ceu.course_list_cfm$cf.call(/ceu/course_list.cfm:54)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1016)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:921)
at application_cfc$cf.udfCall_000002(/Application.cfc:513)
at application_cfc$cf.udfCall(/Application.cfc:476)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:476)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2725)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2712)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2683)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1159)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:42)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Unknown Source)
|
| | TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 52: AND Webinar_list.webinar_dt + Webinar_list.webinar_starttime >= getdate()<br>
53: ORDER BY Webinar_list.webinar_dt<br>
<b>54: </CFQUERY></b><br>
55: <br>
56: <CFloop QUERY="GetCourseList"><br>
|
| | codePrintPlain | | string | 52: AND Webinar_list.webinar_dt + Webinar_list.webinar_starttime >= getdate()
53: ORDER BY Webinar_list.webinar_dt
54: </CFQUERY>
55:
56: <CFloop QUERY="GetCourseList">
|
| | column | | | id | | | line | | | Raw_Trace | | string | ceu.course_list_cfm$cf.call(/ceu/course_list.cfm:54) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/ceu/course_list.cfm |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 511: <cfinclude template="#ARGUMENTS.targetPage#"><br>
512: <cfelse><br>
<b>513: <cfinclude template="#ARGUMENTS.targetPage#"></b><br>
514: </cfif><br>
515: </cffunction><br>
|
| | codePrintPlain | | string | 511: <cfinclude template="#ARGUMENTS.targetPage#">
512: <cfelse>
513: <cfinclude template="#ARGUMENTS.targetPage#">
514: </cfif>
515: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall_000002(/Application.cfc:513) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 474: <br>
475: <cffunction name="onRequest"><br>
<b>476: <cfargument name="targetPage" type="String" required=true/></b><br>
477: <br>
478: <cfif cgi.remote_addr NEQ '127.0.0.1'><br>
|
| | codePrintPlain | | string | 474:
475: <cffunction name="onRequest">
476: <cfargument name="targetPage" type="String" required=true/>
477:
478: <cfif cgi.remote_addr NEQ '127.0.0.1'>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall(/Application.cfc:476) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
|
| | type | | | where | |
|
| Sql | | string | SELECT article_headers.art_id, course_list.cid, course_list.ctitle, course_list.ccategory, course_list.csummary,
course_list.ctotalcredits, course_list.ccostpercredit, course_list.clocation, course_list.camount, course_author.authorname,
course_list.course_reviewer1, course_list.course_reviewer2, course_list.course_reviewer3, course_author.authorcredentials,
course_author.authorbio, course_list.caudience, course_list.clevel, course_list.cobjectives, Webinar_list.wkey, Webinar_list.webinar_dt,
Webinar_list.webinar_starttime, Webinar_list.webinar_endTime
FROM course_list
INNER JOIN course_author ON course_list.cauthorid = course_author.cauthorid
INNER JOIN Webinar_list ON course_list.cid = webinar_list.cid
LEFT JOIN article_headers on article_headers.cid = webinar_list.cid
WHERE article_headers.art_type = 'Webinar' AND Webinar_list.isAvailable = 'YES'
AND Webinar_list.webinar_dt + Webinar_list.webinar_starttime >= getdate()
ORDER BY Webinar_list.webinar_dt |
|
| SQLState | |
| StackTrace | | string | lucee.runtime.exp.DatabaseException: The data types datetime and time are incompatible in the add operator.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1752)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:946)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:840)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7748)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4410)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:293)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:263)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:813)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:296)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:242)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1128)
at lucee.runtime.tag.Query._doEndTag(Query.java:695)
at lucee.runtime.tag.Query.doEndTag(Query.java:560)
at ceu.course_list_cfm$cf.call(/ceu/course_list.cfm:54)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1016)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:921)
at application_cfc$cf.udfCall_000002(/Application.cfc:513)
at application_cfc$cf.udfCall(/Application.cfc:476)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:476)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2725)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2712)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2683)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1159)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:42)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Unknown Source)
|
|
| TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 52: AND Webinar_list.webinar_dt + Webinar_list.webinar_starttime >= getdate()<br>
53: ORDER BY Webinar_list.webinar_dt<br>
<b>54: </CFQUERY></b><br>
55: <br>
56: <CFloop QUERY="GetCourseList"><br>
|
| | codePrintPlain | | string | 52: AND Webinar_list.webinar_dt + Webinar_list.webinar_starttime >= getdate()
53: ORDER BY Webinar_list.webinar_dt
54: </CFQUERY>
55:
56: <CFloop QUERY="GetCourseList">
|
| | column | | | id | | | line | | | Raw_Trace | | string | ceu.course_list_cfm$cf.call(/ceu/course_list.cfm:54) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/ceu/course_list.cfm |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 511: <cfinclude template="#ARGUMENTS.targetPage#"><br>
512: <cfelse><br>
<b>513: <cfinclude template="#ARGUMENTS.targetPage#"></b><br>
514: </cfif><br>
515: </cffunction><br>
|
| | codePrintPlain | | string | 511: <cfinclude template="#ARGUMENTS.targetPage#">
512: <cfelse>
513: <cfinclude template="#ARGUMENTS.targetPage#">
514: </cfif>
515: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall_000002(/Application.cfc:513) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 474: <br>
475: <cffunction name="onRequest"><br>
<b>476: <cfargument name="targetPage" type="String" required=true/></b><br>
477: <br>
478: <cfif cgi.remote_addr NEQ '127.0.0.1'><br>
|
| | codePrintPlain | | string | 474:
475: <cffunction name="onRequest">
476: <cfargument name="targetPage" type="String" required=true/>
477:
478: <cfif cgi.remote_addr NEQ '127.0.0.1'>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall(/Application.cfc:476) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
|
|
| type | |
| where | |