Railo 4.1.2.005 Error (database)
Message
Detail This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
SQL

SELECT

cms_post.*,
cms_channel.slug as "channel_slug",
cms_channel.name as "channel_name",
cms_image.image,
concat ("/noticias/", cms_channel.slug, "/", cms_post.slug, ".phtml") as "permalink",
cms_post_listed_channel.channel_id as "otherchannel_id",
getChannelSlug(cms_post_listed_channel.channel_id) as "otherchannel_slug"


FROM

cms_post, cms_channel, cms_image , cms_post_listed_channel

WHERE
cms_post.site_id = 15 AND

cms_post.deleted = 'N' AND
cms_post.published = 1 AND
cms_post.date_available < NOW() AND

cms_post.channel_id = cms_channel.id AND
cms_post.main_image_id = cms_image.id AND

cms_post.id = cms_post_listed_channel.post_id

ORDER BY
cms_post.date_available DESC

LIMIT 3000;

DatabaseName MySQL
DatabaseVersion 5.6.37-log
DriverName MySQL-AB JDBC Driver
DriverVersion mysql-connector-java-5.1.20 ( Revision: tonci.grgin@oracle.com-20111003110438-qfydx066wsbydkbw )
Datasource orinoco
Stacktrace The Error Occurred in
C:\Fast-CMS\webapps\www\orinoco\publicador\console\application-content-templates.cfm: line 260
258:
259: WHERE
260: cms_post.site_id = #CodeSiteId# AND
261:
262: cms_post.deleted = 'N' AND

called from C:\Fast-CMS\webapps\www\orinoco\publicador\application.cfm: line 13
Java Stacktrace
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073):1073
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096):4096
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028):4028
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:951):951
  at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1929):1929
  at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3412):3412
  at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:481):481
  at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3118):3118
  at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2288):2288
  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2709):2709
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2677):2677
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2627):2627
  at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:841):841
  at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681):681
  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:209):209
  at railo.runtime.type.QueryImpl.(QueryImpl.java:224):224
  at railo.runtime.tag.Query.executeDatasoure(Query.java:656):656
  at railo.runtime.tag.Query.doEndTag(Query.java:502):502
  at orinoco.publicador.console.application_content_templates_cfm1440$cf.call(C:\Fast-CMS\webapps\www\orinoco\publicador\console\application-content-templates.cfm:260):260
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:838):838
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:785):785
  at orinoco.publicador.application_cfm$cf.call(C:\Fast-CMS\webapps\www\orinoco\publicador\application.cfm:13):13
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:838):838
  at railo.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:30):30
  at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:19):19
  at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2135):2135
  at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2102):2102
  at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:332):332
  at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:848):848
  at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:686):686
  at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501):501
  at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137):137
  at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557):557
  at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231):231
  at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086):1086
  at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:428):428
  at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193):193
  at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020):1020
  at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135):135
  at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:255):255
  at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154):154
  at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116):116
  at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:317):317
  at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116):116
  at org.eclipse.jetty.server.Server.handle(Server.java:370):370
  at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489):489
  at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:949):949
  at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1011):1011
  at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644):644
  at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235):235
  at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82):82
  at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:668):668
  at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52):52
  at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608):608
  at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543):543
  at java.lang.Thread.run(Unknown Source):-1
 
Timestamp 9/25/17 10:19:54 AM BRT