Neuzugänge

mehr




Bestleiher

mehr




Railo 4.2.1.008 Error (database)
Message
Detail Unknown column 'c.cat_id' in 'where clause'
SQL
select * from book_category where c.cat_id in (3194,9198)
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/m/cfg/library2/dsp_footer.cfm: line 219
217: <cfquery datasource="#attributes.dbname#" name="qry_getMetaCatejournal#SESSION_SHOP.LIBRARY_ID#" cachedwithin="#CreateTimeSpan(30,3,0,0)#">
218: select * from book_category where c.cat_id in (3194,9198)
219: </cfquery>
220:
221: <!--- nur spezielle Unterkategorien f�r audiobooks --->

called from /var/www/vhost1/ROOT/m/dsp_footer.cfm: line 38
called from /var/www/vhost1/ROOT/m/index.cfm: line 43
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: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.(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 m.cfg.library2.dsp_footer_cfm$cf.call(/var/www/vhost1/ROOT/m/cfg/library2/dsp_footer.cfm:219):219
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:813):813
  at m.dsp_footer_cfm$cf.call(/var/www/vhost1/ROOT/m/dsp_footer.cfm:38):38
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:813):813
  at m.index_cfm$cf.call(/var/www/vhost1/ROOT/m/index.cfm:43):43
  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 19.03.24 03:26:35 MEZ