Homer Simpson wrote:
I implemented a fulltext search in wiki by using the Lucene classes to
index
and search the wiki SQL Tables. At the moment I simply use the following query to select the articles I want to search in:
"SELECT * FROM cur WHERE cur_namespace=0"
There is no "cur" table in current versions of MediaWiki. It's obsolete, and left over from an upgrade from an old version.
To prevent finding already deleted articles I compare the results with
the
results I get using the following query:
"SELECT * FROM archive WHERE ar_title='searchterm'"
This is a poor practice, and also your query is wrong.
Check page, and don't forget to use page_namespace.
Thanks, I did'nt think about left over tables from older versions. I am at home, so I can't check the tables, but I don't remember any page_namespace field, but I'll check that again.
Again thanks for your fast answer Marcel