logo Sign In

Search bug (?) Multiple duplicate results.....

Author
Date
Author
Time
Post link
In my last few forum searches, I've noticed that some of the results are repeated many times- the same result post sometimes is repeated 20 times among the other search results.

Anybody else have this problem?

Author
Time
Post link

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)

 

I saw the original theatrical release of the Old Trilogy on the big screen and I'm proud of it...
How did I accomplish that (considering my age) is my secret...
Author
Time
Post link

I haven't seen duplicate results myself, so an example search with duplicate results would be helpful.

Don't know what happened, but the database's full text catalog got corrupted somehow. I rebuilt it and search seems to be working again.

User-specific search is coming in a future version of the software.

Forum Administrator

MTFBWY…A

Author
Time
Post link

Maybe a server issue, as today the same search string ("games") seems to be working.

Please add the User-specific search soon, I'm wasting my nerves trying to find my old posts (I just love reading posts from educated, cultural and well spoken people who agree with me, LOL!)

I saw the original theatrical release of the Old Trilogy on the big screen and I'm proud of it...
How did I accomplish that (considering my age) is my secret...