| additional | | SQL | | string |
select bf.*, b.bok_file_mask, b.bok_ol_for_epub
from book_format bf
inner join book b on bf.bok_id = b.bok_id
where bok_format_status = 1 and b.bok_id =
and bok_download_format in (1,3,45,46)
order by bok_download_format asc
| |
| | | DatabaseName | | | | DatabaseVersion | | | | DriverName | | string | MySQL-AB JDBC Driver | |
| | | DriverVersion | | string | mysql-connector-java-5.0.8 ( Revision: ${svn.Revision} ) | |
| | | Datasource | | |
| | | DataSource | | | | Detail | | string | 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 'and bok_download_format in (1,3,45,46)
order by bok_download_format asc' at line 5 | |
| | | ErrorCode | | | | Extended_Info | | | | ExtendedInfo | | | | Message | | | | NativeErrorCode | | | | queryError | | string |
select bf.*, b.bok_file_mask, b.bok_ol_for_epub
from book_format bf
inner join book b on bf.bok_id = b.bok_id
where bok_format_status = 1 and b.bok_id =
and bok_download_format in (1,3,45,46)
order by bok_download_format asc
| |
| | | Sql | | string |
select bf.*, b.bok_file_mask, b.bok_ol_for_epub
from book_format bf
inner join book b on bf.bok_id = b.bok_id
where bok_format_status = 1 and b.bok_id =
and bok_download_format in (1,3,45,46)
order by bok_download_format asc
| |
| | | SQLState | | | | StackTrace | | string |
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:3277):3277
at com.mysql.jdbc.Connection.execSQL(Connection.java:3206):3206
at com.mysql.jdbc.Statement.execute(Statement.java:727):727
at railo.runtime.db.driver.state.StateUtil.execute(StateUtil.java:19):19
at railo.runtime.db.driver.state.StateStatement.execute(StateStatement.java:25):25
at railo.runtime.type.util.QueryUtil.execute(QueryUtil.java:214):214
at railo.runtime.type.QueryImpl.<init>(QueryImpl.java:224):224
at railo.runtime.tag.Query.executeDatasoure(Query.java:687):687
at railo.runtime.tag.Query.doEndTag(Query.java:531):531
at shop.act_build_booklist_cfm$cf.call(/var/www/vhost1/ROOT/shop/act_build_booklist.cfm:102):102
at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909
at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:813):813
at shop.index_cfm$cf.call(/var/www/vhost1/ROOT/shop/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
| |
| | | TagContext | | 1 | | codePrintHTML | | string | 100: and bok_download_format in (1,3,45,46)<br>
101: order by bok_download_format asc<br>
<b>102: </cfquery></b><br>
103: <cfset get_all_download_formats = evaluate("get_all_download_formats#b#")><br>
104: <br>
| |
| | | codePrintPlain | | string | 100: and bok_download_format in (1,3,45,46)
101: order by bok_download_format asc
102: </cfquery>
103: <cfset get_all_download_formats = evaluate("get_all_download_formats#b#")>
104:
| |
| | | column | | | | id | | | | line | | | | Raw_Trace | | string | shop.act_build_booklist_cfm$cf.call(/var/www/vhost1/ROOT/shop/act_build_booklist.cfm:102) | |
| | | template | | string | /var/www/vhost1/ROOT/shop/act_build_booklist.cfm | |
| | | type | | |
| | | 2 | | codePrintHTML | | string | 53: <cfinclude template="act_prepare_booklist.cfm"><br>
54: <cfinclude template="dsp_head_order.cfm"><br>
<b>55: <cfinclude template="act_build_booklist.cfm"></b><br>
56: <cfinclude template="dsp_pagecontent.cfm"><br>
57: <cfinclude template="../dsp_footer.cfm"><br>
| |
| | | codePrintPlain | | string | 53: <cfinclude template="act_prepare_booklist.cfm">
54: <cfinclude template="dsp_head_order.cfm">
55: <cfinclude template="act_build_booklist.cfm">
56: <cfinclude template="dsp_pagecontent.cfm">
57: <cfinclude template="../dsp_footer.cfm">
| |
| | | column | | | | id | | | | line | | | | Raw_Trace | | string | shop.index_cfm$cf.call(/var/www/vhost1/ROOT/shop/index.cfm:55) | |
| | | template | | string | /var/www/vhost1/ROOT/shop/index.cfm | |
| | | type | | |
| |
| | | type | | | | where | | |
|
