php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #17391 MySQL's FULLTEXT index not usefull for the bugsystem
Submitted: 2002-05-23 11:03 UTC Modified: 2002-09-18 20:08 UTC
Votes:1
Avg. Score:3.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: edink at proventum dot net Assigned:
Status: Closed Package: Website problem
PHP Version: 4.0CVS-2002-05-23 OS: N/A
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: edink at proventum dot net
New email:
PHP Version: OS:

 

 [2002-05-23 11:03 UTC] edink at proventum dot net 
I don't seem to be getting any results when I enter data in "Find bugs with any of the words" field.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-05-23 20:44 UTC] jimw@php.net 
works fine for me. can you give a specific example that fails to return any results?
 [2002-05-23 21:01 UTC] edink@php.net 
I searched for pow which failed to find bug #17374. I still cannot find that bug if I search for "pow" and status "closed" (I've closed the bug report in the meanwhile).

Btw, I'm not able to respond as a regular user, so I had to use my dev account. The error I get is "You aren't allowed to change a bug to that state."
 [2002-05-24 13:02 UTC] sander@php.net 
Words with less than 4 characters are ignored by MySQL's full-text search which is used by this bug system. That full-text thingy sucks anyway but AFAIK it's the only serious indexing that can be used on TEXT's.
 [2002-05-30 05:19 UTC] edink@php.net 
Apparently that can be solved only by recompiling MySQL. Anyone willing to do so?
 [2002-06-16 07:53 UTC] sander@php.net 
Let's make this bugreport a generic complain-report about MySQL's FULLTEXT indexing/search stuff:

-as stated above, it ignores words with three or less letters...
-it uses an OR search
-it ignores "quotes to search for a certain string"

Does anybody know of a good alternative to index over 30 megs of text?
 [2002-09-18 20:08 UTC] iliaa@php.net 
Thank you for your bug report. This issue has already been fixed
in the latest released version of PHP, which you can download at 
http://www.php.net/downloads.php

Apparently someone did recompile MySQL, since searching for words <4 characters long, now works.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Thu Jul 31 23:00:03 2025 UTC