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 Licensehttp://mutualwiki/COPYINGalong 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