SQLException Expression #1 of ORDER BY clause is not in SELECT list, references column 'comics.f.appr_dtt' which is not in SELECT list; this is incompatible with DISTINCT
java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column 'comics.f.appr_dtt' which is not in SELECT list; this is incompatible with DISTINCT at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1383) at org.sanzu.sql.AdvancedStatement.executeQuery(AdvancedStatement.java:200) at org.sanzu.sql.AdvancedStatement.executeQuery(AdvancedStatement.java:193) at org.sanzu.sql.AdvancedStatement.retrieveAll(AdvancedStatement.java:671) at org.sanzu.sql.AdvancedStatement.retrieveAll(AdvancedStatement.java:653) at org.eum.model.card.CardDAO.selectByCriteria(CardDAO.java:56) at org.eum.index.EntryLoader.filterByEUM(EntryLoader.java:61) at org.eum.index.EntryLoader.loadEntries(EntryLoader.java:34) at org.eum.web.eum.PrepareIndex.execute(PrepareIndex.java:35) at org.sanzu.core.Controller.execute(Controller.java:337) at org.apache.jsp.WEB_002dINF.jsp.home.card_jsp._jspService(card_jsp.java:110) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:400) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:344) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.eum.http.VisitorFilter.doFilter(VisitorFilter.java:41) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:221) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318) 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)
[más]
Stan Lee, no te olvidamos! Siempre estarás con nosotros! |
Novedades | Actualizaciones | |||||
---|---|---|---|---|---|---|
11992 |
11991 |
11990 |
11989 |
Vengadores | Patrulla-X | Cósmicos | Juveniles | |
---|---|---|---|---|