Error Occurred While Processing Request 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 'or or or or or or or or ) group by e' at line 26
 
The error occurred in C:\webroot\platform\prototype\shared\decorators\metadata\jCFC_types.cfc: line 1357
Called from C:\webroot\platform\prototype\shared\modules\search\global\search.cfm: line 7
Called from C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm: line 610
Called from C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm: line 27
Called from C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm: line 26
Called from C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm: line 1
Called from C:\webroot\platform\prototype\shared\layers\content.cfc: line 64
Called from C:\webroot\platform\prototype\shared\layers\content.cfc: line 52
Called from C:\webroot\platform\prototype\shared\engine\app.cfc: line 127
Called from C:\webroot\platform\prototype\shared\engine\app.cfc: line 218
Called from C:\webroot\platform\prototype\shared\decorators\metadata\jCFC_types.cfc: line 1357
Called from C:\webroot\platform\prototype\shared\modules\search\global\search.cfm: line 7
Called from C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm: line 610
Called from C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm: line 27
Called from C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm: line 26
Called from C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm: line 1
Called from C:\webroot\platform\prototype\shared\layers\content.cfc: line 64
Called from C:\webroot\platform\prototype\shared\layers\content.cfc: line 52
Called from C:\webroot\platform\prototype\shared\engine\app.cfc: line 127
Called from C:\webroot\platform\prototype\shared\engine\app.cfc: line 218
1355 :                 )
1356 : 
1357 :                 group by #v.ct#.id_#t#
1358 : 
1359 :             )

VENDORERRORCODE   1064
SQLSTATE   42000
SQL    ( select events.id_events as id, events.name as label, events.display as link, events.teaser as snippet, events.description as altText, 'events' as type, cast( 'exempt' as char ) as topics from events where ids_events = 1 AND ( or or or or or or or or ) group by events.id_events ) union ( select listings.id_listings as id, listings.name as label, listings.display as link, listings.teaser as snippet, listings.description as altText, 'listings' as type, group_concat( cast( ltxxx.idt as char ) ) as topic from listings left outer join listings__topics ltxxx on listings.id_listings = ltxxx.id_listings left outer join listings__attractions__link on listings.id_listings = listings__attractions__link.id_listings left outer join attractions on listings__attractions__link.id_attractions = attractions.id_attractions left outer join listings__businesses__link on listings.id_listings = listings__businesses__link.id_listings left outer join businesses on listings__businesses__link.id_businesses = businesses.id_businesses left outer join listings__conference_facilities__link on listings.id_listings = listings__conference_facilities__link.id_listings left outer join conference_facilities on listings__conference_facilities__link.id_conference_facilities = conference_facilities.id_conference_facilities left outer join listings__coupon__link on listings.id_listings = listings__coupon__link.id_listings left outer join coupon on listings__coupon__link.id_coupon = coupon.id_coupon left outer join listings__dining__link on listings.id_listings = listings__dining__link.id_listings left outer join dining on listings__dining__link.id_dining = dining.id_dining left outer join listings__lodging__link on listings.id_listings = listings__lodging__link.id_listings left outer join lodging on listings__lodging__link.id_lodging = lodging.id_lodging left outer join listings__press_releases__link on listings.id_listings = listings__press_releases__link.id_listings left outer join press_releases on listings__press_releases__link.id_press_releases = press_releases.id_press_releases where ids_listings = 1 AND ( or or or or or or or or or or or or or or or or or or or or or or or ) group by listings.id_listings ) union ( select pages.id_pages as id, pages.title as label, pages.display as link, pages.meta_description as snippet, pages.intro_text as altText, 'pages' as type, cast( 'exempt' as char ) as topics from pages left outer join pages__page_sections__link on pages.id_pages = pages__page_sections__link.id_pages left outer join page_sections on pages__page_sections__link.id_page_sections = page_sections.id_page_sections where ids_pages = 1 AND ( or or or or or or or or or ) group by pages.id_pages ) order by label
DATASOURCE   abilenevisitors
Resources:

