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

go to bug id or search bugs for

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
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: jsgoupil at lookstrike dot com
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Wed Jan 15 17:01:31 2025 UTC