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)