Dear wiki friends,

I am running a media wiki with the following versions:

* MediaWiki http://www.mediawiki.org/ : 1.5rc4 * PHP http://www.php.net/ : 5.0.4 (apache2handler) * MySQL http://www.mysql.com/ : 4.1.13-nt * Extensions: * Special pages: * LuceneSearch by Kate Turner and Brion Vibber * Extension functions: * wfLuceneSearch and syntaxSetup

I've downloaded lucene search via cvs and compiled it. when I start the indexer with the following command:

C:\apachefriends\xampp\lucene>java -Djdbc.drivers=com.mysql.jdbc.Driver org.wiki media.lsearch.MWSearch -rebuild dewiki

I receive the following error message:

"26.09.2005 09:23:15 org.wikimedia.lsearch.SearchState <init> INFO: dewiki using analyzer org.apache.lucene.analysis.de.GermanAnalyzer 26.09.2005 09:23:16 org.wikimedia.lsearch.SearchState initializeIndex INFO: Creating new index for dewiki dewiki: running full update... 26.09.2005 09:23:16 org.wikimedia.lsearch.MWSearch main WARNUNG: [dewiki] Error starting query: SQL error: Syntax error or access violat ion message from server: "Key column 'page_timestamp' doesn't exist in table" java.sql.SQLException: Syntax error or access violation message from server: "Ke y column 'page_timestamp' doesn't exist in table" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278) at com.mysql.jdbc.Connection.execSQL(Connection.java:2251) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:158 6) at org.wikimedia.lsearch.SearchState.enumerateArticles(SearchState.java:279 ) at org.wikimedia.lsearch.MWSearch.main(MWSearch.java:115)"

I assume the database structure doesn't match to what lucene search expects. Since I am running a MediaWiki 1.5 I set

# Set this to run with MediaWiki 1.4 databases; # if running with MediaWiki 1.5, remove it. mwsearch.oldmediawiki=false

in mwsearch.conf

My mwsearch.conf looks like following (with correct username password instead of ****):

# This should be a user which is able to connect to the database # and read the wiki tables. mwsearch.username=**** mwsearch.password=****

mwsearch.database.host=localhost mwsearch.dburl=jdbc:mysql://{0}/{1}

# A directory to put the search index in. It will be created if # it doesn't already exist. The {0} parameter is filled in by # the database name. mwsearch.indexpath=./mwindex/{0} mwsearch.titledb=./mwtitle/{0}

# List of all databases separated by spaces. mwsearch.databases=dewiki

# List of those databases in Latin-1 encoding, separated by spaces. # Any other database is assumed to be UTF-8 encoded. # This affects only the index build, when data is pulled from the DB. #mwsearch.latin1dbs=enwiki svwiki

# Databases whose names carry these suffixes are assumed # to have a language prefix. The prefix will be used # to select a language-specific analyzer to handle # stop-words, grammatical normalization, and word separation. # Unrecognized languages will get the English analyzer. mwsearch.suffix=wiki

# Set this to run with MediaWiki 1.4 databases; # if running with MediaWiki 1.5, remove it. mwsearch.oldmediawiki=false

# If using table prefixes, set it here. #mwsearch.tableprefix=mw_

# Max number of results to return to client mwsearch.maxlines = 100

Any help appreciated.

Greetings Markus