Lucee 5.1.4.19 Error (database)
Message
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 jde9e3_1_4a8pon_posts.post_title' at line 14
SQL select id,
post_title,
post_content,
post_parent,
post_name
from
jde9e3_1_4a8pon_posts
where
jde9e3_1_4a8pon_posts.post_type = 'page' AND
jde9e3_1_4a8pon_posts.post_status = 'publish' AND
jde9e3_1_4a8pon_posts.post_name = '8622' AND
jde9e3_1_4a8pon_posts.post_parent =

ORDER BY jde9e3_1_4a8pon_posts.post_title
DatabaseName MySQL
DatabaseVersion 5.5.44-0+deb8u1
DriverName MySQL Connector Java
DriverVersion mysql-connector-java-5.1.38 ( Revision: fe541c166cec739c74cc727c5da96c1028b4834a )
Datasource decea
Stacktrace The Error Occurred in
/var/www/html/www.decea.gov.br/Application.cfm: line 97
95:
96: ORDER BY #prefix#_posts.post_title
97: </cfquery>
98: <!---</cfif>--->
99:

Java Stacktrace lucee.runtime.exp.DatabaseException:
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
  at com.mysql.jdbc.Util.getInstance(Util.java:387)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
  at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
  at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1192)
  at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:301)
  at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:275)
  at lucee.runtime.type.QueryImpl.(QueryImpl.java:221)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:864)
  at lucee.runtime.tag.Query.doEndTag(Query.java:622)
  at application_cfm$cf.call(/Application.cfm:97)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:928)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:842)
  at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:54)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2408)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2398)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2366)
  at lucee.runtime.engine.Request.run(Request.java:34)
 
Timestamp 23/11/17 7h25min55s BRST