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