Catch Entries: 15 |
additional | Struct (ordered) | SQL | string | SELECT permalink, id, rating, date_created, created, modified, title, data, image, caption, full_coverage, sponsor, featured
FROM qry
GROUP BY permalink, id, rating, date_created, created, modified, title, data, image, caption, full_coverage, sponsor, featured
ORDER BY sort ASC, created DESC |
| DatabaseName | string | HSQL Database Engine |
| DatabaseVersion | | DriverName | string | HSQL Database Engine Driver |
| DriverVersion | | Datasource | |
|
DataSource | |
Detail | |
ErrorCode | |
Extended_Info | |
ExtendedInfo | |
Message | string | Not in aggregate function or group by clause: org.hsqldb.Expression@2b5fd9db in statement [SELECT permalink, id, rating, date_created, created, modified, title, data, image, caption, full_coverage, sponsor, featured
FROM qry
GROUP BY permalink, id, rating, date_created, created, modified, title, data, image, caption, full_coverage, sponsor, featured
ORDER BY sort ASC, created DESC] |
|
NativeErrorCode | |
queryError | string | SELECT permalink, id, rating, date_created, created, modified, title, data, image, caption, full_coverage, sponsor, featured
FROM qry
GROUP BY permalink, id, rating, date_created, created, modified, title, data, image, caption, full_coverage, sponsor, featured
ORDER BY sort ASC, created DESC |
|
Sql | string | SELECT permalink, id, rating, date_created, created, modified, title, data, image, caption, full_coverage, sponsor, featured
FROM qry
GROUP BY permalink, id, rating, date_created, created, modified, title, data, image, caption, full_coverage, sponsor, featured
ORDER BY sort ASC, created DESC |
|
SQLState | |
StackTrace | string | lucee.runtime.exp.DatabaseException: Not in aggregate function or group by clause: org.hsqldb.Expression@2b5fd9db in statement [SELECT permalink, id, rating, date_created, created, modified, title, data, image, caption, full_coverage, sponsor, featured
FROM qry
GROUP BY permalink, id, rating, date_created, created, modified, title, data, image, caption, full_coverage, sponsor, featured
ORDER BY sort ASC, created DESC]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:310)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:261)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:215)
at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:336)
at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:297)
at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:285)
at lucee.runtime.tag.Query.executeQoQ(Query.java:1034)
at lucee.runtime.tag.Query._doEndTag(Query.java:643)
at lucee.runtime.tag.Query.doEndTag(Query.java:542)
at mobile.functions_cfc$cf.udfCall(/mobile/functions.cfc:31)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:205)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:681)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1912)
at lucee.runtime.tag.Invoke.doComponent(Invoke.java:209)
at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:186)
at mobile.page_cfm$cf.call(/mobile/page.cfm:72)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:836)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:42)
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:1110)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1056)
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:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:676)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476)
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)
|
|
TagContext | Array | 1 | Struct | codePrintHTML | string | 29: GROUP BY permalink, id, rating, date_created, created, modified, title, data, image, caption, full_coverage, sponsor, featured<br>
30: ORDER BY <cfif sortByCategory>sort ASC, </cfif>created DESC<br>
<b>31: </cfquery></b><br>
32: <br>
33: <cfreturn qry2/><br>
|
| codePrintPlain | string | 29: GROUP BY permalink, id, rating, date_created, created, modified, title, data, image, caption, full_coverage, sponsor, featured
30: ORDER BY <cfif sortByCategory>sort ASC, </cfif>created DESC
31: </cfquery>
32:
33: <cfreturn qry2/>
|
| column | | id | | line | | Raw_Trace | string | mobile.functions_cfc$cf.udfCall(/mobile/functions.cfc:31) |
| template | string | /var/www/mobile/functions.cfc |
| type | |
| 2 | Struct | codePrintHTML | string | 70: <cfset section = url.c/><br>
71: <cfelse><br>
<b>72: <cfinvoke component="functions" method="SelectNewsByCategory" categories="#url.s#" page="#url.p#" items_per_page="#items_per_page#" returnvariable="news"/></b><br>
73: <!---<cfdump var="#news#">---><br>
74: <!---<cfquery name="categories" datasource="#Application.DSN#"><br>
|
| codePrintPlain | string | 70: <cfset section = url.c/>
71: <cfelse>
72: <cfinvoke component="functions" method="SelectNewsByCategory" categories="#url.s#" page="#url.p#" items_per_page="#items_per_page#" returnvariable="news"/>
73: <!---<cfdump var="#news#">--->
74: <!---<cfquery name="categories" datasource="#Application.DSN#">
|
| column | | id | | line | | Raw_Trace | string | mobile.page_cfm$cf.call(/mobile/page.cfm:72) |
| template | string | /var/www/mobile/page.cfm |
| type | |
|
|
type | |
where | |