| Railo 3.3.4.003 Error (database) | |
| Message | 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 salesrank LIMIT 10' at line 4 |
| SQL |
SELECT DISTINCT asin, discount, amazonprice, listprice, title, updatedate FROM deals WHERE productgroup = 5 AND amazonprice <= 1000 AND asin NOT IN () ORDER BY salesrank LIMIT 10 |
| DatabaseName | MySQL |
| DatabaseVersion | 4.1.22 |
| DriverName | MySQL-AB JDBC Driver |
| DriverVersion | mysql-connector-java-5.0.6 ( $Date: 2007-03-09 22:13:57 +0100 (Fri, 09 Mar 2007) $, $Revision: 6341 $ ) |
| Datasource | dealazon |
| Stacktrace |
The Error Occurred in
/web/spendfish.com/www/web/category.cfm: line 109107: WHERE productgroup = <cfqueryparam cfsqltype="cf_sql_integer" value="#id#"> 
called from/web/spendfish.com/www/web/books/index.cfm: line 9 |
| Java Stacktrace | 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 salesrank LIMIT 10' at line 4 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936):936 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934):2934 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616):1616 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708):1708 at com.mysql.jdbc.Connection.execSQL(Connection.java:3255):3255 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1293):1293 at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:867):867 at railo.runtime.type.QueryImpl.<init>(QueryImpl.java:231):231 at railo.runtime.tag.Query.executeDatasoure(Query.java:622):622 at railo.runtime.tag.Query.doEndTag(Query.java:474):474 at category_cfm$cf.call(/web/spendfish.com/www/web/category.cfm:109):109 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:799):799 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:746):746 at books.index_cfm$cf.call(/web/spendfish.com/www/web/books/index.cfm:9):9 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:799):799 at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:751):751 at railo.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:35):35 at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:24):24 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2035):2035 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2002):2002 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:297):297 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32):32 at javax.servlet.http.HttpServlet.service(HttpServlet.java:91):91 at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103):103 at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:175):175 at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:240):240 at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:424):424 at com.caucho.server.port.TcpConnection.run(TcpConnection.java:481):481 at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:685):685 at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:607):607 at java.lang.Thread.run(Thread.java:662):662 |
