Sign In

Post #377959

Author
JediSage
Parent topic
Forum Search
Link to post in topic
https://originaltrilogy.com/post/id/377959/action/topic#377959
Date created
17-Sep-2009, 2:45 PM

Was searching for the term "Inglorious Basterds" (sans quotes) in Off Topic. First I tried Inglorious with no results. I then tried the whole title and got this error message.

The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error occurred near 'Basterds'. Expected ''''' in search condition 'Inglorious Basterds'.
 
The error occurred in E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumSearch.cfc: line 41
Called from E:\Inetpub\originaltrilogy.com\wwwroot\forum\search-results.cfm: line 26
Called from E:\Inetpub\originaltrilogy.com\wwwroot\forum\search-results.cfm: line 1
Called from E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumSearch.cfc: line 41
Called from E:\Inetpub\originaltrilogy.com\wwwroot\forum\search-results.cfm: line 26
Called from E:\Inetpub\originaltrilogy.com\wwwroot\forum\search-results.cfm: line 1
39 : 		
40 : >
41 : exec prcForumSearchPostFullText #arguments.SearchID#, #arguments.GroupID#
42 :
43 :

SQL    exec prcForumSearchPostFullText 15988, 2
DATASOURCE   ot_forum
VENDORERRORCODE   7631
SQLSTATE   HY000
Resources:

 

Browser   Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 (.NET CLR 3.5.30729)
Remote Address   75.144.196.245
Referrer   http://originaltrilogy.com/forum/search-results.cfm/Inglorious/search/15987/
Date/Time   17-Sep-09 01:43 PM
Stack Trace
at cfForumSearch2ecfc561348969$funcFORUMSEARCHRESULTS.runFunction(E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumSearch.cfc:41) at cfsearch2dresults2ecfm1414989553._factor2(E:\Inetpub\originaltrilogy.com\wwwroot\forum\search-results.cfm:26) at cfsearch2dresults2ecfm1414989553.runPage(E:\Inetpub\originaltrilogy.com\wwwroot\forum\search-results.cfm:1) at cfForumSearch2ecfc561348969$funcFORUMSEARCHRESULTS.runFunction(E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumSearch.cfc:41) at cfsearch2dresults2ecfm1414989553._factor2(E:\Inetpub\originaltrilogy.com\wwwroot\forum\search-results.cfm:26) at cfsearch2dresults2ecfm1414989553.runPage(E:\Inetpub\originaltrilogy.com\wwwroot\forum\search-results.cfm:1)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error occurred near 'Basterds'. Expected ''''' in search condition 'Inglorious Basterds'.
at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at macromedia.jdbc.base.BaseStatement.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
at coldfusion.sql.Executive.executeQuery(Executive.java:775)
at coldfusion.sql.Executive.executeQuery(Executive.java:685)
at coldfusion.sql.Executive.executeQuery(Executive.java:646)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500)
at cfForumSearch2ecfc561348969$funcFORUMSEARCHRESULTS.runFunction(E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumSearch.cfc:41)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594)
at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:341)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1916)
at cfsearch2dresults2ecfm1414989553._factor2(E:\Inetpub\originaltrilogy.com\wwwroot\forum\search-results.cfm:26)
at cfsearch2dresults2ecfm1414989553.runPage(E:\Inetpub\originaltrilogy.com\wwwroot\forum\search-results.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:219)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at com.seefusion.Filter.doFilter(Filter.java:49)
at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1494)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)