Catch
Entries: 15 |
| additional | | Struct (ordered) | | SQL | | string | SELECT
article_id,
pmid,
title,
abstract,
epubdate,
published_date,
journal,
doi,
"" as categoryterm,
url
FROM
articles
WHERE 1=1 AND a.journal = 'Bioinformatics (Oxford, England)'
UNION ALL
select
idnewsfeeds as article_id,
id as pmid,
title,
summary as abstract,
publisheddate as epubdate,
publisheddate as published_date,
"" as journal,
"" as doi,
categoryterm,
id as url
from newsfeeds
WHERE 1=1 AND a.journal = 'Bioinformatics (Oxford, England)'
ORDER BY epubdate desc, published_date desc, pmid desc
LIMIT 10 OFFSET 440 |
| | DatabaseName | | | DatabaseVersion | | string | 8.0.42-0ubuntu0.22.04.1 |
| | DriverName | | | DriverVersion | | string | mysql-connector-j-8.0.33 (Revision: 7d6b0800528b6b25c68b52dc10d6c1c8429c100c) |
| | Datasource | |
|
| DataSource | |
| Detail | |
| ErrorCode | |
| Extended_Info | |
| ExtendedInfo | |
| Message | | string | Unknown column 'a.journal' in 'where clause' |
|
| NativeErrorCode | |
| queryError | | string | SELECT
article_id,
pmid,
title,
abstract,
epubdate,
published_date,
journal,
doi,
"" as categoryterm,
url
FROM
articles
WHERE 1=1 AND a.journal = 'Bioinformatics (Oxford, England)'
UNION ALL
select
idnewsfeeds as article_id,
id as pmid,
title,
summary as abstract,
publisheddate as epubdate,
publisheddate as published_date,
"" as journal,
"" as doi,
categoryterm,
id as url
from newsfeeds
WHERE 1=1 AND a.journal = 'Bioinformatics (Oxford, England)'
ORDER BY epubdate desc, published_date desc, pmid desc
LIMIT 10 OFFSET 440 |
|
| Sql | | string | SELECT
article_id,
pmid,
title,
abstract,
epubdate,
published_date,
journal,
doi,
"" as categoryterm,
url
FROM
articles
WHERE 1=1 AND a.journal = 'Bioinformatics (Oxford, England)'
UNION ALL
select
idnewsfeeds as article_id,
id as pmid,
title,
summary as abstract,
publisheddate as epubdate,
publisheddate as published_date,
"" as journal,
"" as doi,
categoryterm,
id as url
from newsfeeds
WHERE 1=1 AND a.journal = 'Bioinformatics (Oxford, England)'
ORDER BY epubdate desc, published_date desc, pmid desc
LIMIT 10 OFFSET 440 |
|
| SQLState | |
| StackTrace | | string | lucee.runtime.exp.DatabaseException: Unknown column 'a.journal' in 'where clause'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
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 index_cfm$cf.call(/index.cfm:177)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1046)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:921)
at application_cfc$cf.udfCall1(/Application.cfc:175)
at application_cfc$cf.udfCall(/Application.cfc)
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:715)
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: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:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:668)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
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:770)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:829)
|
|
| TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 175: ORDER BY epubdate desc, published_date desc, pmid desc<br>
176: LIMIT #perPage# OFFSET #(url.page-1) * perPage#<br>
<b>177: </cfquery></b><br>
178: <cfquery name="getArticles_keywords" datasource="aiformedical"><br>
179: SELECT <br>
|
| | codePrintPlain | | string | 175: ORDER BY epubdate desc, published_date desc, pmid desc
176: LIMIT #perPage# OFFSET #(url.page-1) * perPage#
177: </cfquery>
178: <cfquery name="getArticles_keywords" datasource="aiformedical">
179: SELECT
|
| | column | | | id | | | line | | | Raw_Trace | | string | index_cfm$cf.call(/index.cfm:177) |
| | template | | string | /web/sites/production/aimedicalcompendium/index.cfm |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 173: function onRequest( string targetPage ) {<br>
174: try {<br>
<b>175: include arguments.targetPage;</b><br>
176: } catch (any e) {<br>
177: // writeDump(#application#);<br>
|
| | codePrintPlain | | string | 173: function onRequest( string targetPage ) {
174: try {
175: include arguments.targetPage;
176: } catch (any e) {
177: // writeDump(#application#);
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall1(/Application.cfc:175) |
| | template | | string | /web/sites/production/aimedicalcompendium/Application.cfc |
| | type | |
|
|
| type | |
| where | |