php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #28664 bug database: three letter strings are being ignored
Submitted: 2004-06-07 06:17 UTC Modified: 2004-06-25 10:42 UTC
Votes:2
Avg. Score:4.0 ± 1.0
Reproduced:2 of 2 (100.0%)
Same Version:1 (50.0%)
Same OS:1 (50.0%)
From: jsgoupil at lookstrike dot com Assigned:
Status: Closed Package: Website problem
PHP Version: Irrelevant OS: WinXP
Private report: No CVE-ID: None
 [2004-06-07 06:17 UTC] jsgoupil at lookstrike dot com
Description:
------------
When I'm searching a bug into the PHP Database, (because i don't want to post a bug twice), some functions doesn't work correctly !

It could be cool if you can add "Version Number" and option like > 4.1, 4.3, 5....

Reproduce code:
---------------
When you arrive on the Advanced Search Page
Change Return only bugs with status for "All"
Change "Display All Bugs"
Search with 2 words (ie. end line)...

With the radio button, if you select, any, all or raw, you got exactly the same result... the same number of bugs...


Expected result:
----------------
any : (default) One or more (any) of the search terms may be present. 
all : All search terms are required. 
raw : Allows full use of MySQL's FULLTEXT boolean search operators. 

Actual result:
--------------
any, all, raw = same result (i think its an any result)

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-06-24 23:02 UTC] philip@php.net
It works fine but apparently three letter words (in your case the word 'end') are being ignored, could someone with server access check the mysql ft_min_word_len setting?  It should be set to 3 and not 4 otherwise the PHP code will need updating (see format_search_string() in functions.inc)

Test words: end, wez, len, str
 [2004-06-25 10:42 UTC] derick@php.net
The setting was indeed 4, I changed that to 3 and rebuild the indexes.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Mar 05 04:01:29 2024 UTC