Lucee 5.3.8.206 Error (database)A messageYou have an error in your SQL syntax; consult the manual that corresponds to the version of your MySQL server for the correct syntax to use near ‘) * 100) as percvotes
from buyersg2015 where btype = “Theater You’re Most Exci ‘at line 1SQLselect prod, company, copy, votes, id, ((votes /) * 100) as percvotes
from buyersg2015 where btype = “Theater You’re Most Excited To Get Back To (Professional)” and a region like “% Boston%”
and year = 2021 order by votes to limit 0.3Name of the data baseMySQLDatabaseVersion5.7.12Driver’s nameMySQL / J connectorDriverVersionmysql-connector-java-8.0.24 (Revision: 4f7120a617b9d5efb9dedda9064b9896db424a60)The data sourcebwwacreadStack traceThe error occurred in
/home/bway/public_html/bway/includes/createawardsstoryregion.cfm: line 86

84: limit 0.3
85:
86:
87:
88: # Prod #

Java stack tracelucee.runtime.exp.DatabaseException: You have an error in your SQL syntax; consult the manual that corresponds to the version of your MySQL server for the correct syntax to use near ‘) * 100) as percvotes
buyersg2015

where btype = “Theater You’re Most Exci ‘at line 1
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException (SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException (SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeInternal (StatementImpl.java:762)
at com.mysql.cj.jdbc.StatementImpl.execute (StatementImpl.java:646)
at lucee.runtime.type.util.QueryUtil.execute (QueryUtil.java:320)
at lucee.runtime.type.QueryImpl.execute (QueryImpl.java:287)
at lucee.runtime.type.QueryImpl.(QueryImpl.java:235)
at lucee.runtime.tag.Query.executeDatasoure (Query.java:1134)
at lucee.runtime.tag.Query._doEndTag (Query.java:699)
at lucee.runtime.tag.Query.doEndTag (Query.java:565)
at boston.includes.createawardsstoryregion_cfm $ cf.call (/boston/includes/createawardsstoryregion.cfm:86)
at lucee.runtime.PageContextImpl._doInclude (PageContextImpl.java:1034)
at lucee.runtime.PageContextImpl._doInclude (PageContextImpl.java:926)
at lucee.runtime.listener.ClassicAppListener._onRequest (ClassicAppListener.java:65)
at lucee.runtime.listener.MixedAppListener.onRequest (MixedAppListener.java:45)
at lucee.runtime.PageContextImpl.execute (PageContextImpl.java:2460)
at lucee.runtime.PageContextImpl._execute (PageContextImpl.java:2450)
at lucee.runtime.PageContextImpl.executeCFML (PageContextImpl.java:2421)
at lucee.runtime.engine.Request.exe (Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service (CFMLEngineImpl.java:1179)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML (CFMLEngineImpl.java:1125)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML (CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service (CFMLServlet.java:51)
on javax.servlet.http.HttpServlet.service (HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:162)
on org.apache.tomcat.websocket.server.WsFilter.doFilter (WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:197)
on org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke (AuthenticatorBase.java:540)
at org.apache.catalina.core.StandardHostValve.invoke (StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java:357)
on org.apache.coyote.http11.Http11Processor.service (Http11Processor.java:382)
at org.apache.coyote.AbstractProcessorLight.process (AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol $ ConnectionHandler.process (AbstractProtocol.java:895)
on org.apache.tomcat.util.net.NioEndpoint $ SocketProcessor.doRun (NioEndpoint.java:1722)
on org.apache.tomcat.util.net.SocketProcessorBase.run (SocketProcessorBase.java:49)
on org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker (ThreadPoolExecutor.java:1191)
on org.apache.tomcat.util.threads.ThreadPoolExecutor $ Worker.run (ThreadPoolExecutor.java:659)
on org.apache.tomcat.util.threads.TaskThread $ WrappingRunnable.run (TaskThread.java:61)
at java.lang.Thread.run (Thread.java:748)
Timestamp12/6/21 12:27:13 PM EST