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