[Mediawiki-l] wikitext search

Thu Apr 13 18:38:10 UTC 2006

See maybe:
http://thread.gmane.org/gmane.org.wikimedia.mediawiki/11329/focus=11341

François

Mr Scsi wrote:
> 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