Railo 4.2.1.008 Error (database) | |
Message | |
Detail | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by bib_order desc limit 0,1' at line 6 |
SQL | SELECT bib_id FROM book_sampleimage WHERE bok_id = 964544 AND bib_status = 1 AND bib_order < order by bib_order desc limit 0,1 |
DatabaseName | MySQL |
DatabaseVersion | 5.5.20-log |
DriverName | MySQL-AB JDBC Driver |
DriverVersion | mysql-connector-java-5.0.8 ( Revision: ${svn.Revision} ) |
Datasource | cdo_5 |
Stacktrace | The Error Occurred in /var/www/vhost1/ROOT/shop/book/bib/qry_getBibPictures.cfm: line 74 72: order by bib_order desccalled from /var/www/vhost1/ROOT/shop/book/bib/index.cfm: line 55 53: <!--- (B)lick (I)ns (B)uch ---> |
Java Stacktrace | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936):936 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985):2985 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631):1631 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723):1723 at com.mysql.jdbc.Connection.execSQL(Connection.java:3283):3283 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332):1332 at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:882):882 at railo.runtime.db.driver.state.StateUtil.execute(StateUtil.java:127):127 at railo.runtime.db.driver.state.StatePreparedStatement.execute(StatePreparedStatement.java:117):117 at railo.runtime.type.util.QueryUtil.execute(QueryUtil.java:222):222 at railo.runtime.type.QueryImpl. at railo.runtime.tag.Query.executeDatasoure(Query.java:687):687 at railo.runtime.tag.Query.doEndTag(Query.java:531):531 at shop.book.bib.qry_getbibpictures_cfm$cf.call(/var/www/vhost1/ROOT/shop/book/bib/qry_getBibPictures.cfm:74):74 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:813):813 at shop.book.bib.index_cfm$cf.call(/var/www/vhost1/ROOT/shop/book/bib/index.cfm:55):55 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909 at railo.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:39):39 at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:19):19 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2212):2212 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2179):2179 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:331):331 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717):717 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290):290 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233):233 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191):191 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127):127 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102):102 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109):109 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293):293 at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190):190 at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291):291 at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776):776 at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705):705 at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898):898 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690):690 at java.lang.Thread.run(Thread.java:636):636 |
Timestamp | 28.03.24 14:02:05 MEZ |