struct
Cause
struct
ErrorCode 1064
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 'Memorial%' OR org.OrgName LIKE '%Soldiers' Memorial%' ' at line 27
SQLState 42000
StackTrace 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 'Memorial%' OR org.OrgName LIKE '%Soldiers' Memorial%' ' at line 27 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:1002) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1229) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533) at cfSearch2ecfm695812227._factor6(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:249) at cfSearch2ecfm695812227._factor14(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:40) at cfSearch2ecfm695812227._factor16(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:4) at cfSearch2ecfm695812227.runPage(D:\home\art-stl.com\wwwroot\artszipper\Search.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:342) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) 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:53) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) 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)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 249
RAW_TRACE at cfSearch2ecfm695812227._factor6(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:249)
TEMPLATE D:\home\art-stl.com\wwwroot\artszipper\Search.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_SEARCH
LINE 40
RAW_TRACE at cfSearch2ecfm695812227._factor14(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:40)
TEMPLATE D:\home\art-stl.com\wwwroot\artszipper\Search.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_SEARCH
LINE 4
RAW_TRACE at cfSearch2ecfm695812227._factor16(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:4)
TEMPLATE D:\home\art-stl.com\wwwroot\artszipper\Search.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_SEARCH
LINE 1
RAW_TRACE at cfSearch2ecfm695812227.runPage(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:1)
TEMPLATE D:\home\art-stl.com\wwwroot\artszipper\Search.cfm
TYPE CFML
Type com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
DataSource stlrac5
Detail 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 'Memorial%' OR org.OrgName LIKE '%Soldiers' Memorial%' ' at line 27
ErrorCode 42000
Message Error Executing Database Query.
NativeErrorCode 1064
RootCause
struct
ErrorCode 1064
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 'Memorial%' OR org.OrgName LIKE '%Soldiers' Memorial%' ' at line 27
SQLState 42000
StackTrace 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 'Memorial%' OR org.OrgName LIKE '%Soldiers' Memorial%' ' at line 27 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:1002) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1229) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533) at cfSearch2ecfm695812227._factor6(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:249) at cfSearch2ecfm695812227._factor14(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:40) at cfSearch2ecfm695812227._factor16(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:4) at cfSearch2ecfm695812227.runPage(D:\home\art-stl.com\wwwroot\artszipper\Search.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:342) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) 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:53) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) 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)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 249
RAW_TRACE at cfSearch2ecfm695812227._factor6(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:249)
TEMPLATE D:\home\art-stl.com\wwwroot\artszipper\Search.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_SEARCH
LINE 40
RAW_TRACE at cfSearch2ecfm695812227._factor14(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:40)
TEMPLATE D:\home\art-stl.com\wwwroot\artszipper\Search.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_SEARCH
LINE 4
RAW_TRACE at cfSearch2ecfm695812227._factor16(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:4)
TEMPLATE D:\home\art-stl.com\wwwroot\artszipper\Search.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_SEARCH
LINE 1
RAW_TRACE at cfSearch2ecfm695812227.runPage(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:1)
TEMPLATE D:\home\art-stl.com\wwwroot\artszipper\Search.cfm
TYPE CFML
Type com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
SQLState 42000
Sql SELECT distinct cce.EventUUID, cce.EventName, cce.EventDesc, cce.EventAgeRange, cce.AdultOnly, cce.isTicketed, cce.isRacFunded, cce.isTicketed, cce.isApproved, cce.isSpecialOffer, cce.SpecialOfferStartDate, cce.SpecialOfferEndDate, cce.EventImage, cce.OrgID, org.OrgName, org.UserUUID, ccc.OrderBy, '' AS VenueName, cce.VenueID, cce.VenueOtherName, ccc.CatID, ccc.CatName, ccc.CatIcon,ccc.CatID FROM CulCalEvents cce INNER JOIN CulCalCategories ccc ON ccc.CatID = cce.CatID INNER JOIN Organizations org ON org.OrgID = cce.OrgID WHERE cce.Active = 1 AND cce.EventUUID IN ( SELECT DISTINCT ccd.EventUUID FROM CulCalDates ccd WHERE DATE(ccd.CalDateEnd) >= {d '2013-05-22'} ORDER BY ccc.CatID ASC ) AND (org.OrgName LIKE '%Soldiers' Memorial%' OR org.OrgName LIKE '%Soldiers' Memorial%' OR cce.VenueOtherName = 'Soldiers' Memorial' )
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:595) at cfSearch2ecfm695812227._factor6(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:249) at cfSearch2ecfm695812227._factor14(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:40) at cfSearch2ecfm695812227._factor16(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:4) at cfSearch2ecfm695812227.runPage(D:\home\art-stl.com\wwwroot\artszipper\Search.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:342) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) 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:53) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at com.seefusion.Filter.doFilter(Filter.java:49) at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) 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) Caused by: 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 'Memorial%' OR org.OrgName LIKE '%Soldiers' Memorial%' ' at line 27 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:894) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:1002) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1229) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:843) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:533) ... 37 more
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 249
RAW_TRACE at cfSearch2ecfm695812227._factor6(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:249)
TEMPLATE D:\home\art-stl.com\wwwroot\artszipper\Search.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_SEARCH
LINE 40
RAW_TRACE at cfSearch2ecfm695812227._factor14(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:40)
TEMPLATE D:\home\art-stl.com\wwwroot\artszipper\Search.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_SEARCH
LINE 4
RAW_TRACE at cfSearch2ecfm695812227._factor16(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:4)
TEMPLATE D:\home\art-stl.com\wwwroot\artszipper\Search.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_SEARCH
LINE 1
RAW_TRACE at cfSearch2ecfm695812227.runPage(D:\home\art-stl.com\wwwroot\artszipper\Search.cfm:1)
TEMPLATE D:\home\art-stl.com\wwwroot\artszipper\Search.cfm
TYPE CFML
Type Database
queryError 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 'Memorial%' OR org.OrgName LIKE '%Soldiers' Memorial%' ' at line 27
where [empty string]