|
| 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 'order by rand()' at line 14 |
| 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 'order by rand()' at line 14 |
| SQL |
select p.properties_id, p.properties_ref, c.categories_name, v.villages_name, i.thumb, p.properties_price from imdb_properties p
left join imdb_categories as c on c.categories_id = p.category_id and c.languages_id = 2
left join imdb_villages as v on v.villages_id = p.villages_id and v.languages_id = 2
left join imdb_images as i on i.properties_id = p.properties_id and i.position = 1
where p.properties_id != 421
and p.properties_miet = 0
and p.properties_status = 1
and i.thumb is not NULL
and p.properties_price < '0'
and p.properties_price > '0'
and p.category_id = 0
and p.villages_id = 0
and p.properties_miet =
order by rand()
|
| Stacktrace |
The Error Occurred in
/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/imdb/global.cfc: line 502
500: and p.category_id = #val(loc.qSimilar.category_id)#
501: and p.villages_id = #val(loc.qSimilar.villages_id)#
502: and p.properties_miet = #(loc.qSimilar.properties_miet)#
503: order by rand()
504: </cfquery>
called from/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/imdb/global.cfc: line 249
247: <cfset loc.outHTML = loc.outHTML & "<p style=""padding: 0 0 2px 19px;""><strong>#application.cms.global.langXML('script09','aehnliche_objekte',loc.request)#</strong></p><br />">
248: <!--- </cfif> --->
249: <cfset loc.outHTML = loc.outHTML & "#similar(loc.id,loc.request,loc.imLang)#<img src=""#loc.lpath#b.gif"" width=""150"" height=""5"" border=""0"" alt="""" /></td>">
250: <cfset loc.outHTML = loc.outHTML & "</tr></table>">
251: <cfreturn loc.outHTML>
called from/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/elemente/script_09a.cfm: line 100
98: <cfelse>
99: <cfoutput>#application.imdb.suche.top(this_langID,url.prodid,imdbSuch,request)#</cfoutput>
100: <cfoutput>#application.imdb.global.details(url.id,url.prodid,this_langID,url.bpos,lpath,request)#</cfoutput>
101: </cfif>
102: <cfif session_mm eq 1 and isdefined("session.user") and session.edit eq 1>
called from/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/layout/home_proddetails.cfm: line 135
133: <!--- nur zum testen auskommentiert --->
134: <cfif session_mm eq 0 or (session_mm eq 1 and isdefined("url.up_element") is false)>
135: <cfinclude template="../elemente/#get_el.e_ausgabe_script#">
136: </cfif>
137: <!--- <cfif isdefined("url.dump") and url.dump eq "yes">
called from/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/home/home_content.cfm: line 2
1: <cfif isdefined("url.admin") is false>
2: <cfinclude template="/WEB-INF/mio/bin/layout/home_proddetails.cfm">
3: </cfif>
4:
called from/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/layout/home_cont_lg.cfm: line 19
17: <cfinclude template="../layout/home_navigation_la.cfm">
18: <cfoutput></td>#chr(10)#<td class="cont_mBig"></cfoutput>
19: <cfinclude template="../home/home_content.cfm"><!--- <cfoutput><cfdump var="#request#"></cfoutput> --->
20: <cfoutput></td></tr></table>#chr(10)#</cfoutput>
21: <cfinclude template="home_footer.cfm">
called from/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/layout/home_layout01.cfm: line 65
63: <cfelse>
64: <cfif pageAnzZellen eq 2>
65: <cfinclude template="home_cont_lg.cfm">
66: <cfelseif pageAnzZellen eq 1>
67: <cfinclude template="home_cont_fat.cfm">
called from/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/home/home_start.cfm: line 159
157: <cfset ebene_alt = ebene>
158: <!--- <cfinclude template="home_back.cfm"> --->
159: <cfinclude template="#layout#">
160: </cfif>
161:
called from/var/www/www.lucie-hauri.com/ROOT/de/home.cfm: line 2
1: <cfsetting enablecfoutputonly="Yes" showdebugoutput="Yes">
2: <cfinclude template="/WEB-INF/mio/bin/home/home_start.cfm">
3: <cfsetting enablecfoutputonly="No" showdebugoutput="Yes">
|
| 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 rand()' at line 14
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.imdb.global$cfc.udfCall2(/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/imdb/global.cfc:502):502
at web_inf180.mio.bin.imdb.global$cfc.udfCall(/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/imdb/global.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.util.VariableUtilImpl.callFunctionWithoutNamedValues(Unknown Source):-1
at railo.runtime.PageContextImpl.getFunction(Unknown Source):-1
at web_inf180.mio.bin.imdb.global$cfc.udfCall1(/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/imdb/global.cfc:249):249
at web_inf180.mio.bin.imdb.global$cfc.udfCall(/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/imdb/global.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.elemente.script_09a$cfm.call(/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/elemente/script_09a.cfm:100):100
at railo.runtime.PageContextImpl.include(Unknown Source):-1
at railo.runtime.PageContextImpl.include(Unknown Source):-1
at web_inf180.mio.bin.layout.home_proddetails$cfm.call(/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/layout/home_proddetails.cfm:135):135
at railo.runtime.PageContextImpl.include(Unknown Source):-1
at railo.runtime.PageContextImpl.include(Unknown Source):-1
at web_inf180.mio.bin.home.home_content$cfm.call(/var/www/www.lucie-hauri.com/ROOT/WEB-INF/mio/bin/home/home_content.cfm:2):2
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:19):19
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:269):269
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188):188
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213):213
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172):172
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127):127
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117):117
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108):108
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174):174
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200):200
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291):291
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775):775
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704):704
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897):897
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689):689
at java.lang.Thread.run(Thread.java:662):662
|
|