Browser   CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address   38.107.179.221
Referrer  
Date/Time   07-Feb-12 10:53 AM
Stack Trace
at cfjCFC_types2ecfc1400369700$funcGLOBALSEARCH.runFunction(C:\webroot\platform\prototype\shared\decorators\metadata\jCFC_types.cfc:1357) at cfsearch2ecfm1655531468.runPage(C:\webroot\platform\prototype\shared\modules\search\global\search.cfm:7) at cfpageContent2ecfm1301161118._factor19(C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm:610) at cfpageContent2ecfm1301161118._factor20(C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm:27) at cfpageContent2ecfm1301161118._factor21(C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm:26) at cfpageContent2ecfm1301161118.runPage(C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm:1) at cfcontent2ecfc2102950302$funcRENDERCONTENT._factor0(C:\webroot\platform\prototype\shared\layers\content.cfc:64) at cfcontent2ecfc2102950302$funcRENDERCONTENT.runFunction(C:\webroot\platform\prototype\shared\layers\content.cfc:52) at cfapp2ecfc1189240969$funcEXECUTELAYERTRIGGERS.runFunction(C:\webroot\platform\prototype\shared\engine\app.cfc:127) at cfapp2ecfc1189240969$funcONREQUESTEND.runFunction(C:\webroot\platform\prototype\shared\engine\app.cfc:218) at cfjCFC_types2ecfc1400369700$funcGLOBALSEARCH.runFunction(C:\webroot\platform\prototype\shared\decorators\metadata\jCFC_types.cfc:1357) at cfsearch2ecfm1655531468.runPage(C:\webroot\platform\prototype\shared\modules\search\global\search.cfm:7) at cfpageContent2ecfm1301161118._factor19(C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm:610) at cfpageContent2ecfm1301161118._factor20(C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm:27) at cfpageContent2ecfm1301161118._factor21(C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm:26) at cfpageContent2ecfm1301161118.runPage(C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm:1) at cfcontent2ecfc2102950302$funcRENDERCONTENT._factor0(C:\webroot\platform\prototype\shared\layers\content.cfc:64) at cfcontent2ecfc2102950302$funcRENDERCONTENT.runFunction(C:\webroot\platform\prototype\shared\layers\content.cfc:52) at cfapp2ecfc1189240969$funcEXECUTELAYERTRIGGERS.runFunction(C:\webroot\platform\prototype\shared\engine\app.cfc:127) at cfapp2ecfc1189240969$funcONREQUESTEND.runFunction(C:\webroot\platform\prototype\shared\engine\app.cfc:218)

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 'or  or  or  or  or  or  or  or 
                )

                group by e' at line 26
	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:406)
	at com.mysql.jdbc.Util.getInstance(Util.java:381)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1051)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2687)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2616)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:782)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:879)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1364)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1127)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1058)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
	at cfjCFC_types2ecfc1400369700$funcGLOBALSEARCH.runFunction(C:\webroot\platform\prototype\shared\decorators\metadata\jCFC_types.cfc:1357)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2360)
	at cfsearch2ecfm1655531468.runPage(C:\webroot\platform\prototype\shared\modules\search\global\search.cfm:7)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
	at cfpageContent2ecfm1301161118._factor19(C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm:610)
	at cfpageContent2ecfm1301161118._factor20(C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm:27)
	at cfpageContent2ecfm1301161118._factor21(C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm:26)
	at cfpageContent2ecfm1301161118.runPage(C:\webroot\platform\prototype\shared\modules\content\pageContent.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
	at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:271)
	at cfcontent2ecfc2102950302$funcRENDERCONTENT._factor0(C:\webroot\platform\prototype\shared\layers\content.cfc:64)
	at cfcontent2ecfc2102950302$funcRENDERCONTENT.runFunction(C:\webroot\platform\prototype\shared\layers\content.cfc:52)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:517)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:496)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:355)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2301)
	at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:389)
	at cfapp2ecfc1189240969$funcEXECUTELAYERTRIGGERS.runFunction(C:\webroot\platform\prototype\shared\engine\app.cfc:127)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
	at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2582)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2383)
	at cfapp2ecfc1189240969$funcONREQUESTEND.runFunction(C:\webroot\platform\prototype\shared\engine\app.cfc:218)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337)
	at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88)
	at coldfusion.runtime.AppEventInvoker.onRequestEnd(AppEventInvoker.java:323)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:377)
	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:200)
	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)