Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.26.0

Bug #13585 bug search broken w short keywords (pear.php.net vs mysql configuration)
Submitted: 2008-04-04 04:09 UTC Modified: 2009-03-13 00:26 UTC
From: cweiske Assigned: dufuz
Status: Closed Package: pearweb (version 1.17.1)
PHP Version: 5.2.5 OS:
Roadmaps: 1.18.0    
Subscription  


 [2008-04-04 04:09 UTC] cweiske (Christian Weiske)
Description: ------------ One: I'm trying to find bugs related to the chm manual. I go to http://pear.php.net/bugs/search.php and type in "chm", set status to "All". No bugs found. Two: Same as before, but searching for "manual chm", checking the "all" radio box. I get the same result set like when searching for "manual" only.

Comments

 [2008-04-08 09:21 UTC] wiesemann (Mark Wiesemann)
I guess that the "ft_min_word_len" MySQL setting is the reason for this problem. => http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html ("The default minimum value is four characters")
 [2008-04-08 09:38 UTC] dufuz (Helgi Þormar Þorbjörnsson)
FYI we are still running 4.0 but I suspect it was present then too ... I'll check and update and doc it somewhere for the 5.x upgrade.
 [2008-04-08 09:40 UTC] wiesemann (Mark Wiesemann)
I just linked to the 5.0 docs, but the information is also true for lower versions: http://dev.mysql.com/doc/refman/4.1/en/fulltext-fine-tuning.html ("4.1" is only the directory name, the manual is named "MySQL 3.23, 4.0, 4.1 Reference Manual")
 [2008-04-08 09:44 UTC] dufuz (Helgi Þormar Þorbjörnsson)
Yeah I know ... that's why I said "suspect" :-D I think I might even add this as a check in the installation .. see if the mysql is properly configured, doubt we'll ever try to support more databases, this century anyway. Thanks for the heads up.
 [2009-02-03 15:07 UTC] doconnor (Daniel O'Connor)
-Summary: bug search broken +Summary: bug search broken w short keywords (pear.php.net vs mysql configuration)
 [2009-03-12 22:42 UTC] dufuz (Helgi Þormar Þorbjörnsson)
server config changed to min len 3 - waiting on a server restart
 [2009-03-13 00:06 UTC] dufuz (Helgi Þormar Þorbjörnsson)
interesting, chm still returns nada even after I changed the config to min len 3 and restarted the server - investigating further
 [2009-03-13 00:26 UTC] dufuz (Helgi Þormar Þorbjörnsson)
-Status: Open +Status: Closed -Assigned To: +Assigned To: dufuz
This bug has been fixed in CVS. If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET). If this was a problem with the pear.php.net website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better. There we go - just had to run repair table bugdb for the config change to affect the index.