logo Sign In

Post #332388

Author
RRS-1980
Parent topic
Search bug (?) Multiple duplicate results.....
Link to post in topic
https://originaltrilogy.com/post/id/332388/action/topic#332388
Date created
4-Oct-2008, 11:08 PM

How do I find my own posts only? Other forum software used to have "find all post by this user" option.

 

Look what I got when I used searching today:

Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Execution of a full-text operation failed. The catalog does not exist or is currently unavailable. Please retry the action again later and if this symptom persists, contact the system administrator.
 
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 : 		<cfif request.ForumSearchStatus eq "FullText">
40 : 			<cfquery name="qryForumSearchResults" datasource="#request.ForumDSN#" username="#request.ForumDBUsername#" password="#request.ForumDBPassword#" cachedwithin="#arguments.CacheTime#">
41 : 			exec prcForumSearchPostFullText #arguments.SearchID#, '#arguments.SearchTerm#', #arguments.GroupID#
42 : 			</cfquery>
43 : 		<cfelseif request.ForumSearchStatus eq "Titles">

SQL    exec prcForumSearchPostFullText 3637, 'games', 2
DATASOURCE   ot_forum
VENDORERRORCODE   7619
SQLSTATE   HY000
Resources:

 

Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Alexa Toolbar; MEGAUPLOAD 1.0; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 1.1.4322; Alexa Toolbar; MEGAUPLOAD 1.0)
Remote Address   89.206.4.66
Referrer   http://originaltrilogy.com/forum/
Date/Time   04-Oct-08 10:06 PM
Stack Trace (click to expand)
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]Execution of a full-text operation failed. The catalog does not exist or is currently unavailable. Please retry the action again later and if this symptom persists, contact the system administrator. 
	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.tds.TDSRequest.getRow(Unknown Source)
	at macromedia.jdbc.sqlserver.SQLServerImplResultSet.fetchAtPosition(Unknown Source)
	at macromedia.jdbc.base.BaseImplResultSet.next(Unknown Source)
	at macromedia.jdbc.base.BaseResultSet.next(Unknown Source)
	at coldfusion.sql.QueryTable.populate(QueryTable.java:287)
	at coldfusion.sql.QueryTable.populate(QueryTable.java:216)
	at coldfusion.sql.Executive.getRowSet(Executive.java:314)
	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.setupCachedQuery(QueryTag.java:695)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:496)
	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)