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.
-- brion vibber (brion @
pobox.com)