kaufverkaufmietobjektemerkzettelkontakt

Sie befinden sich hier:
Railo 2.0.2.002 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 'and languages_id = 2' at line 1
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 'and languages_id = 2' at line 1
SQL select categories_name from imdb_categories where categories_id = and languages_id = 2
Stacktrace The Error Occurred in
/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/cms/Navigation.cfc: line 160
158: </cfif>
159: <cfif isdefined("local.request.form.fkategorie") and local.request.form.fkategorie neq 0>
160: <cfquery datasource="#application.init.db#" name="local.qKatNa">select categories_name from imdb_categories where categories_id = #local.request.form.fkategorie# and languages_id = #local.langID#</cfquery>
161: <cfset local.outHtml = local.outHTML & "&nbsp;&nbsp;&raquo;&nbsp;&nbsp;<a href=""#application.cms.linkgen.mioLinker(local.prodid,'&back=#local.prodid#,#local.request.form.fkategorie#,0')#"" class=""plink"">#local.qKatNa.categories_name#</a>">
162: </cfif>

called from/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/layout/home_header.cfm: line 61
called from/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/layout/home_cont_lg.cfm: line 15
called from/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/layout/home_layout01.cfm: line 65
called from/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/home/home_start.cfm: line 159
called from/var/www/www.lucie-hauri.com/ROOT/de/home.cfm: line 2
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 'and languages_id = 2' at line 1
	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:3249):3249
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3178):3178
	at com.mysql.jdbc.Statement.execute(Statement.java:711):711
	at railo.runtime.type.QueryImpl.<init>(Unknown Source):-1
	at railo.runtime.tag.Query.a(Unknown Source):-1
	at railo.runtime.tag.Query.doEndTag(Unknown Source):-1
	at web_inf180.mio.bin.cms.navigation$cfc.udfCall1(/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/cms/Navigation.cfc:160):160
	at web_inf180.mio.bin.cms.navigation$cfc.udfCall(/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/cms/Navigation.cfc):-1
	at railo.runtime.type.UDF.implementation(Unknown Source):-1
	at railo.runtime.type.UDF.a(Unknown Source):-1
	at railo.runtime.type.UDF.call(Unknown Source):-1
	at railo.runtime.ComponentImpl.a(Unknown Source):-1
	at railo.runtime.ComponentImpl._call(Unknown Source):-1
	at railo.runtime.ComponentImpl.call(Unknown Source):-1
	at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(Unknown Source):-1
	at railo.runtime.PageContextImpl.getFunction(Unknown Source):-1
	at web_inf180.mio.bin.layout.home_header$cfm.call(/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/layout/home_header.cfm:61):61
	at railo.runtime.PageContextImpl.include(Unknown Source):-1
	at railo.runtime.PageContextImpl.include(Unknown Source):-1
	at web_inf180.mio.bin.layout.home_cont_lg$cfm.call(/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/layout/home_cont_lg.cfm:15):15
	at railo.runtime.PageContextImpl.include(Unknown Source):-1
	at railo.runtime.PageContextImpl.include(Unknown Source):-1
	at web_inf180.mio.bin.layout.home_layout01$cfm.call(/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/layout/home_layout01.cfm:65):65
	at railo.runtime.PageContextImpl.include(Unknown Source):-1
	at railo.runtime.PageContextImpl.include(Unknown Source):-1
	at web_inf180.mio.bin.home.home_start$cfm.call(/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/home/home_start.cfm:159):159
	at railo.runtime.PageContextImpl.include(Unknown Source):-1
	at railo.runtime.PageContextImpl.include(Unknown Source):-1
	at de.home$cfm.call(/var/www/www.lucie-hauri.com/ROOT/de/home.cfm:2):2
	at railo.runtime.PageContextImpl.include(Unknown Source):-1
	at railo.runtime.listener.ClassicAppListener._onRequest(Unknown Source):-1
	at railo.runtime.listener.MixedAppListener.onRequest(Unknown Source):-1
	at railo.runtime.PageContextImpl.execute(Unknown Source):-1
	at railo.runtime.engine.CFMLEngineImpl.serviceCFML(Unknown Source):-1
	at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32):32
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802):802
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252):252
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173):173
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213):213
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178):178
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126):126
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105):105
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107):107
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148):148
	at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199):199
	at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282):282
	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767):767
	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697):697
	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889):889
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684):684
	at java.lang.Thread.run(Thread.java:595):595