© 2008-2024 ciando GmbH
| Impressum
| Datenschutzbestimmungen
| Kontakt
| F.A.Q.
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)#">called from /var/www/vhost1/ROOT/m/dsp_footer.cfm: line 38 36: </cfif>called from /var/www/vhost1/ROOT/m/index.cfm: line 43 41: |
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. 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 |