[Mediawiki-l] wikitext search

Mr Scsi mrscsi at gmail.com
Thu Apr 13 15:57:05 UTC 2006


Hello,
We have an installation of Wikimedia with a mysql backend for a proof of
concept.
Currently, everyone thinks very highly of it with one problem. The search
function doesn't seem to be searching the wikitext field of any articles.
It returns catagory names and page names if they match exactly, but nothing
from the body of the article.
I'm sure this is just a configureation issue, that needs to be set. Could
someone tell me what we are missing?

Heres all the version info:

This wiki is powered by *MediaWiki <http://www.mediawiki.org/>*, copyright
(C) 2001-2006 Magnus Manske, Brion Vibber, Lee Daniel Crocker, Tim Starling,
Erik Möller, and others.

MediaWiki is free software; you can redistribute it and/or modify it under
the terms of the GNU General Public License as published by the Free
Software Foundation; either version 2 of the License, or (at your option)
any later version.

MediaWiki is distributed in the hope that it will be useful, but WITHOUT ANY
WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
details.

You should have received a copy of the GNU General Public
License<http://mutualwiki/COPYING>along with this program; if not,
write to the Free Software Foundation,
Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. or read it
online <http://www.gnu.org/copyleft/gpl.html>

   - MediaWiki <http://www.mediawiki.org/>: 1.5.6
   - PHP <http://www.php.net/>: 4.3.9 (apache2handler)
   - MySQL <http://www.mysql.com/>: 4.1.12




I have enabled logging with sql dump, here is a test search:

Start request
GET /index.php/Special:Search?search=bre&fulltext=Search
Host: mutualwiki
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.1)
Gecko/20060111 Firefox/1.5.0.1
Accept: text/xml,application/xml,application/xhtml+xml,text/html;q=0.9
,text/plain;q=0.8,image/png,*/*;q=0.5
Accept-Language: en-us,en;q=0.5
Accept-Encoding: gzip,deflate
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive: 300
Connection: keep-alive
Referer: http://mutualwiki/index.php/Special:Version
Cookie: wikidbUserName=Req73000; wikidbUserID=44;
wikidb_session=5ae00ad07ddba778b8aff0b372a79098

Main cache: eaccelbagostuff
Message cache: eaccelbagostuff
Parser cache: eaccelbagostuff
User::loadFromSession() unable to load from memcached
SQL: /* Database::begin */ BEGIN
SQL: SHOW PROCESSLIST
Using reader #0: localhost...
SQL: SHOW STATUS
SQL: /* User::loadFromDatabase */ SELECT
user_name,user_password,user_newpassword,user_email,user_email_authenticated,user_real_name,user_options,user_touched,user_token
FROM `user`  WHERE user_id = '44'  LIMIT 1
SQL: /* User::loadFromDatabase */ SELECT ug_group  FROM `user_groups`  WHERE
ug_user = '44'
User::loadFromSession() successfully saved user

