wikitext search

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

wikitext search

Mr Scsi
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
_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Fxp
Reply | Threaded
Open this post in threaded view
|

Re: wikitext search

Fxp

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

_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Fxp
Reply | Threaded
Open this post in threaded view
|

Re: wikitext search

Fxp
In reply to this post by Mr Scsi
wrong link, sorry:
http://thread.gmane.org/gmane.org.wikimedia.mediawiki/11505/focus=11505
François

_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: wikitext search

Mr Scsi
In reply to this post by Mr Scsi
>
>
> 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:
>
>
> wrong link, sorry:
> http://thread.gmane.org/gmane.org.wikimedia.mediawiki/11505/focus=11505
> Fran?ois
>


Thanks for the response, but that wasn't my problem.
I dug and dug through the dump files and logs to finally come to the
conclusion that mysql is pre configured to limit full text search to minimum
of 4 characters.

I made the change:

[mysqld]
ft_min_word_len=3


in my /etc/my.cnf. Ran the maintenance script to reindex and bingo.
_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Fxp
Reply | Threaded
Open this post in threaded view
|

Re: wikitext search

Fxp
Super :-)

>
>
> Thanks for the response, but that wasn't my problem.
> I dug and dug through the dump files and logs to finally come to the
> conclusion that mysql is pre configured to limit full text search to minimum
> of 4 characters.
>
> I made the change:
>
> [mysqld]
> ft_min_word_len=3
>
>
> in my /etc/my.cnf. Ran the maintenance script to reindex and bingo.

_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l