Vote Now 2024 BroadwayWorld Omaha Awards
News on your favorite shows, specials & more!

Vote For The 2024 BroadwayWorld Omaha Awards; ANASTASIA at Lincoln Community Playhouse Leads Best Musical!

Voting continues through December 31, 2024.

By: Dec. 16, 2024
Vote For The 2024 BroadwayWorld Omaha Awards; ANASTASIA at Lincoln Community Playhouse Leads Best Musical! Image
Enter Your Email to Unlock This Article

Plus, get the best of BroadwayWorld delivered to your inbox, and unlimited access to our editorial content across the globe.




Existing user? Just click login.

Lucee 6.1.1.109-RC 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 ') * 100) as percvotes
from buyersg2015

LATEST NEWS

Voting Open for the Top 3 of Next On Stage: Season 5
ICYMI: Next On Stage: Season 5- Meet the Top 5
Find Out Who Makes the Next On Stage Top 5
Find Out Who Makes the Next On Stage Top 5
where btype = "Best Cabaret/Concert/Solo' at line 1
SQL select prod,company,copy,votes,id,((votes/) * 100) as percvotes
from buyersg2015

where btype = "Best Cabaret/Concert/Solo Performance"

and region like "%Nebraska%"
and year = 2024

order by votes desc

limit 0,25
DatabaseName MySQL
DatabaseVersion 8.0.39
DriverName MySQL Connector/J
DriverVersion mysql-connector-j-9.1.0 (Revision: cf2917ea44ae2e43a4514a33771035aa99de73bf)
Datasource bwwacread
Stacktrace The Error Occurred in
/home/bway/public_html/bway/admin2013/bwwawards/createawardsstoryregion.cfm: line 105
103: limit 0,25
104: </cfif>
105: </cfquery>
106:
107: <cfoutput query=first>
Java Stacktrace lucee.runtime.exp.DatabaseException: 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 ') * 100) as percvotes
 from buyersg2015
 
 where btype = "Best Cabaret/Concert/Solo' at line 1
  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:112)
  at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114)
  at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:837)
  at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:685)
  at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345)
  at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:296)
  at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:242)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:1128)
  at lucee.runtime.tag.Query._doEndTag(Query.java:695)
  at lucee.runtime.tag.Query.doEndTag(Query.java:560)
  at bwwawards.createawardsstoryregion_cfm$cf.call(/bwwawards/createawardsstoryregion.cfm:105)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1046)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940)
  at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:63)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:42)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2725)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2712)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2683)
  at lucee.runtime.engine.Request.exe(Request.java:45)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1159)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116)
  at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
  at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
  at 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)
  at 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)
  at 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)
  at 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)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1722)
  at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
  at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.base/java.lang.Thread.run(Thread.java:1583)
 
Timestamp 12/16/24 9:34:23 AM EST

Copyright 2024 Wisdom Digital Media


Comments

To post a comment, you must register and login.



Videos