SQL: /* Parser::replaceLinkHolders */ SELECT page_id, page_namespace,
page_title FROM `page` WHERE (page_namespace=4 AND page_title
IN('Searching'))
Would search with '+bre'
Match with /\bbre\b/
SQL: SELECT page_id, page_namespace, page_title FROM `page`,`searchindex`
WHERE page_id=si_page AND  MATCH(si_title) AGAINST('+bre' IN BOOLEAN MODE)
AND page_is_redirect=0 AND page_namespace IN
(0,1,2,3,4,6,7,8,9,10,11,12,13,14,15)   LIMIT 0,20
Would search with '+bre'
Match with /\bbre\b/
SQL: SELECT page_id, page_namespace, page_title FROM `page`,`searchindex`
WHERE page_id=si_page AND  MATCH(si_text) AGAINST('+bre' IN BOOLEAN MODE)
AND page_is_redirect=0 AND page_namespace IN
(0,1,2,3,4,6,7,8,9,10,11,12,13,14,15)   LIMIT 0,20
SQL: /* Database::immediateCommit */ COMMIT
SQL: /* Database::begin */ BEGIN
SQL: /* LinkCache::addLinkObj */ SELECT page_id  FROM `page`  WHERE
page_namespace = '2' AND page_title = 'Req73000'  LIMIT 1
SQL: /* User::getNewtalk */ SELECT wl_user  FROM `watchlist`  WHERE wl_title
= 'Req73000' AND wl_namespace = '3' AND wl_user = '44' AND
(wl_notificationtimestamp != 0)
SQL: /* LinkCache::addLinkObj */ SELECT page_id  FROM `page`  WHERE
page_namespace = '3' AND page_title = 'Req73000'  LIMIT 1
SQL: /* Revision::fetchRow */ SELECT
page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted
FROM `page`,`revision`  WHERE (rev_id=page_latest) AND (page_id=rev_page)
AND page_namespace = '8' AND page_title = 'Mutual_of_Omaha_Wiki_News'  LIMIT
1
SQL: /* Revision::fetchRow */ SELECT
page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted
FROM `page`,`revision`  WHERE (rev_id=page_latest) AND (page_id=rev_page)
AND page_namespace = '8' AND page_title = 'Mutual_of_Omaha_Wiki_News'  LIMIT
1
SQL: /* Revision::fetchRow */ SELECT
page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted
FROM `page`,`revision`  WHERE (rev_id=page_latest) AND (page_id=rev_page)
AND page_namespace = '8' AND page_title = 'Mutual_Wiki_News'  LIMIT 1
SQL: /* Revision::fetchRow */ SELECT
page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted
FROM `page`,`revision`  WHERE (rev_id=page_latest) AND (page_id=rev_page)
AND page_namespace = '8' AND page_title = 'Mutual_Wiki_News'  LIMIT 1
SQL: /* Revision::fetchRow */ SELECT
page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted
FROM `page`,`revision`  WHERE (rev_id=page_latest) AND (page_id=rev_page)
AND page_namespace = '8' AND page_title = 'Recent_Changes'  LIMIT 1
SQL: /* Revision::fetchRow */ SELECT
page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted
FROM `page`,`revision`  WHERE (rev_id=page_latest) AND (page_id=rev_page)
AND page_namespace = '8' AND page_title = 'Recent_Changes'  LIMIT 1
SQL: /* Revision::fetchRow */ SELECT
page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted
FROM `page`,`revision`  WHERE (rev_id=page_latest) AND (page_id=rev_page)
AND page_namespace = '8' AND page_title = 'Special:Categories'  LIMIT 1
SQL: /* Revision::fetchRow */ SELECT
page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted
FROM `page`,`revision`  WHERE (rev_id=page_latest) AND (page_id=rev_page)
AND page_namespace = '8' AND page_title = 'Special:Categories'  LIMIT 1
SQL: /* Revision::fetchRow */ SELECT
page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted
FROM `page`,`revision`  WHERE (rev_id=page_latest) AND (page_id=rev_page)
AND page_namespace = '8' AND page_title = 'Sandbox'  LIMIT 1
SQL: /* Revision::fetchRow */ SELECT
page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted
FROM `page`,`revision`  WHERE (rev_id=page_latest) AND (page_id=rev_page)
AND page_namespace = '8' AND page_title = 'Sandbox'  LIMIT 1
SQL: /* Revision::fetchRow */ SELECT
page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted
FROM `page`,`revision`  WHERE (rev_id=page_latest) AND (page_id=rev_page)
AND page_namespace = '8' AND page_title = 'Sandbox'  LIMIT 1
SQL: /* Revision::fetchRow */ SELECT
page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted
FROM `page`,`revision`  WHERE (rev_id=page_latest) AND (page_id=rev_page)
AND page_namespace = '8' AND page_title = 'Sandbox'  LIMIT 1
SQL: /* Revision::fetchRow */ SELECT
page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted
FROM `page`,`revision`  WHERE (rev_id=page_latest) AND (page_id=rev_page)
AND page_namespace = '8' AND page_title = 'Contact'  LIMIT 1
SQL: /* Revision::fetchRow */ SELECT
page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted
FROM `page`,`revision`  WHERE (rev_id=page_latest) AND (page_id=rev_page)
AND page_namespace = '8' AND page_title = 'Contact'  LIMIT 1
SQL: /* Revision::fetchRow */ SELECT
page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted
FROM `page`,`revision`  WHERE (rev_id=page_latest) AND (page_id=rev_page)
AND page_namespace = '8' AND page_title = 'Contact'  LIMIT 1
SQL: /* Revision::fetchRow */ SELECT
page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted
FROM `page`,`revision`  WHERE (rev_id=page_latest) AND (page_id=rev_page)
AND page_namespace = '8' AND page_title = 'Contact'  LIMIT 1
** private caching;  **
SQL: /* Database::immediateCommit */ COMMIT
Request ended normally



More information about the MediaWiki-l mailing list