Photo Flash: NYMF Rings the NASDAQ Opening Bell

Photo Flash: NYMF Rings the NASDAQ Opening Bell


Photo Flash: In Rehearsal with NYMF Opener MOSES MANPhoto Flash: In Rehearsal with NYMF Opener MOSES MAN
Photo Flash: Sneak Peek at ACAPPELLA, Coming to NYMF This MonthPhoto Flash: Sneak Peek at ACAPPELLA, Coming to NYMF This Month
Photo Flash: First Look at SONGS FOR THE FALLEN at NYMFPhoto Flash: First Look at SONGS FOR THE FALLEN at NYMF

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.id <> and columntable.status = 1 group by columntable.mainswap' at line 8
 
The error occurred in /home/bway/public_html/bway/nymf/rightindexregional.cfm: line 262
Called from /home/bway/public_html/bway/nymf/rightindexregional.cfm: line 1
Called from /home/bway/public_html/bway/nymf/rightindexregional.cfm: line 262
Called from /home/bway/public_html/bway/nymf/rightindexregional.cfm: line 1
260 : <Cfif #dirme# eq 'westend'>
261 : limit 0,30
262 : <Cfelse>
263 : limit 0,20
264 : </cfif>

VENDORERRORCODE   1064
SQLSTATE   42000
SQL    SELECT columntable.id as colid, columntable.AuthorName, columntable.seo_friendly,columntable.Title, columntable.Blurb, columntable.DatePosted, columntable.MainSwap,columntable.mainswapbig,columntable.short_title FROM columntable inner join regionstable on columntable.id = regionstable.colid WHERE regionstable.regionsid = 8 and columntable.id > 800000 and columntable.id <> and columntable.id <> and columntable.status = 1 group by columntable.mainswap order by columntable.dateposted desc limit 0,20
DATASOURCE   bww
Resources:

Browser   ColdFusion
Remote Address   68.68.101.194
Referrer  
Date/Time   01-Jul-15 06:14 PM
Stack Trace
at cfrightindexregional2ecfm1553259847._factor8(/home/bway/public_html/bway/nymf/rightindexregional.cfm:262) at cfrightindexregional2ecfm1553259847.runPage(/home/bway/public_html/bway/nymf/rightindexregional.cfm:1) at cfrightindexregional2ecfm1553259847._factor8(/home/bway/public_html/bway/nymf/rightindexregional.cfm:262) at cfrightindexregional2ecfm1553259847.runPage(/home/bway/public_html/bway/nymf/rightindexregional.cfm:1)

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.id <> 

and columntable.status = 1
group by columntable.mainswap' at line 8
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	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 cfrightindexregional2ecfm1553259847._factor8(/home/bway/public_html/bway/nymf/rightindexregional.cfm:262)
	at cfrightindexregional2ecfm1553259847.runPage(/home/bway/public_html/bway/nymf/rightindexregional.cfm:1)
	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)