Ticket Central Browse All Shows

ADDAMS FAMILY
C.R.O.W. - Children's Repertory of Oregon Workshops
(Runs 4/21 - 4/23)
BIG FISH
Albany Civic Theater
(Runs 2/10 - 3/4)
ADDAMS FAMILY
Springfield Little Theatre
(Runs 6/9 - 6/25)
BIG FISH
North Montgomery High School
(Runs 3/9 - 3/11)

VIEW ALL ADD A SHOW AUDITIONS

BWW Authors View More

Latest News More

The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

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 ') and columntable.dateposted > '2016-09-06' order by columntable.dateposted desc' at line 1
 
The error occurred in /home/bway/public_html/bway/nymf/2017/portus/indexnewregion.cfm: line 586
584 : <cfset toplist = ValueList(Gettop.id)>
585 : </Cfif>
586 : <cfquery name="getcolumnstt"datasource="#ds#" cachedwithin="#createtimespan(0,0,3,30)#">SELECT columntable.Title,columntable.short_title,columntable.mainswapbig as mainswap,columntable.seo_friendly FROM columntable inner join regionstable on regionstable.colid=columntable.id WHERE columntable.id > 1300000 and columntable.status=1 and(regionstable.regionsid = #regid#)and columntable.id not in (#toplist#) and columntable.dateposted > '#dateformat(daysvar3,'yyyy-mm-dd')#' order by columntable.dateposted desc
587 : limit 0,12
588 : </cfquery>

VENDORERRORCODE   1064
SQLSTATE   42000
SQL   SELECT columntable.Title,columntable.short_title,columntable.mainswapbig as mainswap,columntable.seo_friendly FROM columntable inner join regionstable on regionstable.colid=columntable.id WHERE columntable.id > 1300000 and columntable.status=1 and(regionstable.regionsid = 8)and columntable.id not in () and columntable.dateposted > '2016-09-06' order by columntable.dateposted desc limit 0,12
DATASOURCE   bww
Resources:

Browser   ColdFusion
Remote Address   68.68.101.194
Referrer  
Date/Time   05-Dec-16 06:21 PM
Stack Trace
at cfindexnewregion2ecfm292099701.runPage(/home/bway/public_html/bway/nymf/2017/portus/indexnewregion.cfm:586) at cfindexnewregion2ecfm292099701.runPage(/home/bway/public_html/bway/nymf/2017/portus/indexnewregion.cfm:586)

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ') and columntable.dateposted > '2016-09-06' order by columntable.dateposted desc' at line 1
	at sun.reflect.GeneratedConstructorAccessor178068.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
	at com.mysql.jdbc.Util.getInstance(Util.java:372)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2531)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2489)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:947)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1420)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1183)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1114)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
	at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:854)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:586)
	at cfindexnewregion2ecfm292099701.runPage(/home/bway/public_html/bway/nymf/2017/portus/indexnewregion.cfm:586)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:201)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)