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

Vote For The 2021 BroadwayWorld Connecticut Awards; First Stats Announced!

This year's regional awards include in-person and streaming categories.

By: Dec. 06, 2021
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 5.3.8.206 Error (database)
MessageYou 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

Guest Artists Set For Connecticut Ballet's THE NUTCRACKER
Video: Jumpstart Your Career on Stage and Screen with AMDA College of the Performing Arts
The Bad Boys Of Reggae Inner Circle To Perform at United Banquet Hall
Registration Open For Winter Classes For Kids at Playhouse Theatre Academy
where btype = "Theater You''''re Most Ex' at line 1
SQLselect prod,company,copy,votes,id,((votes/) * 100) as percvotes
from buyersg2015

where btype = "Theater You''''re Most Excited To Get Back To (Professional)"

and region like "%Connecticut%"
and year = 2021

order by votes desc

limit 0,3
DatabaseNameMySQL
DatabaseVersion5.7.12
DriverNameMySQL Connector/J
DriverVersionmysql-connector-java-8.0.24 (Revision: 4f7120a617b9d5efb9dedda9064b9896db424a60)
Datasourcebwwacread
StacktraceThe Error Occurred in
/home/bway/public_html/bway/includes/createawardsstoryregion.cfm: line 86
84: limit 0,3
85: </cfif>
86: </cfquery>
87: <cfoutput query=first>
88: <Cfif #prod# is not ''>#Prod# </Cfif>

Java Stacktracelucee.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 = "Theater You''''re Most Ex' 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.<init>(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 connecticut.includes.createawardsstoryregion_cfm$cf.call(/connecticut/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)
  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.lang.Thread.run(Thread.java:748)
 
Timestamp12/6/21 12:27:18 PM EST



Comments

To post a comment, you must register and login.



Watch Next on Stage



Videos